yes it can be done in excel i just d-f

C. I want to draw $500/month for five years out of an investment. The investment will earn 10%. How much do I need to have before I start drawing? d. I want to have $1,000,000 in my retirement fund. I can contribute $200/month. I can make 10% on my investment. How many years before I reach my goal? e. I want to make 15% on my investment and someone agrees to pay me $10,000 in seven years, what is the most I should pay for that investment today? f. I have $5,000 today. I plan on investing an additional $250/month for the next five years. Then after five years of investing, I plan to leave the funds untouched for another 20 years. How much will I have in 25 years if I make 12%/year, compounded monthly, on all my money? 17. Solve the following time value of money problems (assume all annuities are ordinary annuities and unless stated differently, assume values are annual): 4 points each (24 points) a invest $500 today, earn 10% and leave it invested for 8 years. What will it grow to? py 500 N=8 IV=1071 I% 10 b. Tinvest $500 today, it grows to $1,000 in 10 vears. What was my annual rate of return (display as a percentage to one decimal position)? FEP ( 7.2% 10% Woo 500 (1+r) o c I want to draw $500/month for five years out of an investment. The investment will earn 10% How much do I need to have before I start drawing? d. I want to have $1,000,000 in my retirement fund. I can contribute $200/month. I can make 10% on my investment. How many years before I reach my goal? e. I want to make 15% on my investment and someone agrees to pay me $10,000 in seven years, what is the most I should pay for that investment today? f. Thave $5,000 today. I plan on investing an additional $250/month for the next five years Then after five years of investing, I plan to leave the funds untouched for another 20 yea How much will I have in 25 years if I make 12%/year, compounded monthly, on all my money? On my honor, I pledge that I have upheld the Honor Code, and that the work I have done on this has been honest and that the work of others in this class has, to the best of my knowledge, beer