Working Out Your Depreciations with Excel
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.
Before computers and Microsoft Excel came along, accountants used a pen and paper to keep track of their clients’ business financials. And before that, before the numeral system was invented, the abacus was the main accounting tool used by merchants and traders to keep track of their finances. 
EzyLearn Excel, MYOB and Xero online training courses count towards 
Bank feeds are an important aspect of reconciling your (or your client’s) accounts. Our 
THE INTERNET HAS CHANGED the way businesses market their services to prospects, from a simple sales message to an educational one. 
A lot of our enquiries regarding 
There are several associations for bookkeepers who want to become Registered BAS Agents but the most progressive is the Institute of Certified Bookkeepers. This organisation came from the UK where they are still a leading member group, when the Australian Bookkeeping Industry began the process of regulation and they recognised the benefit of letting their partners use their logo to demonstrate their membership status.
Finally, If you decide you just want to learn how to use the software using practical exercises and following step by step processes that are performed in most companies everyday then enrol into one of our EzyLearn courses. The Certificate we provide is a Certificate of Completion once all our Knowledge Reviews have been completed successfully and these knowledge reviews are at the end of each section of each course. In the MYOB course we have 5 courses.
No matter who you are or what you do you will need content and you will use that content to promote you and the services you provide. I have been using all of these tools to help convert EzyLearn into an “online only” training company in 2006 but I was able to explore how to provide these services to real estate agents when I managed the social media strategy for Derek Farmer, a real estate agent in Cammeray at the time. Here are the content options we had to play with:
EzyLearn has several hundred videos as part of our online training courses and sometimes we use them to give prospective students 
This is the one that EVERYONE is interested in and for good reason; the demographic targeting is fantastic. Facebook is becoming increasingly important for real estate agents to promote themselves — indeed, Social Estate and BuddyBid are just two companies getting in early to earn a couple of hundred dollars a month for each real estate agent they take on board.
Most people think it’s important to create a Facebook post every day but that’s hard to do if you need to generate original content. Instead most people re-post other content that is relevant to the audience — this is often referred to as curated content (for instance, where you make a comment or affirm your belief in an article).
Facebook ads are relatively simple to create so there is NO reason to get someone else to do them (particularly if they’re going to charge you the equivalent of 4 hours’ labour!). The key elements of a Facebook Ad are their structure: Campaigns, Adsets, then individual ads and once you get that right and understand how it works, creating a Facebook Ad can be done by someone in your office or who you trust (again, a work at home mum).
In our Social Media Marketing Course we include every aspect of how to manage your own website using the very popular WordPress Content Management System. This includes having multiple users be able to publish content. We also teach you how to optimise your blogs and pages for important keywords using tags and categories, how to use meta tags on your pages and even on images so everything gets indexed by Google and how to make your website look fantastic with professional themes (templates).
Google Analytics is the most popular website traffic analysing system and you can use it to measure the effectiveness of your website day-by-day, week-by-week and for specific date ranges.
