*REQUEST* can it be shown on excel along with formuals used

can the problem be done through excel with formulas

1. 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 anntal 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 carn 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 altemative 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) f. On January 1, 1963, a kid from Sioux Falls purchased a limited edition Superman comic at the original market price of 12 cents, On January 1, 1997 (34 years later), the comic was sold at auction for $2,500. What annual rate of return did this kid eam on the comic? ( 2 points) 2. The net cash flows associated with three investments are provided below. Assume that all blank cells represent zero net cash flows. What is the maximum amount you are willing to pay for each investment? Assume an 11.00% discount rate. (6 points) 1. 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 anntal 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 carn 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 altemative 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) f. On January 1, 1963, a kid from Sioux Falls purchased a limited edition Superman comic at the original market price of 12 cents, On January 1, 1997 (34 years later), the comic was sold at auction for $2,500. What annual rate of return did this kid eam on the comic? ( 2 points) 2. The net cash flows associated with three investments are provided below. Assume that all blank cells represent zero net cash flows. What is the maximum amount you are willing to pay for each investment? Assume an 11.00% discount rate. (6 points)