|
ENCORE! Sample Models
This progression of models shows how a model is developed, and introduces key modeling concepts at each step of the way. The first listed version of a model is the simplest. Models become progressively more complicated, expanding from the previous version as the version number increases. Each version can operate without the use of files from the previous version. You can optionally download all ENCORE! Fundamentals of Financial Modeling files at once in a ZIP archive.
Revenue Examples
- Rev1 - simple revenue projection for three product lines.
- Rev2 - mixture of history and projection, 5 years of each.
- Rev3 - using "Column Control" to define what is history and what is projected.
- Rev4 - start with a projection for "Total Sales" and apply a mix percentage to compute product line sales.
- Rev5 - use the FORECAST function to do an initial forecast of "Total Sales."
- Rev6 - allow user to override the regression forecast for selected years.
Expenses
- Exp1 - basic expense projections.
- Exp2 - project "Salaries and Wages" based on "Headcount"; "Benefits" based on a percentage of "Salaries and Wages."
Net Income
- Net1 - input "Interest Income" and "Interest Expense"; do a simple tax calculation.
- Net2 - calculate "Tax Loss Carryforward."
- Net3 - calculate "Interest Income" and "Interest Expense" based on "Short Term Investment" and "Short Term Debt."
Balance Sheet
- Bs1 - input balance sheet items and add them up.
- Bs2 - calculate "Accounts Receivable", "Accounts Payable", and "Inventpry" based on days and turnover.
- Bs3 - improve the calculations for "Fixed Assets", "Depreciation", "Accumulated Depreciation", "Long Term Debt", and "Retained Earnings."
- Bs4 - calculate "Short Tem Investment" or "Short Term Debt" to automatically plug the balance sheet.
Master Logic File
- Master1 - put it all together in one big logic file.