Lawrence Block is considering investing in a gold coin. The coin costs $ 47,500. He anticipates spending $ 1,000 to have the coins value reevaluated by experts at the end of the first year.
Lawrence believes that he can receive $ 3,500 in exhibitor fees by allowing a major museum to showcase his coin during the second year of ownership. He would like to sell the coin, but he will need to market and promote it first. He anticipates spending $ 2,000 by the end of the third year on the process.
If he can receive $ 50,000 at the end of the fourth year, should Lawrence make this investment if he needs to earn 4.50% on it?
How would I solve using Excel?