Scribd Logo
Upload

Welcome to Scribd!

  • 113 views

    Rental Cash Flow Analysis

    Uploaded by

    9rbbpd2rmy

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Rental Cash Flow Analysis

    Uploaded by

    9rbbpd2rmy
    113 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    113 views3 pages

    Rental Cash Flow Analysis

    Uploaded by

    9rbbpd2rmy

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    Rental Property Cash Flow Analysis by Vertex42.

    com
    [Property Description] © 2015-2019 Vertex42 LLC
    [42]
    HELP
    Monthly Operating Income Scenario A Scenario B
    Number of Units 5 6 Edit the light blue cells.
    Average Monthly Rent per Unit
    Total Rental Income 236,768.00 76,560.00 The example in Scenario A is only included
    % Vacancy and Credit Losses 50.00% 7% to show how to enter data. It should not be
    Total Vacancy Loss 118,384.00 64,308.00 used as a guide for what numbers to include
    Other Monthly Income (laundry, vending, parking, etc.) 485.00 in your own analysis.
    Gross Monthly Operating Income 118,869.00 12,252.00
    TO PRINT: Hide this column first.
    Monthly Operating Expenses
    Property Management Fees 416.00 416.00 ← Don't forget these are MONTHLY numbers.
    Repairs and Maintenance 1,824.00 1,824.00
    Real Estate Taxes 4686 4686
    Rental Property Insurance 1,592.00 1,592.00
    Homeowners/Property Association Fees
    Replacement Reserve
    Utilities 1,022.00 1,022.00 ← Unhide the rows below this one to list specific utilities.
    - Water and Sewer
    - Gas and Electricity
    - Garbage
    - Cable, Phone, Internet 50.00 50.00
    Pest Control
    Accounting and Legal
    Advertising
    Monthly Operating Expenses 9,590.00 9,590.00

    Net Operating Income (NOI) Related Templates


    Total Annual Operating Income 1,426,428.00 147,024.00 ► Home Mortgage Calculator
    Total Annual Operating Expense 115,080.00 115,080.00 ► Home Affordability Calculator
    Annual Net Operating Income 1,311,348.00 31,944.00 ► Financial Calculators

    Capitalization Rate and Valuation


    Desired Capitalization Rate 7% 6.00%
    Property Valuation (Offer Price) 18,733,542.86 532,400.00
    Actual Purchase Price 150,000.00
    Actual Capitalization Rate 874.23% -

    Loan Information
    Down Payment 50,000.00
    Loan Amount 2,460,000.00 -
    Acquisition Costs and Loan Fees 77,025.00
    Length of Mortgage (years) 30
    Annual Interest Rate 4.250%
    Initial Investment 127,025.00 -
    Monthly Mortgage Payment (PI) 12,101.72 -
    Annual Interest 103,748.34 -
    Annual Principal 41,472.31 -
    Total Annual Debt Service 145,220.66 -

    Cash Flow and ROI


    Total Monthly Cash Flow (before taxes) 97,177.28 2,662.00
    Total Annual Cash Flow (before taxes) 1,166,127.34 31,944.00
    Cash on Cash Return (ROI) 918.03%

    Note: This spreadsheet should only be used for informational and educational purposes. Please verify
    calculations and seek professional assistance before making financial decisions.
    Rental Cash Flow Analysis © 2015-2019 by Vertex42.com
    Rental Cash Flow Analysis

    By Vertex42.com
    https://www.vertex42.com/ExcelTemplates/rental-cash-flow-analysis.html
    calculations and seek professional assistance before making
    financial decisions.

    © 2015-2019 Vertex42 LLC


    content is a copyrighted work under the United States and other
    copyright laws.
    Do not submit copies or modifications of this template to any
    website or online template gallery.
    Please review the following license agreement to learn how you
    may or may not use this template. Thank you.

    License Agreement
    https://www.vertex42.com/licensing/EULA_privateuse.html

    Do not delete this worksheet

    You might also like