Show all formulas and data in Excel since the problem has to be completed there.
How frequently do you save money each year? Annually (1), quarterly (4), or monthly (12 times each year)? Problem2Prablem3Prablem4Problem5Expectedreturnonyoursavingsduringretirement(thisisanAFA)Expectedreturnonyoursavingsbeforeretirement(thisisanAPR)AmauntyoullhaveinyauraccountatretirementbasedontheamountyausaveeachperiadAmountyoucouldspendeachperioddurirgpourretirement How much money do you currently have in savings? Amount you'll have in your account at retirement based on the amount you save each period plus the amount al ready in saving5 Amount yru could spend each period during yrur retirement How much money would you like to have in savings when you retire? Interest rate [rate of return] you would reed per periad to hit this target amount. That periodic rate converted into an effective annual return \{EAR] Time Value of Money Revlew 50 Polnts with dallar amaurts or percentages as Qurrency ar Percentage, respectively. FV function to ca culate how much Dal a will have in savines when she gets to retirement. IT function to calculate how much Dalia can spend each period while in retirement (use the same number of periods in a year as specified in cell c7). Format cells with percentages using the Percentages format, and cells with dollar amounts using the Currency format. In both cases, display two decimals. How frequently do you save money each year? Annually (1), quarterly (4), or monthly (12 times each year)? Problem2Prablem3Prablem4Problem5Expectedreturnonyoursavingsduringretirement(thisisanAFA)Expectedreturnonyoursavingsbeforeretirement(thisisanAPR)AmauntyoullhaveinyauraccountatretirementbasedontheamountyausaveeachperiadAmountyoucouldspendeachperioddurirgpourretirement How much money do you currently have in savings? Amount you'll have in your account at retirement based on the amount you save each period plus the amount al ready in saving5 Amount yru could spend each period during yrur retirement How much money would you like to have in savings when you retire? Interest rate [rate of return] you would reed per periad to hit this target amount. That periodic rate converted into an effective annual return \{EAR] Time Value of Money Revlew 50 Polnts with dallar amaurts or percentages as Qurrency ar Percentage, respectively. FV function to ca culate how much Dal a will have in savines when she gets to retirement. IT function to calculate how much Dalia can spend each period while in retirement (use the same number of periods in a year as specified in cell c7). Format cells with percentages using the Percentages format, and cells with dollar amounts using the Currency format. In both cases, display two decimals
