Posted: August 1st, 2023

Hcm410ip1 | HCM410 Fiscal Management in Healthcare Services | Colorado Technical University

***This is a TWO-PART- assignment paper and financial excel sheet***

2-3 pages  APA 6 format, in-text citation, Use at least two (2) scholarly references to substantiate your work. Please provide a copy of all references used.  

Spreadsheet is attached.

The links to the mentioned articles are provided below

**youtube video to help with  completing spreadsheet**

Assignment Details: 


As a member of the finance team, you have been asked to forecast the upcoming year’s operational budget for Krona Community Hospital. Click here for last year’s budget. After reviewing specific data, internal input, and external input from various sources, you find that the executive management team would like the budget to reflect the following:

  • 10% increase in inpatient revenue
  • 15% increase in outpatient revenue
  • 5% increase in pharmacy revenue
  • 15% increase in home health and hospital revenue
  • 10% increase in payroll and benefits

(explanation of assignment from professor)

“ The assignment is to take the number that its here and increase it by whatever percentage or decrease it by whatever percentage theyre asking you to do. So, you just have to do a math problem. So in the columns right next to it. Come up with the new budget. So youre going to as part one of the individual project submit this excel spreadsheet with the new numbers on it.” 


Additionally, provide discussion on the following:

  • How do you think that revenue would increase in each of the areas? Think outside of the box, and perform research to determine current trends in those areas.
  • Why would there be a forecasted need to increase payroll and benefits?
  • Explain the role of key leadership in the budgeting process, from the chief executive officer down through to the staff level of a financial analyst.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: