You can use the profit volume and break-even analysis starter workbook (PROFITVOL), shown in Figures 11-1 through 11-4, to test the effect of changing revenues on business profits. To complete the schedule, you define the following: Revenue variables, including the unit sales price, the low … [Read more...] about Using the Profit Volume and Break-Even Analysis Starter Workbook
Finance
Easy Refresher: Profit Volume and Break-Even Analysis
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
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
Optimization Modeling with Solver in Excel
Excel’s Solver tool lets you solve optimization-modeling problems, also commonly known as linear programming programs. With an optimization-modeling problem, you want to optimize an objective function but at the same time recognize that there are constraints, or limits. While this abstract … [Read more...] about Optimization Modeling with Solver in Excel
Simple Modeling with Goal Seek in Excel
You can use the Goal Seek command to determine which input value for a formula pro- duces a specified formula result. Goal Seek, then, lets you quantify what needs to happen in order to achieve some specified result. Rather than supplying a set of formula inputs and letting Excel calculate the … [Read more...] about Simple Modeling with Goal Seek in Excel