Show calculations clearly, in excel if possible

MANAGERIAL ACCOUNTING HANDOUT PROBLEM 12 Score Name Section Problem (10 points). Using present value and future value techniques, calculate the indicated amount for each of the following independent cases. Round all calculations to the nearest whole dollar TIME VALUE OF MONEY CASES (1) Smith deposited $8,500 in a savings account that earns interest at an annual rate of 16%, compounded quarterly. The $8,500 and the interest camed must remain in the account for five years before they can be withdrawn. How much money will be in the account at the end of the five years? (2) Smith is planning to open an individual retirement account in which she will invest $3,000 annually at the end of cach year. She plans to retire after making 25 annual investments in a program that cams an annual return of 1 2%. How much will be in the account on the date of the final investment? (3) Smith has decided to establish a fund that will be used after five years to replace a production facility. The company plans to make quarterly contributions of $75,000 beginning in three months. The fund is expected to earn 10% per year, compounded quarterly. How much will be in the fund after five years? (4) Smith Company is considering an investment that will return S103,500 at the end of each year for 14 years. If the company demands an annual return of 14%, how much should it be willing to pay today for the investment