the file “Sample.xlsx” cointains questions, with answers using Excel functions and also using Excel to do the calculation using normal formulas. “Todo.xls” contains 8 more questions, these need to be solved just like the questions in “Sample.xlsx”, showing detailed calculations to get same answer as Excel function. PLEASE MAKE SURE THAT THIS IS DONE JUST LIKE THE WORK IN “Sample.xlsx”.
29985.069406566497 15000 1200 16200 16200 1296 17496 17496 1399.68 18895.68 18895.68 1511.6544000000001 20407.3344 20407.3344 1632.5867519999999 22039.921151999999 22039.921151999999 1763.19369216 23803.114844159998 23803.114844159998 1904.2491875327999 25707.364031692799 25707.364031692799 2056.5891225354239 27763.953154228224 27763.953154228224 2221.1162523382582 29985.069406566483 29985.069406566483 8162.9787689085197 3 10000 7.0000000000000007E-2 0.81629787689085187 8162.9787689085188 8162.9787689085188 344097.63655695791 20 30000 0.06 0.68819527311391571 11.469921218565263 344097.63655695791 344097.63655695791 9.0064683420005878 9 1288.3718952291338 240000 4.1666666666666666E-3 360 0.2238265956413508 0.77617340435864923 5.3682162301213815E-3 1288.3718952291315 6 9.4222391070304917E-2 500000 250 2000 360 2.7777777777777779E-3 1.0213380873783042 2.1338087378304227E-2 2.1338087378304227E-2 7 7.8E-2 1200000 525000 2.2857142857142856 9.0909090909090912E-2 1.078048645928869 7.8048645928868954E-2 7.8048645928868954E-2 7.8048645928868954E-2 8 94257 500000 25000 525000 525000 26250 551250 551250 27562.5 578812.5 578812.5 28940.625 607753.125 607753.125 30387.65625 638140.78125 638140.78125 31907.0390625 670047.8203125 670047.8203125 33502.391015624999 703550.21132812498 703550.21132812498 35177.51056640625 738727.72189453128 738727.72189453128 36936.386094726564 775664.1079892579 775664.1079892579 38783.205399462895 814447.31338872085 814447.31338872085 2000000 1185552.6866112791 1185552.6866112791 0.05 10 1.6288946267774416 -0.62889462677744157 -7.9504574965456681E-2 94256.862448185013 Answer: Problem Assignment: Time Value of Money If you deposit $15,000 today and earn 8% annual interest, how much will you have in 9 years? 1 2 Tiffany will receive a graduation gift of $10,000 from her parents in 3 years. If the discount rate is 7%, what is this gift worth today? 3 What…
Attachments:
Sample.xlsx