HETWIN is a supermarket chain that operates 500 stores. the companys sales have fallen behind its competitors as it currently does not offer its customers online shopping service. it is considering a proposal to establish an online shopping service using the technology of NOBEL,an existing online retailer.
sales revenue and gross profits
the number of customers using the online delivery service in the first five years is estimated to be as follows
Yr. 1 100,000. customers per week
Yr. 2. 120,000. //
Yr. 3. 150,000. //
Yr. 4. 160,000. //
Yr. 5. 170,000. //
customers are expected to spend an avregae of $200 per week. Delivery to customers will be free of charge. the expected gross profit margin is 20% of selling price
loss of existing in store sales
it is estimated that 30% of customers purching online would habe purchased in store if the online facility was not available. the sales revenue per customer and gross profits margin on online sales will be the same as that for in store sales
capital expenditure
HETWIN will purchase a fleet of delivery vehicles costing $15 million. the vichels will have a useful life for five years and will be depreciated on a stright line basis.they will have no residual value at the end of the five year period. the vehicle will be eligible for tax depreciation.
contract with the online retailer
the contract with NOBEL will be for an initial period of 5 years. HETWIN will pay $340million to buy one of NOBEL existing warehouse. HETWIN will also invest $90million to expand the facility. the expanded warehouse will then be leaseed back to NOBEL for five years for fee of $20million per annum. the cost of purchasing the warehouse and expansion Cost will not be eligible for tax depreciation the warehouse will have a realisable value of $350million at the end of the five years period. HETWIN will pay 1% of gross profit from the online business to NOBLE. HETWIN wi also pay a fee of & 30million per annum to license the technology and as a contribution towards NOBEL research and development costs.
other operating costs
the online operation will result I. additional costs in the five year of & 60million, including delivery costs but excluding depreciation. this amount will raise by $5million each year as a customer numbers increase.
taxation
HETWIN fianacial director has provided the following taxation information:
* tax depreciation: 25% per annum of the reducing balance, with a balancing adjustment in the year of disposable
* taxation rate: 30% of taxable profotits. half of the tax is payable in the year in which it arises., the balance is paid in the following year.
* HETWIN has sufficient taxable profits from other parts of its business to enable the offset of any pre tax losses on this project
other information
* a cost of capital is 12%. per annum is used to elevate the project of this type.
* ignore inflation
Required
evaluate HETWIN using the discounted cash flow model if growth rate is 5%
