AC220Unit 4 Problems Show your work in Excel using formulas for calculator computation provided in the learning map for Unit 4 as appropriate. Students could also use excel formulas given as a Hint. (Select Formulas Financial tab in Excel for a listing of formulas) Q1. Today. you earn a salary of $54,000. What will be your annual salary twelve years from now if you earn annual raises of 3.4 percent? (Hint: Find Future Value) Q2. You hope to buy your dream car three years from now. Today. that car costs $63,400. You expect the price to increase by an average of 3.1 percent per year over the next three years. How much will your dream car cost by the time you are ready to make the purchase? (Hint: Find Future Value) Q3. Your father invested a lump sum 25 years ago at 3.15 percent interest. Today, he gave you the proceeds of that investment which totalled $61,332.41 How much did your father originally invest? (Hint: Find Present Value] Q4. You have just received notication that you have won the $2.5 million rst prize in the Georgia Lottery. However, the prize will be awarded on your 60th birthday, 45 years from now. The appropriate interest rate is 5 percent. What is the present value of your winnings? Q5. You are depositing $3,000 in a retirement account today and expect to earn an average return of 4.5 percent on this money. How much additional income will you earn it you leave the money invested for 35 years instead of just 30 years? (Hint: Use Future value formula)