Quertion I

C$291218.$

$4/$rant $-4641$

Guribion $?$

$4$ man

appropriale is west hromel is nerenel nhele if $|$halonts eune th ther ene nork, nels En lelyhackes pratitilly efler:

$\backslash$table$[[$Firs$,$Len $8],[1,1$me$],[3,$cxam$],[8,140$x$],[4,$Prase$],[3,$Naxe$],[8,$Nuep$],[7,8,$ mex$],[3,$Nime$],[5,1/$kex$],[,13$ay$.],[$Hata$,48$ emb$]]$

$\backslash$table$[[$Gueplien $4],[81$ kn$],[4$ man$]]$

$218$ kn

$4$pant

Tracington insubtients is athering minembenest acocuri end lirep ther ielonmation priviter what ie fir aver ner aroul artuens in this invoitmen?

fiemember bo une a MM$//$useliont $/$round

be llee? Solve $1,2,3,4$ and show the detailed formula used Quertion I

C$291218.$

$4/$rant $-4641$

Guribion $?$

$4$ man

appropriale is west hromel is nerenel nhele if $|$halonts eune th ther ene nork, nels En lelyhackes pratitilly efler:

$\backslash$table$[[$Firs$,$Len $8],[1,1$me$],[3,$cxam$],[8,140$x$],[4,$Prase$],[3,$Naxe$],[8,$Nuep$],[7,8,$ mex$],[3,$Nime$],[5,1/$kex$],[,13$ay$.],[$Hata$,48$ emb$]]$

$\backslash$table$[[$Gueplien $4],[81$ kn$],[4$ man$]]$

$218$ kn

$4$pant

Tracington insubtients is athering minembenest acocuri end lirep ther ielonmation priviter what ie fir aver ner aroul artuens in this invoitmen?

fiemember bo une a MM$//$useliont $/$round be llee? Solve $1,2,3,4$ and show detailed way how you solved it

A divtant celative poomises you throaph emall a Sil millios inhmilance$-$ Aher some resparch, you find that the money can he imverted inbo in wocount paying a fiond IV$,$ raser, compounded quartedy. I How roch netinement money would be in the account ator is pears? $($round to meneret dollar$)$ Students must So their own work, whit roo help$/$ walutions provided ty others.

The ernal from the last qumtion tur redd out to be fraudient, but you'd swill ilie to hove the provided after $35$ poars Hear much morery would meed to be irvested at the beginning of each month for the nest $35$ years in order bo hares $522,590,712$ at the end of the time perlod? You estimate comervatively that your monery will eane $6\%$ a pear. $[$round to the neanett dollar$)$ Studenks mant do their owet work, with no helof$/$uplytions provided by etherr.

D$)$ Anocher arecitable flellow emaih to inform you that you have won the Paris Olympics lottery. You can take your winninges ina himp sum of $52,500,000$ or receive annual end of year payments of $$200,000$ for $20$ ypark. Auwaning that yoor moley can ewirn $3\%$a year, what is the walue of the anhual annuity streem option? $($round to the nearest dollar$)$ srudents mual do thrir cwen work, with no lictpryutions prowided by others.

Question $8$

Ameal

$54321\mathrm{.}94$

Smed$-$Avinal

$43\mathrm{.}399\mathrm{.}77$

Quertiely

$54,40921$

Monetly

Yow can sense that pout Bodgler has concerm about her netinement. She has learned of the concept of compouinding by reading your lestbook duling her down time. Demonetrate compounding to your young finalice protege by caloulatinet $($with Excel fumelont of cournel what the value of $$1,000$ at $55$ would be in $30$ rears with annual, ieven! anroul, quarterly and monthly compounding. fround to heo decimal placei$)$ Snudents munt do their own work, with no helpfsolutiona provided by othern. Solve $5,6,7,8$ and show detailed way how you solved it

Guestion$9$

Aneral

$5\mathrm{.}00016$

Semd$-$Anheal

$5\mathrm{.}0075$

Guatierly

$5095$

Moethly

$5118x$

$4$ points

Question $10$

$182$

$4$ peints

Question $11$

$3\mathrm{.}77$

$25$ points

Caloulate the effective amual rate for each of the compounding optiom in Oveition $8,$ using a firction, $($round to three decimal places$)$ shudents mout do their cwn work, with no helpliblutions provided by otherk.

A netistieblower exposed an tiegal papoff xheme at a prison. The whitleblower's attorney butrves hes cfient could be elpble for a $$3$ milhon whisleblower par out. The ehistleblower believes this is a good start, but would reed $$6$ milion to retire comfortally, with the Miestyle he deulres. if athe to coffect on the $$9$ mitlon, how manr years woudd it tale to doutile Nis moser to $56$ metion, arruning a $5$ Kincount rate? Caloalate thes for hem uing an facel function, not with the rule of $72.$ fround to the nearmt terith of a year$)$ ftuterts must do their own work, with no helphatutiom provided ty others.

Ure an fxcel function to find the expected rate of retarn based on the following $5$ years of heitorical retorms, froond to one dectimat place$)$ suaterlls must do thes oen work, elth no helplsolutions provided by cthers.

$\backslash$table$[[$Yean$,2018,2019,2020,2021,2022],[$Reture$,806,205,45,85,155]]$

Question $12$

$8\mathrm{.}6\%$

$2\mathrm{.}5$ points

Use in Eacel$/$function to find the itandard deviation of historical returns in the previous $$veetion$.$ fround to one decimal place$)$ Studenks must do their own work, with no help$/$relutions proplided by others.Solve $9,10,11,12$ and show correct way how you solve it