Calculate the breakeven point for the project

Assignment Help Cost Accounting
Reference no: EM132655680

Case Study: Airbnb in Hobart

  • Denise, an Australian resident, is a self-funded retiree from Sydney, who is planning, this year, on moving to Hobart and purchasing a home. This will be the first home she had ever purchased. She has been looking at three-bedroom, two-bathroom properties with parking for three cars, and a reasonably sized outdoor entertaining area. Her plan is to live in the property, while letting two of the bedrooms as Airbnb, for up to 4 guests. Currently, she has $700,000 in her account with the Commonwealth Bank. As she has an income stream from her investments of $4,000 per fortnight, she is prepared to put up to $450,000 of her savings (but is somewhat flexible with this figure) towards the purchase of the property, making up the short-fall with a bank-loan. The Commonwealth Bank has already pre-approved her for a home loan of up to $350,000. However, of course, she would like to take on the lowest debt possible, while making the highest possible profit from the Airbnb.

Denise has now approached you, a highly capable Hobart team of management and cost accountants, with an excellent professional reputation, and extensive knowledge of local council regulations. She asks you to research the financial viability of the proposed project and has provided you with two options:

OPTION A:

  • An almost brand-new, high-end property, of 260m2, in Sandy Bay, on the market for $750,000, including all furnishings and fittings. It meets all of Denise's criteria, has magnificent views over the Casino, and is in close proximity to thecentral business district (CBD), while having the added advantage of the two guest bedrooms with ensuite bathrooms, a second lounge and kitchenette being located on the ground floor, thereby affording privacy to both herself and her guests. It also has 15 solar panels,[1] providing 4,950 Wof power, uses energy-efficient LED lights, providing a $380 saving on the normal quarterly electricity bill, of $900, and has a 3000 litre rain-water tank, for flushing toilets and watering the garden. While the outdoor area is big enough for entertaining guests, there is no room for a vegetable garden. This property is already operating as an Airbnb, bringing in $250, per room, per night, with a pre-Covid occupancy rate of 99%. The annual council rates are $2,500, and insurance to cover the property, including lability insurance for the Airbnb guests, and all fixtures and fittings is $1,800 per annum.

OPTION B:

A spacious, 200 m2, older property in Berriedale, priced at $450,000, with a lovely outlook over the river, and in close proximity tothe popular MONA (art gallery). It meets all of Denise's basic criteria, although all three bedrooms are located on the one level, and the property is in need of a total renovation, to make it fit for purpose. Denise has received an estimate of approximately $150,000 for the renovation work, with an additional $40,000, approximately, for painting, decorating, furnishing, and landscaping, to create dedicated outdoor entertainment area. This property has not been used as an Airbnb, but similar Airbnbs in the area earn up to $200, per room, per night. The annual council rates are $1,200, and the insurance to cover the property, including liability insurance for the Airbnb guests, and all fixtures and fittings, is $1,000 per annum. The quarterly power bill is currently $450. Denise wants to change to energy-efficient LED lighting, at a cost of $80. This should save her up to $180 on her quarterly power bill. She has also obtained a quote for $6000, for installing solar panels (4,950 W), which will lower her quarterly bill by a further $300, and another for $950, for a 3000 litre rain-water tank for the toilets and watering the garden. The property has a large back garden which is already set up for raising chickens and growing vegetables. There are also a dozen different fruit trees. Denise estimates that for an annual outlay of $200 for feed and fertilisers, she could be self-sufficient in eggs, fruit and vegetables.

Required

a) provide estimates/answers, for each option, for the following questionsusing an excel file (Reference all material taken from other sources)

Problem 1. Calculate the breakeven point for the project?

Reference no: EM132655680

Questions Cloud

Explain how public policy is formed in american system : Explain how public policy is formed in the American system of government. How is the problem identified?
Compute the Alberts net tax payable : Martin and Michele received $400 interest on Montgomery County (Virginia) school bonds. Compute the Alberts net tax payable
Explain the evidenced-based psychotherapy : Explain the diagnostic criteria for your assigned anxiety disorder. Explain the evidenced-based psychotherapy and psychopharmacologic treatment for your.
Impact of the same on the foreign reserves : What do you think of the impact of the same on the foreign reserves." Comment on this statement with the help of an IS-LM diagram.
Calculate the breakeven point for the project : Denise has now approached you, a highly capable Hobart team of management and cost accountant. Calculate the breakeven point for the project?
Police departments use of force policies : From the e-Activity, suggest three measures that are recommended by either protocol, other police departments' use of force policies,
How much you are ready to pay for reliance zero coupon : How much you are ready to pay for Reliance Zero coupon bond INR 1,000 (face value) with the maturity period 10 years and YTM 8%.
Determine the tax consequences to Vic : The Land Company, which had sold land to Vic for $80,000, reduced the mortgage on the land by $12,000. Determine the tax consequences to Vic
What you understand by economic development : In 1994, South Africa's government inherited this country with several unresolved matters from the apartheid system.

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd