the Budget Worksheet

the Budget Worksheet

Part 1: Develop the Budget Worksheet

For Part 1 of this Assessment, you will develop a sample budget for the healthcare product or service you have proposed. You will also apply ratios to analyze the budget and provide information that can guide choices. To do this:

1) Review the Learning Resources, particularly those on creating budgets.

2) Open the FE_workbook_firstinitial_lastname.xlsx file you created in FE001 and used in FE002.

3) Navigate to the A4 Budget Development worksheet.

4) Create a 5-year budget for the healthcare product or service that records the projected expenses and revenues associated with the healthcare product or service you have proposed. Be sure to include startup and operating expenses in your budget.

5) 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).

b) The total estimated expenses and costs per year and for the 5-year period for your product or service

PencilNote“Total estimated expenses” should match those you presented on the A3 Estimated Expenses worksheet.

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 will strengthen your business case or help inform the decision-making process.