Question

In: Finance

Dominos balance sheet Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018...

Dominos balance sheet

Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend
Cash & Short Term Investments 151.81M 314.39M 169.31M 227.53M 237.42M
Cash Only 151.81M 314.39M 169.31M 227.53M 237.42M
Short-Term Investments - - - - -
Total Accounts Receivable 118.4M 131.58M 150.37M 173.68M 190.09M
Accounts Receivables, Net 118.4M 131.58M 150.37M 173.68M 190.09M
Accounts Receivables, Gross 121.76M 134.24M 152.71M 175.1M 191.97M
Bad Debt/Doubtful Accounts (3.36M) (2.66M) (2.34M) (1.42M) (1.88M)
Other Receivables - - - - -
Inventories 37.94M 36.86M 40.18M 39.96M 45.98M
Finished Goods 31.63M 30.17M 36.64M 36.65M 42.92M
Work in Progress - - - - -
Raw Materials 6.32M 6.69M 3.54M 3.32M 3.05M
Progress Payments & Other - - - - -
Other Current Assets 120.21M 119.81M 136.01M 138.61M 93.47M
Miscellaneous Current Assets 120.21M 119.81M 136.01M 138.61M 93.47M
Total Current Assets 428.36M 602.64M 495.87M 579.78M 566.95M
2014 2015 2016 2017 2018 5-year trend
Net Property, Plant & Equipment 114.05M 131.89M 138.53M 169.59M 234.94M
Property, Plant & Equipment - Gross 310.22M 336.17M 359.5M 406.87M 487.12M
Buildings 25.86M 18.56M 18.63M 18.67M 12.25M
Land & Improvements - - - - -
Computer Software and Equipment - - - - -
Other Property, Plant & Equipment 99.8M 111.07M 120.73M 128.61M 170.5M
Accumulated Depreciation 196.17M 204.28M 220.96M 237.28M 252.18M
Total Investments and Advances 4.59M 6.05M 7.26M 8.12M 8.72M
Other Long-Term Investments 4.59M 6.05M 7.26M 8.12M 8.72M
Long-Term Note Receivable - - - - -
Intangible Assets 36.86M 44.6M 56.31M 68.25M 78.73M
Net Goodwill 16.3M 16.1M 16.06M 15.42M 14.92M
Net Other Intangibles 20.56M 28.51M 40.26M 52.82M 63.81M
Other Assets 10.01M 8.8M 9.38M 8.27M 12.52M
Tangible Other Assets 10.01M 8.8M 9.38M 8.27M 12.52M
Total Assets 596.33M 799.85M 716.3M 836.75M 943.08M

Liabilities & Shareholders' Equity

2014 2015 2016 2017 2018 5-year trend
ST Debt & Current Portion LT Debt 565,000 59.33M 38.89M 32.32M 35.89M
Short Term Debt - - - - -
Current Portion of Long Term Debt 565,000 59.33M 38.89M 32.32M 35.89M
Accounts Payable 86.55M 106.93M 111.51M 106.89M 92.55M
Income Tax Payable - - - - -
Other Current Liabilities 178.49M 209.72M 253.3M 259.07M 251.3M
Dividends Payable 14.35M 557,000 - - -
Accrued Payroll 23.62M 33M 42.09M 37.42M 40.96M
Miscellaneous Current Liabilities 140.52M 176.17M 211.21M 221.65M 210.34M
Total Current Liabilities 265.61M 375.98M 403.7M 398.29M 379.74M
Long-Term Debt 1.5B 2.18B 2.15B 3.12B 3.5B
Long-Term Debt excl. Capitalized Leases 1.5B 2.18B 2.15B 3.12B 3.48B
Non-Convertible Debt 1.5B 2.18B 2.15B 3.12B 3.48B
Convertible Debt - - - - -
Capitalized Lease Obligations - - - 4.61M 14.61M
Provision for Risks & Charges 26.95M 23.31M 27.14M 30.61M 31.07M
Deferred Taxes 3.11M (5.87M) (8.94M) (2.75M) (5.53M)
Deferred Taxes - Credit 5.59M - - - 35.7M
Deferred Taxes - Debit 2.48M 5.87M 8.94M 2.75M 41.22M
Other Liabilities 17.05M 19.34M 19.61M 21.75M 5.11M
Other Liabilities (excl. Deferred Income) 17.05M 19.34M 19.61M 21.75M 5.11M
Deferred Income - - - - -
Total Liabilities 1.82B 2.6B 2.6B 3.57B 3.95B
Non-Equity Reserves - - - - -
Preferred Stock (Carrying Value) - - - - -
Redeemable Preferred Stock - - - - -
Non-Redeemable Preferred Stock - - - - -
Common Equity (Total) (1.22B) (1.8B) (1.88B) (2.74B) (3.04B)
Common Stock Par/Carry Value 556,000 498,000 481,000 429,000 410,000
Retained Earnings (1.25B) (1.8B) (1.88B) (2.74B) (3.04B)
ESOP Debt Guarantee - - - - -
Cumulative Translation Adjustment/Unrealized For. Exch. Gain (2.66M) (3.55M) (3.11M) (2.03M) (4.43M)
Unrealized Gain/Loss Marketable Securities - - - - -
Revaluation Reserves - - - - -
Treasury Stock - - - - -
Total Shareholders' Equity (1.22B) (1.8B) (1.88B) (2.74B) (3.04B)
Accumulated Minority Interest - - - - -
Total Equity (1.22B) (1.8B) (1.88B) (2.74B) (3.04B)
Liabilities & Shareholders' Equity 596.33M 799.85M 716.3M 836.75M 943.08M

