#1 Use 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 enter negative numbers".

How much money do you plan to save each period? (ears until your retirement reart you plan fo be in retirernent (how long your money needs to last) Expected retum on your savings before retirement (this is an LAA) Expected return on your sayings during retiretuent (this is an EAA?) How frequently do you saye money each year? Annuslly (1). quarferly (4), or monthly (12 times each year)? Time Value of Money Review 50 Points Your friend Oalia needs your help in planning for retirement: 5he has told you how much she is saving and how frequently, the number of years untif her retirement, and how long she needs the savings to last in retirement, She has also told you what she believes she can earn on her inventment prior to retirement, but she knows the interest earned dusing retirement will be lower as she will invest in afer assets. Use the information provided in the celis to construct a spreadsheet to help Dalia 1ee what she can expect for reirement. Format all cells with dollar amounts or percentages as Currency or Pertentege, respectively