Finance questions

Question: #1024

Finance questions

Is anyone familiar with Case 19: Palms Hospital Traditional Project Analysis from Cases in Healthcare Finance 4th edition by Louis C. Gapenski? Pages 143-148...

Additional Requirements

Min Pages: 1

Level of Detail: Show all work

Other Requirements: I need all of the input data to help me complete this case:

Land initial cost

Land opportunity cost (and salvage value)

Building/equipment cost

Build/equipment salvage value

Procedures per day

Average net revenue per procedure

Labor costs

Utilities costs

Incremental overhead

Supply cost ($/procedure)

Inflation rate on charges

Inflation rate on costs

Tax rate

Revenues lost from inpatient surgeries

Reduction in inpatient surgery costs

Cost of capital

I have some of the data, but not sure how much I am on track.

Solution: #1028

Finance questions

1. Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a separate page of the spreadsheet.

loan_amortization_soln 039.xlsx 50 KB