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

Free

80.2K

Verified Solution

Question

Finance

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

Haverly Company Income Statement This Year($000)
$%
Revenue$83640100.0
COGS3599043
Gross Margin$4765057
Expenses:
??? Marketing$1816921.7
??? Engineering36534.4
??? Fin & Admin37354.5
??? Total Exp.$2555730.6
EBIT$2209326.4
Interest32773.9
EBT$1881622.5
Inc Tax79039.4
Net Income$1091313
Haverly Company Balance Sheet This Year($000)
ASSETSLIABILITIES & EQUITY
Cash$   6421Accounts payable$   2249
Accounts receivable13940Accruals444
Inventory7198
Current assets$27559Current liabilities$   2693
Long-term debt$23937
Fixed AssetsEquity
??? Gross$55564??? Stock accounts$14413
??? Accumulated depreciation(29519)??? Retained earnings12561
Net$26045??? Total Equity$26974
Total assets$53604Total L&E$53604

The following facts are available.

  • Payables are almost entirely due to inventory purchases and canbe estimated through COGS, which is approximately 45% purchasedmaterial.
  • Currently owned assets will depreciate an additional $1103000next year.
  • There are two balance sheet accruals. The first is for unpaidwages. The current payroll of $31 million is expected to grow by13% next year. The closing date of the year will be six workingdays after a payday. The second accrual is an estimate of the costof purchased items that have arrived in inventory, but for whichvendor invoices have not yet been received. This materials accrualis generally about 8% 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 of10%.

PLANNING ASSUMPTIONS

Income Statement Items

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

Assets and Liabilities

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

Develop next year's financial plan for Haverly on the basis ofthese assumptions and last year's financial statements. Include aprojected income statement, balance sheet and a statement of cashflows. Enter your dollar answers in thousands. For example, ananswer of $200 thousands should be entered as 200, not 200000.Round dollar answers and intermediate calculations to the nearestthousand. Round the percentage values to 1 decimal place. Enter allamounts in Income Statement as a positive numbers. Use a minussign, to indicate a negative cash outflow, or a decrease in cash inBalance Sheet and Cash Flow Statement.

HAVERLY COMPANY
INCOME STATEMENTS
($000)
THIS YEARNEXT YEAR
$%$%
Revenue$83640100.0$  100.0
COGS3599043%
Gross Margin$4765057$  %
Expenses:
??? Marketing$1816921.7$  %
??? Engineering36534.4%
??? Fin & Admin37354.5%
??? Total Exp.$2555730.6$  %
EBIT$2209326.4$  %
Interest32773.9%
EBT$1881622.5$  %
Inc Tax79039.4%
Net Income$1091313$  %
HAVERLY COMPANY
BALANCE SHEETS
($000)
ASSETSLIABILITIES & EQUITY
THIS YRNEXT YRTHIS YRNEXT YR
Cash$   6421$  Accts. Pay.$   2249$  
Accts. Rec.13940Accruals444
Inventory7198
Curr. Assets$27559$  Curr. Liab.$   2693$  
Long Term Debt$23937$  
Fixed AssetsEquity
??? Gross$55564$  ??? Stock Accts$14413$  
??? Accum. Depr.(29519)??? Retained Earn12561
Net$26045$  ??? Total Equity$26974$  
Total Assets$53604$  Total L & E$53604$  
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$  

Answer & Explanation Solved by verified expert
3.7 Ratings (344 Votes)

Income Statement($000)
This Year Next Year
$ % $ %
Revenue 83640 100 93677 100
COGS 35990 43 41389 44.2
Gross Margin 47650 57 52288 55.8
Expenses: 0
Marketing 18169 21.7 18735 20
Engineering 3653 4.4 4384 4.7
Fin & Admin 3735 4.5 3996 4.3
Total Exp 25557 30.6 27115 28.9
EBIT 22093 26.4 25173 26.9
Interest 3277 3.9 2394 2.6
Inc Tax 7903 9.4 9567 10.2
Net Income 10913 13 13212 14.1
Balance Sheet($000)
Assets Liability & Equity
This Year Next Year This Year Next Year
Cash 6421 14020 Accts. Pay 2249 1552
Accts. Recv 13940 11710 Accurals 444 194
Inventory 7198 9198
Current Assets 27559 34927 Curren Liab 2693 1746
Long Term Debt 23937 23937
Fixed Assets Equity
Gross 55564 60564 Stock Accts 14413 14413
Accum Dep -29519 -31122 Retained Earning 12561 24273
Net 26045 29442 Total Equity 26974 38686
Total Assets 53604 64369 Total L & E 53604 64369
Changes in Working Capital Next Year($000)
A/R 2230
Inventory -2000
A/P -697
Accruals -250
TOTAL -716
Statement of Cash Flow
Next Year ($000)
Opeating Activities
Net Income 13212
Depreciation 1603
Increase in WC -716
Cash Flow from Operating Acivities 14099
Investing Activities
Increase in Gross Fixed Assets -5000
Financing Activities
Decrease In Debt 0
Dividend -1500
Net Cash Flow 7599
Reconciliation
Beginning Cash 6421
Net Cash Flow 7599
Ending Cash 14020

WORKING NOTES

