Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help to add 5 more financial ratios to my excel sheet. I can't think of any more ratios. I have attached the excel sheet
Please help to add 5 more financial ratios to my excel sheet. I can't think of any more ratios. I have attached the excel sheet below. I have done 15, but I need 20.
Ratio MICROSOFT CORPORA FINANCIAL RATIOS 2017 2.48 1.19 0.2929 0.37 0.2482 0.2357 0.088 Current Debt to Equity Return on Equity Total Asset Turnover Operating Profit Margin Net Profit Margin Return on Assets Formula Current assets Current liabilities Total Debt Equity Net income Equity Revenue Total Assets Operating Income Revenue Net Income Revenue Net Income Total Assets Price to Earnings Share Price Earnings Per Share 26.25 Price to Operating Profit Share Price Operating Profit Per Share 24.93 Price to Sales Share Price Sales Per Share 6.19 Equity to Asset Total Equity Total Assets 0.3 Cash to Debt Operating cash flows Total debt 1.54 Debt to Asset Goodwill to Asset Inventory Turnover Total Debt Total Assets Goodwill Total Assets Cost of Goods Sold Average Inventories 0.36 0.15 15.46 MICROSOFT CORPORATION FINANCIAL RATIOS Calculation 159,851 64,527 86,194 72,394 (21,204 72,394) 100 89,950 241,086 (22,326 89,950) 100 (21,204 89,950) 100 (21,204 241,086) 100 2016 2.35 0.75 0.2333 0.44 0.2365 0.1969 0.0867 Calculation 139660 59,357 53,687 71,997 (16,798 71,997) 100 85,320 193,694 (20,182 85,320) 100 (16,798 85,320) 100 (16,798 193,694) 100 2015 2.5 0.44 0.1523 0.53 0.1941 0.1303 0.0692 72.26 2.75 26.08 56.21 2.16 30.63 72.26 2.90 21.7 56.21 2.59 20.57 72.26 11.68 5.13 56.21 10.95 3.99 72,394 241,086 0.37 71,997 193,468 0.46 132,981 86,194 2.12 113,240 53,461 2.74 86,194 241,086 35,122 241,086 34,261 2,216 0.28 0.09 12.72 53,687 193,468 17,872 193,468 32,780 2,577 0.2 0.1 11.88 Calculation 124,712 49,858 35,292 80,083 (12,193 80,083) 100 93,580 176,223 (18,161 93,580) 100 (12,193 93,580) 100 (12,193 176,223) 100 46.70 1.52 46.70 2.27 46.70 11.70 80,083 174,472 96,526 35,292 35,292 174,472 16939 174,472 33,038 2,781Step 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