Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave

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:

  1. 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.
  1. 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.
  1. 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.
  2. 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.
  3. RFR pays tax at the corporate tax rate of 30%.
  1. Sarah believes that RFR’s current weighted average cost of capital of 11% is appropriate for the analysis of the proposed expansion.
  2. Inflation is already included in all forecasted cash flows.
  1. 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.
  2. 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.
  1. In five years the new equipment would have a scrap value of $75,000, while the old reused equipment would have no value.
  2. 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:

  1. 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.
  1. 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

Cite This Work

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 29 March 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 29 March 2024.

My Assignment Help. Feasibility Study: Proposed Expansion Of Rob's Furniture Restoration Ltd Essay. [Internet]. My Assignment Help. 2020 [cited 29 March 2024]. Available from: https://myassignmenthelp.com/free-samples/25742-financial-management/case-study-of-robs-furniture-restoration-ltd.html.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Plagiarism checker
Verify originality of an essay
essay
Generate unique essays in a jiffy
Plagiarism checker
Cite sources with ease
support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close