jagomart
digital resources
picture1_Investment Property Calculator 1


 144x       Filetype XLSX       File size 0.06 MB       Source: www.mckinleyplowman.com.au


File: Investment Property Calculator 1
the mp investment property analyser is an essential tool used to assess the affordability of purchasing an investment property this calculates not only the potential tax benefits but also determines ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
                                       The ‘MP+ Investment Property Analyser’ is an essential tool used to assess the affordability of purchasing an investment property.  This 
                                       calculates not only the potential tax benefits but also determines the weekly cash outlay required to fund the property.  By understanding the net 
                                       cash contributions required for a particular property, an amateur or experienced investor can identify and manage any deficiencies in their budget.  
                                       The 'MP+ Investment Property Analyser' also facilitates the development of a long term investment strategy by quantifying the capital growth 
                                       needed for a property investment to be profitable.  Please feel free to update the sample calculation below by completing steps 1, 2 & 3, to analyse 
                                       your next investment property acquisition.
                                       What is the on-going cash contribution required to pay for an investment property?
                                       Use the 'MP+ Investment Property Analyser' to estimate the on-going cashflow required to own an investment property.
                                       Adjust the light orange cells only to analyse your investment options. Refresh the page with F5 to reset the sheet to default
                                       values, also feel free to download the spreadsheet using the link at the bottom.
                                                                      Example Field To Edit           Calculated Value           Subtotals and Totals
                                                            Step 1                                               Step 2
                                                              Price of land                    $ 220,000          Your Income   $80,000
                                                              Price of house                   $ 179,960          Tax Rate      31.5% (inc. Medicare levy)
                                                              House & Land Package             $ 399,960 
                                                              Interest only loan               $ 399,960           For every $1,000 of negative gearing you will 
                                                                                                                           receive a tax saving of $315.
                                                              Interest rate                     6.65%
                                                            Step 3
                                                                                   Income:
                                                                                   Rent received (per annum)                 $ 20,800 
                                                                                   Annual Cash Inflow                        $ 20,800 
                                                                                   Expenses:
                                                                                   Bank fees and charges                       $ 395 
                                                                                   Borrowing costs (claim over 5 years)        $ 120 
                                                                                   Council rates                              $ 1,000 
                                                                                   Interest expense                          $ 26,597 
                                                                                   Insurance                                   $ 650 
                                                                                   Postage, stationery & telephone             $ 60 
                                                                                   Property agents fees                       $ 1,800 
                                                                                   Repairs & maintenance (non-capital)         $ 250 
                                                                                   Strata levies                               $ 100 
                                                                                   Travel expenses                             $ 500 
                                                                                   Water charges                               $ 700 
                                                                                   Annual Cash Outflow                       $ 32,172 
                                                                                   Tax Adjustments:
                                                                                   Depreciation (building)                    $ 4,049 
                                                                                   Depreciation (chattels)                    $ 2,699 
                                                                                   Total Non-Cash Deductions                  $ 6,749 
                                                                                   Total Negative Gearing                    $ 18,121 
                                                                                   Estimated Tax Savings                      $ 5,708 
                                               It is estimated that $108.93 is the effective net contribution required to cover the cost of owning 
                                                  the investment property. This means a mininmum annual capital growth rate of only 1.42% 
                                                       would be enough to produce an overall profit on your rental property investment!
                                       The MP+ Investment Property Analyser has determined an estimated tax benefit, effective net contribution and minimum capital growth rate based 
                                       on your inputs and certain assumptions.  We recommend that you seek professional advice to interpret these results and assumptions in 
                                       conjunction with developing a sustainable investment strategy that suits your long term goals.  If you would like further information and / or would 
                                       like to know more about McKinley Plowman please visit our website at www.mckinleyplowman.com.au or contact our offices on +61 8 9301 2200. 
                                                                                                         © Copyright 2012 - All rights reserved
The words contained in this file might help you see if this file matches what you are looking for:

...The mp investment property analyser is an essential tool used to assess affordability of purchasing this calculates not only potential tax benefits but also determines weekly cash outlay required fund by understanding net contributions for a particular amateur or experienced investor can identify and manage any deficiencies in their budget facilitates development long term strategy quantifying capital growth needed be profitable please feel free update sample calculation below completing steps analyse your next acquisition what ongoing contribution pay use estimate cashflow own adjust light orange cells options refresh page with f reset sheet default values download spreadsheet using link at bottom example field edit calculated value subtotals totals step price land income house rate inc medicare levy package interest loan every negative gearing you will receive saving rent received per annum annual inflow expenses bank fees charges borrowing costs claim over years council rates expens...

no reviews yet
Please Login to review.