An investor wants to finance a project in Canada with a value of $1.5 million with a 70 percent, 25-year loan* at a nominal (face) rate of 8 percent. The project's NOI is expected to be $120,000 during year 1 and the NOI, as well as its value, is expected to increase at an annual rate of 3 percent thereafter. The lender will require an initial debt coverage ratio of atleast1.20. Assume the outgoing cap rate is equal to the ingoing cap rate and the sale in Year 4 is based on Year 5 NOI. *Don’t forget that Canadian Mortgages compound semi-annually. If you are not familiar with amortizing mortgages, you can use the Financial Functions in Excel. The function requires that you work with five (5) variables: Pmt, Nper (in months), Pv, Fv and Rate. Also you need to decide if the payments are at the beginning or the end of the period (they are at the end – that is you get the loan and make the first payment at the end of the first month). d. What would be the loan-to-value ratio?

International Financial Management
14th Edition
ISBN:9780357130698
Author:Madura
Publisher:Madura
Chapter14: Multinational Capital Budgeting
Section: Chapter Questions
Problem 30QA
icon
Related questions
Question

An investor wants to finance a project in Canada with a value of $1.5 million with a 70 percent, 25-year loan* at a nominal (face) rate of 8 percent. The project's NOI is expected to be $120,000 during year 1 and the NOI, as well as its value, is expected to increase at an annual rate of 3 percent thereafter. The lender will require an initial debt coverage ratio of atleast1.20. Assume the outgoing cap rate is equal to the ingoing cap rate and the sale in Year 4 is based on Year 5 NOI.

*Don’t forget that Canadian Mortgages compound semi-annually.

If you are not familiar with amortizing mortgages, you can use the Financial Functions in Excel. The function requires that you work with five (5) variables: Pmt, Nper (in months), Pv, Fv and Rate. Also you need to decide if the payments are at the beginning or the end of the period (they are at the end – that is you get the loan and make the first payment at the
end of the first month).

d. What would be the loan-to-value ratio?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
International Financial Management
International Financial Management
Finance
ISBN:
9780357130698
Author:
Madura
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT