Question

Given the following information, calculate free cash flow. Sales 1,080 EBITDA/Sales Margin 15% D&A % of...

Given the following information, calculate free cash flow.

Sales 1,080
EBITDA/Sales Margin 15%
D&A % of Sales 2%
Tax Rate 38%
Capex % of Sales 2%
Increase in NWC 8

I have to create a formula in Excel. Thank you!

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given the following information, please calculate after tax cash flow for year 1. Assuming a sales...
Given the following information, please calculate after tax cash flow for year 1. Assuming a sales price of $1,100,000, please calculate the after tax cash flow from the sale (don’t forget the depreciation recapture.) Finally, calculate the after tax IRR for the investment. Purchase Price: $900,000 Loan: $750,000, 5%, 25 years (annual payments) Year 1 NOI: $100,000 Year 2 ATCF: $33,000 Year 3 ATCF: $34,000 Use an 85/15 ratio for depreciation. 39 year, straight line. 35% tax rate on income,...
Calculate free cash flow for the below company. EBITDA 112.0 Depreciation 18.0 Amortization 12.0 Tax rate...
Calculate free cash flow for the below company. EBITDA 112.0 Depreciation 18.0 Amortization 12.0 Tax rate 32.0% Capital expenditure 40.0 (Inc) / dec in OWC (15.0) Select one: 60.8 21.2 30.8 57.0
Garey, Inc. had sales for 2019 of $500,000, and EBITDA was 25% of sales. Furthermore, depreciation...
Garey, Inc. had sales for 2019 of $500,000, and EBITDA was 25% of sales. Furthermore, depreciation was $13,000, interest was $8,500, the corporate tax rate was 21%, and the company pays 10% of its net income as dividends. Given this information and the balance sheets below, calculate the free cash flow for 2019. a. $92,430 b. $98,080 c. $89,730 d. $91,280 e. None of the above is within $10 of the correct answer.
Project Costing and Cash Flow Modelling For the following project, calculate the undiscounted cash flow. You...
Project Costing and Cash Flow Modelling For the following project, calculate the undiscounted cash flow. You can do it in Excel and paste the result below: Year 0 1 2 3 4 5 Unit Price - $105 $110 $115 $120 $125 Units Sold - 900 1000 1100 1200 1300 Net Sales - Variable Costs - $54,000 $60,000 $66,000 $72,000 $78,000 Fixed Costs - $15,000 $15,750 $16,538 $17,364 $18,233 Depreciation - $10,000 $10,000 $10,000 $10,000 $10,000 PBIT - Tax@40% - NOPAT...
Use the following information and a Free Cash Flow to the Firm model to calculate the...
Use the following information and a Free Cash Flow to the Firm model to calculate the stock price for Andrews, Inc. Show your work. The free cash flow to the firm last year was 900.   The free cash flow is expected to grow at a rate of 10 percent annually for the next two years and remain the same thereafter. CAPM Equity Return 0.130 WACC 0.065 Cash & Marketable Sec. 580 Market Value of Debt 12,000 Book Value of Debt...
You are trying to calculate the enterprise value of DCB Corp using a free cash flow...
You are trying to calculate the enterprise value of DCB Corp using a free cash flow model. To that end you have put together some forecast for year 1 in the table below. Assume that free cash flows will grow at 1.5% in perpetuity and that the weighted average cost of capital of the firm (WACC) is 8%. Using this information, calculate the enterprise value of the firm. Express your answer in $-millions and round to two decimals (do not...
Given the following information, calculate free cash flow to equity: Net Income: $70 Working Capital Investment:...
Given the following information, calculate free cash flow to equity: Net Income: $70 Working Capital Investment: $4 Beginning gross fixed assets, $90, Ending gross fixed assets, $136 Beg accumulated depreciation $30, Ending accumulated depreciation $40 Depreciation Exp:$20 Capital expenditures: $45 Net Borrowing: $0 In addition, a piece of equipment with original book value $19 was sold for $10. The equipment book value at time of sale was $2 and gain was classified as unusual.Find Free Cash Flow to Equity.
3.1 Project Costing and Cash Flow Modelling For the following project, calculate the undiscounted cash flow....
3.1 Project Costing and Cash Flow Modelling For the following project, calculate the undiscounted cash flow. You can do it in Excel and paste the result below. Year 0 1 2 3 4 5 Unit Price - $105 $110 $115 $120 $125 Units Sold - 900 1000 1100 1200 1300 Net Sales - Variable Costs - $54,000 $60,000 $66,000 $72,000 $78,000 Fixed Costs - $15,000 $15,750 $16,538 $17,364 $18,233 Depreciation - $10,000 $10,000 $10,000 $10,000 $10,000 PBIT - Tax@40% -...
Given the following project information, calculate the after-tax operating cash flow (ATOCF) using the four approaches...
Given the following project information, calculate the after-tax operating cash flow (ATOCF) using the four approaches of calculating operating cash flow.                                                                      Project cost = $950,000 Project life = five years Projected number of units sold per year = 10,000 Projected price per unit = $200 Projected variable cost per unit = 150 Fixed costs per year = $150,000 Required rate of return = 15% Marginal tax rate = 35% Depreciation = Straight-line to zero over five years (ignore...
Calculate Net Operating Profit After Tax (NOPAT), Operating Cash Flow (OCF) and Free Cash Flow (FCF)...
Calculate Net Operating Profit After Tax (NOPAT), Operating Cash Flow (OCF) and Free Cash Flow (FCF) for Unlimited Masks Inc., with the following financial information: - EBIT $20.2mm - Depreciation $3.6mm - Interest Expense $4.0mm - Capital Expenditures $2.5mm - Change in working capital $4.0mm - Tax rate 21%
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT