Expense Forecasting and Benchmarking
Looking Ahead: Application Assignment: Expense Forecasting and Financial Analysis Cycle
You will begin this assignment in Week 9 and it will be due by Day 7 of Week 10.
Throughout this course, you’ve examined the importance of anticipating financial fluctuations that may impact your organization’s ability to provide services. While financial managers have no time machines or crystal balls, they do have expense forecasts. Expense forecasting is one of the preeminent tools that financial managers can use to prepare their organizations for future fiscal turbulence. In this Assignment, you will examine a scenario and generate a corresponding expense forecast in Excel.
Before pursuing an opportunity or making a major purchase, financial decision makers must first ascertain if the expenditures are justified. Determining whether a new process, system, or purchase will yield worthwhile returns is no easy task. However, managers have a variety of tools to help them decide whether the new expenditure is warranted. Analyzing a venture’s benefit/cost ratio, marginal profit and loss statement, and break-even points enable nurse managers to make educated decisions about how they choose to commit their funds.
Note: For those Assignments in this course that require you to perform calculations you must:
- Use the Excel spreadsheet template for the Week 3 assignment
- Show all your calculations and formulas in the spreadsheet.
- Answer any questions included with the problems (as text in the Excel spreadsheet).