Please provide help with the attached document for a business finance class

Business 2210 Unit 2 Project- Solution You Must Demonstrate Computational Support To Receive Any Credit 1. (10 Points) Bill starts a retirement fund at age 21 and plans on depositing equal annual amounts on each birthday, starting at age 21, and ending at age 60. He wants to have $2 million at age 60. John starts his fund on his 30th birthday. He wants to deposit equal annual amounts on each birthday starting on his 30th birthday and ending on his 60th birthday. John wants to have $2 million at age 60. If the investment funds earn 10% per year, calculate the amounts the Bill and John respectively will have to save each year (rounded to the nearest dollar) to meet their goals. Comment on the difference. 2. (8 Points) A retirement home in Florida costs $200,000 today. Housing prices in Florida are increasing at a rate of 4% per year. Joe wants to buy the home in 8 years when he retires. Joe has $25,000 right now in a savings account paying 8% interest per year. Joe wants to make eight equal annual deposits into the savings account starting today. How much must each deposit be so Joe will have enough money in his savings account to buy the retirement home when he retires? 3. (8 Points) Frank Zanca is considering three different investments that his broker has offered to him. The different cash flows are as follows: End of Year 1 2 3 4 5 6 7 8 A 300 300 300 300 B C 400 300 300 300 300 300 600 600 Because Frank only has enough savings for one investment, his broker has proposed the third alternative to be, according to his expertise, "the best in town." However, Frank questions his broker and wants to calculate the present value of each investment. Assuming a 15% discount rate, what is Frank's best alternative? 4. (8 Points) Answer the questions below using the following information on stocks A, B, and C. A B C Expected Return 20% 21% 10% Standard Deviation 12% 10% 10% Beta 1.8 2.2 0.8 Assume the risk-free rate of return is 3% and the expected market return is 12% a. Calculate the required return for stocks A, B, and C. b. Assuming an investor with a well-diversified portfolio, which stock would the investor want to add to his portfolio? c. Assuming an investor who will invest all of his money into one security, which stock will the investor choose? Not a diversified portfolio, ownership of one security. 5. (8 Points) Redesign Corp. is considering a new strategy that would increase its expected return from 12% to 13.9%, but would also increase its beta from 1.2 to 1.8. The risk-free rate is 5% and the return on the market is expected to be 10%. Should Redesign change its strategy? 6. (8 Points) Use the following data: Market risk premium = 10% Risk-free rate = 2% Beta of XYZ stock = 1.6 Beta of PDQ stock = 2.4 Investment in XYZ stock = $15,000 Investment in PDQ stock = $60,000 You have no assets other than your investments in XYZ and PDQ stock. What is the expected return of your portfolio? Show all work