You can use the business planning starter workbook for many business projections. However, you might want to change the starter workbook so that it more closely matches your requirements. For example, you can add text that describes the business and the forecasting horizon. You can increase or … [Read more...] about Customizing the Business Planning Starter Workbook
Using Excel
Understanding the Business Planning Starter Workbook’s Calculations
The business planning starter workbook has seven parts: the inputs forecast, Balance Sheet, Common Size Balance Sheet, Income Statement, Common Size Income Statement, Cash Flow Statement, and Financial Ratios Table. I want to briefly describe the calculations that occur within each of these parts in … [Read more...] about Understanding the Business Planning Starter Workbook’s Calculations
Using the Business Planning Starter Workbook
You can use the business planning starter workbook, shown in Figures 10-1 through 10-5, to construct pro forma financial statements that let you forecast profits and losses, financial condition, and cash flows for a business or organization. To use the workbook, you develop and then enter … [Read more...] about Using the Business Planning Starter Workbook
Working with the Financial Analysis Tools in Excel’s Small Business Financial Manager
The Small Business Financial Manager provides you with four Financial Analysis Tools: Business Comparison Reports, Buy vs. Lease Analysis, a Create Projection Wizard, and What-If Analysis. You can move backward and forward within a Financial Manager Tool wizard’s dia- log boxes by clicking the … [Read more...] about Working with the Financial Analysis Tools in Excel’s Small Business Financial Manager
Working with the Report Wizard in Excel’s Small Business Financial Manager
After you’ve imported your accounting data, you use the Report Wizard to produce a fi- nancial report based on the imported accounting data. Reviewing the Report Wizard Reports The Report Wizard produces reports that fall into one of seven categories: balance sheets, cash flow statements, change … [Read more...] about Working with the Report Wizard in Excel’s Small Business Financial Manager
Importing Financial Data Into Excel’s Small Business Financial Manager
Before you can begin using the Small Business Financial Manager, you import the financial data stored in your accounting system and store it in a database. You may also need to reorganize the data slightly once it’s in this database. And, of course, as your accounting records change, you’ll want to … [Read more...] about Importing Financial Data Into Excel’s Small Business Financial Manager