*Question* for years ((**2015-2018**)) please show work , please and thank you :)

What is Dominos 1) current ratio 2) debt-equity ratio 3) profit margin 4) return on assets (ROA) 5) return on equity (ROE) 6) Use the Dupont identity to calculate total assets turnover (TAT). For years (2015-2018)

Solutions

Expert Solution

PARTICULARS 2015 2016 2017 2018
A.TOTAL CURRENT ASSET                                  602.64                                495.87                                579.78                                  566.95
B.TOTAL CURRENT LIABILITIES                                  375.98                                403.70                                398.29                                  379.74
*CURRENT RATIO = CURRENT ASSET/CURRENT LIABILITIES                                       1.60                                    1.23                                    1.46                                       1.49
C.TOTAL LIABILITIES                                       2.60                                    2.60                                    3.57                                       3.95
D.TOTAL SHAREHOLDER'S EQUITY                                     -1.80                                   -1.88                                   -2.74                                     -3.04
*DEBT EQUITY RATIO=TOTAL LIABILITIES/TOTAL SHAREHOLDER'S EQUITY                                     -1.44                                   -1.38                                   -1.30                                     -1.30
D.NET INCOME = RETAINED EARNING OF CURRENT YEAR - PREVIOUS YEAR =-1.8+1.25 =-1.88+1.8 =-2.74+1.88 =-3.04+2.74
                                    -0.55                                   -0.08                                   -0.86                                     -0.30
E.NET SALES(ASSUMING ALL CREDIT SALES) =0.13424-0.12176 =0.15271-0.13424 =0.1751-0.15271 =0.19197-0.1751
                                      0.01                                    0.02                                    0.02                                       0.02
*PROFIT MARGIN=NET INCOME/NET SALES                                   -55.00                                   -4.00                                -43.00                                   -15.00
F.AVERAGE TOTAL ASSET =(0.79985+0.59633)/2 =(0.7163+0.79985)/2 =(0.83675+0.7163)/2 =(0.94308+0.83675)/2
                                      0.70                                    0.76                                    0.78                                       0.89
*RETURN ON ASSET=NET INCOME/AVERAGE TOTAL ASSET                                     -0.79                                   -0.11                                   -1.10                                     -0.34
G.AVERAGE SHAREHOLDERS EQUITY =-(1.22+1.8)/2 =-(1.88+1.8)/2 =-(2.74+1.88)/2 =-(3.04+2.74)/2
                                    -1.51                                   -1.84                                   -2.31                                     -2.89
*RETURN ON EQUITY=AVERAGE SHAREHOLDERS EQUITY/NET INOCOME                                       2.75                                  23.00                                    2.69                                       9.63
F.ASSET TURNOVER=SALES/AVERAGE TOTAL ASSETS                                    0.014                                  0.026                                    0.03                                       0.02
G.EQUITY MULTIPLIER=AVERAGE TOTAL ASSETS/AVERAGE SHAREHOLDERS EQUITY                                     -0.46                                   -0.41                                   -0.34                                     -0.31
*DUPONT ANALYSIS=NET PROFIT MARGIN*ASSET TURNOVER*EQUITY MULTIPLIER                                       0.36                                    0.04                                    0.37                                       0.10

Related Solutions

