Part 1 is to complete the estimated expenses and revenue for your project. Your excel spreadsheet will record:
- Each of the estimated expenses associated with your proposed idea, including startup expenses. Be sure to label each appropriately, with enough description to make it clear what the item is and what the estimated cost involves.
- Each of the estimated revenues associated with your proposed idea. 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).
- Calculate the total estimated expenses and revenues for the next 5-year period.
- Calculate the Return on Investment (ROI) for your proposed idea.
- Be sure to type this budget information directly on to the excel spreadsheet. This needs to be done so the Instructor can click on the cells to determine formulas used and how you arrived at answers.
- Anecdotal Note – A screenshot of the excel spreadsheet is to be included o the HC Budget template. Please know that the Instructor cannot click into cells on this specific document because it is embedded within a MW document. This is why the student needs to submit the excel spreadsheet (Part 2 of the assignment).
Part 2 is to complete Projected Expenses and Revenues (Five Year) Summary of Analysis and Interpretation of Results:
Create a brief (1- to 2-page) description of your analysis that clearly describes the estimated financial impact of your proposed idea. Interpret the results by explaining what your ROI calculation means to the organization. Place your analysis on the Healthcare Budget Request Template under the section titled W4A3 Projected Expenses and Revenues (Five Year). Take a screenshot of the excel spreadsheet and include this within the executive summary on the HC Budget template.
A power-point was developed to guide you in this work and it has been placed in Doc Sharing.
Thank you and have a great week 4!
Dr. Parsons
Deliverables: 2-part assignment, 100 points
