PART 2 Use Microsoft Excel and complete the following 5 questions. You must reference your cells as well as type the formulas correctly 1. Ashley wants to buy a car She can only afford a $350 car payment. She is givena financing option from XYZ Financial which will allow him to repay the loan over 4 years. The interest rate is 4.5%. Can Ashley purchase the car if the financing amount is $18,000? If not, how much can she afford to finance? Dr. Pickens wants to buy a burger chain. He currently has $25,000. He needs to have $65,000 in 5 years. He can earn 10% compounded annually. If he saves money at the beginning of the year, how much must he save per year to meet his goal? 2. 3. SARDY Corporation's stock is currently valued at $40 per share. You own 1 share. It is expected to grow by 4% per year for the next 8 years. How much would SARDY Corporation be worth in 8 years? Donald Draper has no money after getting canned (fired) from his job as an advertising agent. He wants to have $7,000,000 in 35 years. How much would he need to steal and invest today assuming he can rob a bank and earn 12% compound annually. He will not add additional payments. He wants to know the lump sum needed to invest today. 4. 5. Bud Jett (get it...ike budget) has two options for an investment. OPTION 1-Invest $1,000 per month for 20 years at the beginning of each year and earn 8% annually. OPTION 2-Invest $800 per month for 20 years at the end of each year and earn 7.5% annually. a. b. Calculate both options and select which investment is better for our financial cartoon friend: Bud Jett