Forecasting Case- Scamper Industries The CFO of Scamper Industries, Ms. Amy Craw
ID: 2712447 • Letter: F
Question
Forecasting Case-Scamper Industries
The CFO of Scamper Industries, Ms. Amy Crawford, is getting ready for a board of director's meeting next week. In the board meeting she is going to propose that the company purchase a new building because of the anticipated growth and expansion of their warehouse needs, sales force and support personnel over the next 5 years. In preparation for the meeting, Ms. Crawford has collected the recent income statements and balance sheets for the past two years, 2008 and 2009, as shown in Table 1.
Financial Information
Table 1
2008
2009
INCOME STATEMENT
Net Sales
$2,000,000
$2,400,000
Cost of Sales
Direct Labor
$500,000
$600,000
Direct Materials
$300,000
$360,000
Overhead
$600,000
$624,000
Total Cost of Sales
$1,400,000
$1,584,000
Gross Margin
$600,000
$816,000
Selling Expenses
$125,000
$125,000
General and Administrative Expenses
$97,500
$97,500
Depreciation
$125,000
$125,000
Total Expenses
$347,500
$347,500
Net Income
$252,500
$468,500
Gross Margin Ratio
30.00%
34.00%
Profit Margin Ratio
12.63%
19.52%
Dividends
$50,500
$93,700
BALANCE SHEET
Assets
Cash balances
$70,600
$84,600
A/R
$210,000
$240,000
Inventories
$239,240
$385,740
Total Current Assets
$519,840
$710,340
Gross Plant and Equipment
$5,163,000
$5,163,000
Accumulated Depreciation
$1,728,000
$1,853,000
Net Plant and Equipment
$3,435,000
$3,310,000
Total assets
$3,954,840
$4,020,340
Liabilities and Owner's Equity
A/P
144,000
149,200
Accrued expenses
165,300
167,400
Total Current Liabilities
309,300
316,600
Long-term Debt (Plug figure)
0
0
Common Stock
1,765,540
1,448,940
Retained Earnings
1,880,000
2,254,800
Total Shareholder's Equity
3,645,540
3,703,740
Total Liabilities and Equity
3,954,840
4,020,340
Background Information
Scamper Industries has been growing at a constant rate of 20% over the past of couple of years because of excellent customer service, and is expected to continue growing at the same rate for the next couple of years. This is due to Scamper Industries excellent service, support, and pricing. The company produces and sells dog kennels nationwide and has become very successful at it. The kennels are sold through different retail outlets throughout the nation, but there is one central warehouse, selling and administration facility that is quickly becoming too small. As indicated by the income statement in Table 1, the past year produced revenues of $2,400,000 and a net income of $468,500. Scamper Industries have been growing rapidly, but so far managing the growth well. The company is profitable, efficient with the use of their assets, reasonably liquid, and using long-term debt effectively. Over the past couple of years, they have been able to reduce debt, manage their cash flows, and build up a very strong business.
Financial Need
According to the plan proposed by Ms. Crawford, Scamper Industries, SI, would purchase a new building at $3,000,000, to accommodate the future expected growth. During the next two years, SI would invest $2,000,000 next year, and $1,000,000, the following year. This new building would meet the company's anticipated housing needs for several years. The additional depreciation expense would be 10% of $2,000,000, next year and 10% of the total cost of $3,000,000, the year after, and for the next 9 years. This depreciation expense would be in addition to the existing depreciation.
The move to the new building is intended to be done with as little disruption to regular business operations as possible and with as little inconvenience to employees and customers as possible. Because of the move, the inventory for next year would be reduced by 20% of the current year inventory, but then go back up to the same inventory amount as the current year in two years. The 20% cutback in inventories would only last next year.
SI intends to borrow the necessary funds to finance the purchase of the building over the next two years. In the past, there has been a very good relationship with the local bank and that will continue. The necessary loan amounts will be taken out in each of the next two years as deemed necessary by the projections. The loan will be paid back starting in three years. Interest will be charged at that time. Interest will not be considered at the present time.
Amy Crawford’s Task
In preparation for the board of director's meeting, Ms. Crawford intends to provide a set of pro forma financial statements, including an income statement and a balance sheet for the next two years. As part of Ms. Crawford's staff, you have been asked to provide these financial statements for the next two years.
Income Statement
The projected sales for the next two years will continue to grow at 20%, each year. For the cost of sales, direct labor has been 25% of sales for the past few years, but because of further training and reassignments of responsibility, the direct labor percentage is expected to decrease by 1% each year for the next two years. This trend is expected to continue with more efficient use of the work force. The direct materials expense percentage is expected to increase by 2% next year because of the reduction in inventory, but decrease by 1% from the 2009 expense percentage the year after because of efficiencies provided by the new building. The overhead expense is projected to be the average percentage for the past two years; it is the same percentage for both projected years. The selling expenses are expected to increase by $50,000 next year because of the inconveniences caused by moving into the new building; the year after the selling expenses should decrease by $15,000 from the 2009 amount because of efficiencies provided by the new building. The general expenses are fixed expenses and will remain constant the next two years. Dividends are historically distributed at 20% of net income.
Balance Sheet
Cash is projected at 3% of sales, and accounts receivable is projected at 9% of sales. Accounts payable is projected at 7% of sales; and the accrued expenses are projected at 8% of sales. There are no plans to sell any additional shares of stock to finance the new building, so the common stock remains constant. Retained earnings will grow each year by the amount of profit after taxes minus any dividends distributed.
The bank debt projected is the difference between the total assets and total liabilities and owner's equity. This is the amount needed to be financed for this project through a loan with the bank.
1. Based upon the above information, set up a projected income statement and projected balance sheet for the years 2010 and 2011.
2. According to the projections, how much will Scamper Industries have to borrow in 2010? How much will Scamper Industries have to borrow in 2011?
3. Based upon the projections and ratios (gross profit margin, profit margin, debt to asset ratio), what do you think of this proposed acquisition?
2008
2009
INCOME STATEMENT
Net Sales
$2,000,000
$2,400,000
Cost of Sales
Direct Labor
$500,000
$600,000
Direct Materials
$300,000
$360,000
Overhead
$600,000
$624,000
Total Cost of Sales
$1,400,000
$1,584,000
Gross Margin
$600,000
$816,000
Selling Expenses
$125,000
$125,000
General and Administrative Expenses
$97,500
$97,500
Depreciation
$125,000
$125,000
Total Expenses
$347,500
$347,500
Net Income
$252,500
$468,500
Gross Margin Ratio
30.00%
34.00%
Profit Margin Ratio
12.63%
19.52%
Dividends
$50,500
$93,700
BALANCE SHEET
Assets
Cash balances
$70,600
$84,600
A/R
$210,000
$240,000
Inventories
$239,240
$385,740
Total Current Assets
$519,840
$710,340
Gross Plant and Equipment
$5,163,000
$5,163,000
Accumulated Depreciation
$1,728,000
$1,853,000
Net Plant and Equipment
$3,435,000
$3,310,000
Total assets
$3,954,840
$4,020,340
Liabilities and Owner's Equity
A/P
144,000
149,200
Accrued expenses
165,300
167,400
Total Current Liabilities
309,300
316,600
Long-term Debt (Plug figure)
0
0
Common Stock
1,765,540
1,448,940
Retained Earnings
1,880,000
2,254,800
Total Shareholder's Equity
3,645,540
3,703,740
Total Liabilities and Equity
3,954,840
4,020,340
Explanation / Answer
2008 2009 2010 2011 Explanation INCOME STATEMENT Net Sales 20,00,000 24,00,000 2880000 3456000 20% Increase each year Cost of Sales Direct Labor 5,00,000 6,00,000 691200 794880 24%; 23% on sales Direct Materials 3,00,000 3,60,000 489600 483840 17%; 14% on sales Overhead 6,00,000 6,24,000 806400 967680 Average of 30% & 26% ie. 28% on sales Total Cost of Sales 14,00,000 15,84,000 19,87,200 22,46,400 Gross Margin 6,00,000 8,16,000 8,92,800 12,09,600 Selling Expenses 1,25,000 1,25,000 1,75,000 1,10,000 ie. +50000; -15000 from 2009 figure General and Administrative Expenses 97,500 97,500 97,500 97,500 Constant Depreciation 1,25,000 1,25,000 3,25,000 4,25,000 ie. + 200000;+300000 respectively over 2009 Total Expenses 3,47,500 3,47,500 5,97,500 6,32,500 Net Income 2,52,500 4,68,500 2,95,300 5,77,100 Gross Margin Ratio 30.00% 34.00% 31 35 Gross Margin/Net sales Profit Margin Ratio 12.63% 19.52% 10.25 16.70 Net Income/Net sales 50,500 93,700 59060 115420 Dividends BALANCE SHEET Assets Cash balances 70,600 84,600 86400 103680 3% on sales A/R 2,10,000 2,40,000 259200 311040 9% on sales Inventories 2,39,240 3,85,740 308592 3,85,740 20% cutback in 2010; Restored in 2011 Total Current Assets 5,19,840 7,10,340 654192 800460 Gross Plant and Equipment 51,63,000 51,63,000 71,63,000 81,63,000 Investment in Buildings Accumulated Depreciation 17,28,000 18,53,000 20,53,000 21,53,000 Additional depreciation provided Net Plant and Equipment 34,35,000 33,10,000 51,10,000 60,10,000 Total assets 39,54,840 40,20,340 57,64,192 68,10,460 Liabilities and Owner's Equity A/P 1,44,000 1,49,200 201600 241920 7%on sales Accrued expenses 1,65,300 1,67,400 230400 276480 8% on sales Total Current Liabilities 3,09,300 3,16,600 432000 518400 Long-term Debt (Plug figure) 0 0 13,92,212 18,90,400 Bal.Fig.T/L- C/L- Equity (amt. to be borrowed) Common Stock 17,65,540 14,48,940 14,48,940 14,48,940 Retained Earnings 18,80,000 22,54,800 24,91,040 29,52,720 Op. bal.+ Current year Net Income- dividend Total Shareholder's Equity 36,45,540 37,03,740 39,39,980 44,01,660 Total Liabilities and Equity 39,54,840 40,20,340 57,64,192 68,10,460 2. Year 2008 2009 2010 2011 Amt. To be borrowed 0 0 13,92,212 18,90,400 3. G/P Margin 30.00% 34.00% 31% 35% N/P Margin 12.63% 19.52% 10.25% 16.70% Debt 0 0 1392212 1890400 Assets 3954840 4020340 5764192 6810460 Debt/assets 0 0 24.15 27.76 % of assets funded by debt 24% 28% For this amount of debt financing, G/p has not increased proportionately and N/P has come down. Proposed acquisition does not seem to be worth while