All Topics / The Treasure Chest / re cashflow spreadsheet

Viewing 1 post (of 1 total)
  • Profile photo of peterppeterp
    Member
    @peterp
    Join Date: 2003
    Post Count: 307
    March 12, 2003 - 7:22 am

    G’day Graham – I have done something like this myself, though it doesn’t calculate loan repayments – only cash flow position for a given rent and property value (loan = 80% of value).

    My headings are as follows:

    Purchase Price
    Deposit
    Amt borrowed

    INITIAL PURCHASE COSTS
    Deposit
    Prop stamp duty
    Loan stamp duty
    Loan app fee
    Contingencies

    CONTINUING INCOME
    Monthly rent
    Weeks/year occupied
    Total income

    CONTINUING EXPENSES
    Loan payments/mth
    Prop manager
    Body corporate
    Insurances
    Rates/water
    Maintenance allowance
    Total pre-tax expenses

    CONTINUING TAX DEDUCTIONS
    Loan interest
    Property management
    Body corporate fees
    Insurances
    Post 1985 bldg depreciation
    Rates/water
    Total tax deductions

    TOTAL AFTER TAX EXPENSES

    CASHFLOW PER MONTH

    YIELD %

    Peter

Viewing 1 post (of 1 total)

The topic ‘re cashflow spreadsheet’ is closed to new replies.