Calculate Average Monthly Cashflow on Rental Property Step 1: Set Up Your Excel Sheet Open a New WorkbookCreate a new spreadsheet in Excel. Label these columns: Category Value Enter Basic DetailsAdd these values: Purchase Price: $200,000 Monthly Rent: $1,400 Down Payment (Equity): $40,000...
Calculate the rental yield of a property using our easy-to-use rental yield calculator. Knowing the rental yield can determine if the property is a good investment.
To run this formula in an Excel spreadsheet, it looks like this: =P*(1+(r/n)^(n*t) To use the latest example from above, with a 15% return compounded monthly for five years, the Excel formula would read like this: =1000*(1+0.15/12)^(12*5) That said, Excel actually has a ...