Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q17: Mr. Johnson is a business man in Taipei. He purchased a new apartment worth NTD 10300000. He paid NTD 2,750,000 as down payment.

image

Q17: Mr. Johnson is a business man in Taipei. He purchased a new apartment worth NTD 10300000. He paid NTD 2,750,000 as down payment. He got the interest rate at 2%. He has to pay off the total loan in 20 years. At the end of 2nd years of the loan Mr. Johnson and friends went to Dubai for some business purposes. When he return back he took a Big ticket lottery from Abu Dhabi airport. He was so lucky in it. Because he won the lottery worth NTD 7,000,000. (Your answer should use Excel format)- (A) Calculate the monthly annuity of the loan(3 Points).. (B) If Mr. Johnson would like to pay off his all the loan amount with lottery prise money, how much the total payment amount does he need to pay at the end of 24th month? (2 Points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To calculate the monthly annuity of the loan we can use the PMT function in Excel The formula for th... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fixed Income Securities Valuation Risk and Risk Management

Authors: Pietro Veronesi

1st edition

0470109106, 978-0470109106

More Books

Students also viewed these Economics questions

Question

How is imprecision quantified?

Answered: 1 week ago