Questions 18-27 use the same data

18)Mortgage - find payment

N = 20 years, monthly payments, starts at end of JanuaryInterest rate = 5%, compounded Monthly

PV = 500,000FV = 0Compute payment PMT?

FindAmortization schedule - First 5 months (August - December)

P1 = 1P2 = 12

19) Balance at end of December in 1st year?

20) Total principal repayment at end of 1st year ?

21) Total interest payments at end of 1st year?

Amortization schedule - 2nd yearP1 = 49P2 = 60

22) Balance at end of December in 5th year

23) Total principal repayment in 5th year

24) Total interest payments in 5th year

Amortization schedule - 3rd year

25) Balance at end of December in 19th year

26) Total Principal Repayment in 19th year

27) Total Interest payments in 19th

------------------------------------------------------------------------

Questions 28 - 31 use the same data

28) Find Mortgage paymentN = 30 years, monthly payment, Annuity Due

Interest rate = 3.9%, compounded monthly , PV = 350000FV = 0Compute PMT?

Amortization schedule after 10 years - Same data as Q28

P1 = 1P2 = 120

29) Balance after 10 years of payments

30) Tot. principal repayment after 10 yrs of payments

31)Tot. interest payments after 10 yrs of payments

32) Compute IRR ?using following data:

CF0=-100000CF1=50000CF2=40000CF3=30000CF4=20000CF5=10000

33) Compute NPV?

CF0=-100000CF1=50000CF2=40000CF3=30000CF4=20000CF5=10000

Interest rate = 11%