This spreadsheet contains instructions and calculations for a financial model. The worksheets are organized to give a clear idea of the contents of the spreadsheet, guidelines to use the model, data to be entered and the resulting graphs to interpret the model.

Financial Model

The first two worksheets contain the table of contents and the instructions respectively. The instructions provide detailed information regarding the methods to be used to input data, assumptions to be used, viewing data, customizing the model and printing the financial statements.

The spreadsheet titled Assumptions contains tables where data from the balance sheet and expenses can be entered. The worksheet titled Details contains a table where the expenses and income from different sources can be outlined. The sheet titled staffing needs summarizes the hours of contract labor, full time labor, full time employees and PP employees along with the average billing rate.

Summary statements contains calculations from the data entered in the previous worksheets to determine the net income, total assets, total liability and equity. It also contains a summary of the total sources of cash and the ending cash. The results are presented in the form of graphs in the Revenue Growth chart and the breakeven chart.

The Revenue growth chart shows the revenue on the Y axis and the years from 2000 to 2004 on the X axis. The forecasted revenue and income can be assessed by studying the nature of these graphs. The breakeven chart has the amount on the Y axis and the months from January 2000 to October 2001 on the X axis.

The graphs for Receipts and Disbursements can be plotted here. This graph will give an idea of the cash flow breakeven.

Financial Model

Skip to toolbar