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

Are you 1) Angry, 2) Frustrated or 3) Exhausted trying to use Microsoft Excel?

Master Microsoft Excel one step at a time with the guidance of: Training Workbooks Excel…

3 days ago

How does $20,000 mortgage repayments equate to $47,598.02?

All eyes will be on the announcement from the Reserve Bank Governor today to see…

5 days ago

Cyber Security for Bookkeepers – How are scammers trying to get you

Every contract bookkeeper loves receiving these emails but they can wreak havoc with your computer…

3 weeks ago

Engaging a New Worker? Here Are The Things You Need To Do, particularly if you’re classified by the ATO as a withholder:

There’s lots to do when businesses engage a new worker.  As an employer, you’ll be…

1 month ago

Cert IV in Bookkeeping and Accounting + MYOB and Xero Course TRIO

Not every students needs a Cert IV in Bookkeeping and most business admin and accounts…

1 month ago

COMPLETE Xero Course includes Beginners to Advanced skills

This Xero course is the most popular with job seekers and business owners because it…

1 month ago