1. What is the value today of receiving $300,000 in ten years if the discount rate is 5.5% compounding monthly? What is the value if the discount rate is 5.25% compounding quarterly? Make a data presentation for this problem and calculate the answers by formulae.

2. What interest rate per year, compounded monthly, is equivalent to an annual interest rate of 16 % compounded 1 time per year? Make a data presentation for this problem and calculate the answer by formula. Paste your formula so it is visible beside the cell with the answer.

Answer using Excel