This Year Next Year
Avereage Accounts Rece 60 45 days
Accts. Recv/Revenue*360 13940/83640*360 x/93677*360
x=11709.625
Inventory Tunover 5 4.5 times
COGS/Inventoy 35990/7198 41389/y
y=9197.56
Avereage Accounts Payable 50 30 days
Accts. Payable/Purchase*360 2249/(35990*0.45)*360 a/(41389*0.45)*360
a=1552.09
Accurals
Payroll (310+13%)*6/30 days 70
Material Accural 1552*0.08 124
194

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The Haverly Company expects to finish the current year with thefollowing financial results, and is developing its annual plan fornext year.Haverly Company Income Statement This Year($000)$%Revenue$83640100.0COGS3599043Gross Margin$4765057Expenses:??? Marketing$1816921.7??? Engineering36534.4??? Fin & Admin37354.5??? Total Exp.$2555730.6EBIT$2209326.4Interest32773.9EBT$1881622.5Inc Tax79039.4Net Income$1091313Haverly Company Balance Sheet This Year($000)ASSETSLIABILITIES & EQUITYCash$   6421Accounts payable$   2249Accounts receivable13940Accruals444Inventory7198Current assets$27559Current liabilities$   2693Long-term debt$23937Fixed AssetsEquity??? Gross$55564??? Stock accounts$14413??? Accumulated depreciation(29519)??? Retained earnings12561Net$26045??? Total Equity$26974Total assets$53604Total L&E$53604The following facts are available.Payables are almost entirely due to inventory purchases and canbe estimated through COGS, which is approximately 45% purchasedmaterial.Currently owned assets will depreciate an additional $1103000next year.There are two balance sheet accruals. The first is for unpaidwages. The current payroll of $31 million is expected to grow by13% next year. The closing date of the year will be six workingdays after a payday. The second accrual is an estimate of the costof purchased items that have arrived in inventory, but for whichvendor invoices have not yet been received. This materials accrualis generally about 8% 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 of10%.PLANNING ASSUMPTIONSIncome Statement ItemsRevenue will grow by 12% with no change in product mix.Competitive pressure, however, is expected to force some reductionsin pricing.The pressure on prices will result in a 1.5% deterioration(increase) in the next year's cost ratio.Spending in the marketing department is considered excessiveand will be held to 20% of revenue next year.Because of a major development project, expenses in theengineering department will increase by 20%.Finance and administration expenses will increase by 7%.Assets and LiabilitiesAn enhanced cash management system will reduce cash balances by10%.The ACP will be reduced by 15 days. (Calculate the currentvalue to arrive at the target.)The inventory turnover ratio (COGS/inventory) will decrease by0.5x.Capital spending is expected to be $5 million. The averagedepreciation life of the assets to be acquired is five years. Thefirm uses straight-line depreciation, and takes a half year in thefirst year.Bills are currently paid in 50 days. Plans are to shorten thatto 30 days.A dividend totaling $1.5 million will be paid next year. No newstock will be sold.Develop next year's financial plan for Haverly on the basis ofthese assumptions and last year's financial statements. Include aprojected income statement, balance sheet and a statement of cashflows. Enter your dollar answers in thousands. For example, ananswer of $200 thousands should be entered as 200, not 200000.Round dollar answers and intermediate calculations to the nearestthousand. Round the percentage values to 1 decimal place. Enter allamounts in Income Statement as a positive numbers. Use a minussign, to indicate a negative cash outflow, or a decrease in cash inBalance Sheet and Cash Flow Statement.HAVERLY COMPANYINCOME STATEMENTS($000)THIS YEARNEXT YEAR$%$%Revenue$83640100.0$  100.0COGS3599043%Gross Margin$4765057$  %Expenses:??? Marketing$1816921.7$  %??? Engineering36534.4%??? Fin & Admin37354.5%??? Total Exp.$2555730.6$  %EBIT$2209326.4$  %Interest32773.9%EBT$1881622.5$  %Inc Tax79039.4%Net Income$1091313$  %HAVERLY COMPANYBALANCE SHEETS($000)ASSETSLIABILITIES & EQUITYTHIS YRNEXT YRTHIS YRNEXT YRCash$   6421$  Accts. Pay.$   2249$  Accts. Rec.13940Accruals444Inventory7198Curr. Assets$27559$  Curr. Liab.$   2693$  Long Term Debt$23937$  Fixed AssetsEquity??? Gross$55564$  ??? Stock Accts$14413$  ??? Accum. Depr.(29519)??? Retained Earn12561Net$26045$  ??? Total Equity$26974$  Total Assets$53604$  Total L & E$53604$  HAVERLY COMPANYCHANGES IN WORKING CAPITALNEXT YEAR ($000)A/R$  Inventory$  A/P$  Accruals$  $  HAVERLY COMPANYSTATEMENT OF CASH FLOWSNEXT YEAR ($000)OPERATING ACTIVITIESNet Income$  DepreciationIncrease in W/CCash Flow From Operating Activities$  INVESTING ACTIVITIESIncrease in Gross Fixed Assets$  FINANCING ACTIVITIESDecrease in Debt$  Dividend$  $  NET CASH FLOW$  RECONCILIATIONBeginning Cash$  Net Cash Flow$  Ending Cash$  

Other questions asked by students