ENCORE! Sample Models

Home Encore! Samples WebFact   Services Testimonials Price List Contact E-mail Title Corporate Planning Model Description This corporate planning model calculates a projected Income Statement, Balance Sheet, and Cash Flow Statement based on user assumptions for Sales, Margins, Collections, etc. The balance sheet is automatically balanced, and the classic simultaneous equation is solved: the Balance Sheet is dependent on the Income Statement (earnings affects how much has to be borrowed or invested), and the Income Statement is dependent on the Balance Sheet (interest income or expense depends on Short Term Investment or Short Term Debt). Interest Income on Short Term Investment, and Interest Expense on Short Term Debt are computed based on the AVERAGE of the balance at the end of the prior period, and the balance at the end of the current period. The model does a 12 month projection, but can be easily modified to work with other time periods. Screen Shots Key Assumptions and Results The Analyze Menu Option Income Statement as a Percent of Sales Sample Report 1: Graph of Sales and Profits Sample Report 2: Income Statement Application Files Click on a selection to view colored syntax code snippets. All files are included in the download package. Exec Model Logic Global Variable Logic Input Report Download File Size: 27 kbytes HTTP Download