In: Finance
Yr0 Yr1 Yr2 Yr3 Yr4 Yr 5 Yr 6 $1,000 $1,200 $2,000 ? |
(Hint: compare the PVs of annuity X ($5,200 per year for 8 years) with annuity B ($7,300 per year for 5 years)
Chapter 7
6 months 1 year 18 months 2years |
$20 $20 $20 $20 +$1000 |
Question 1).
$1000 in Year 1, $1200 in Year 2 and $2000 in year 4 at 6% per annum.
FV = PV*(1+r)^T
So at year 6, total = 1000*1.06^5 + 1200*1.04^4 + 2000*1.06^2 = $5100.40
Question 2)
a). Bank X promises to pay you $5,200 per year for 8 years, whereas Bank Y offers to pay you $7,300 per year for 5 years.
r= 5%, assuming payment are made at the end of year.
To calculate PV, using excel funtion PV(rate, nper, pmt, [fv], [type])
So for bank X, using PV(5%, 8, 5200, 0, 0) = $33608.71
For bank Y, using PV(5%, 5, 7300,0,0) = $31605.18
b). We will select bank X as PV is higher for it.
Question 3). Today, Dinero Bank offers you a $60,000, five-year term loan at 7.5 percent annual interest (APR). What will your annual loan payment be? (Hint: Find PMT)
for annual loan payment, using excel formula PMT(rate, nper, pv, [fv], [type])
so, using PMT(7.5%, 5, 60000,0,0) = $14830
Please post rest of the question separately.