Background
Rob’s Furniture Restoration Ltd (RFR) is a family-owned furniture restoration business located in Hornsby. Rob started the company in 2006, with his wife Meredith. They each own 35% of RFR’s shares, with the balance owned by Rob’s sister, Sarah. The company’s Board of Directors consists of Rob, who is the Managing Director, Meredith and Sarah, who is the Company Secretary. Sarah is also RFR’s Accountant and Office Manager.
The last few years have been challenging for RFR, due to increased competition from large international furniture manufacturers. The company has survived by focusing on producing high quality custom furniture. In doing so, it has established a reputation for craftsmanship and quality finishes.
RFR currently operates from a factory in Hornsby that it has owned since incorporation. It rents additional space in Asquith for $85,000 p.a. The company is currently considering a proposal to increase the scale of its operations. This would involve the sale its Hornsby property, as well as the cancellation of the lease on its Asquith property and the purchase of a larger property in Mount Colah, where it would locate its expanded operations. By cancelling the Asquith lease, RFR would incur in a tax-deductible $7,000 cancellation fee.
Moving to the new property would likely increase RFR’s annual maintenance costs from $4,800 to $11,500. Those costs are expected to increase by 2% p.a. over the next five years, irrespective of whether RFR goes ahead with the proposed expansion. The schedule of expected maintenance costs associated with the proposal are shown in the Appendix (the 2% annual increase is included in those estimates).
Rob and Meredith have asked Sarah to investigate the financial viability of the proposed expansion. They recently returned from an overseas trip (part work and part holiday), during which they met the Managing Director of Omod Group, a large international furniture manufacturer, with the intention of negotiating an exclusive contract to repair the furniture produced by Omod’s Australian operations. The trip cost $37,500 in airfare, accommodation and meals. Since most of it was business related, RFR reimbursed Rob and Meredith for $21,500 of the expenses they incurred.
Upon their return, Rob and Meredith met with Sarah to explain that if RFR expanded its operations, it could enter into a lucrative service and repair contract with Omod. They believe that by purchasing new production equipment and increasing the size of RFR’s facilities, it could expand its operations sufficiently to become the sole repairer for all Omod’s Australian furniture. However, this would mean that RFR had to consolidate its operations at the new premises in Mount Colah.
Current Situation
Rob and Meredith believe that RFR would be able to take on this expansion without a negative effect on the quality of the products it provides to its existing clients. Rob provided revenue forecasts based on the proposed expansion, as detailed in the Appendix. He also outlined some preliminary estimates of the costs involved. The new premises would cost about $2,430,000 to purchase. Another large cost would be the new equipment RFR would have to purchase for the increased quantity of work resulting from a deal with Omod. They received a reliable quote of $260,000 for this equipment.
Rob is very excited and believes that RFR could double its revenues in the next three years, if it goes ahead with the relocation and expansion. Sarah thinks the company is already profitable enough and provides a good return on investment, and that a larger volume of business could create difficulties. She also believes that Rob and Meredith have not considered the additional staff that would be needed if RFR goes ahead with the proposal. She anticipates that three new workers would be required, and that all the company’s workers (the three new people and the existing four) would need special training on the new equipment. This training would cost $8,000 per person and would have to be undertaken before the equipment could be used. The new staff wages would be $74,700 p.a. each, in line with the current staff wages. Furthermore, an allowance must be made for all wages to increase at 2.5% p.a. Details of the estimated wages are shown in the Appendix (the 2.5% annual increase is included in those estimates).
Another firm recently offered RFR $1,085,000 for the property in Hornsby. Sarah believes this is a good offer, which RFR should accept if it decides to relocate to Mount Colah. Selling the Hornsby property would have no tax implications.
Meredith is worried about the amount of capital required for the proposed consolidation and expansion. RFR certainly does not have any spare cash. The company borrowed money for recent renovations and is still making payments on the resulting term loan from the bank. In the current climate, she is concerned that additional financing would be hard to get. She feels that a thorough business plan and report should be submitted to the board members, so that an informed decision can be made. Rob and Meredith agree that Sarah has the skills to assemble the necessary data and write the report.
A summary of the data Sarah gathered is presented below:
- It was agreed that the sales figures presented by Rob in the Appendix would be used in the analysis. However, Sarah is concerned that Rob’s revenue projections are too optimistic.
- The tax office has agreed that the $8,000 training fee per staff member would be a tax deduction at the time of payment, although Sarah says the company has the option to spread this expense over ten years for accounting purposes.
- Sarah informed Rob that there is old unused equipment at the current premises that could be used for the proposed expansion. Although it is fully depreciated, it was recently appraised for insurance purposes and has a market value of $18,000.
- Sarah analysed RFR’s cash flows and found that it would need to borrow $2,500,000 to finance the proposed relocation and expansion. RFR’s bank has given preliminary approval for this loan, but wants to see the final business plan. The interest rate for the loan would be 5.25% p.a., compounding monthly, and it would be repayable over 10 years.
- RFR pays tax at the corporate tax rate of 30%.
- Sarah believes that RFR’s current weighted average cost of capital of 11% is appropriate for the analysis of the proposed expansion.
- Inflation is already included in all forecasted cash flows.
- Land is not depreciable and no capital gains tax applies to it. In five years it is estimated that the new premises at Mount Colah would be worth about $4,250,000.
- The Tax Office has determined that the building at the Mount Colah premises, which is valued at $950,000, could be depreciated at 7% p.a., while new the equipment could be depreciated at 20% p.a.
- In five years the new equipment would have a scrap value of $75,000, while the old reused equipment would have no value.
- There would be an increase in inventory of common spare parts, estimated to be 6% of the following years’ revenue, each year, if RFR goes ahead with the expansion.
You have been asked to assist Sarah to produce the following:
- A one-page executive summary with a recommendation to RFR’s directors on whether it should expand its business, as outlined above. It should provide reasons for the recommendation and a summary of the financial analysis conducted.
- Readable Excel spreadsheets showing the NPV calculations for the project, as well as all other calculations used to support your decision.
Revenue Forecasts
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Increased revenues |
$750,000 |
$780,000 |
$840,000 |
$900,000 |
$960,000 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Wages per employee |
$74,700 |
$76,568 |
$78,482 |
$80,444 |
$82,455 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Building maintenance |
$11,500 |
$11,730 |
$11,965 |
$12,204 |
$12,448 |
The report has been prepared with an intention to analyse the feasibility of proposed expansion strategy with directors of Rob’s Furniture Restoration Limited (RFR), a family owned business with 3 directors on board. The company is seeking an opportunity to expand its business and has accordingly consulted the Accounts team to conduct a feasibility study of the project and comment on the same. The feasibility study has been annexed to the report and the project is feasible based on the calculations detailed in annexure. The Net Present value stands at $ 1,234,455.
The assumptions under the said computation have been detailed here-in-below:
- Trip cost is sunk cost and $37,500 has not been considered;
- Reimbursed expenditure is not considered ;
- Staff salary of 3 additional staff is considered;
- Increase in salary takes place from second year;
- The price offered by other party for the property in Hornsby is not taken into consideration;
- The sale value of premise includes the sale price of building and has not been considering separately;
- The increase in working capital is realised at the end of the period.
Sl No |
Particulars |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Terminal Value |
1 |
Increased Revenues |
750000 |
780000 |
840000 |
900000 |
960000 |
||
2 |
Cancellation Agreement (Net of Tax) |
-4900 |
||||||
3 |
Increase in Maintenance cost |
6700 |
6834 |
6970.68 |
7110.094 |
7252.295 |
||
4 |
Land Cost |
-2430000 |
||||||
5 |
Cost of Equipment |
-260000 |
||||||
6 |
Training Cost (Net of Tax) |
-39200 |
||||||
7 |
Wage Cost for 3 employees |
224100 |
229702.5 |
235445.1 |
241331.2 |
247364.5 |
||
8 |
Valuation of Premise post 5 Year |
4250000 |
||||||
9 |
Depreciation of old equipment |
3600 |
3600 |
3600 |
3600 |
3600 |
||
10 |
Depreciation of New Equipment |
37000 |
37000 |
37000 |
37000 |
37000 |
||
11 |
Saving in Rent Cost |
85000 |
85000 |
85000 |
85000 |
85000 |
||
12 |
Depreciation on Building |
66500 |
61845 |
57515.85 |
53489.74 |
49745.46 |
||
13 |
Increase in Working Capital |
45000 |
1800 |
3600 |
3600 |
3600 |
57600 |
|
14 |
Residual Value of Machine |
75000 |
||||||
15 |
Net Cash flow before Tax |
-2734100 |
282100 |
354218.5 |
410868.4 |
468869 |
526437.8 |
4382600 |
16 |
Tax Impact |
84630 |
106265.6 |
123260.5 |
140660.7 |
157931.3 |
39780 |
|
17 |
Cash Flow Post Tax |
-2734100 |
197470 |
247953 |
287607.9 |
328208.3 |
368506.4 |
4342820 |
18 |
Depreciation (Add Back) |
107100 |
102445 |
98115.85 |
94089.74 |
90345.46 |
||
19 |
Net Cash flow |
304570 |
350398 |
385723.7 |
422298 |
458851.9 |
4342820 |
|
20 |
Discounting Factor |
1 |
0.900901 |
0.811622 |
0.731191 |
0.658731 |
0.593451 |
0.593451328 |
21 |
Present Value of Cash Flows |
-2734100 |
274387.4 |
284390.8 |
282037.9 |
278180.8 |
272306.3 |
2577252.297 |
22 |
Net Present Value |
1234455.451 |
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2020). Feasibility Study: Proposed Expansion Of Rob's Furniture Restoration Ltd Essay.. Retrieved from https://myassignmenthelp.com/free-samples/25742-financial-management/case-study-of-robs-furniture-restoration-ltd.html.
"Feasibility Study: Proposed Expansion Of Rob's Furniture Restoration Ltd Essay.." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/25742-financial-management/case-study-of-robs-furniture-restoration-ltd.html.
My Assignment Help (2020) Feasibility Study: Proposed Expansion Of Rob's Furniture Restoration Ltd Essay. [Online]. Available from: https://myassignmenthelp.com/free-samples/25742-financial-management/case-study-of-robs-furniture-restoration-ltd.html
[Accessed 12 November 2024].
My Assignment Help. 'Feasibility Study: Proposed Expansion Of Rob's Furniture Restoration Ltd Essay.' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/25742-financial-management/case-study-of-robs-furniture-restoration-ltd.html> accessed 12 November 2024.
My Assignment Help. Feasibility Study: Proposed Expansion Of Rob's Furniture Restoration Ltd Essay. [Internet]. My Assignment Help. 2020 [cited 12 November 2024]. Available from: https://myassignmenthelp.com/free-samples/25742-financial-management/case-study-of-robs-furniture-restoration-ltd.html.