*REQUEST* can it be shown on excel along with formulas

Compute the requested value(s) for each scenario. Show all component numbers that factor into determination of the final answer(s) in separate cells. a. You have determined that $120,000 will be required 18 years from now to help pay for your daughter's higher education. If your bank is paying 6.25% annual rate of return on its 'College Opportunity' account, how much must you deposit each quarter to reach your goal? (2 points) b. Your brother in-law is offering to pay you $40,000 ten years from now in exchange for a $15,000 investment today. If you accept his offer, what annual rate of interest would you earn on your investment? ( 2 points) c. You plan to retire in 12 years and move to Cabo San Lucas where you have your eye on a nice beach house. The current market value of the house is $100,000 and the annual appreciation rate is 5.00%. If you can earn 7.50% annual rate of return on your Z-Trade investment account, how much must you invest at the end of each month for the next 10 years to be able to buy your dream home upon retirement? (2 points) d. Your credit card carrier is offering loans at 22.00% compounded annually or 20.00% compounded monthly. Which loan alternative is the most attractive? (2 points) e. Starting eleven years from now you would like to withdraw $24,000 a year for a period of 5 years (years 11 through 15) plus the additional amount of $40,000 in year 15. Assuming an interest rate of 8.00%, how much must you deposit today to make these future withdrawals a reality? (4 points)