Calculate earnings for Years 1 through 5.
budget an additional $5,000 each year for charges like council dues, strata fees, upkeep, and other expenses.
When you sell the property, pay back the remaining loan balance to your lender.

Complete the underlined cells to produce the nett cash flows for Years 0 through 5.

Complete excel formula Thank you so much.

Down payment Additional fees Rental Income Annual repayment Extra expenses Selling price Outstanding balance. Net cash flow Year 0 Year 1 Year 2 Year 3 Year 4 Year 5