In: Finance
Trump De Drum Ltd (TDT) is a company in aquacultural industry specialised in farming of aquatic organisms. DT is considering opening a new farm in Sandy Bay. This project would involve the purchase of 13 hectares land at a price of $1,000,000 (Note that: The land is not subject to depreciation for accounting and tax purposes). In addition to that, the company will need to purchase eight special equiments which cost $125,000 each. The equipments are expected to be in use for 5 years and after that, they will be scrapped without any residual value. Each year, each of these equipments will incur $5,000 maintenance cost. It is assumed that the farm will first be used at the beginning of the next financial year: 1 July 2021.
Before starting this new operation, TDT will need to redevelop and renovate the warehouse at the farm. This is expected to cost $200,000. Assume that TDT is not able to claim any annual tax deduction for the capital expenditure to the renovation of the building until the business is sold.
Revenue projections from the farm for the next five years are as follows:
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Beginning |
1/7/2021 |
1/7/2022 |
1/7/2023 |
1/7/2024 |
1/7/2025 |
Ending |
30/6/2022 |
30/6/2023 |
30/6/2024 |
30/6/2025 |
30/6/2026 |
Production quantity (tons) |
120 |
140 |
170 |
185 |
185 |
Price (per tons) |
$9,000 |
$9,150 |
$9,250 |
$9,300 |
$9,350 |
Operating variable costs associated with the new business including material costs and labour costs. Estimated material costs per tons in year 1 is $2,000 and this cost will increase by 3.5% every year. The farm will require about 6 workers working for 8 hours a day, 200 days per year. The pay rate is flat at $20/ hour including superannuation. Annual operating fixed costs associated with production (excluding depreciation) are $100,000. Existing administrative costs are $550,000 per annum. As a result of the new operation, these administrative costs will increase by 30%. The company is subject to a tax rate of 30% on its profits.
Meanwhile, TDT Ltd is currently financed by 60% of equity and 40% of debt. Company’s bond is traded at a price of $980. The bond has 10 year term, 8% coupon rate paid semi-annually and face value of $1,000. In addition, company’s equity has a beta of 1.2 while the risk-free rate in the market is 3% and market portfolio return is estimated to be 12%.
P. De Potato, the company CFO would like you to help him examine the viability of the project for the next five years, taking into account the projections of sales and operations costs prepared by company’s accountants.
Your tasks:
Based on the information in the case study, P. De Potato has asked you to write a report to TDT’s management advising them as to the best course of action regarding this project. Your report should address the following specific questions asked by management:
1) Base Case workings
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Year ending | 30-06-2022 | 30-06-2023 | 30-06-2024 | 30-06-2025 | 30-06-2026 | |
Productions | 120 | 140 | 170 | 185 | 185 | |
% Growth | 16.67% | 21.43% | 8.82% | 0.00% | ||
Sale Price | 9000 | 9,150 | 9,250 | 9,300 | 9,350 | |
% Growth | 1.67% | 1.09% | 0.54% | 0.54% | ||
Sales | 10,80,000 | 12,81,000 | 15,72,500 | 17,20,500 | 17,29,750 | |
Material Cost | 2,40,000 | 2,89,800 | 3,64,217 | 4,10,226 | 4,24,584 | |
per ton | 2000 | 2070 | 2,142.45 | 2,217.44 | 2,295.05 | |
%increase | 3.50% | 3.50% | 3.50% | 3.50% | ||
Labour | 1,92,000 | 1,92,000 | 1,92,000 | 1,92,000 | 1,92,000 | |
Maintainence Cost | 40,000 | 40,000 | 40,000 | 40,000 | 40,000 | |
Operating fixed cost | 1,00,000 | 1,00,000 | 1,00,000 | 1,00,000 | 1,00,000 | |
Admin Fixed cost | 1,65,000 | 1,65,000 | 1,65,000 | 1,65,000 | 1,65,000 | |
Depreciation | 2,00,000 | 2,00,000 | 2,00,000 | 2,00,000 | 2,00,000 | |
Profit before tax | 1,43,000 | 2,94,200 | 5,11,284 | 6,13,274 | 6,08,166 | |
Tax | 42,900 | 88,260 | 1,53,385 | 1,83,982 | 1,82,450 | |
PAT | 1,00,100 | 2,05,940 | 3,57,898 | 4,29,292 | 4,25,717 | |
Operating Cashflow | 3,00,100 | 4,05,940 | 5,57,898 | 6,29,292 | 6,25,717 | |
Terminal Value | 10,00,000 | |||||
Net Cashflow | -22,00,000 | 3,00,100 | 4,05,940 | 5,57,898 | 6,29,292 | 16,25,717 |
Investment total | -22,00,000 | |||||
Land | -10,00,000 | |||||
Equipment | -10,00,000 | |||||
Warehouse | -2,00,000 | |||||
NPV | 23,60,642 | |||||
IRR | 13.55% | |||||
YTM of Bond | ||||||
Price | 980 | Annual Payment | 80 | |||
FV | 1000 | FV- Current price/maturity | 2 | |||
Maturity | 10 | Current+FV/2 | 990 | |||
Coupon | 8% | YTM | 8.28% | |||
Expected Return of Stock | ||||||
Risk free | 3% | Risk Premium | 9% | |||
Beta | 1.2 | |||||
Market Return | 12% | Return | 13.8% | |||
Cost of Capital | Equity | Bond | ||||
Weight | 0.6 | 0.4 |
Related SolutionsTrump De Drum Ltd (TDT) is a company in aquacultural industry specialised in farming of aquatic...Trump De Drum Ltd (TDT) is a company in aquacultural industry
specialised in farming of aquatic organisms. DT is considering
opening a new farm in Sandy Bay. This project would involve the
purchase of 13 hectares land at a price of $1,000,000 (Note that:
The land is not subject to depreciation for accounting and tax
purposes). In addition to that, the company will need to purchase
eight special equiments which cost $125,000 each. The equipments
are expected to be in...
Trump De Drum Ltd (TDT) is a company in aquacultural industry specialised in farming of aquatic...Trump De Drum Ltd (TDT) is a company in aquacultural industry
specialised in farming of aquatic organisms. DT is considering
opening a new farm in Sandy Bay. This project would involve the
purchase of 13 hectares land at a price of $1,000,000 (Note that:
The land is not subject to depreciation for accounting and tax
purposes). In addition to that, the company will need to purchase
eight special equiments which cost $125,000 each. The equipments
are expected to be in...
Trump De Drum Ltd (TDT) is a company in aquacultural industry specialised in farming of aquatic...Trump De Drum Ltd (TDT) is a company in aquacultural industry
specialised in farming of aquatic organisms. DT is considering
opening a new farm in Sandy Bay. This project would involve the
purchase of 13 hectares land at a price of $1,000,000 (Note that:
The land is not subject to depreciation for accounting and tax
purposes). In addition to that, the company will need to purchase
eight special equiments which cost $125,000 each. The equipments
are expected to be in...
Case Study: Trump De Tomato Ltd (TDT) is a company in aquacultural industry specialised in farming...Case Study:
Trump De Tomato Ltd (TDT) is a company in aquacultural industry
specialised in farming of aquatic
organisms. TDT is considering opening a new farm in Sandy Bay. This
project would involve the purchase
of 13 hectares land at a price of $1,000,000 (Note that: The land
is not subject to depreciation for accounting
and tax purposes). In addition to that, the company will need to
purchase eight special equiments which cost
$125,000 each. The equipments are expected to...
Miltons Ltd is a company based in Germany and is specialised in the production of a...Miltons Ltd is a company based in Germany and is specialised
in the production of a wide range of mobility scooters. Miltons Ltd
exports its production to a retailer in the UK. The Management
Board of Miltons Ltd is considering the budget for the coming year.
The table below provides the original budget:
Original Budget
Expected volume of sales
10,000 units
Selling price
€200 per scooter
Costs
Total Variable Cost
€600,000
Fixed Cost
€400,000
However, Benjamin Hans the Director of...
QUESTION 2 Salju Bhd is a company that specialised in producing office furnishings for industry-customers as...QUESTION 2
Salju Bhd is a company that specialised in producing office
furnishings for industry-customers as well as for walk-in
customers. The furnishings are grouped based on its materials. The
following information is available from the company’s inventory
records as at 31 December 2017.
Wooden Furniture (RM)
Bamboo Furniture (RM)
Rattan Furniture
(RM)
Metal Furniture (RM)
Glass Furniture (RM)
Acrylic
Furniture(RM)
Historical cost – FIFO method
(in total)
213,500
122,500
178,500
21,500
50,000
25,000
Estimated selling price
(per unit)
4,125...
Sprint Bolt Ltd is a producer of specialised sport shoes. The company has been conducting research...Sprint Bolt Ltd is a producer of specialised sport shoes. The
company has been conducting research and development of a new
model, where the lower mould can automatically adjust itself to
avoid foot injury. The model has been tested and the managing board
is happy to launch its production if it is financially viable.
The company has already spent $800,000 for research and
development. The new model will have a five- year lifetime, after
that the company will stop its...
Sprint Bolt Ltd is a producer of specialised sport shoes. The company has been conducting research...Sprint Bolt Ltd is a producer of specialised sport shoes. The
company has been conducting research and development of a new
model, where the lower mould can automatically adjust itself to
avoid foot injury. The model has been tested and the managing board
is happy to launch its production if it's financial viable. The
company has already spent $800,000 for research and development.
The new model will have a five-year lifetime, after that the
company will stop its production. The...
Sprint Bolt Ltd is a producer of specialised sport shoes. The company has been conducting research...Sprint Bolt Ltd is a producer of specialised sport shoes. The
company has been conducting research and development of a new
model, where the lower mould can automatically adjust itself to
avoid foot injury. The model has been tested and the managing board
is happy to launch its production if it is financially viable.
The company has already spent $800,000 for research and
development. The new model will have a five- year lifetime, after
that the company will stop its...
QUESTION 4 KAM Ltd (KAM) is a private company in the electronics industry. The company has...QUESTION 4
KAM Ltd (KAM) is a
private company in the electronics industry. The company has grown
steadily since its incorporation in 1997 and is seeking public
listing in the next financial year.
KAM prepared its
financial statements under International Financial Reporting
Standards (IFRS).
You work in the
finance department of KAM and are currently working on the
financial statements for the year ended 30 April 2020.
In order to gain
maximum interest from the market when shares are offered...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|