Question

In: Accounting

The Haverly Company expects to finish the current year with the following financial results, and is...

The Haverly Company expects to finish the current year with the following financial results, and is developing its annual plan for next year.

Haverly Company Income Statement This Year ($000)
$ %
Revenue $74920 100.0
COGS 26984 36
Gross Margin $47936 64
Expenses:
    Marketing $11605 15.5
    Engineering 9314 12.4
    Fin & Admin 8106 10.8
    Total Exp. $29025 38.7
EBIT $18911 25.2
Interest 2255 3
EBT $16656 22.2
Inc Tax 6996 9.3
Net Income $  9660 12.9
Haverly Company Balance Sheet This Year ($000)
ASSETS LIABILITIES & EQUITY
Cash $   9753 Accounts payable $   1499
Accounts receivable 12487 Accruals 553
Inventory 6746
Current assets $28986 Current liabilities $   2052
Long-term debt $27264
Fixed Assets Equity
    Gross $51345     Stock accounts $12084
    Accumulated depreciation (23758)     Retained earnings 15173
Net $27587     Total Equity $27257
Total assets $56573 Total L&E $56573

The following facts are available.

  • Payables are almost entirely due to inventory purchases and can be estimated through COGS, which is approximately 40% purchased material.
  • Currently owned assets will depreciate an additional $1100000 next year.
  • There are two balance sheet accruals. The first is for unpaid wages. The current payroll of $31 million is expected to grow by 11% next year. The closing date of the year will be six working days after a payday. The second accrual is an estimate of the cost of purchased items that have arrived in inventory, but for which vendor invoices have not yet been received. This materials accrual is generally about 9% of the payables balance at year end.
  • The combined state and federal income tax rate is 42%.
  • Interest on current and future borrowing will be at a rate of 14%.

PLANNING ASSUMPTIONS

Income Statement Items

  1. Revenue will grow by 13% with no change in product mix. Competitive pressure, however, is expected to force some reductions in pricing.
  2. The pressure on prices will result in a 2% deterioration (increase) in the next year's cost ratio.
  3. Spending in the marketing department is considered excessive and will be held to 10% of revenue next year.
  4. Because of a major development project, expenses in the engineering department will increase by 15%.
  5. Finance and administration expenses will increase by 8%.

Assets and Liabilities

  1. An enhanced cash management system will reduce cash balances by 5%.
  2. The ACP will be reduced by 15 days. (Calculate the current value to arrive at the target.)
  3. The inventory turnover ratio (COGS/inventory) will decrease by 0.5x.
  4. Capital spending is expected to be $7 million. The average depreciation life of the assets to be acquired is five years. The firm uses straight-line depreciation, and takes a half year in the first year.
  5. Bills are currently paid in 50 days. Plans are to shorten that to 30 days.
  6. A dividend totaling $2 million will be paid next year. No new stock will be sold.

Develop next year's financial plan for Haverly on the basis of these assumptions and last year's financial statements. Include a projected income statement, balance sheet and a statement of cash flows. Enter your dollar answers in thousands. For example, an answer of $200 thousands should be entered as 200, not 200000. Round dollar answers and intermediate calculations to the nearest thousand. Round the percentage values to 1 decimal place. Enter all amounts in Income Statement as a positive numbers. Use a minus sign, to indicate a negative cash outflow, or a decrease in cash in Balance Sheet and Cash Flow Statement.

HAVERLY COMPANY
INCOME STATEMENTS
($000)
THIS YEAR NEXT YEAR
$ % $ %
Revenue $74920 100.0 $   100.0
COGS 26984 36 %
Gross Margin $47936 64 $   %
Expenses:
    Marketing $11605 15.5 $   %
    Engineering 9314 12.4 %
    Fin & Admin 8106 10.8 %
    Total Exp. $29025 38.7 $   %
EBIT $18911 25.2 $   %
Interest 2255 3 %
EBT $16656 22.2 $   %
Inc Tax 6996 9.3 %
Net Income $  9660 12.9 $   %
HAVERLY COMPANY
BALANCE SHEETS
($000)
ASSETS LIABILITIES & EQUITY
THIS YR NEXT YR THIS YR NEXT YR
Cash $   9753 $   Accts. Pay. $   1499 $  
Accts. Rec. 12487 Accruals 553
Inventory 6746
Curr. Assets $28986 $   Curr. Liab. $   2052 $  
Long Term Debt $27264 $  
Fixed Assets Equity
    Gross $51345 $       Stock Accts $12084 $  
    Accum. Depr. (23758)     Retained Earn 15173
Net $27587 $       Total Equity $27257 $  
Total Assets $56573 $   Total L & E $56573 $  
HAVERLY COMPANY
CHANGES IN WORKING CAPITAL
NEXT YEAR ($000)
A/R $  
Inventory $  
A/P $  
Accruals $  
$  
HAVERLY COMPANY
STATEMENT OF CASH FLOWS
NEXT YEAR ($000)
OPERATING ACTIVITIES
Net Income $  
Depreciation
Increase in W/C
Cash Flow From Operating Activities $  
INVESTING ACTIVITIES
Increase in Gross Fixed Assets $  
FINANCING ACTIVITIES
Decrease in Debt $  
Dividend $  
$  
NET CASH FLOW $  
RECONCILIATION
Beginning Cash $  
Net Cash Flow $  
Ending Cash $  

