A Real-Life Granny Flat Construction Scenario
Choosing between a one-bedroom and two-bedroom granny flat is a decision you’ll need to make early on in the project, and it’s largely a financial one.
EzyLearn’s Microsoft Excel Training Course includes a new case study, “Investing in a Granny Flat”, which uses the construction of a granny flat as a real life example to help you to better understand how to develop a financial forecast for an investment.
Determine construction and ancillary costs
How much it will cost to construct both a one-bedroom and two-bedroom granny flat is the first step. You need to work out how much it will cost to get each granny flat constructed to the point that someone can move in, as well as any ancillary costs, like council fees and levies, real estate management fees interest rates and so forth.
Determine rental income
Some granny flat companies will give you rental income estimates, but you’re encouraged to investigate this yourself. Rental incomes are heavily dependent on your local area and the demand for that type of property. In Sydney, the demand for rental property far outweighs the demand in regional NSW. Take into consideration vacancy rates in the area and the types of property that are in demand. Areas with high vacancy rates and low demand for one-bedroom units could indicate there’s little demand for a permanently rented one-bedroom granny flat, which will put the rent down.
Determine depreciation amounts
Both granny flats will be subject to the same depreciation rate, however the amounts will differ due to the differing value of each dwelling. In addition to an annual depreciation rate on the dwelling, consider other elements of the granny flat that will also be subject to depreciation. Floor coverings, for example, can be depreciated over time. Carpeting is typically depreciated at a rate of 20 percent, where tiles are depreciated at 2.5 percent because the latter has a longer lifespan.
Determine the best investment
Add all of these costs into Excel to determine the average annual rental yield, expressed as a percentage of the property value. Rental yields are used to show the return on an investment. The higher the rental yield, the better the return is. Taken in combination with your own personal circumstances and plans for the future should help you to determine which option represents the better investment.
***
Our Microsoft Excel training courses, featuring the new granny flat case study, go into much greater detail. Or view our full suite of training courses.
***
At EzyLearn, we’re committed to helping students of all our courses find better employment opportunities, become their own boss and upskill. To this end, we constantly update our courses with new, highly relevant content — it’s why we provide you with the option of Lifetime access you can always refer back to our courses as you progress in your skills’ development.
We’re thrilled to announce our new Micro Courses which are be added to our existing courses, or can be purchased alone. These are based on real-life case studies and relate to real people in genuine, real-life scenarios. Subscribe to our blog and be alerted of updates.
Although the process of running a P&L differ between accounting software packages, they usually all contain the same elements, depending only on the business itself. In the first section, the cost of sales is subtracted from the revenue, which highlights gross profit. The business’ operating expenses are then subtracted from the gross profit, which leaves the operating profit. Now, all of the non-operating revenues and expenses must be factored into account, after which the business’ profit or loss will be displayed. 
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.
Although I’ve had some exposure to Salesforce when I originally spoke to that company (many years ago and much has probably changed) they only offered yearly plans (but showed them as a low monthly fee) and the upfront cost was too high so I didn’t go down that path.
I had the pleasure of meeting Reece, the managing director of CreataCRM, at Cebit 2016 and was amazed I’d never heard of this company before.
Following his $1 billion innovation announcement in December, Prime Minister Malcolm Turnbull received quite a grilling on the ABC program 7.30, hosted by Leigh Sales, who brought up one of the most widely criticised initiatives of the Abbott-Turnbull Coalition government: the NBN. 
