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

Top 5 Things Small Businesses Must Do Before June 30 to Get Their EOFY Accounting in Order

As the end of the financial year (EOFY) approaches in Australia, small business owners need…

3 days ago

How EzyLearn Gets Xero Skills Into Your Brain (So They Stick!)

[A casual chat between two friends – Sam, a job seeker wanting to upskill, and…

1 week ago

Mastering Xero with EzyLearn: Building Confidence Through Practical Learning

In today's digital landscape, proficiency in cloud-based accounting software like Xero is essential for professionals…

2 weeks ago

Xero gives itself a 90% high distinction – users disagree

Have you seen the recent ads promotion 90+ % approval from their customers? The claims…

4 weeks ago

Intuit QuickBooks Course updates coming – features and navigation changes

Intuit is hunting for ways of helping their software become more relevant to Australian small…

4 weeks ago

Another price increase from Xero – 4 straight years of price increases sends social media mad?

It's interesting how negative the sentiment is on Linkedin and Facebook when you start seeing…

1 month ago