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.
Subjects: Finance, Spreadsheets
Source: Professor Kerry Back (Washington University in St. Louis) (visit original source)  
This page/content is for Premium, Lifetime Access members only.
Register
Already a member? Log in here