Determine the net present value of the projected cash flows

Assignment Help Financial Accounting
Reference no: EM13510332

QUESTION

Health Zone (Pty) Ltd operates ten health clubs in the Western Cape region. The company was established three years ago by its executive directors, and has become a competitive force in the region. Before setting up their own business, the executive directors had worked for another health club group. Health Zone (Pty) Ltd attempts to distinguish itself in the market through its friendly staff and competitive pricing.

Health Zone (Pty) Ltd clubs have similar layouts and facilities that include cardiovascular equipment, free weight areas, circuit training, swimming pools and squash courts. The company would like to expand to other provinces and open another 30 clubs within the next five years.

The company plans to open its first Health Zone (Pty) Ltd club in the Gauteng province on 1 July 2004. A suitable site has been secured in Sandton in an established shopping centre, and Health Zone (Pty) Ltd has entered into a ten-year lease agreement with the landlord for rental of these premises. The financial director of Health Zone (Pty) Ltd has prepared cash flow forecasts for the new Sandton club, which are summarised below:

HEALTH ZONE CLUB, SANDTON
PROJECTED CASH FLOWS
Years ending 30 June 2005 2006 2007 2008 2009
Notes R'000 R'000 R'000 R'000 R'000
Revenue 2 940 4 686 6 723 7 359 8 119
Advertising in clubs 300 330 363 399 439
Membership fees 2 2 640 4 356 6 360 6 960 7 680
Operating costs (3 225) (3 516) (3 660) (3 989) (4 350)
Personnel expenses 3 (1 440) (1 555) (1 680) (1 814) (1 960)
Rental of premises 4 (450) (504) (565) (632) (708)
Water and electricity 3 (330) (363) (399) (439) (483)
Head office charges 5 (300) (324) (350) (378) (408)
Cleaning and security expenses 3 (270) (292) (315) (340) (367)
Sales commission 6 (145) (159) 0 0 0
Maintenance of equipment 7 (40) (44) (48) (53) (58)
Other expenses 3 (250) (275) (303) (333) (366)
Financing costs 8 (823) (846) (674) (262) 0
Interest income 8 0 0 0 0 38
Working capital 9 313 28 30 33 36
Net cash (utilised)/generated (795) 352 2 419 3 141 3 843

Notes

1 Capital expenditure and expenses incurred to date and payable on 1 July 2004:
R'000
Refurbishment of premises 2 200
Purchase of gym equipment 3 000
Market research costs 250
Pre-opening operating costs 250
Sales commission 264
5 964
15

2 The forecast of membership fees are based on the following assumptions:
2005 2006 2007 2008 2009
Number of members 1 000 1 500 2 000 2 000 2 000
Annual fee per member (rand) 2 640 2 904 3 180 3 480 3 840

Members must pay fees monthly in advance. The new club has already signed up 1 000 members largely due to the aggressive marketing drive by the company's sales personnel.

These 1 000 members have contractually agreed to pay R220 a month with effect from 1 July 2004. Membership is only granted for a 12-month period and is renewable annually subject to price escalations.

The financial year of Health Zone (Pty) Ltd ends on 30 June.

3 Personnel expenses, water and electricity, cleaning and security costs and other expenses are fixed costs in nature.

4 Rentals are paid monthly in arrear. Health Zone (Pty) Ltd will also have to pay a rental deposit of R250 000 by 1 July 2004, the start of the rental period. The rental deposit will be refunded at the expiry of the ten-year lease period. The landlord will allow Health Zone (Pty) Ltd to refurbish the premises before 1 July 2004 as the premises are currently vacant.

5 Health Zone (Pty) Ltd has established a head office infrastructure sufficient for support of 40 health clubs on a national basis. The head office responsibilities include identifying suitable sites for new clubs, negotiating leases, opening new clubs, consolidating the financial reporting of individual clubs and overall review of financial performance of clubs. Head office costs are allocated to individual clubs on a discretionary basis.

6 Each Health Zone (Pty) Ltd club employs sales personnel to attract new members and renew memberships annually. Sales personnel are incentivised to sign up new members. Sales commission is set at 10% of the annual membership fees of new members and is paid upfront.
The cash flow forecasts take into account that sales commission is paid annually in advance.

7 Gym equipment is purchased from GymQuip (Pty) Ltd, and a one-year warranty is included in the purchase agreement. GymQuip (Pty) Ltd also maintains the equipment in all of Health Zone (Pty) Ltd's clubs and charges a fixed monthly maintenance fee for doing so. Gym equipment generally has a useful life of five years, and has negligible value at the end of that period.

8 Health Zone (Pty) Ltd funds the establishment and operation of new clubs. Head office loans bear interest and repayment is dependent on operational cash flows. Surplus cash generated by individual clubs is deposited with head office and attracts interest at market related rates.

9 Health Zone (Pty) Ltd clubs generate positive working capital.

10 Tax has not been included in the cash flow forecasts of new clubs since individual clubs have no control over this aspect.

11 Cash flows per the above forecasts are assumed to occur at the end of the financial year. Although this assumption is conservative, it is consistent with head office capital budgeting policy.

Health Zone (Pty) Ltd requires that new clubs achieve a 20% pre-tax rate of return. For capital budgeting purposes Health Zone (Pty) Ltd requires that new clubs generate positive cash flows, in net present value terms, over the initial five-year period after opening of the club in question.

16
Leasing option

