Forecasting Financial Statements

ABOUT THIS CONTENT

Given a set of assumptions about operations and financing, this spreadsheet generates income statements, balance sheets, and statements of cash flows. It is designed for a start-up company in that the initial balance sheet is blank, but it can be modified for a going concern by inputting the initial balance sheet. The spreadsheet is designed for bank notes payable to be the balancing variable -- using the Excel Solver (as explained in the spreadsheet) minimizes bank notes payable subject to maintaining a desired minimum cash balance.
Source: Professor Kerry Back (Washington University in St. Louis)
| visit original source  
Download: 3  

3

Subjects: Finance, Spreadsheets
This content is for Premium, Lifetime Access members only.
Log In Register