Question: Part Two- for Option B only: Create a loan amortization table over the length of the financing. You should use the example from the asynchronous
Part Two- for Option B only:
-
- Create a loan amortization table over the length of the financing. You should use the example from the asynchronous lecture. While that slide was shown in months, your analysis for this project should be shown in years. Hint: If your table is correct, the total payments and total interest should equal the numbers you calculated in the above step, and remaining principal should equal zero in the final year.
- Debt will be acquired to fund construction, and payments will begin in January 2019.
-
Assumptions
- The hospital only needs to fund the capital equipment, the startup costs are being funded from existing cash.
- The hospital has an S&P credit rating of A that was used to determine interest rates.
- The length of a bank loan (Options A&B) is tied to the useful life of the asset that is being financed. The items in this project have a variety of useful lives. For this project, we are assuming an average useful life of 15 years, so the entire loan will be over 15 years. In reality, your bank may require more than one loan, based on the useful life of each different group of building/equipment.
- Bonds (Option C) are not restricted by the useful life of the asset they are financing, so they are able to cover long terms- 20 years for our project.
| Option A | Option B | Option C | ||
| 50% equity/50% Loan | Loan | Public Bond (A rating) | ||
| annual interest rate w/fees | 3.00% | 3.00% | 3.75% | |
| PV | 5,500,000 | 11,000,000 | 11,000,000 | |
| term | 15 | 15 | 20 | |
| FV | 0 | 0 | 0 | |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