The major constraint facing Health Zone (Pty) Ltd is access to funding in order to open new clubs.
The company has a limited capital base and at present new clubs are funded by means of cash flows generated by existing clubs.
GymQuip (Pty) Ltd has offered to lease gym equipment to Health Zone (Pty) Ltd. While the terms of such lease agreements have not yet been negotiated, GymQuip (Pty) Ltd has indicated that -
• lease terms would be five years;
• lease payments would be monthly in advance;
• maintenance charges would be incorporated into monthly lease payments; and
• Health Zone (Pty) Ltd would not be entitled to purchase the equipment at the end of the lease term.
Membership fees

Health Zone (Pty) Ltd is considering offering members the option of paying membership fees annually in advance. Members currently only have the option of paying monthly in advance. The company has not yet decided what discounts should be offered to members who elect to pay annually in advance.

REQUIRED

(a) Determine the net present value of the projected cash flows at 1 July 2004 of the new Health Zone (Pty) Ltd club in Sandton for the period 1 July 2004 to 30 June 2009. Show all your workings.

(b) Calculate the average number of members that the Sandton Health Zone club would require to break even, from an accounting perspective, in the 2007 financial year.

(c) List the potential advantages to Health Zone (Pty) Ltd of leasing gym equipment from GymQuip (Pty) Ltd as opposed to purchasing the equipment.

(d) List factors to be considered by Health Zone (Pty) Ltd in determining the discount that should be offered to members who elect to pay membership fees annually in advance.

(e) List procedures that should be followed when assessing the creditworthiness of new members of Health Zone (Pty) Ltd clubs.

Reference no: EM13510332

Questions Cloud

Smokers and nonsmokers : Chimnesia has two equally sized groups of people: smokers and nonsmokers
Determine how far does the roller coaster travel : A roller coaster, traveling with an initial speed of 15 meters per second, decelerates uniformly at -7.0 meters per second per second to a full stop
What is total revenue : a. All your costs are fixed and your goal is to maximize the total revenue received from selling advertising. Suppose that the expected number of viewers is one million people. What price should you charge? How many minutes of advertising will ..
Outsourcing relative to keeping production in-house : What are the pros and cons of outsourcing relative to keeping production in-house? (b) What are the pros and cons of outsourcing relative to exiting the business altogether?
Determine the net present value of the projected cash flows : Determine the net present value of the projected cash flows at 1 July 2004 of the new Health Zone (Pty) Ltd club in Sandton for the period 1 July 2004 to 30 June 2009. Show all your workings.
Find abc limited account of motor vehicles : ABC limited account of motor vehicles as at 1/1/03 was Ksh. 5,000,000 while the accumulated depreciation as at that date was Ksh. 2,000,000. During the year the following transaction took place.
Find the speed of the spools ground-touching point : A spool whose inner core has a radius of 1.00 cm and whose end caps have a radius of 1.50 cm has a string tightly wound around the inner core. What is the speed of the spool's ground-touching point
Calculate the taxable income of mr jack rose : Calculate the taxable income of Mr Jack Rose for the year of assessment ended 29 February 2004.
The correctly drawn lewis formula for nh2oh will have : 2. The correctly drawn Lewis formula for NH2OH will have

Reviews

Write a Review

Financial Accounting Questions & Answers

  Ilustrate what is the accounts receivable turnover

What is the inventory turnover for 2010? Ilustrate what is the accounts receivable turnover for 2010?

  Discuss the main financial statements

Unit costs are calculated in a similar way in most business sectors, as are pricing decisions - you will need to give the formula and explain the link between Unit Cost and Selling Price, and the importance of information on Fixed Costs, Variable..

  What is their yield to maturity

Ezzell Enterprises' noncallable bonds currently sell for $1,165. They have a 15-year maturity, an annual coupon of $95, and a par value of $1,000. What is their yield to maturity?

  Post the general journal entries to the general ledger

Journalize any adjusting entries in the General Journal and post to the General Ledger. Show your calculations for the adjustments in the Adjustments tab.

  Required write a report to the client geolab exploration

required write a report to the client geolab exploration limited which covers the followinga. a two-column common-size

  Compute the amount of depreciation expense

Compute the amount of depreciation expense for the year ended December 31, 2011, using the straight-line method of depreciation and what is the balance of the Accumulated Depreciation Equipment account at December 31, 2013?

  To what extent does an independent accountant owe allegiance

Beginning with the Enron debacle more than a decade ago, and continuing through the Bernie Madoff scandal of recent years, there has been much discussion regarding the relative roles and responsibility of the SEC and the independent auditors and a..

  Calculate the average age of lozier inventory for 2010

Calculate the average age of Lozier's inventory for 2010 and 2011. Assume a 360-day calendar year.

  What is meant by forensic-type fieldwork phase of an audit

What is meant by the forensic-type fieldwork phase of an audit? An AICPA Fraud Task Force suggests that if a forensic accountant is brought into an audit to conduct a separate investigation (and not an adjunct to an audit), what standards apply?

  Preparation of balance sheet from given datathe following

preparation of balance sheet from given data.the following items were taken from the 2004 financial statements of texas

  Describe the value and non value added in the activities of

describe the value and non value added in the activities of insurance business.prince insurance company is reviewing

  Illustrate how you suggest ways of improving this process

Workers go to a box that contains individual customer order sheets. They take the bottom order (the oldest) and go into the warehouse with a handcart and a box . They then fill the order and carry the parts to a packing station. Illustrate how you..

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