***Please show work in Excel (work and cell formulas)***

Hypothetical age is 25 years and 8 months (highlighted in yellow)

A) What is your assumed age to the closest month? Your assumption must have a month for example, 22 years is not acceptable since it does not have a month but 22 years and one month are acceptable. So, choose an age that has 1 to 11 months At your retirement, when you are 68 years old, how much will the total amount of money be if you switch from coffee drinking to investing in the stock market? Assume that when you get to 68 (retirement age) you switch your funds from stock market investment to bond market investment. Assume you can earn 7.5% on your bond investment. You decide to withdraw a constant amount each year for the next 20 years when you get to retirement age How much will be your anmual withdrawal from age 69 to 88 (Nothing left at 88,20 years of withdrawals) ff you switch your coffee drinking to stock and bond investments? If you aim to have one million in your retirement account when you get to age 68 , how much you must invest in the stock market per month if the stock market monthly average return is 0.83% ? Assume you bought a stock at $60 and 4 months later, you sold it for $80 dollars. Assume no dividends and no transaction commission costs i. What is your holding period return both in dollars and in percentage? ii. What is your Effective Annual Return in percentage? Answer all questions using Excel functions, no mathematical solutions. All answers must be done using PV, FV, Rate, PMT functions of Excel in arder to get full 50 points, A) What is your assumed age to the closest month? Your assumption must have a month for example, 22 years is not acceptable since it does not have a month but 22 years and one month are acceptable. So, choose an age that has 1 to 11 months At your retirement, when you are 68 years old, how much will the total amount of money be if you switch from coffee drinking to investing in the stock market? Assume that when you get to 68 (retirement age) you switch your funds from stock market investment to bond market investment. Assume you can earn 7.5% on your bond investment. You decide to withdraw a constant amount each year for the next 20 years when you get to retirement age How much will be your anmual withdrawal from age 69 to 88 (Nothing left at 88,20 years of withdrawals) ff you switch your coffee drinking to stock and bond investments? If you aim to have one million in your retirement account when you get to age 68 , how much you must invest in the stock market per month if the stock market monthly average return is 0.83% ? Assume you bought a stock at $60 and 4 months later, you sold it for $80 dollars. Assume no dividends and no transaction commission costs i. What is your holding period return both in dollars and in percentage? ii. What is your Effective Annual Return in percentage? Answer all questions using Excel functions, no mathematical solutions. All answers must be done using PV, FV, Rate, PMT functions of Excel in arder to get full 50 points