Math Problem Statement

Your pro forma income statement shows sales of ​$967 comma 000​, cost of goods sold as ​$511 comma 000​, depreciation expense of $ 100 comma 000​, and taxes of ​$99 comma 680 due to a tax rate of 28 %. What are your pro forma​ earnings? What is your pro forma free cash​ flow? Question content area bottom Part 1 Complete the pro forma income statement​ below:  ​(Round to the nearest​ dollar.) Sales $

Cost of Goods Sold $

Gross Profit $

Depreciation $

EBIT $

Taxes (28%) $

Earnings $

Solution

Let's break this down step-by-step.

Part 1: Pro Forma Income Statement

  1. Sales: Given as $967,000.

  2. Cost of Goods Sold (COGS): Given as $511,000.

  3. Gross Profit: Gross Profit=SalesCost of Goods Sold\text{Gross Profit} = \text{Sales} - \text{Cost of Goods Sold} Gross Profit=967,000511,000=456,000\text{Gross Profit} = 967,000 - 511,000 = 456,000

  4. Depreciation Expense: Given as $100,000.

  5. Earnings Before Interest and Taxes (EBIT): EBIT=Gross ProfitDepreciation\text{EBIT} = \text{Gross Profit} - \text{Depreciation} EBIT=456,000100,000=356,000\text{EBIT} = 456,000 - 100,000 = 356,000

  6. Taxes (28%): Given that the tax rate is 28%, you calculate taxes as: Taxes=EBIT×0.28\text{Taxes} = \text{EBIT} \times 0.28 Taxes=356,000×0.28=99,680\text{Taxes} = 356,000 \times 0.28 = 99,680

  7. Pro Forma Earnings: Earnings=EBITTaxes\text{Earnings} = \text{EBIT} - \text{Taxes} Earnings=356,00099,680=256,320\text{Earnings} = 356,000 - 99,680 = 256,320

Summary of the Pro Forma Income Statement:

CategoryAmount ($)
Sales967,000
Cost of Goods Sold511,000
Gross Profit456,000
Depreciation100,000
EBIT356,000
Taxes (28%)99,680
Earnings256,320

Part 2: Pro Forma Free Cash Flow

Free Cash Flow (FCF) can be calculated as:

FCF=Earnings+Depreciation\text{FCF} = \text{Earnings} + \text{Depreciation} Using the values we found earlier:

FCF=256,320+100,000=356,320\text{FCF} = 256,320 + 100,000 = 356,320

Final Results:

  • Pro Forma Earnings: $256,320
  • Pro Forma Free Cash Flow: $356,320

Would you like any further details or clarifications?

Related Questions:

  1. How would the free cash flow change if depreciation increased?
  2. What would happen if the tax rate was 35% instead of 28%?
  3. How is EBIT different from operating income?
  4. Why is depreciation added back when calculating free cash flow?
  5. How does an increase in sales affect gross profit?

Tip: Depreciation is a non-cash expense, which is why it’s added back to earnings to calculate free cash flow.

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Financial Statement Analysis
Income Statement
Free Cash Flow

Formulas

Gross Profit = Sales - Cost of Goods Sold
EBIT = Gross Profit - Depreciation
Taxes = EBIT * Tax Rate
Earnings = EBIT - Taxes
Free Cash Flow = Earnings + Depreciation

Theorems

-

Suitable Grade Level

College Level / Financial Analysis