Question
For Problems 1 and 2, you can use any Excel technique explored in the last two labs. 1.You have taken a loan of $140,000 CAD.
For Problems 1 and 2, you can use any Excel technique explored in the last two labs.
1.You have taken a loan of $140,000 CAD. The nominal annual rate of interest compounded monthly on this loan is 7.03%. You can afford to pay monthly $ 1066.22 CAD.
How many months it will take you to repay the loan?
Your answer will be an integer value that includes the last monthly payment, which will be smaller than the rest.
2.You have taken a loan of $185,000. You can afford to pay monthly payments of $1440.33. This loan will be repaid in 18 years.
What is the nominal annual rate of interest charged on this loan?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals Of Financial Management Concise
Authors: Eugene F. Brigham, Joel F. Houston
11th Edition
0357517717, 9780357517710
