Financing Building Costs of Saint Louis University:

Saint Louis University is building a $13,000,000 office and classroom building in St. Louis in Missouri, and is planning to finance the construction at an 80% loan-to-value ratio, meaning that the borrowed money corresponds to 80% of the value of the building. The balance of 20% will be paid in cash up front. This loan has a ten-year maturity, calls for monthly payments, and is contracted at an interest rate of 7%.

Using the above information, answer the following questions.

1.What is the monthly payment?

Answer:

2.Using the provided Excel file, construct the amortization table in the spread "Sheet2".

3.How much of the first payment is interest?

Answer:

4.How much of the first payment is principal?

Answer:

5.How much will Saint Louis University owe on this loan after making monthly payments for three years (the amount owed immediately after the thirty-sixth payment)?

Answer:

6.Should this loan be refinanced after three years with a new seven-year 6% loan, if the cost to refinance is $210,000? (This means that the refinance cost must be added to the owed amount at the end of three years). To make this decision, calculate the new loan payments and then the present value of the difference in the loan payments.

Answer:

7.Returning to the original ten-year 7% loan, how much is the loan payment if these payments are scheduled for quarterly rather than monthly payments?

Answer:

8.For this loan with quarterly payments, how much will Saint Louis University owe on this loan after making quarterly payments for three years (the amount owed immediately after the twelfth payment)? (Hint: you can use the provided Excel file and do the estimations in the spread "Sheet3")

Answer:

9.What is the effective annual rate (EAR) on the original ten-year 7% loan?

Answer:

10. For the original ten-year 7% loan, how much is paid in interest over the entire life of the loan?

Answer:

11. For the ten-year 7% loan, what is the total construction cost including financial cost?

Answer: