Develop the Ratio Analysis Worksheet
FE004: Ratio Analysis
Part 1: Develop the Ratio Analysis Worksheet
For Part 1 of this Assessment, you will use ratios to determine the breakeven point and payback period for your proposed healthcare product or service. To do this:
1) Review Learning Resources.
2) Open the FE_workbook_firstinitial_lastname.xlsx file you used in FE003.
3) Navigate to the A5 Ratio Analysis worksheet.
4) Develop formulas or functions that calculate the following:
a) The total estimated startup expenses (those occurring in Year 0) for your product or service. Be sure to label each appropriately, with enough description to make it clear what the item is and any necessary details regarding sources of revenues (including reimbursements).
PencilNote: “Total estimated expenses” should match those you presented on the A3 Estimated Expenses worksheet.
b) The breakeven point for your product or service
c) The payback period for your product or service idea
PencilNote: The values used for this calculation, including estimated revenues, should match those you presented on the A3 Estimated Expenses worksheet.
d) Include any other ratios or other analyses that you believe are applicable and will strengthen your business case or help inform the decision-making process.
5) Save and submit your assessment.
Part 2: Summary of Analysis and Interpretation of Results
For Part 2 of this Assessment, you will describe your ratio analysis. To do this:
1) Create a brief (1- to 2-page) description in a Word document of your ratio analysis.
2) When will your organization’s investment(s) in the healthcare product or service break even?
3) What is the payback period?
4) What assumptions have you made in your analyses?
5) What do these analyses mean for your organization?
A3 Estimated Expenses
ESTIMATED EXPENSES
This worksheet presents the estimated expenses for the development, launch, and maintenance for the Heathway’s clinic.
A4 Budget Development
BUDGET DEVELOPMENT
This worksheet presents the budget development for Heathway’s clinic.
A5 Ratio Analysis
RATIO ANALYSIS
This worksheet presents the ration analysis for Heathway’s clinic.
A6 Financial Statement Analysis
FINANCIAL STATEMENT ANALYSIS
This worksheet presents the financial statement analysis for Heathway’s clinic.
Blog ArchiveCopyright © 2019 HomeworkMarket.com Read
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code “Newclient”
