Show the Process on Excel Sheet. Solve Both Questions

A. Assume you receive payments from an investment at the end of each year. What is the present value of an investment that promises to pay the following: $240 received at the end of each year for 3 years. Assume an 8% interest rate compounded semiannually. Does your equal payment period match the compounding period?

B. You deposit equal payments of $1000 in the bank for the next ten years. Assume the payments are made at the beginning of each year. Given you will have $18,000 at the end of ten years with quarterly compounding. What is the effective rate, the nominal rate and the periodic rate of this investment? Does your equal payment period match your compounding period?