Please use excel spreadsheet and show formula input.

29. Transit Insurance Co. has made an investment in another company that will guarantee it a cash flow of $37,250 each year for the next 5 years. If the company uses a discount rate of 15%, what is the present value of this investment? a) $124,868 b) $101,766 c) $251,154 d) $186,250