| When
you customize the model, you can choose the following features. (Not all of
these features are available in the Standard version.) |
| • Time range and time grain (weeks, months, quarters, years) |
| • Investment subprojects that you can analyze separately and in
aggregate. |
• Blend equity, debt and lease financing, independently for each
subproject, with effects on interest, depreciation,
lease expenses and taxes. |
| • Choose the sales model |
| − Simple sales model based on initial revenue and revenue growth |
| − Sales model based on prices, initial sales units and sales
units growth |
| • Number and names of assets whose financial performance is
separately tracked |
| • Types of working capital (which vary proportional to revenue) |
| • Types of fixed operating expenses (that do not vary with
revenue) |
| • Types of variable operating expenses (that vary with revenue) |
| |
| You can enter the following input data (in the darker blue cells
on worksheet "Inputs"). |
| • initial investment, a choice of depreciation methods, and
asset salvage value |
| • working capital initial value, requirements, and salvage value |
| • opportunity cost |
| • a project revenue stream |
| • income taxes and credits |
| • a choice of methods of computing the discount rate. |
| |
| The main outputs of the model are: |
| • The operating cash flow, shown on worksheet "Cash
Flow" |
• The net present value (NPV), return on capital (ROC), and
internal rate of return (IRR) , shown on worksheet
"Valuation." |
| |
| The model contains Excel graphs of key variables. These graphs
are integrated into the FinModel model
from which they get their source data. You can add more graphs, and
optionally import them to FinModel and include them in future exported Excel
workbooks. |
| |
| As you explore the model, we suggest that you |
• Read some of the Excel comments that are attached to Analysis
Variables throughout the workbook.
These comments also appear in
FinModel in convenient places. |
• View worksheet "Formulas" which shows the named
variables and symbolic formulas of the model
in a compact and readable form.
The symbolic formulas are not active in this Excel workbook, but they
give you some idea how the model
works, and how it looks in FinModel. |