The Owl Corporation is planning for 20X2. The firm expects to have the following financial result in 20X1 ($000).

Management has made the following planning assumptions:
Income Statement
• Revenue will grow by 10%.
• The cost ratio will improve to 37% of revenues.
• Expenses will be held to 44% of revenues.
Balance Sheet
• The year end cash balance will be $1.5 million.
• The ACP will improve to 40 days from the current 60.
• Inventory turnover will improve to 7_ from 6_.
• Trade payables will continue to be paid in 45 days.
• New capital spending will be $5 million.
• Newly purchased assets will be depreciated over 10 years using the straight line method taking a full year’s depreciation in the first year.
• The company’s payroll will be $13.7 million at the end of 20X2.
• No dividends or new stock sales are planned.
The following facts are also available:
• The firm pays 10% interest on all of its debt.
• The combined state and federal income tax rate is a flat 40%.
• The only significant payables come from inventory purchases, and product cost is 75% purchased materials.
• Existing assets will be depreciated by $1,727,000 next year.
• The only significant accrual is payroll. The last day of 20X2 will be one week after a payday.
Forecast Owl’s income statement and balance sheet for 20X2. Round all calculations to the nearest $1,000 and use a 360-dayyear.

Transcribed Image Text:

INCOME STATEMENT Revenue COGS Gross margin Expense EBIT Interest EBT Income tax EAT $37,483 14,807 $22,676 17,721 S 4,955 S 1,380 3,575 1.430 S 2,145 100.0 39.5 60.5 47.3 13.2 3.7 9.5 3.8 5.7 BALANCE SHEET Assets Liabilities & Equity Cash Accts. Rec. Inventory Curr. Assets Fixed Assets 1,571 6,247 2,468 $10,286 Accts. Pay.1,388 Accruals 98 Curr. Liab. Capital Debt Equity 2,373 $25,608 Accum. Dep. 14,936) $10,672 $20,958 Gross $12,390 6,195 $18,585 $20,958 Net Total Assets Total L & E