Math Problem Statement
You are evaluating a new product. In year 3 of your analysis, you are projecting pro forma sales of $4.64.6 million and cost of goods sold of $2.762.76 million. You will be depreciating a $1.41.4 million machine for 55 years using straight-line depreciation. Your tax rate is 2121%. Finally, you expect net working capital to increase from $210 comma 000210,000 in year 2 to $305 comma 000305,000 in year 3. What are your pro forma earnings for year 3? What is your pro forma free cash flow for year 3? Question content area bottom Part 1 Complete the following pro forma statement. (Round to the nearest dollar.) Pro Forma Income Statement
Year 3 Sales $ 4600000 COGS 76000000 Depreciation
EBIT $ 7080000 Tax
148680000.00% Earnings $
Add Back Depreciation
Subtract Change in NWC
Free Cash Flow $
Solution
To calculate the pro forma earnings and free cash flow for Year 3, we can follow these steps:
Pro Forma Income Statement for Year 3
-
Sales: $4,600,000
-
Cost of Goods Sold (COGS): $2,760,000
-
Depreciation:
- Cost of machine = $1,410,000
- Useful life = 5 years
- Annual Depreciation =
-
EBIT (Earnings Before Interest and Taxes):
-
Tax:
- Tax Rate = 21%
-
Earnings:
Calculation of Free Cash Flow for Year 3
-
Add Back Depreciation:
- Add back the depreciation expense:
-
Change in Net Working Capital (NWC):
- Increase in NWC = New NWC - Old NWC = $305,000 - $210,000 = $95,000
- This amount is subtracted from the cash flow.
-
Free Cash Flow (FCF): \text{Free Cash Flow} = \text{Earnings} + \text{Depreciation} - \text{Change in NWC
Summary of Pro Forma Income Statement
Item | Amount |
---|---|
Sales | $4,600,000 |
COGS | $2,760,000 |
Depreciation | $282,000 |
EBIT | $1,558,000 |
Tax (21%) | $327,180 |
Earnings | $1,230,820 |
Add Back Depreciation | $282,000 |
Subtract Change in NWC | $95,000 |
Free Cash Flow | $1,417,820 |
Final Results
- Pro Forma Earnings for Year 3: $1,230,820
- Pro Forma Free Cash Flow for Year 3: $1,417,820
Would you like further details or explanations on any part of this calculation? Here are some related questions you might consider:
- How does depreciation impact tax calculations?
- What are the implications of increasing net working capital?
- How do changes in sales projections affect earnings?
- What other factors should be considered in cash flow projections?
- How can free cash flow be utilized in business decisions?
Tip: Regularly updating your financial projections can help adjust for market changes and improve decision-making.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Financial Analysis
Earnings Calculation
Cash Flow Analysis
Formulas
EBIT = Sales - COGS - Depreciation
Tax = EBIT * Tax Rate
Earnings = EBIT - Tax
Free Cash Flow = Earnings + Depreciation - Change in NWC
Theorems
-
Suitable Grade Level
Grades 11-12
Related Recommendation
Pro Forma Earnings and Free Cash Flow Calculation for $967,000 in Sales
Calculate Free Cash Flow for a Project with $310,000 Revenue and $140,000 Expenses
Calculate Free Cash Flows for a Project with Depreciation and Tax Adjustments
Operating Cash Flow Calculation for a 3-Year Project with Depreciation and Tax Adjustment
Calculate the Free Cash Flow (FCF) for 2012