Solutions

Expert Solution




Related Solutions

The Haverly Company expects to finish the current year with the following financial results, and is...
The Haverly Company expects to finish the current year with the following financial results, and is developing its annual plan for next year. Haverly Company Income Statement This Year ($000) $ % Revenue $83640 100.0 COGS 35990 43 Gross Margin $47650 57 Expenses:     Marketing $18169 21.7     Engineering 3653 4.4     Fin & Admin 3735 4.5     Total Exp. $25557 30.6 EBIT $22093 26.4 Interest 3277 3.9 EBT $18816 22.5 Inc Tax 7903 9.4 Net Income $10913 13 Haverly Company Balance Sheet This...
The Eagle Feather Fabric Company expects to complete the current year with the financial results given...
The Eagle Feather Fabric Company expects to complete the current year with the financial results given below. Forecast next year using a modified percentage of sales method assuming no dividends are paid and no new stock is sold along with the following: A 17% growth in sales and a 40% growth in net fixed assets. A 15% growth in sales with a 10% growth in expenses and a 20% growth in net fixed assets. (Note that negative debt means the...
Burgandy Company produces and sells mattresses. It expects to sell 7,000 mattresses in the current year...
Burgandy Company produces and sells mattresses. It expects to sell 7,000 mattresses in the current year and had 800 mattresses in finished goods inventory at the end of the previous year. Burgandy would like to complete operations in the current year with at least 900 completed mattresses in inventory. There is no ending work-in-process inventory. The mattresses sell for $500 each. How many mattresses will be produced in the current year? a.9,450 mattresses b.6,320 mattresses c.7,100 mattresses d.8,000 mattresses
For the current year ending January 31, Harp Company expects fixed costs of $177,000 and a...
For the current year ending January 31, Harp Company expects fixed costs of $177,000 and a unit variable cost of $52.00. For the coming year, a new wage contract will increase the unit variable cost to $57.00. The selling price of $60.00 per unit is expected to remain the same. If required, round your answer to the nearest whole unit. Required: a. Compute the break-even sales (units) for the current year. b. Compute the anticipated break-even sales (units) for the...
EXAMPLE 1- TAXPAYER HAS 3 PASSIVE ACTIVITIES WITH THE FOLLOWING RESULTS FOR THE CURRENT YEAR(YEAR 1):...
EXAMPLE 1- TAXPAYER HAS 3 PASSIVE ACTIVITIES WITH THE FOLLOWING RESULTS FOR THE CURRENT YEAR(YEAR 1): ACTIVITY A ($10,000), ACTIVITY B ($15,000), AND ACTIVITY C $6,000TAXPAYER CAN DEDUCT ONLY $6,000 OF THE PASSIVE LOSSES SINCE PASSIVE LOSSES ARE DEDUCTIBLE ONLY UP TO PASSIVE INCOME WITH THE FOLLOWING LOSS CARRYFORWARDS TO YEAR 2: $19,000 DISALLOWED LOSSES X 10/25= ($7,600) LOSS CARRIED FORWARD FROM ACITIVITY A $19,000 DISALLOWED LOSSES X 15/25= ($11,400) LOSS CARRIED FORWARD FROM ACTIVITY B can someone explain this...
Bullwinkle Corporation, an S corporation, reports the following results for the current year: Ordinary income =...
Bullwinkle Corporation, an S corporation, reports the following results for the current year: Ordinary income = $40,000 Long-term capital gain= $18,000 Section 1231 gain = $8,000 Short-term capital loss= $14,000 Bullwinkle's AAA and accumulated E&P balances at the beginning of the year are $40,000 and $30,000, respectively. Bullwinkle made a $70,000 cash distribution to its sole shareholder, Maryann, on June 1 and a second $70,000 cash distribution on December 1. Maryann's basis in her Bullwinkle Corporation stock on January 1...
Internal Analysis ( Company UPS) •             Financial Results: Report and discuss key financial ratios and results....
Internal Analysis ( Company UPS) •             Financial Results: Report and discuss key financial ratios and results. Strengths and weaknesses? Include your source  
Financial Results of the company Kroger? Discuss key financial ratios and results. Keep it simple. Strengths...
Financial Results of the company Kroger? Discuss key financial ratios and results. Keep it simple. Strengths and weaknesses?
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity Target Price Actual Price Difference A 1,900.00 $ 302.00 $ 303.00 $ 1.00 B 9,500.00 314.60 272.60 (42.00 ) C 950.00 219.50 327.00 $ 107.50 The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity Target Price Actual Price Difference A 1,550.00 $ 295.00 $ 296.00 $ 1.00 B 7,750.00 307.60 265.60 (42.00 ) C 775.00 212.50 320.00 $ 107.50 The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT