[Solved] W8A5 RATIO ANALYSIS

Assignment Prompt & Instructions

## READ
## **W8A5 RATIO ANALYSIS**
Your personal decisions regarding purchases are likely made, in no small part, based on your financial position. You will likely consult your bank statements and checkbook before buying. But the extent that you will go beyond current resources—including loans and financing—will depend on factors such as need for the good or service and potential it has for returning value. Similarly, leaders must juggle need, financial position, and potential for return when making expenditure decisions.
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.
### **RESOURCES**
Be sure to review the Learning Resources before completing this activity.
Click the weekly resources link to access the resources.
[**WEEKLY RESOURCES**](https://waldenu.instructure.com/courses/190151/modules/items/7927281 "Click this link to access the weekly resources (open in a new tab)")
### **TO PREPARE**
– Complete the required reading in the Learning Resources.
– Reflect on how these might be applied to your project.
### **THE ASSIGNMENT**
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:
1. W8A5a Expense Forecasting
2. W8A5b Breakeven Analysis
3. 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.
### **BY DAY 7 OF WEEK 8**
**Submit** your Assignment.
***NOTE: Please make sure that all three tabs for the W8A5 Assignment are complete before uploading your Excel Workbook for submission.**
\
xBreak.docx](https://www.sweetstudy.com/files/xbreak-docx "xBreak.docx")
\
xExcel_Assignment_Workbook_student.xlsx](https://www.sweetstudy.com/files/xexcel-assignment-workbook-student-xlsx "xExcel_Assignment_Workbook_student.xlsx")
\
xHealthCare_Budget_Request_Guide1.docx](https://www.sweetstudy.com/files/xhealthcare-budget-request-guide1-docx "xHealthCare_Budget_Request_Guide1.docx")
\
xHealthCare_Budget_Request_Guide-2.docx](https://www.sweetstudy.com/files/xhealthcare-budget-request-guide-2-docx-10423695 "xHealthCare_Budget_Request_Guide-2.docx")
\
xrubric.docx](https://www.sweetstudy.com/files/xrubric-docx "xrubric.docx")