21 and 23. Show which EXCEL formula to use . Please do both questions or try to attempt. Thank you

16. (Solving for interest rate o nary annuity) rate must you late $100,000 saving $8.000 of each of the next 10 years. At what hou to invest to meet your goal? 17. (Solving for interest rate of what rate you rate of 12% over 5 years. What of each of the next 10 At interest must interest years. Non-Annual Compounding today 18. (solving for Fv) plan interest is compounded, the future value your investment if of a. Annual b, Semi-annually Bimonthly Quarterly Monthly 19. f Daily today at an annualinterest rate of 12% over 10 ye (Solving for FV) You plan invest s200,000 is compounded, interest to uture value of your investment if a. Annually Semi annually d. Quarterly e. Monthly 20. annuity) Timothy just bought a car for $45,000 with a $10,000 deposit. He borrowed the balance with a s35,000 loan from the automobile dealer The loan is for 5.6% annual, compounded and payable monthly over 5 years. What will be his monthly payments? If he decides to start the first payment on day what will be his monthly payments thereafter? 21. (Non-annual annuity) Jasmine just bought a car for $35,000 with a $5,000 deposit. She borrowed the balance with the dealer. The loan is for 3.6% annual, compounded and 22. payable monthly over 3 years. What will her payments? If he decides to start the first payment on day 1, what will be his be thereafter? monthly payments (Non-annual annuity) Stan wants to plan for his retirement in 30 years. During his 30 year retirement, he must he spend monthly, while earning 10% in his retirement funds He will save monthly in his 401K save monthly at the end of his to meet his objectives. y. How much annuity) Sta month retirement fund with his e the in his funds ring his 30 year retirement, he 24. if he save monthly, beginning the end of 30 e will 12% in his begins savings at the beginning this month to plans to (Growth annuity) Maureen has just of current month? meet objectives. annual ly. Hi much ow his the first year and will receive a signed a nal How his annual salary 10% increase eve basketbal contract results change professio annual in her savings each year in a mutual fund where she year for w re she after lo years? expects to earn 1 ye earn $250,000 25. Growth annuity) Michael has just signed a professi the first year and as onal basketbaM salary each year in a mutual fund where he expects r 10 savings after 10 years? to earn 1 much of her contract wh years. annually. H earn $2