Problem 25. What EXCEL formula can you use to solve this problem? Show all work.

e. Monthly s45,000 with a S10,000 deposit. He h 20. annual annuity) Timothy just bought a car for Orr balance a s from the automobile dealer. mnu the first on day monthly over s What will monthly payments? If he decides to start bor 1, will his monthly payments thereafter? annuity) Jasmine just bought a car for s35,000 with a $5,000 deposit. She balance with automobile dealer. The loan is for 3.6% annual compounded a $30,000 loan from the 21 a payable monthly over 3 years What will be her monthly payments? If he decides to start the first p on day 1, what will be his monthly payments thereafter? 22. (Non-annual annuity) stan wants to plan for his retirement in 30 years. During his 30 year retirement he plans to spend monthly, while earning 10% in his retirement funds. He will save monthly in his retirement fund with his employer over the next 30 years where he plans to earn 12% annually. How much must he save monthly, beginning at the end of this month to meet his objectives 23 plans wants to plan for his retirement in 10 years. During his 30 year tirement, he to spend $5,000 monthly while earning 10% in his retirement He will save monthly in his 401 retirement fund with his employ over the next 30 where he plans to earn 12% lly. How much must he save monthly, beginning at the end of this month to meet his objectives. How will his results change if he begins savings at the beginning of the current month? 24. has just signed a professional contract where she will earn $250,000 the first year and will basketball 10 years. She plans to save 20% of annual salary receive a 10% annual increase every year for in her savings each year in a mutual fund where she expects to earn 15% annually. How much will she have after lo years? 25. (Growth annuity) Michael has just signed a professional basketball contract where he will earn $2,500,000 the first year and will receive a 5% annual increase every year for 10 years. He plans to save 5 of his annual salary each year in a mutual fund where he expects to earn 16% annually. How much will she have in his savings after years