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
The following table gives the the approximate amount of emissions E of nitrogen oxides in...
Karen Gaines invested $12,000 in a money market account with an interest rate of 3.25%...
Two long distance runners began an 18 3/4-mile run. They ran uphill for 5 5/8...
You may need to use the appropriate technology to answer this question A company manufactures...
Imagine that the construction of each room in a new hotel project will cost $118,000...
1 1 Part of Required Information The following prormation apples to the questions sprayed below)...
requirement at the bottom of first picture! thank you very much ...