Microsoft Excel Training Course

Depreciation and Tax Deductions Associated with Granny Flats

Working Out Your Depreciations with Excel

Ok, so you may or may not have the room for a granny flat, but either way, Excel is the foremost tool for forecasting financial investments.

If you have the room, building a granny flat on your property can prove to be very lucrative. EzyLearn has recently created a new Microsoft Excel exercise, using the construction of a granny flat as a case study, which forms part of our online Excel Training Course.

It was created to help students understand how to use Excel for financial forecasting, but it’s also useful to those interested in constructing a granny flat on their property.

Costs that will be depreciated

In a recent post, we mentioned claiming depreciation on the property’s existing dwelling. If the existing dwelling on your property is rather old, it may not be able to be depreciated. Depreciation rates are determined by the ATO, while an quantity surveyor will be able to determine the value of your dwelling. The cost of the new granny flat will be depreciated over time. Keep in mind that individual elements of the granny flat, such as the floorings, can also be depreciated in addition to the capital structure.

Most expenses can be deducted

The ATO has a long list of expenses relating to rental properties that can be deducted. If you visit their website, you’ll find that most expenses relating to a rental property can be claimed as a tax deduction, depending on the type of rental property. If your granny flat is intended as a long term rental, as the granny flat in our case study is, then nearly all expenses, including the demolition of the old garage and other capital works can be deducted right away.

***

How you treat these expenses and depreciable assets is covered in the granny flats case study of our Microsoft Excel Training Course. Visit our website for more information on our full suite of training courses.

***

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Jerry knows all about email..

Jerry Lame is a serial entrepreneur and loves shiny new objects. He was a corporate…

2 weeks ago

I’m not sure what to say..

Have you ever been in that situation? There's lots going on and you have a…

2 weeks ago

Do you need to learn Email Marketing?

I must admit that I have written a lot about email marketing lately and it's…

2 weeks ago

New menu items have been added for ‘Customers & leads’ and ‘Budgets’

There have been some big changes in Intuit QuickBooks Online navigation that have given our…

3 weeks ago

Why MYOB makes you log in after inactivity

Have you noticed a change in how MYOB makes you login? They're starting to do…

3 weeks ago

Are you Selling Your Property?

They say that Spring is the season to sell your home but is that the…

4 weeks ago