Discounted cash flow valuation Assignment

Part A

Prepare a discounted cash flow spreadsheet analysis reporting the Net Present Value (NPV) and Internal Rate of Return (IRR) results for the potential investor. Assume the investor has sufficient income from her employment to cover any cash shortfalls during the life of the investment. The property will be held for 5 years after purchase. Based on your results, should the investor purchase the investment property? Why or why not? - Formula needs to be showen on EXCEL