Canadian Realestate Magazine forum is the place for positive industry interaction and welcomes your professional and informed opinion.

Rental income cash flow calculator

Notify me of new replies via email
N.VanPeter | 19 Jan 2015, 04:53 PM Agree 0
I'm looking for a rental income cash flow calculator or spreadsheet. Please let me know if you have one or know where I can find one?

Thanks
  • Jaf | 20 Jan 2015, 02:38 PM Agree 0
    Hello

    I'm looking for a rental income cash flow calculator or spreadsheet. Please let me know if you have one or know where I can find one?

    Thanks
  • GS | 02 Feb 2015, 01:13 AM Agree 0
    Here is one that can help you


    Property Info

    Address:____________________________ Type:______________________

    Purchase Price -----> $90,000 OPERATION COSTS: Annual Cost
    Down Payment -----> $18,000
    Other Acq. Costs --> $2,700 Management $900
    Cash In > $20,700 Accounting $100
    Annual Legal
    INCOME FROM OPERATIONS: Potential Occupied Repairs $1,600
    # of Units Mnthly Rent Annual Occup % Income Maintenance $800
    Calculations 4 $- 90 $0 Insurance $900
    3 $- 85 $0 Janitorial
    2 $- 95 $0 Supplies
    1 $1,200.00 $14,400 100 $14,400 Prop/op taxes $1,000
    $- $- 100 $0 Other $900
    $- $- 100 $0 $0
    $- $- 100 $0 $0
    $0
    Vacancy & credit loss % as whole #, will convert to % ---> 2 $0
    $0
    Gross Potential Income ---------------> $14,400 $0

    Gross Operating Income -------------> $14,112 Total Operating Exp ----> $6,200

    Gross Rent Multiplier or GRM -----> 6.25 Net Operating Income -> $7,912

    Cash Flow Before Taxes (CFBT) Capitalization Rate -> 8.8%

    Net Operating Income -> $7,912 ST/Fed Income Tax = $3,300
    Enter Debt Service ----->
    Capital Expenditures --> Cash Flow After Taxes (CFAT) ------> $4,612
    Loan Proceeds In ------->
    Interest Earned In ------> Break-Even Ratio ---> 44%

    CFBT -------> $7,912 Return on Equity Year One -------------> 22.3%

    ** Note You fill in yellow areas Blue/green areas are calculated for you

    Linked text takes you to an online article explaining the calculation.
    • N.VanPeter | 07 Feb 2015, 04:42 PM Agree 0
      Thanks GS, can this info be found on a web site or spreadsheet?
  • Gerry | 05 Feb 2015, 02:08 AM Agree 0
    BiggerPockets.com
    • N.VanPeter | 07 Feb 2015, 04:42 PM Agree 0
      Thanks Gerry, I'll check it out!
Post a reply