Problem:
The board of directors of Trinity Hospital is working on a five-year strategic plan for the facility. One of the strategic goals is to build a new $1 million cancer research wing in five years. The group is concerned that current economic conditions might reduce revenues over the next five years and they are uncertain about the fate of the construction project. You are part of team tasked with conducting a capital budgeting analysis.
The entire SLP component of the course will involve different aspects of the capital budgeting analysis. You are to perform the calculations and interpret the findings in your SLP papers.
Identify the relevant assets as well as labor and non-labor costs categories that you will want to include in the analysis.
Submit the list of categories and an explanation for why you selected these items in a WORD document.
Construct an EXCEL spreadsheet using these categorical labels