PMT John and Gunnar intend to buy a house for 20,000,000 and are considering taking a 100% loan for it. They have been offered a loan at 4.15% interest with 480 months (repayment loan). What is the payment per month, using PMT?

b) FV: Parents of John and Gunnar have 10,500,000 in savings and are planning to deposit it in a bank. They get 2.1% interest. How much will they have after having invested the money for 5 years in the bank? Interest is compounded once a year.

c) PV or NPV: A bond has the following payment schedule. Year 1 -> 170,000, year 2 -> 170,000 and year 3 -> 1,170,000. What is the present value of this amount with a 10% discount rate?

d) IRR: What is the yield of the bond if the purchase price is 910,000?

Answer rating: 100% (QA)

a PMT Calculation for Loan Given Loan Amount PV 20000000 Interest Rate r 415 per year Number of Peri... View the full answer