A project has an initial cost of $162,000 and an estimated salvage value after 14 years of $76,000.Estimated average annual receipts and distributions will be uniform for the 15 years, compute the prospective rate of return before taxes.

Use excel to answer this question and show your work.