Scribd Logo
Upload

Welcome to Scribd!

  • 112 views

    Income Property Cash Flow3

    Uploaded by

    CraigFrazer
    This cashflow analysis worksheet summarizes the financial projections for a rental property over 5 years. It includes estimates for rental income and expenses, mortgage details, depreciation amounts, taxable income and liability calculations, and before and after tax cashflow. The analysis assumes annual rent increases of 1.5%, steady expenses, and tax rates of 25% for cost recovery and 15% for capital gains.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Income Property Cash Flow3

    Uploaded by

    CraigFrazer
    112 views1 page
    This cashflow analysis worksheet summarizes the financial projections for a rental property over 5 years. It includes estimates for rental income and expenses, mortgage details, depreciation amounts, taxable income and liability calculations, and before and after tax cashflow. The analysis assumes annual rent increases of 1.5%, steady expenses, and tax rates of 25% for cost recovery and 15% for capital gains.

    Original Description:

    More detailed spreadsheet example for purposes of calculating ROI for real estate investments.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This cashflow analysis worksheet summarizes the financial projections for a rental property over 5 years. It includes estimates for rental income and expenses, mortgage details, depreciation amounts, taxable income and liability calculations, and before and after tax cashflow. The analysis assumes annual rent increases of 1.5%, steady expenses, and tax rates of 25% for cost recovery and 15% for capital gains.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    112 views1 page

    Income Property Cash Flow3

    Uploaded by

    CraigFrazer
    This cashflow analysis worksheet summarizes the financial projections for a rental property over 5 years. It includes estimates for rental income and expenses, mortgage details, depreciation amounts, taxable income and liability calculations, and before and after tax cashflow. The analysis assumes annual rent increases of 1.5%, steady expenses, and tax rates of 25% for cost recovery and 15% for capital gains.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    Cashflow Analysis Worksheet

    Property Address
    Date of Analyis

    Mortgage Data Cost Recovery Data


    First Second
    Mortgage Mortgage Purchase: $200,000
    Down Payment 10% $20,000 N/A Value Allocation: 80%
    Amount Financed -$180,000 $ - Depreciable Asset: $160,000
    Interest Rate (Annual) 4.75% 7.500% Acquisition Costs: $8,000
    Term (Months) 360 180 Recovery Type: Straight Line
    Payments/Yr 12 12 Useful Life: 27.5
    Periodic Payment $938.97 $0.00 In Service Date: Jan
    Annual Debt Service $11,268 $0 Recapture: None

    Taxable Income
    Year 1 2 3 4 5
    1 Potential Rental Income $15,000 $15,225 $15,453 $15,685 $15,920
    2 - Vacancy & Credit Losses $1,200 $1,218 $1,236 $1,255 $1,274
    3 = Eff. Rental Income $13,800 $14,007 $14,217 $14,430 $14,647
    4 + Other Income
    5 = Gross Operating Inc $13,800 $14,007 $14,217 $14,430 $14,647
    6 - Operating Expenses $2,070 $2,075 $2,080 $2,086 $2,091
    7 = Net Operating Inc $11,730 $11,932 $12,137 $12,345 $12,556
    8 - Interest 1st Mortgage $8,490 $8,355 $8,214 $8,066 $7,910
    9 - Interest 2nd Mortgage $0 $0 $0 $0 $0
    10 - Depreciation - Improvements $5,576 $5,818 $5,818 $5,818 $5,818
    11 - Depreciation - Personal Property
    12 - Acquisition Costs (Amortized) $267 $267 $267 $267 $6,933
    $6,933
    13 - Other
    14 = Gain/(Loss) Before Taxes ($2,603) ($2,508) ($2,161) ($1,805) ($8,105)
    14a Suspended Loss Current Year $0 $0 $0 $0 $0
    14b Suspended Loss Carryover N/A $0 $0 $0 $0
    14c Cumulative Suspended Losses $0 $0 $0 $0
    14d = Taxable Gain/(Loss) ($2,603) ($2,508) ($2,161) ($1,805) ($8,105)
    15 Tax Liability ($651) ($627) ($540) ($451) ($2,026)

    Before & After Tax Cashflow


    16 Net Operating Income $11,730 $11,932 $12,137 $12,345 $12,556
    17 - Annual Debt Service $11,268 $11,268 $11,268 $11,268 $11,268
    18 - Other
    19 - Other
    20 =Before Tax Cashflow $462 $664 $869 $1,077 $1,288
    21 - Tax Liability ($651) ($627) ($540) ($451) ($2,026)
    22 + Investment Tax Credit
    23 = After Tax Cashflow $1,113 $1,291 $1,409 $1,528 $3,315

    Assumptions
    Change in Rents N/A 1.5% 1.5% 1.5% 1.5%
    Annual Vacancy Estimate 8.0% 8.0% 8.0% 8.0% 8.0%
    Change in Expenses N/A 0.3% 0.3% 0.3% 0.3%
    Tax Rate Cost Recovery 25.0% 25.0% 25.0% 25.0% 25.0%
    Tax Rate Capital Gain 15.0%

    You might also like