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.

Note that in questions $6$ and $7$ you must provide nominal interest rates. or with an author who is not you: you get zero on the homework.

$\backslash$table$[[\backslash$table$[[$Question$],[$number$]],$Accumulation Stage,Payments Stage,$\backslash$table$[[$Interest rate for both stages$],[$Nominal Interest Rate$]]],[$Present Value,Future Value,Period of Deferral,Annuity Payments,Annuity Payment Timing,Annuity Term$],[1,2$dots?,$$0,{15}^{\frac{1}{2}}$ years,$$4,200$ quarterly,End,$12$ years,$7\mathrm{.}7\%$ semi$-$annually$],[2,$$$40,000,$so$,???$ 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,?$\mathrm{.}7?2???\%$ quarterly$],[7,$So$,$$$60000,11$ years,$$150$ monthly,Beginning,$20$ years,?.??????$\%$ 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. without an author or with an author who is not you: you get zero on the homework. $1.$ Present value

$2.$period of deferral

$3.$ Annunity term

$4.$annunity payments

$5.$ Future value

$6.$intrest rate for both stage

$7.$ Intrest rate for both stage