You are making a $120,000 investment and feel that a 20 percent rate of return is reasonable given the nature of the risks involved. You feel you will receive $48,000 in the first year, $54,000 in the second year, and $56,000 in the third year. You expect to pay out $12,000 as an additional investment in the fourth year.
What is the net present value of this investment given your expectations? Provide detailed calculations of Excel functions used.