Accounting for Decision-Makers
dhriase
Week1CaseExceltemplate.xlsxSect 1 to 3 key numbers
| Fill in the yellow boxes from the financial statements given | ||
| Merck | Novartis | |
| 2016 | ||
| Part 1 | ||
| Total Assets | ||
| Total Liabilities | ||
| Total Equity | ||
| Part 2 | ||
| Net Income | ||
| Part 3 | ||
| End Retained Earnings |
Section 4 ratios
| Fill in the yellow boxes from the financial statements given | ||||||||
| Part 4 | Merck | Novartis | ||||||
| 2016 | 2015 | 2016 | 2015 | |||||
| CURRENT RATIO: | ||||||||
| Current assets | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Current liabilities | 0 | 0 | 0 | 0 | ||||
| QUICK RATIO: | ||||||||
| Cash + ST investments + receivables | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Current liabilities | 0 | 0 | 0 | 0 | ||||
| DEBT TO TOTAL ASSETS: | ||||||||
| Total debt | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Total assets | 0 | 0 | 0 | 0 | ||||
| DEBT TO TOTAL EQUITY: | ||||||||
| Total debt | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Total equity | 0 | 0 | 0 | 0 | ||||
| NET PROFIT ON SALES: | ||||||||
| Net income | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Net sales | 0 | 0 | 0 | 0 | ||||
| RETURN ON ASSETS: | ||||||||
| Net income + interest | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Average assets | 0 | 0 | 0 | 0 | ||||
| ` | ||||||||
| RETURN ON EQUITY: | ||||||||
| Net income - preferred dividends | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Average common equity | 0 | 0 | 0 | 0 | ||||
Sect 5 common size
| Fill in the yellow boxes from the financial statements given and calculate the percentages | |||||||||
| Part 5 | Merck | Novartis | |||||||
| 2016 | % | 2015 | % | 2016 | % | 2015 | % | ||
| Assets | |||||||||
| Total Current Assets | |||||||||
| Total Assets | |||||||||
| Liabilities and Equity | |||||||||
| Total Current Liabilities | |||||||||
| Total Liabilities | |||||||||
| Total Equity | |||||||||
| Total Liabilities and Equity | |||||||||
