Question # 1 Funding a retirement goal. 30 points A. Use the "PROJECTING RETIREMENT INCOME AND INVESTMENT NEEDS interactive spread sheet to calculate these amounts or use your financial calculator: Austin Miller wishes to have $600,000 in a retirement fund 30 years from now. He can create the retirement fund by making a single lump-sum deposit today. Use your financial calculator or the appendixes to determine the lump sum amount needed if the fund that earns 6% annually. $ How much does Austin need to save each month if he wants to accumulate $600,000 by the time he retires and earns 6% over the course of the 30 years? How much would Austin need to have on deposit at retirement in order to withdraw $45,000 annually over 15 years in the retirement fund earning 6%? $