For this Assignment, you consider analysis tools such as expense forecasting, break-even, cost-benefit, marginal profit and loss and cost-effectiveness that can help determine the financial and organizational impact of proposed expenditures and investments.
Complete the required reading in the Learning Resources.
Reflect on how these might be applied to your project.
Conduct a financial analysis using the three scenarios provided in the Excel Assignment Workbook. These are not based on your project but will help you learn the process.
Complete the following:
Ratio Analyses Worksheets:
Open your Excel Assignment Workbook. This assignment will be completed on 3 separate tabs named:
W8A5a Expense Forecasting
W8A5b Breakeven Analysis
W8A5c Marginal Profit and Loss
Using the Healthcare Budget Request Guide for guidance, complete the three scenarios: expense forecasting, break-even, marginal profit and loss for the scenarios provided.
*NOTE: Please make sure that all three tabs for the W8A5 Assignment are complete before uploading your Excel Workbook for submission.
Be sure to review the Learning Resources before completing this activity.
Click the weekly resources link to access the resources.
Hayes, A. (2019, February 16). Break-even analysis definitionLinks to an external site. [Blog post]. https://www.investopedia.com/terms/b/breakevenanalysis.as
Penner, S. J. (2016). Economics and financial management for nurses and nurse leaders (3rd ed.). New York, NY: Springer Publishing Company.
Chapter 8, “Cost Finding, Break Even, and Charges” (pp. 189–214)
Chapter 9, “Comparing Cost and Benefits” (pp. 217–242)
