Profit volume analysis, sometimes called cost-profit-volume analysis, is the process of calcu- lating the profits of a business at different volumes, or revenue levels. Break-even analysis, a component of profit volume analysis, is simply the calculation of the revenue level at which a business … [Read more...] about Easy Refresher: Profit Volume and Break-Even Analysis
Customizing the Business Planning Starter Workbook
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
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
Easy Refresher: Financial Statements and Ratios
Financial statements describe either the past or the future financial condition and performance of a business. The term financial statement can refer to one of several types of schedules and summaries of economic information. Typically, however, the term describes a set of documents that include an … [Read more...] about Easy Refresher: Financial Statements and Ratios
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