I am filling out this dcf analysis spreadsheet for Mohawk industries How to I find everything from the FCFE section and below Any help would be appreciated Pro Forma 12 31 21 12 31 22 12 31 20 12 31 23 12 31 24 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 $ in millions Actual 12 31 19 Sales Sales Growth Rate EBIT Margin EBIT Interest Rate on Average Debt Interest Expense EBT Income Tax Rate Income Tax Expense Net Income to Common Total Assets Total Common Equity Total Interest Bearing Debt All Other Liabilities Sales Ending Assets Interest Bearing Debt Assets All Other Liabilities Assets FCFE Years of Discounting PV of FCFE Terminal Value PV of Terminal Value PV of Equity Fiscal Year End Target Price Fiscal Year End Diluted EPS 3 month T Bill Estimate of Future Beta Cost of Equity Latest diluted share count in millions DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 0 0 0 0 0 0 0 00 DIV 0 DIV 0 0 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 0 00 0 00 0 00 DIV 0 3 5 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 0 5 DIV 0 DIV 0 1 5 DIV 0 DIV 0 2 5 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV OL DIV 0 DIV 0 DIV 0 0 0000 Pro Forma 12 31 21 12 31 22 12 31 20 12 31 23 12 31 24 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 $ in millions Actual 12 31 19 Sales Sales Growth Rate EBIT Margin EBIT Interest Rate on Average Debt Interest Expense EBT Income Tax Rate Income Tax Expense Net Income to Common Total Assets Total Common Equity Total Interest Bearing Debt All Other Liabilities Sales Ending Assets Interest Bearing Debt Assets All Other Liabilities Assets FCFE Years of Discounting PV of FCFE Terminal Value PV of Terminal Value PV of Equity Fiscal Year End Target Price Fiscal Year End Diluted EPS 3 month T Bill Estimate of Future Beta Cost of Equity Latest diluted share count in millions DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 0 0 0 0 0 0 0 00 DIV 0 DIV 0 0 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 0 00 0 00 0 00 DIV 0 3 5 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 0 5 DIV 0 DIV 0 1 5 DIV 0 DIV 0 2 5 DIV 0 DIV 0 DIV 0 DIV 0 DIV 0 DIV OL DIV 0 DIV 0 DIV 0 0 0000

Question

I am filling out this dcf analysis spreadsheet for Mohawk industries  How to I find everything from the FCFE section and below  Any help would be appreciated  Pro Forma 12 31 21 12 31 22 12 31 20 12 31 23 12 31 24  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  $ in millions Actual 12 31 19 Sales Sales Growth Rate EBIT Margin EBIT Interest Rate on Average Debt Interest Expense EBT Income Tax Rate Income Tax Expense Net Income to Common Total Assets Total Common Equity Total Interest Bearing Debt All Other Liabilities Sales Ending Assets Interest Bearing Debt Assets All Other Liabilities Assets FCFE Years of Discounting PV of FCFE Terminal Value PV of Terminal Value PV of Equity Fiscal Year End Target Price Fiscal Year End Diluted EPS 3 month T Bill Estimate of Future Beta Cost of Equity Latest diluted share count in millions  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  0 0  0 0  0 0 0 00   DIV 0   DIV 0  0 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  0 00 0 00 0 00  DIV 0  3 5  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  0 5  DIV 0   DIV 0  1 5  DIV 0   DIV 0  2 5  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV OL  DIV 0   DIV 0   DIV 0  0 0000  Pro Forma 12 31 21 12 31 22 12 31 20 12 31 23 12 31 24  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  $ in millions Actual 12 31 19 Sales Sales Growth Rate EBIT Margin EBIT Interest Rate on Average Debt Interest Expense EBT Income Tax Rate Income Tax Expense Net Income to Common Total Assets Total Common Equity Total Interest Bearing Debt All Other Liabilities Sales Ending Assets Interest Bearing Debt Assets All Other Liabilities Assets FCFE Years of Discounting PV of FCFE Terminal Value PV of Terminal Value PV of Equity Fiscal Year End Target Price Fiscal Year End Diluted EPS 3 month T Bill Estimate of Future Beta Cost of Equity Latest diluted share count in millions  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  0 0  0 0  0 0 0 00   DIV 0   DIV 0  0 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  0 00 0 00 0 00  DIV 0  3 5  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0  0 5  DIV 0   DIV 0  1 5  DIV 0   DIV 0  2 5  DIV 0   DIV 0   DIV 0   DIV 0   DIV 0   DIV OL  DIV 0   DIV 0   DIV 0  0 0000

Accepted Answer

The Answer is in the image, click to view ...

Question

I am filling out this dcf analysis spreadsheet for Mohawk industries. How to I find everything from the FCFE section and below? Any help would

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Passive Income A Guide To Building Passive Income Streams

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question