Given the following information regarding an income-producing property, determine the NPV using levered cash flows in your analysis: required equity investment: $240,000; expected NOI for each of the next five years: $139,000; debt service for each of the next five years: $105,000; expected holding period: five years; required yield on levered cash flows: 16%; expected sale price at end of year 5: $1,900,000; expected cost of sale: $120,000; expected mortgage balance at the time of sale: $1,400,000.

Using Excel