Alan borrows $100,000 at nominal interest rate 9% per annum which matures in 5 years. Repayments are made monthly such that each monthly payment in the last 2 years is twice that in the first 3 years. a) Calculate the monthly payments for this loan. b) Construct the amortization table for this loan which includes the following columns Installment, Interest payment, Principal payment, Outstanding balance. c) After 3 years, the market nominal interest rate falls to 6% per annum. Alan wants to terminate the loan. The bank charges the termination fee which is 40% of the difference in total remaining interest payment. Calculate the amount Alan needs to pay the bank (including outstanding balance and termination fool

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter19: Lease And Intermediate-term Financing
Section: Chapter Questions
Problem 17P
icon
Related questions
Question
Alan borrows $100,000 at nominal interest rate 9% per annum which matures in 5
years. Repayments are made monthly such that each monthly payment in the last 2
years is twice that in the first 3 years.
a) Calculate the monthly payments for this loan.
b) Construct the amortization table for this loan which includes the following columns
Installment, Interest payment, Principal payment, Outstanding balance.
c) After 3 years, the market nominal interest rate falls to 6% per annum. Alan wants
to terminate the loan. The bank charges the termination fee which is 40% of the
difference in total remaining interest payment. Calculate the amount Alan needs
to pay the bank (including outstanding balance and termination fee).
d) Alan borrows the amount in part c) at 6% per annum. If he keeps to the current
monthly payment, how long will he pay off everything ?
e) What is Alan's monthly payment if he decides to keep to his schedule of paying
off the debt in the next 2 years ?
f) Suppose Alan follows the payment schedule in part e). Write down the equation of
value for the cash flow generated by Alan in terms of the hypothetically constant
monthly internal rate of return i. Use Excel's Solver to find i.
Transcribed Image Text:Alan borrows $100,000 at nominal interest rate 9% per annum which matures in 5 years. Repayments are made monthly such that each monthly payment in the last 2 years is twice that in the first 3 years. a) Calculate the monthly payments for this loan. b) Construct the amortization table for this loan which includes the following columns Installment, Interest payment, Principal payment, Outstanding balance. c) After 3 years, the market nominal interest rate falls to 6% per annum. Alan wants to terminate the loan. The bank charges the termination fee which is 40% of the difference in total remaining interest payment. Calculate the amount Alan needs to pay the bank (including outstanding balance and termination fee). d) Alan borrows the amount in part c) at 6% per annum. If he keeps to the current monthly payment, how long will he pay off everything ? e) What is Alan's monthly payment if he decides to keep to his schedule of paying off the debt in the next 2 years ? f) Suppose Alan follows the payment schedule in part e). Write down the equation of value for the cash flow generated by Alan in terms of the hypothetically constant monthly internal rate of return i. Use Excel's Solver to find i.
Expert Solution
steps

Step by step

Solved in 4 steps with 12 images

Blurred answer
Knowledge Booster
Mortgage Amortization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage