Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete all ratios from Profitability, Liquidity, Leverage, Activity, and Price-to-Earnings ratios are present and correctly calculated based on the years 2020 of Domino's Pizza Inc.

Complete all ratios from Profitability, Liquidity, Leverage, Activity, and Price-to-Earnings ratios are present and correctly calculated based on the years 2020 of Domino's Pizza Inc. (DPZ on NYSE). Please attach formulas used. Complete the ratios on the last table highlighted in yellow. Number are in millions of USD (except per share items)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

2018 2019 400.709 59.93 59.93 -3.297 2.023 0.473 2.496 -20.9 -6.741 66.137 5.322 -6.706 37.112 496.95 -85.565 -85.565 -3.423 12.258 50.152 361.972 53.665 53.665 -0.872 -4.737 7.938 3.201 -18.172 -12.455 10.01 2.174 -5.352 -23.795 394.171 -119.888 -119.888 Cash Flow of Domino's Pizza Inc. 2020 Net Income/Starting Line 491.296 Depreciation 65.038 Depreciation/Depletion 65.038 Deferred Taxes 14.424 Unusual Items 2.922 Other Non-Cash Items -28.46 Non-Cash Items -25.538 Accounts Receivable -33.334 Other Assets -24.959 Payable/Accrued 68.954 Other Liabilities 5.544 Other Assets & Liabilities, Net 31.369 Changes in Working Capital 47.574 Cash from Operating Activities 592.794 Purchase of Fixed Assets -88.768 Capital Expenditures -88.768 Acquisition of Business 0 Sale of Fixed Assets 0.174 Sale/Maturity of Investment 0 Purchase of Investments -40 Other Investing Cash Flow -0.333 Other Investing Cash Flow Items, Total -40.159 Cash from Investing Activities -128.927 Other Financing Cash Flow -6.803 Financing Cash Flow Items -6.803 Cash Dividends Paid - Common -121.925 Total Cash Dividends Paid -121.925 Sale/Issuance of Common Repurchase/Retirement of Common -304.59 Common Stock, Net -304.59 Options Exercised 30.97 Issuance (Retirement) of Stock, Net -273.62 Long Term Debt Issued 158 Long Term Debt Reduction -202.058 Long Term Debt, Net -44.058 Issuance (Retirement) of Debt, Net -44.058 Cash from Financing Activities -446.406 Foreign Exchange Effects 0.761 Net Change in Cash 18.222 Net Cash - Beginning Balance 483.924 Net Cash - Ending Balance 502.146 Cash Interest Paid 160.6 Cash Taxes Paid 60.4 -1.276 57.711 -27.854 - 14.049 - 14.049 -105.715 -105.715 8.367 94.007 -70.152 -0.591 31.631 -88.257 -15.169 -15.169 -92.166 -92.166 -699.007 -699.007 13.064 -685.943 675 -92.085 582.915 582.915 -222.792 0.201 246.505 237.419 483.924 142.3 80.3 -591.212 -591.212 9.832 -581.38 970 -604.088 365.912 365.912 -322.803 -0.538 -17.427 254.846 237.419 132.8 71.7 Reserves Balance Sheet of Domino's Pizza Inc. 2020 2019 2018 Cash & Equivalents $ $ 284.72 $ 190.62 $ 25.44 Cash and Short Term Investments 284.72 190.62 25.44 Accounts Receivable - Trade, Gross 24635 213.12 191.97 Provision for Doubtful Accounts (1.79) (2.86 (1.88) Accounts Receivable - Trade, Net 271.56 210.26 190.09 Notes Receivable - Short Term Total Receivables, Net 271 56 210.26 190.09 Inventories - Finished Goods 57.12 49.30 42.92 Inventories - Other 9.57 3.65 3.05 Total Inventory 66.68 52.96 45.98 Prepaid Expenses 28.97 19.13 25.71 Restricted Cash - Current 217.45 314.66 279.74 Deferred Income Tax - Current Asset Discountinued Operations - Current Asset Other Current Assets, Total 217.45 314.66 279.74 Total Current Assets 869.38 787.62 566.95 Buildings - Gross 186.46 164.07 170.50 Land/Improvements - Gross 88.06 44.85 41.15 Machinery/Equipment. Gross 292.46 243.71 243.65 Construction in Progress - Gross 13.01 42.71 31.82 Other Property/Plant/Equipment - Gross 228.27 228.79 Property/Plant/Equipment, Total - Gross 808 26 724.11 487.12 Accumulated Depreciation, Total (282.63) (252.45) (252.18) Property/Plant/Equipment, Total - Net 525.63 471.67 234.94 Goodwill, Net 15.06 15.09 14.92 intangibles - Gross 205.35 177.38 152.97 Accumulated Intangible Amortization (124.04) (104.24) (89.16) Intangibles, Net 81.31 73.14 63.81 LT Investments - Other 13.25 11.98 8.72 Long Term Investments 13.25 11.98 8.72 Note Receivable - Long Term Deferred Charges Defered Income Tax - Long Term Asset 1.90 10.07 5.53 Other Long Term Assets 60.63 12.52 12.52 Other Long Term Assets, Total 62.53 22.59 18.05 Total Assets 1.567.17 1,382.09 907.39 Accounts Payable 94.50 111.10 92.55 Accrued Expenses 201.81 169.48 117.94 Notes Payable/Short Term Debt - Current Port of LT Debt/Capital Leases 2.86 43.39 35.89 Dividends Payable Customer Advances 4.10 4.20 4.00 Other Current Liabilities 167.55 125.66 129.36 Other Current liabilities, Total , 171.65 129.86 133.36 Total Current Liabilities 470.82 453.83 379.74 Long Term Debt 4,058.32 4,052.79 3,495.69 Capital Lease Obligations 57.70 18.26 Total Long Term Debt 4,116.02 4,071.06 3,495.69 Total Debt 4,118.87 4,114.45 3,531.58 Deferred Income Tax LT Liability 6.10 Deferred Income Tax 6.10 37.13 34.68 31.07 Other Long Term Liabilities 237.51 238.29 40,81 Other Liabilities, Total 274.64 272.97 71.87 Total Liabilities 4,867.57 4,797.85 3,947.31 Convertible Preferred Stock - Non Rombl Preferred Stock - Non Redeemable, Net . Common Stock 0.39 0.39 0.41 Common Stock, Total 0.39 0.39 0.41 Additional Paid In Capital - 5.12 0.24 0.57 Retained Earnings (Accumulated Deficit) (3,303.49) (3,412.65) (3,036.47) Translation Adjustment (2.42) (3.74 (4.43 Other Equity, Total (2.42) (3.74) (4.43) Total Equity (3,300.41) (3,415.76) (3,039.92) Total Liabilities & Shareholders' Equity 1,567.17 1,382.09 907.39 Shares Outs - Common Stock Primary Issue 38.87 38.93 40.97 Shares Outstanding - Common Issue 2 0.00 0.00 0.00 Total Common Shares Outstanding 38 87 38.93 40.98 Treas Shares - Common Stock Prmry Issue Treasury Shares - Common Issue 2 Full-Time Employees 14,400.00 13,100.00 14,500.00 Number of Common Shareholders 1578.00 1,510.00 1,565.00 Accumulated intangible Amort, Suppl. 124.04 104.24 89.16 Deferred Revenue - Current 4.10 4.20 4.00 Deferred Revenue . Long Term 15.00 16.30 15.90 Total Current Assets less Inventory 802.70 734.66 520.98 Quick Ratio 1.70 1.62 1.37 Current Ratio 1.85 1.74 1.49 Net Debt Incl. Pref.Stock & Min.Interest 3.834 15 3,923.83 3,506,15 Tangible Book Value, Common Equity (3,396.77) (3,503.99) (3,503.99) (3,118.65) Tangible Book Value per Share, Common Eq (87.39) (90.00) (76.11) Total Long Term Debt, Supplemental 4,141 39 4,145.35 3,559.13 Long Term Debt Maturing within 1 Year 438.01 43.39 35.89 Long Term Debt Maturing in Year 2 438.01 42.84 35.96 Long Term Debt Maturing in Year 3 2.94 897.93 36.03 Long Term Debt Maturing in Year 4 3.20 34.03 953.86 Long Term Debt Maturing in Year 5 1,184.51 34.14 27.20 Long Term Debt Maturing in 2-3 Years 440.95 940.77 71.98 Long Term Debt Maturing in 4-5 Years 1,187.71 68.17 981.05 Long Term Debt Matur, in Year 6 & Beyond 2,074.71 3,093.01 2,470.21 Interest Costs (41.08) (20.85) (18.94) Total Capital Leases, Supplemental 60.56 19.66 17.01 Capital Lease Payments Due in Year 1 5.85 3.30 2.40 Capital Lease Payments Due in Year 2 6.71 2.82 2.42 Capital Lease Payments Due in Year 3 6.23 2.83 2.43 Capital Lease Payments Due in Year 4 6.68 2.86 2.45 Capital Lease Payments Due in Year 5 6.48 2.88 2.47 Capital Lease Payments Due in 2-3 Years 12.93 5.65 4.85 Capital Lease Payments Due in 4-5 Years 13.16 5.74 4.93 Cap. Lease Pymts. Due in Year 6 & Beyond 69.69 25.81 23.78 Total Operating Leases, Supplemental 238.13 236.05 271.27 Operating Lease Payments Due in Year 1 45.14 39.93 40.75 Operating Lease Payments Due in Year 2 42.44 40.07 37.52 Operating Lease Payments Due in Year 3 36.88 36.93 34,54 Operating Lease Payments Due in Year 4 35.47 34.38 30.76 Operating Lease Payments Due in Year 5 28.76 29.99 27.39 Operating Lease Pymts. Due in 2-3 Years 79.32 77.00 72.06 Operating Lease Pymts. Due in 4-5 Years 64.22 64.37 58.15 Oper. Lse. Pymts. Due in Year 6 & Beyond 49.44 54.76 100.31 Number of Restaurants opened 958.00 1,204.00 1,183.00 Number of Restaurants Closed 334.00 98.00 125.00 Number of Restaurants, End of Period 17,644.00 17,020.00 15,914.00 Number of Stores per Region 17,644.00 17,020.00 15,914,00 Number of Company Owned Restaurants 363.00 342.00 390.00 Number of Franchised Restaurants 17,644.00 16,678.00 15,524.00 Income Statement of Domino's Pizza Inc. 2020 2019 2018 Net Sales $ 4,117.41 $ 3,618.77 $ 3,432.87 Revenue 4,117.41 3,618.77 3,432.87 Total Revenue 4,117.41 3,618.77 3,432.87 Cost of Revenue 2,522.92 2,216.28 2,130.19 Cost of Revenue, Total 2,522.92 2,216.28 2,130.19 Gross Profit 1,594.49 1,402.50 1,302.68 Selling/General/Administrative Expense 406.61 382.29 372.46 Advertising Expense 462.24 390.80 358.53 Selling/General/Admin. Expenses, Total 868.85 773.09 730.99 Total Operating Expense 3,391.77 2,989.37 2,861.18 Operating Income 725.64 629.41 571.69 Interest Expense - Non-Operating (172.17) (150.82) (146.35) Interest Expense, Net Non-Operating (172.17) (150.82) (146.35) Interest Income - Non-Operating 1.65 4.05 3.33 Interest/Invest Income - Non-Operating 1.65 4.05 3.33 Interest Inc.(Exp.), Net-Non-Op., Total (170.51) (146.77) (143.01) Other Non-Operating Income (Expense) Other, Net Net Income Before Taxes 555.13 482.64 428.68 Provision for Income Taxes 63.83 81.93 66.71 Net Income After Taxes 491.30 400.71 361.97 Net Income Before Extra. Items 491.30 400.71 361.97 Net Income 491.30 400.71 361.97 Income Available to Com Excl Extra Ord 491.30 400.71 361.97 Income Available to Com Incl Extra Ord 491.30 400.71 361.97 Basic Weighted Average Shares 38.97 40.77 41.86 Basic EPS Excluding Extraordinary Items 12.61 9.83 8.65 Basic EPS Including Extraordinary Items 12.61 9.83 8.65 Dilution Adjustment Diluted Net Income 491.30 400.71 361.97 Diluted Weighted Average Shares 39.64 41.92 43.33 Diluted EPS Excluding Extraord Items 12.39 9.56 8.35 Diluted EPS Including Extraord Items 12.39 9.56 8.35 DPS - Common Stock Primary Issue 3.12 2.60 2.20 Gross Dividends - Common Stock 122.20 105.60 92.20 (Gain) Loss on Sale of Assets, Suppl. 2.92 2.02 (4.74) Other Unusual Expense(Income), Suppl. 0.51 0.53 Non-Recurring Items, Supplemental, Total 2.92 2.53 (4.21) Total Special Items 2.92 2.53 (4.21) Normalized Income Before Taxes 558.05 485.17 424.47 Effect of Special Items on Income Taxes 0.34 0.43 (0.65) Inc Tax Ex Impact of Sp Items 64.17 82.36 66.05 Normalized Income After Taxes 493.88 402.81 358.42 Normalized Inc. Avail to Com. 493.88 402.81 358.42 Basic Normalized EPS 12.67 9.88 8.56 Diluted Normalized EPS 12.46 9.61 8.27 Amort of Intangibles, Supplemental 23.00 22.80 18.70 Depreciation, Supplemental 42.00 37.10 35.00 Interest Expense, Supplemental 172.17 150.82 146.35 Rental Expense, Supplemental 73.70 69.70 62.50 Stock-Based Compensation, Supplemental 24.24 20.27 22.79 Advertising Expense, Supplemental 462.24 390.80 358.53 Audit Fees 0.00 1.43 Audit-Related Fees 0.00 0.19 Tax Fees All Other Fees 0.00 Gross Margin 38.73 38.76 37.95 Operating Margin 17.62 17.39 16.65 Pretax Margin 13.48 13.34 12.49 Effective Tax Rate 11.50 16.98 15.56 Net Profit Margin 11.93 11.07 10.54 Normalized EBIT 728.56 631.94 567.48 Normalized EBITDA 793.56 691.84 621.18 Current Tax - Domestic 19.89 49.54 33.56 Current Tax - Local 10.78 15.34 12.65 Current Tax - Total 30.67 64.87 46.21 Deferred Tax - Domestic 14.30 (2.86) (1.54) Deferred Tax - Local 0.12 (0.44) 0.67 Deferred Tax - Total 14.42 (3.30) (0.87) Other Tax 18.74 20.35 21.37 Income Tax - Total 63.83 81.93 66.71 Defined Contribution Expense - Domestic 12.00 21.60 14.60 Total Pension Expense 21.60 14.60 12.00 2018 2018 37.9473 16.6534 10.5443 2018 Ratio Analysis of Domino's Pizza Inc. Growth Ratios 2020 2019 Sales Growth Income Growth Asset Growth Profitability Ratios 2020 2019 Gross Profit Margin 38.7256 38.7562 Operating Profit Margin 17.6237 17.3928 Net Profit Margin 11.9322 11.0731 Total Return on Assets Net Return on total assets (ROA) Return on stockholder's equity (ROE) Return on invested capital (ROIC/ROCE) Earnings per share (EPS) Activity Ratios 2020 2019 Days of inventory Inventory turnover Average collection period Liquidity Ratios 2020 2019 Current Ratio 1.8465 1.7355 Quick Ratio 1.70 1.62 Working capital Leverage Ratios 2020 2019 Total debt-to-assets ratio Long-term debt-to-capital ratio Debt-to-equity ratio Long-term debt-to-equity ratio Times-interest-earned (or coverage ratio) Other Financials 2020 2019 Dividend yield on common stock Price-earnings ratio Dividend payout ratio Internal cash flow Free cash flow 2018 1.493 1.37 2018 2018

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

Sound Investing, Chapter 15 - Liability Tricks

Authors: Kate Mooney

2nd Edition

0071719377, 9780071719377

More Books

Students also viewed these Accounting questions