Dashboard - always at the top of the detail sheet - summarizes highlights as you work.

Business Drivers - enable you to create formulas and extrapolate into the future based on any number in the spreadsheet.  Totals for Revenue and Cost are picked up in the green boxes and those cells are customizable - this limits the opportunity for a formula error to throw off the entire model.

The model has 'Major' and 'Sub' Drivers which creates significant flexibility while keeping it simple - if you don't need them...don't use them!!!

 

Operating Expenses - provide flexibility to capture costs in three major / common areas and also picks up people costs from the People section that follows.  Here people costs are depicted monthly and benefits are calculated based on the variable set by the user (defaults @ 30%).  Rows can be added - all numbers should be listed above the gray lines - rows inserted above - this ensures that formulas are complete.

People - highly customizable capabilities included - i.e. Quantity per role, entering annual wage instead of monthly, extrapolating people headcounts based on other data - i.e. customers or other variable metrics.

Balance Sheet data is tracked in this section.  Flexibility abounds - model AR / AP to follow revenue / cost respectively, track additions / reductions to capital (and the interest can be modeled in the Operating Expense section based on debt.  All of this activity is picked up, properly, on the SCF and Balance Sheet.

Asset Investments and associated depreciation are captured in this section.  Simply input the 'cost' along with month of acquisition and term of depreciation...depreciation is calculated automatically and all three reports are updated automatically to track the effect of the cash investment and associated depreciation.

Presentation Ready Reports - print monthly or yearly (or both).

P&L...

SCF...

Balance Sheet...