How much money do you plan to save each period? Years until your retirement Years you plan to be in retirement (how long your money needs to last) Expected return on your savings before retirement (this is an EAR) Expected return on your savings during retirement (this is an EAR) How frequently do you save money each year? Annually (1), quarterly (4), or monthly (12 times eacl Expected return on your savings before retirement (this is an APR) Expected return on your savings during retirement (this is an APR) Amount you'll have in your account at retirement based on the amount you save each period Amount you could spend each period during your retirement. 35000 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 Amount you could spend each period during your retirement 2000000 How much money would you like to have in savings when you retire? Interest rate (rate of return) you would need per period to hit this target amount. That periodic rate converted into an effective annual return (EAR) riend Dalla needs your help in planning for retirement. She has told you how much she is saving and how frequently, the number of years until her retirement, and he needs the savings to last in retirement. She has also told you what she belleves she can earn on her investment prior to retirement, but she knows the interest. ad during retirement will be lower as she will invest in safer assets. Use the information provided in the cells to construct a spreadsheet to help Dalia see what she can ct for retirement. Format all cells with dollar amounts or percentages as Currency or Percentage, respectively. data validation in cell C2 to restrict the number to be a decimal larger than zero. When a negative number is entered, the cell should return the error message "Do not the NOMINAL function to convert the effective annual return in cell C5 to an APR. Be sure your formula links to cell C7 since the compounding frequency must match the the NOMINAL function to convert the effective annual return in cell C6 to an APR. Be sure your formula links to cell C7 since the cornpounding frenuency must match the the FV function to calculate how much Dalia will have in savings when she gets to retirement. the PMI function to calculate how much Dalia can spend each petiod while in retirement (use the same namber of periods in a year as specified in cell C7). culate the amount she will have at retirement (cell C11) if she already has $35,000 in het retirement account. Hint: this is easiest to do by using the optional [pw] argumen o the PMT function to calculate the amount she can spend each period in retirement given the amount you calculate cell Cl6. lia would like to have $2,000,000 in her account at retirement. Asuming she currently has no savings, use the RATE function to calculate what rate of return she would nee -6 that periodic rate of return to calculate the effective annual return (EAR) that would allow Dalia to bit her target. Use the POWER function in your formula. Note that the mat cells with percentages using the Percentages format, and celfs with dollar amounts using the Cirrency format. in both cases, display two decienals