Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help fill in blanks, thank you. COMPUTE THE Z-MODEL SCORE in data below WIOWE EFFORT-MO MOLD - -MILP mus IT Z-Model 18 PEACHY Pts
Please help fill in blanks, thank you.
COMPUTE THE Z-MODEL SCORE in data below WIOWE EFFORT-MO MOLD - -MILP mus IT Z-Model 18 PEACHY Pts LADNY INCOME STATEMENT 2016 2017 2016 Compute Z-scores for 2 yn WGNT 2016 2017 Sales/ Rue Net 3,467 3,500 1,4 3,171 Worth Captul/ Total asets 12 - -1 Working Contact 2,265 Coral Garded 2574 250 251 Grow Profit 926 Selling General and Admin 7778701 Operating in Berlore Depreciation SEE 1 154 14 165 4-2 Rotanad Lam/Total Assets Depreciation Armarios - Total Pot. Cars TT E6 Rets Operating cont. EBIT 768 To sets in 84 Internet pe ce credit. Ne 1 2 1 ] - 27 ret-Torincone & 1279135 come Tax Expence (Credit 1 10-29 8a ENT/Total Arts To 38 / 23 incom Before Catraordinary bans 63 981 ELIT NET INCOME 63 98 Tests rosa US DoloreLLI af Current 2015 2011 2016 Cash and Short Te Market Stock /Tots 06 Terrestres - 1 100 991 93 44 Vol. Recewables-Total | | | 981 57 BS Stock Price S 45.00 $ 42.00 Total 200202771 Sok Shares 20.8 28.5 Curreres-her-2019 16 24 Matapo Current At Total 410 410 484 Tat. Labs Property Plant Equipment -Tara B 378 SEE X-4 In total 2 2 0 21 Net Sales/Totalets LD Non-Current Aunt Total Nee 363 998 147 Revenue - ASSETS TOTAL 1,432 1,44 1,431 To sets rer of US Dollar 1-5 tes 2018 2017 2016 Death Current Gartenaraikal Effort-ne help 22 ptsach your ho Individual 12 year www.oneste 191216_1991 Calculate Free Cash Flow for 2 yrs Current Other 2007 76 58 77 USE 25 INC TAX RATE 2016 201 Current Liables T2091 274 275 ) EBIT Long Term Date 35 64 EBITX 1.25 taxatel pelerred Tones and investment 91 871 1191 Jubiles Other 51 52 44 Long Temas Total 1502175228 1431 yenede 409 449 sec 506 481 447 417 tel 5 10 Standar wal sos Shawhaler Iquity Total 1,023990327 UABLES & SHAREHOLDER EQUITY 1432 1492 1.431 Free Cash Flow P/BK VALUE BY INDUSTRY COMPARABLES (MULTIPLES) NAME Firm A-B-C-D are Industry Peer firms Individual Effort. NO Help 20pts Use "Comparables" method to estimate firm X's stock price. Enter correct values in 'boxed' areas. $000 Sales Earnings Book Value Market Cap Value P/S / P/E Firm A 130,000 14,000 115,000 150,000 Firm B 148,000 10,500 105,000 175,000 Firm C 95,000 9,000 85.000 120,000 Firm D 112,000 9,700 92,000 135,000 Firm X > $ 71,000 $ 8,000 $ 54,000 ICOMM SHARES 1,500 Firm X Estimated stock value> Exam-3 At-Home Dec.3 INAME 13 Use Data provided to estimate the value of Firm ABC based on relative P/E ratio Enter Answers into online Quiz Dec. 2-3 INDIVIDUAL EFFORT.NO HELP S&P500 PE Multiples Valuation Estimate PE-annual PE annual - S&PSOO & Firm 'ABC 2020 21.6 15.5 2019 23.8 16.9 2018 19.4 14.8 2017 17.9 14.1 S&P500 & 20.68 Firm 'ABC Relative P/E Step-1 AVG PE +/- 10% range Firm 'ABC' Est'd PE S&P500 PE 22.40 Step 2 FORECAST 2021 Baseline OPTIMI+10%) PESSIM (-10%) Step-3 Firm 'ABC EPS Forecast Firm 'ABC Est'd Stock Value 2021 Baselines 3.60 $ INCOME STATEMENT 2018 2017 2016 Sales/Turnover (Net) 3,509 3,467 3,137 Cost of Goods Sold 2,574 2,540 2,265 Gross Profit (Loss) 935 926 872 Selling, General and Administrative Exp 767 773 707 Operating Inc Before Depreciation 168 154 165 Depreciation and Amortization - Total 84 77 66 Operating Income After Depreciation 84 76 98 Interest - Net -2 3 27 Pret-Tax Income & Other 82 79 125 Income Taxes Expense (Credit) 19 -19 38 Income Before Extraordinary Items 63 98 87 NET INCOME (LOSS) 63 98 87 CASH FLOW STATEMENT (numbers in millions) OPERATING ACTIVITY 2018 2017 2016 Income Before Extraordi 63 98 87 Depreciation and Amort 94 85 77 Adjustments to Net Inco 8 -33 -17 Inventory - Decrease (In -1 -3 -38 Other Changes in Operat -15 17 42 OPERATING ACTIVITIES - 148 166 152 2017 96 INVESTING ACTIVITY Capital Expenditures Other Cash Flow from In INVESTING ACTIVITIES - 2018 96 5 -91 2016 142 -45 -187 -2 -97 2018 2017 32 FINANCING ACTIVITY Cash Dividends FINANCING ACTIVITIES - 2016 32 2017 2016 33 99 93 -68 -62 32 2018 107 57 281 85 280 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 98 277 16 484 24 469 19 483 12pts ea.Calculate Free Cash Flow for 2 Yrs USE 25% INC.TAX RATE 2018 2017 EBIT EBIT x (1 - 25 tax rate) 888 886 878 75 72 69 963 958 947 1,432 1,442 1,431 Current Liabilities 2018 2017 2016 Free Cash Flow 2018 2017 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 Common Stock issued Retained Earnings Shareholders' Equity Total LIABILITIES & SHAREHOLDER EQUITY T 0 0 0 191 216 199 76 58 77 267 274 276 0 35 64 91 87 119 51 52 44 142 175 228 409 449 505 460 447 563 546 510 1,023 993 927 1,432 1,442 1,431 Additional data provided is Cash Flow Statement section at top 417 COMPUTE THE Z-MODEL SCORE in data below WIOWE EFFORT-MO MOLD - -MILP mus IT Z-Model 18 PEACHY Pts LADNY INCOME STATEMENT 2016 2017 2016 Compute Z-scores for 2 yn WGNT 2016 2017 Sales/ Rue Net 3,467 3,500 1,4 3,171 Worth Captul/ Total asets 12 - -1 Working Contact 2,265 Coral Garded 2574 250 251 Grow Profit 926 Selling General and Admin 7778701 Operating in Berlore Depreciation SEE 1 154 14 165 4-2 Rotanad Lam/Total Assets Depreciation Armarios - Total Pot. Cars TT E6 Rets Operating cont. EBIT 768 To sets in 84 Internet pe ce credit. Ne 1 2 1 ] - 27 ret-Torincone & 1279135 come Tax Expence (Credit 1 10-29 8a ENT/Total Arts To 38 / 23 incom Before Catraordinary bans 63 981 ELIT NET INCOME 63 98 Tests rosa US DoloreLLI af Current 2015 2011 2016 Cash and Short Te Market Stock /Tots 06 Terrestres - 1 100 991 93 44 Vol. Recewables-Total | | | 981 57 BS Stock Price S 45.00 $ 42.00 Total 200202771 Sok Shares 20.8 28.5 Curreres-her-2019 16 24 Matapo Current At Total 410 410 484 Tat. Labs Property Plant Equipment -Tara B 378 SEE X-4 In total 2 2 0 21 Net Sales/Totalets LD Non-Current Aunt Total Nee 363 998 147 Revenue - ASSETS TOTAL 1,432 1,44 1,431 To sets rer of US Dollar 1-5 tes 2018 2017 2016 Death Current Gartenaraikal Effort-ne help 22 ptsach your ho Individual 12 year www.oneste 191216_1991 Calculate Free Cash Flow for 2 yrs Current Other 2007 76 58 77 USE 25 INC TAX RATE 2016 201 Current Liables T2091 274 275 ) EBIT Long Term Date 35 64 EBITX 1.25 taxatel pelerred Tones and investment 91 871 1191 Jubiles Other 51 52 44 Long Temas Total 1502175228 1431 yenede 409 449 sec 506 481 447 417 tel 5 10 Standar wal sos Shawhaler Iquity Total 1,023990327 UABLES & SHAREHOLDER EQUITY 1432 1492 1.431 Free Cash Flow P/BK VALUE BY INDUSTRY COMPARABLES (MULTIPLES) NAME Firm A-B-C-D are Industry Peer firms Individual Effort. NO Help 20pts Use "Comparables" method to estimate firm X's stock price. Enter correct values in 'boxed' areas. $000 Sales Earnings Book Value Market Cap Value P/S / P/E Firm A 130,000 14,000 115,000 150,000 Firm B 148,000 10,500 105,000 175,000 Firm C 95,000 9,000 85.000 120,000 Firm D 112,000 9,700 92,000 135,000 Firm X > $ 71,000 $ 8,000 $ 54,000 ICOMM SHARES 1,500 Firm X Estimated stock value> Exam-3 At-Home Dec.3 INAME 13 Use Data provided to estimate the value of Firm ABC based on relative P/E ratio Enter Answers into online Quiz Dec. 2-3 INDIVIDUAL EFFORT.NO HELP S&P500 PE Multiples Valuation Estimate PE-annual PE annual - S&PSOO & Firm 'ABC 2020 21.6 15.5 2019 23.8 16.9 2018 19.4 14.8 2017 17.9 14.1 S&P500 & 20.68 Firm 'ABC Relative P/E Step-1 AVG PE +/- 10% range Firm 'ABC' Est'd PE S&P500 PE 22.40 Step 2 FORECAST 2021 Baseline OPTIMI+10%) PESSIM (-10%) Step-3 Firm 'ABC EPS Forecast Firm 'ABC Est'd Stock Value 2021 Baselines 3.60 $ INCOME STATEMENT 2018 2017 2016 Sales/Turnover (Net) 3,509 3,467 3,137 Cost of Goods Sold 2,574 2,540 2,265 Gross Profit (Loss) 935 926 872 Selling, General and Administrative Exp 767 773 707 Operating Inc Before Depreciation 168 154 165 Depreciation and Amortization - Total 84 77 66 Operating Income After Depreciation 84 76 98 Interest - Net -2 3 27 Pret-Tax Income & Other 82 79 125 Income Taxes Expense (Credit) 19 -19 38 Income Before Extraordinary Items 63 98 87 NET INCOME (LOSS) 63 98 87 CASH FLOW STATEMENT (numbers in millions) OPERATING ACTIVITY 2018 2017 2016 Income Before Extraordi 63 98 87 Depreciation and Amort 94 85 77 Adjustments to Net Inco 8 -33 -17 Inventory - Decrease (In -1 -3 -38 Other Changes in Operat -15 17 42 OPERATING ACTIVITIES - 148 166 152 2017 96 INVESTING ACTIVITY Capital Expenditures Other Cash Flow from In INVESTING ACTIVITIES - 2018 96 5 -91 2016 142 -45 -187 -2 -97 2018 2017 32 FINANCING ACTIVITY Cash Dividends FINANCING ACTIVITIES - 2016 32 2017 2016 33 99 93 -68 -62 32 2018 107 57 281 85 280 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 98 277 16 484 24 469 19 483 12pts ea.Calculate Free Cash Flow for 2 Yrs USE 25% INC.TAX RATE 2018 2017 EBIT EBIT x (1 - 25 tax rate) 888 886 878 75 72 69 963 958 947 1,432 1,442 1,431 Current Liabilities 2018 2017 2016 Free Cash Flow 2018 2017 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 Common Stock issued Retained Earnings Shareholders' Equity Total LIABILITIES & SHAREHOLDER EQUITY T 0 0 0 191 216 199 76 58 77 267 274 276 0 35 64 91 87 119 51 52 44 142 175 228 409 449 505 460 447 563 546 510 1,023 993 927 1,432 1,442 1,431 Additional data provided is Cash Flow Statement section at top 417Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started