A real estate developer is considering investing in a residential property. The property has an estimated purchase price of $$500,000$ and is expected to generate rental income of $$50,000$ per year for the next $10$ years. The developer wants to estimate the probability of achieving a net present value $($NPV$)$ greater than zero using a Monte Carlo simulation. Assume a normal distribution for the annual rental income with a mean of $$50,000$ and a standard deviation of $$5,000.$ Use a discounted rate of $10\%$ in your NPV calculation.

Perform a Monte Carlo simulation with $10,000$ iterations to estimate the probability of obtaining a positive NPV for the residential property. Can someone help me to calculate the NPV $?$ i have hard time to do the formula on EXCEl.