Deferred annuities lecture $+$ questions

Deferred annuities Excel answers

Homework $5$

Instructions

$-$Work individually on all questions. Do not share answers or spreadsheets with anyone

In each of the following questions, solve for the unknown variable $($identified with $?)$

Solve to the correct number of decimal places: FV$,$ A$,$ and PV in dollars to the nearest cent, periods of deferral and annuity terms to two decimal places, interest rates as percents to $6$ decimal places

In question $8$ submit a single Excel spreadsheet with a sepratert rates.

$\backslash$table$[[,$Accumulation Stage,,,Payments Stage,,,Interest rate for both stages$],[\backslash$table$[[$Question$],[$number$]],$Present Value,Future Value,Period of Deferral,Annuity Payments,Anmuity Payment Timing,Annuity Term,Nominal Interest Rate$],[1,2\mathrm{.}2?,$$o$,{15}^{\frac{1}{2}}$ years,$$4,200$ quarterly,End,$12$ years,$7\mathrm{.}7\%$ semi$-$annually$],[2,$$$40,000,$$$0,2\mathrm{.}2?$ months,$$908\mathrm{.}56$ monthly,Beginning,$10$ years,$6\mathrm{.}1\%$ weekly$],[3,$$$5,000,$$$0,5$ years,$$$$2$ daily,Beginning,?.?? days,$8\mathrm{.}5\%$ annually$],[4,$$$17,500,$$$0,14$ years, $8$ months,?.?? annually,End,$5$ years,$7\mathrm{.}5\%$ monthly$],[5,$so$,,\backslash$table$[[5$ years $($after last annuity$],[$payment$)]],$$$17,018\mathrm{.}98$ semi$-$annually,End,$7$ years, $6$ months,$2\mathrm{.}8\%$ annually$],[6,$$$55,000,0,13$ years, $10$ months,$$9,850\mathrm{.}80$ quarterly,End,$5$ years,?.????$2?\%$ quarterly$],[7,$so$,$$$60000,11$ years,$$150$ monthly,Beginning,$20$ years,$2\mathrm{.}72????\%$ monthly$]]$

$4$

Applications of annuities assignment part $1$

Instructions:

Work individually on all questions, Do not share answers or spreadsheets with anyone. nominal interest rates.