Homers Dilemma
Autor: abhi111nav • October 8, 2015 • Case Study • 549 Words (3 Pages) • 1,155 Views
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:
- To increase sales at a growth rate of 25% per anum for the next three years.
- The current plant capacity will reach 100% once the sales are increased by 25% in the next year.
- To support further sales he has two options:
- 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.
- 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.
- Marketing expenses will increase from 5% to 8% of sales.
Homer was also advised to achieve the following:
- To reduce average collection period from 36 days to 24 days.
- To reduce days of inventory holding from 36 days to 30 days.
- To reduce cash levels from 5% of sales to 2%.
- 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:
- Depreciation is WDV method at 10%.
- Bank borrowings are short-term borrowings and are related to sales.
- In case of sale the land will be sold at at-least 3 times its book-value.
- The expected growth rate once the demand has peaked up is a stable growth of 5%.
- The expected cost of financing for the investor will be 10%.
- Secured loan is repaid by Rs.100000 every year till feasible (i.e. retained earnings are able to replenish it).
- 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 |
...