Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Your At-Home problem required calculating the firm's Free Cash Flow for two years. Some problems had 2020-2019 data, others had 2018-2017 data. List your

1) Your At-Home problem required calculating the firm's Free Cash Flow for two years. Some problems had 2020-2019 data, others had 2018-2017 data.
List your TWO $ F-C-F answers (later year first)

2) Your At-Home problem required calculating a firm's Z-score for two years. Each Z-score is the sum of 5 components, X1-to-X5. For your later-year Z-score (either 2020 or 2018) , list in order each of the 5 values that add up to that later year's Z-score.

3) Your At-Home problem required calculating a firm's Z-score for two years. Each Z-score is the sum of 5 components, X1-to-X5. For your earlier-year Z-score (either 2019 or 2017) , list in order each of the 5 values that add up to that earlier year's Z-score.

(4) Problem-3 = S&P500 PE Multiples Valuation for Firm 'ABC'. From the lower-right area of the problem, ENTER THREE ANSWERS, in order.
Enter #1 Answ, #2 Answ, #3 Answ

5) Industry Comparables (Multiples) Problem to estimate Firm X stock value. Enter the TWO hi-lited, boxed $ amounts calculated.
List Firm X's A) Est'd Market Cap value B) Est'd Stock value
image text in transcribed
4 8 1 millions of US Dollars NEW DATA PROVIDED --> INCOME STATEMENT 2020 2019 2018 Sales/Turnover (Net) 4,113 3,543 3,509 Cost of Goods Sold 3,012 2,605 2,574 Gross Profit (Loss) 1,100 938 935 Selling, General and Administrative Exp 847 768 767 Operating Inc Before Depreciation 253 170 168 Depreciation&Amortization - Total 90 85 84 Operating Income EBIT 163 85 84 Interest - Net 1 4 -2 Pret-Tax Income & Other 164 89 82 Income Taxes Expense (Credit) 45 21 19 Income Before Extraordinary Items 119 68 63 NET INCOME (LOSS) 119 68 63 CASH FLOW STATEMENT (# in millions) OPERATING ACTIVITY 2020 2019 2018 Income Before Extraordi 119 68 63 Depreciation+Amortizat 90 85 84 Adjustments to Net Inco 9 Inventory - Decrease in 11 -1 Other Changes in Opera 49 14 -5 OPERATING ACTIVITIES 278 172 148 INVESTING ACTIVITY 2020 2019 2018 Capital Expenditures 131 101 96 Other Cash Flow from in -8 5 INVESTING ACTIVITIES -175 -109 -91 FINANCING ACTIVITY Cash Dividends FINANCING ACTIVITIES 2020 2019 2018 33 33 33 -33-33 -68 Current Assets Cash and Short-Term Investments - To Receivables - Total Inventories - Total Current Assets - Other - Total Current Assets Total Non-Current Assets Property Plant and Equipment - Total Intangible Assets - Total Non-Current Assets Total ASSETS TOTAL 2020 271 57 269 29 626 2019 149 56 280 23 508 2018 107 57 281 24 469 12pts ea.Calculate Free Cash Flow for 2 yrs USE 25% INC.TAX RATE 2020 2019 EBIT EBIT X (1 - 25 tax rate) 1,124 1,097 70 70 1,194 1,167 1,820 1,676 888 75 963 1,432 Free Cash Flow Current Liabilities Debt in Current Liabilities Account Payable/Creditors - Trade Current Liabilities - Other Current Liabilities Total Long-Term Debt Total Deferred Taxes and Investment Tax Cre Liabilities (Other) Long-Term Liabilities Total Liabilities Total Shareholders' Equity Total JABILITIES & SHAREHOLDER EQUITY T 2020 2019 39 39 222 181 85 72 346 292 169 180 103 97 56 48 328 325 674 617 1,146 1,059 1,820 1,676 2018 0 191 76 267 0 91 51 142 409 1,023 1,4 4 8 1 millions of US Dollars NEW DATA PROVIDED --> INCOME STATEMENT 2020 2019 2018 Sales/Turnover (Net) 4,113 3,543 3,509 Cost of Goods Sold 3,012 2,605 2,574 Gross Profit (Loss) 1,100 938 935 Selling, General and Administrative Exp 847 768 767 Operating Inc Before Depreciation 253 170 168 Depreciation&Amortization - Total 90 85 84 Operating Income EBIT 163 85 84 Interest - Net 1 4 -2 Pret-Tax Income & Other 164 89 82 Income Taxes Expense (Credit) 45 21 19 Income Before Extraordinary Items 119 68 63 NET INCOME (LOSS) 119 68 63 CASH FLOW STATEMENT (# in millions) OPERATING ACTIVITY 2020 2019 2018 Income Before Extraordi 119 68 63 Depreciation+Amortizat 90 85 84 Adjustments to Net Inco 9 Inventory - Decrease in 11 -1 Other Changes in Opera 49 14 -5 OPERATING ACTIVITIES 278 172 148 INVESTING ACTIVITY 2020 2019 2018 Capital Expenditures 131 101 96 Other Cash Flow from in -8 5 INVESTING ACTIVITIES -175 -109 -91 FINANCING ACTIVITY Cash Dividends FINANCING ACTIVITIES 2020 2019 2018 33 33 33 -33-33 -68 Current Assets Cash and Short-Term Investments - To Receivables - Total Inventories - Total Current Assets - Other - Total Current Assets Total Non-Current Assets Property Plant and Equipment - Total Intangible Assets - Total Non-Current Assets Total ASSETS TOTAL 2020 271 57 269 29 626 2019 149 56 280 23 508 2018 107 57 281 24 469 12pts ea.Calculate Free Cash Flow for 2 yrs USE 25% INC.TAX RATE 2020 2019 EBIT EBIT X (1 - 25 tax rate) 1,124 1,097 70 70 1,194 1,167 1,820 1,676 888 75 963 1,432 Free Cash Flow Current Liabilities Debt in Current Liabilities Account Payable/Creditors - Trade Current Liabilities - Other Current Liabilities Total Long-Term Debt Total Deferred Taxes and Investment Tax Cre Liabilities (Other) Long-Term Liabilities Total Liabilities Total Shareholders' Equity Total JABILITIES & SHAREHOLDER EQUITY T 2020 2019 39 39 222 181 85 72 346 292 169 180 103 97 56 48 328 325 674 617 1,146 1,059 1,820 1,676 2018 0 191 76 267 0 91 51 142 409 1,023 1,4

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

Fundamentals Of Futures And Options Markets

Authors: John C. Hull

4th Edition

0130176028, 9780130176028

More Books

Students also viewed these Finance questions