Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The management of Coker Corp. is doing a quick forecast of 20X9 using the modified percentage of sales method in preparation for a more detailed

The management of Coker Corp. is doing a quick forecast of 20X9 using the modified percentage of sales method in preparation for a more detailed planning exercise later in the month. The estimate is to assume a 10% growth in sales. All other line items are to be assumed to grow at the same rate except for fixed assets which is projected to increase by $77,000 due to an expansion program already underway. Approximate financial statements for the current year, 20X8, and a planning worksheet are shown below. The firm pays 9% interest on all of its debt. Assume the tax rate is a flat 20%. There are no plans for dividends or the sale of additional stock next year. Make a forecast of Coker's complete income statement and balance sheet. Enter your answers in thousands. For example, an answer of $12 thousands should be entered as 12, not 12,000. (Hints: The easiest way to grow a number by 10% is to multiply it by 1.1 rather than taking 10% and adding. Do not grow subtotals. For example, to grow revenue and COGS by 10%, round each to the nearest thousand and subtract for gross margin. Don't grow interest, debt, or equity; use the debt/interest iteration technique.) Round your answers to the nearest whole thousand. Enter all amounts as a positive numbers.

Coker Corp.
Current and Projected Income Statements ($000)
20X8 20X9
Revenue $683 $
COGS 294
Gross Margin $389 $
Expenses 106
EBIT 283
Interest (9%) 39
EBT $244 $
Inc Tax (20%) 49
Net Income $195 $
Coker Corp.
Current and Projected Balance Sheets ($000)
ASSETS LIABILITIES & EQUITY
20X8 20X9 20X8 20X9
C/A $159 $ C/L $ 84 $
F/A 537 Debt 387
Total $696 $ Equity 225
Total $696 $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inclusive And Sustainable Finance Leadership Ethics And Culture

Authors: Atul K. Shah

1st Edition

0367759403, 978-0367759407

More Books

Students also viewed these Finance questions