please help solve
3. Calculate the future value and the future value of an ord nary annulty for problemse1 to $5 4 using your Casio FX 260 Solar Fraction calculator and add both answers together. Galcalate 3. the same six problem using the Exeil spreadsheet and the afVO formula. 6 7. 1) An investor invested $25,000 in a stock that has averaged a 6% return for 30 years. He/she i. will also inwest $4,000 at the end of each year for 30 years. Calculate the future value and the 9 future value of an ordinacr annily and add both anowers together. Calculate the same 10 problem using the Excel spreadsheet and the aFVO formula. 11 12. 2) An irwestor invested $15,000 in a stock that has averaged a 8$ return for 25 years. He/she 1) will also invest $5,000 at the end of each year for 25 vears. Caloulate the futurc valus and the 14. Guture value of an crdiaarr amailiz and add both answers together. Ciloulate the same 15 problem using the Excel spreadiheet and the = FVO formula. 36 17 3) An investor invested $20,000 in a stock that has averaged a 7X return for is years. He/ahe at will also invest $2,000 at the end of each year for 15 years. Calculate the future value and the 39 fiture value of an crdinary amolix and add both anowers together. Gioulate the same 20 problem using the Exeel spreadsheet and the =FV0 formula. an n a 34 as 26. 4) An investor invested $30,000 in a stock that has averaged a 956 return for 20 years. He/lhe 27 will also invest $6,000 at the end of each year for 20 years Cilclate the future value and the 23 groblem using the Excel spreadsheet and the orVD formula x 31. 5) An investor invested 535,000 in a stock that has averaged a 55 hiun for 35 years. He/she 19 will also imest $8,000 at the end of each year 60 r 35 years, Calculate the futuce value and the an problem using the ficel spreadehet and the fFVO formula. n 46 An invester invested $50,000 in a stock that has averaged a 100 return for 38 yearz. He/the n will also invest $10,000 at the end of each vear for 38 years. Oloulate the future valua and the in probiem uing the fecel spreadichert and the afvo formula 4 47) 4. 47 s) 40 s. al \begin{tabular}{|c|c|c|c|} \hline & & & Anares: \\ \hline$25,000a & 1.0530 - 3143587.28 fueuce Valus & 1) & \\ \hline 54,000a & 1.06/0301/055316.212.74 FV end Ann & 1) & \\ \hline 5143.5172 & & & 1) \\ \hline \end{tabular} 2) 2) (2) Sheet1 Ready Sheet1 Ready 200 problem using the Excel spreadsheet and the =FV0 formula. 110 111 12) An investor invested $50,000 in a stock that has averaged a 10% return for 38 years. He/she 112 will also invest $10,000 at the becinning of each year for 38 years. Calculate the future x alue & 119 the Yuture value of an anaity dus and add both answers together. Calculate the same 114 problem using the Excel spreadsheet and the =FV0 formula. 115 ui Note - the Future Value Syntax is EFY(rate.neec.pmt.[oxl.(typel] 117 rate =% or dedmal noer n number of periods, (Vears, months etc.) emt = payments. 118 since there are no payments for a lump sum FV problem, put a comma 8 a blank space. 119 for pmt,pY= present value. ( $ amount), use a necative $ amount, type = investing S a: 120 end or becinnine of veac, 0= end of year, 1 = beginning of year, use 0 121 222 Note - the Future Value of an Annuity Due Syntax is afYirate.noer.pmt.[ox]. [type]] 123 rate =% or decimal, neer = number of periods, (years, months etc) , pmt = payments. 135 or beginning of yeac, 0= end of year, 1 = beginning of year, use 1 126 .$25,000(1.06)30=$143.587.28FutureValue$4,000(1.06401/.06(1.06)=$335.206.71FVAnnDue$143.587.28FV+$335.205.71FVAnnDue=$478.793.92 \begin{tabular}{|c|c|c|c|} \hline & & Answer & \\ \hline & & 5978.793 .99 & 7) \\ \hline & 7) & & \\ \hline & 7) & & \\ \hline \end{tabular} 8) 8) 8) 9) 9) 9) 9) 10) 10) 10) 11) 11) 8) 239 134 135 136 137) 133 135 109 a49 46 4 48 a) 49 5 s. 120 190 19 8) 8 9) 9) ) y) \begin{tabular}{|l|l|} \hline 10) & 10) \\ \hline & \\ \hline & 11) \\ \hline 11) & 11) \\ \hline \end{tabular} 12) 12) 12) 12)
