Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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.

image text in transcribed 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,781

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

Financial Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

9th edition

1-119-49356-3, 1119493633, 1119493560, 978-1119493631

More Books

Students also viewed these Accounting questions

Question

1. Effort is important.

Answered: 1 week ago