AllFreePapers.com - All Free Papers and Essays for All Students
Search

Homers Dilemma

Autor:   •  October 8, 2015  •  Case Study  •  549 Words (3 Pages)  •  1,169 Views

Page 1 of 3

HOMER’S DILEMMA

SIMPSONS LTD. is a private company owned by Mr. Homer Simpson which specialized in producing machined Persian Carpets. The carpets had good demand in the market but over the years the number of competitors had increased, increasing the efforts required to market the carpets. Homer had only one dream and he knew the time to live it was arriving soon. The demand for Persian carpets was expected to peak out within next three years. Homer had decided to leave Simpsons Ltd. at the end of three years and go off to the Hawaiian Islands to spend his remaining life schooning, boozing and sleeping. He had decide to sell Simpsons Ltd. and use the proceeds to sustain his Hawaiian life style. Homer wanted highest price for his business if he sold it at the end of three years. In order to achieve this target he had approached his banker who advised him the following for the next three years:

  1. To increase sales at a growth rate of 25% per anum for the next three years.
  2. The current plant capacity will reach 100% once the sales are increased by 25% in the next year.
  3. To support further sales he has two options:
  1. He intends to support further production required in the later two years through outsourcing. The additional carpets will be procured at 80% of the expected sale price.
  2. He intends to support further production by setting up additional plant and machinery of Rs.1000000/- in two equal stages in the year 2013 and 2014. This additional capacity will be enough to continue production for next 5 years wherein the total capacity will again reach its peak.
  1. Marketing expenses will increase from 5% to 8% of sales.

Homer was also advised to achieve the following:

  1. To reduce average collection period from 36 days to 24 days.
  2. To reduce days of inventory holding from 36 days to 30 days.
  3. To reduce cash levels from 5% of sales to 2%.
  4. To increase average payment period from 36 days to 48 days.

To achieve the above levels of sales Homer intends to maintain the prices for next three years. As Simpsons is achieving economies of scale the raw material costs will increase at same rate per anum even though prices are maintained constant.

Other Important Information:

  1. Depreciation is WDV method at 10%.
  2. Bank borrowings are short-term borrowings and are related to sales.
  3. In case of sale the land will be sold at at-least 3 times its book-value.
  4. The expected growth rate once the demand has peaked up is a stable growth of 5%.
  5. The expected cost of financing for the investor will be 10%.
  6. Secured loan is repaid by Rs.100000 every year till feasible (i.e. retained earnings are able to replenish it).
  7. Investments generate a return of 10% which is reinvested in the same securities unless needed otherwise. Net capex and additional working capital are financed through investments. At the same time additional revenue/ retained earnings are invested in the investments.

Which option should Homer agree for?

 

Income Statement

Year

2008

2009

2010

2011

2012

Sales (Units)

700

850

1000

1150

1300

Price

2000

2200

2400

2600

2800

Total Sales

1400000

1870000

2400000

2990000

3640000

Less

COGS

770000

1028500

1320000

1644500

2002000

=

Gross Profit

630000

841500

1080000

1345500

1638000

Add

Commission

100000

105000

115000

125000

135000

Add

Interest Income

34650

49000

59372.5

79638.6

107538.3

=

Total Revenue

764650

995500

1254373

1550139

1880538

Labor Costs

105000

127500

150000

172500

195000

Marketing Costs

70000

93500

120000

149500

182000

Admin & General Expenses

50000

50000

50000

50000

50000

R&D Costs

0

100000

0

0

0

Less

Total Operating Expenses

225000

371000

320000

372000

427000

=

Operating Profit

539650

624500

934372.5

1178139

1453538

Less

Depreciation

111111

100000

90000

81000

72900

=

PBIT

428539

524500

844372.5

1097139

1380638

Less

Interest

114950

107000

99350

92000

84950

=

PBT

313589

417500

745022.5

1005139

1295688

Less

Tax @ 30%

94077

125250

223506.8

301541.6

388706.5

=

PAT

219512

292250

521516

703597

906982

Less

Dividend Payout @ 50%

109756

146125

260758

351799

453491

Transfer to Reserves

109756

146125

260758

351799

453491


Balance Sheet

2008

2009

2010

2011

2012

Account Receivables

140000

187000

240000

299000

364000

Inventory

77000

102850

132000

164450

200200

Cash

70000

93500

120000

149500

182000

Total CA

287000

383350

492000

612950

746200

Land

1000000

1000000

1000000

1000000

1000000

Plant & Machinery

1000000

900000

810000

729000

656100

Investments

490000

593725

796386

1075383

1442271

Total Assets

2777000

2877075

3098386

3417333

3844571

Bank Borrowings

70000

93500

120000

149500

182000

Account Payables

77000

102850

132000

164450

200200

Accrued Expenses

22500

27100

32000

37200

42700

Total CL

169500

223450

284000

351150

424900

Secured Loan

1000000

900000

800000

700000

600000

Paid up Share Capital

500000

500000

500000

500000

500000

Reserves and Surplus

1107500

1253625

1514383

1866181

2319672

Total Liabilities

2777000

2877075

3098386

3417333

3844571

...

Download as:   txt (5.9 Kb)   pdf (151.8 Kb)   docx (173.6 Kb)  
Continue for 2 more pages »