MCDONALDS balance sheet. Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018...
MCDONALDS balance sheet. Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend Cash & Short Term Investments 2.08B 7.69B 1.22B 2.46B 866M Cash Only 2.08B 7.69B 1.22B 2.46B 866M Short-Term Investments - - - - - Total Accounts Receivable 1.21B 1.3B 1.47B 1.98B 2.44B Accounts Receivables, Net 1.21B 1.3B 1.47B 1.98B 2.44B Accounts Receivables, Gross 1.21B 1.3B 1.47B 1.98B 2.44B Bad Debt/Doubtful Accounts - - - - - Other Receivables - - - -...
WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current...
WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 683 $ 915 $ 763 Other assets 2,416 1,923 1,722 Total assets $ 3,099 $ 2,838 $ 2,485 Current liabilities $ 576 $ 806 $ 713 Long-term liabilities 1,513 1,003 851 Stockholders’ equity 1,010 1,029 921 Total liabilities and stockholders' equity $ 3,099 $ 2,838 $ 2,485 WIPER, INC Selected Income Statement and Other Data For the year Ended December 31, 2017...
Perform a horizontal analysis of the Balance Sheet. Fiscal year ends in June. USD in millions...
Perform a horizontal analysis of the Balance Sheet. Fiscal year ends in June. USD in millions except per share data. 2016-06 2017-06 2018-06 Assets 193,694 241,086 258,848 Current assets 139,660 159,851 169,662 Cash 113,240 132,981 133,768 Cash and cash equivalents 6,510 7,663 11,946 Short-term investments 106,730 125,318 121,822 Total cash 113,240 132,981 133,768 Receivables 18,277 19,792 26,481 Inventories 2,251 2,181 2,662 Deferred income taxes Other current assets 5,892 4,897 6,751 Total current assets 139,660 159,851 169,662 Non-current assets Property, plant...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash and cash equivalents 3,657 3,705 Notes and accounts receivable 21,394 19,875 Inventories: Crude oil, products and merchandise 10,877 12,037 Materials and supplies 4,203 4,208 Other current assets 1,285 2,798      Total current assets 41,416 42,623 Crude oil, products and merchandise inventories are carried at the lower of current market value or cost (generally determined under the last-in, first-out method – LIFO). Inventory costs include...
LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions...
LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions of dollars) 2018 2017 2018 2017 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 100 $ 48 Accrued wages and taxes $ 60 $ 48 Accounts receivable 110 72 Accounts payable 110 72 Inventory 301 174 Notes payable 70 60 Total $ 511 $ 294 Total $ 240 $ 180 Fixed assets: Long-term debt: $ 429 $ 237 Gross...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2016 and 2015 ($ in millions) 2016 2015   Assets...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2016 and 2015 ($ in millions) 2016 2015   Assets   Cash $ 116    $ 81      Accounts receivable 190    194      Investment revenue receivable 6    4      Inventory 205    200      Prepaid insurance 4    8      Long-term investment 156    125      Land 196    150      Buildings and equipment 412    400          Less: Accumulated depreciation (97) (120)   Patent 30    32    $ 1,218    $ 1,074...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000 Cost of goods sold 72,600 53,400 45,600 33,300 30,000 Dollar amounts stated above are in thousands. a. Compute trend percentages for the above items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. b. State whether the trends are favorable or unfavorable. Required A Required B Compute trend percentages for the above items taken from...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200 Cost of goods sold 332,087 214,419 173,535 120,176 88,788 Accounts receivable 32,560 25,434 23,715 14,180 12,376 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.)
Beltway Technologies: Balance Sheet for the Year Ended December 31, 2017 (in Millions of Dollars) Cash...
Beltway Technologies: Balance Sheet for the Year Ended December 31, 2017 (in Millions of Dollars) Cash Accounts receivable Inventory      Current assets Net fixed assets Total assets $    5.1 26.4     56.1 $ 87.6     26.3 $113.9 Accounts payable Accruals Notes payable     Current liabilities Long-term debt Preferred stock Common stock Total claims $   3.8 5.9      1.3 $10.1 40.8 9.7    53.3 $113.9 To begin, Bill reviewed Beltway's 2017 balance sheet, which is contained in Table 1. Next, Bill...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $   ...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $    235,000 $    400,000 Accounts Receivable        367,200        325,000 Inventory        450,000        500,200 Prepaid Expenses        120,000        160,000 Long-term investment        100,000        300,000 Equiptment (Net)     1,050,000     1,125,000 Total Assets $ 2,322,200 $ 2,810,200 Accounts Payable $    421,000 $    411,000 Salary Payable        134,000        180,000 Interest Payable        110,000        112,000 Bonds Payable        550,000        560,000 Common Shares...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT