Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, I need help filling in all available green spaces with regard to both the Income Statement & Balance Sheet. Please provide a step-by-step analysis,

Hello, I need help filling in all available green spaces with regard to both the Income Statement & Balance Sheet. Please provide a step-by-step analysis, formulas and explanation using Excel (Preferably).
image text in transcribed
image text in transcribed
Any help would be much appreciated.
COSTCO WHOLESALE $ US Numbers in Millions, except EPS a Indicated TATEMENT Total Revenue (actual) Total Revenue (in millions) Total Revenue in billions) $105, 156,000,000.00 S105, 156.00 $105 billion $112.640.00 $116,199.00 $118,719.00 Revenue CAGR 2013-2016 Revenue 1 Year Growth Rate Merchandise Costs Gross Profit Gross Margin $91,948.00 $13,208.00 12.56% $98,458.00 $14,182.00 $101,065.00 S15.134.00 $102,901.00 $15,818.00 $3,053.00 2.90% $3,220.00 $3,624.00 Operating income Operating Margin $3,672.00 $2,039.00 $2.377.00 $2,350.00 Net Income (NI) NI 1 Year Growth Rate $2,058.00 0.93 Return on Sales (ROS) Total Assets To Shareholder Equity $30,283.00 $11,012.00 $33,024.00 $12,515.00 $33,440.00 $10,843.00 $33,163.00 $12,079.00 Return on Assets (ROA) Return on Equity (ROE 18.52% Earnines per Share (EPSI $4.63 2013 2014 2015 2016 40 BALANCE SHEET 42 Current Assets 43 Inventories 44 Current Liabilities $15,840.00 $7,894.00 $13,257.00 $17,588.00 $8.456.00 $14,412.00 $17,299.00 $8,908.00 $16,540.00 $15,218.00 $8,969.00 $15,575.00 1.19 0.6 46 Current Ratio 47 Quick Ratio 48 49 Total Assets 50 Total Shareholder Equity 51 Total Debt 52 Long Term Debt $30,283.00 $11,012.00 $19,271.00 $4,998.00 $33,024.00 $12,515.00 $20,509.00 $5,093.00 $33,440.00 $10,843.00 $22,597.00 $4,864.00 $33,163.00 $12,079.00 $21,084.00 $4,061.00 54 Debt to Asset Ratio (D/A) 55 Long Term Debt to Asset (LTD/A) 56 Debt to Equity Ratio (D/E) 63.64% 16.50% 175.00% 58 Property & Equipment, Net $13,881.00 $14,830.00 $15,401.00 $17,043.00 60 Fixed Asset Turnover (FAT) 61 Total Asset Turnover (TAT) 3.47 62 63 Merchandise Costs 64 Inventory $91,948.00 $7,894.00 $98.458.00 $8.456.00 $101,065.00 $8.908.00 $102,901.00 $8,969.00 66 Inventory Turnover 1165 Sheet1 +

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_2

Step: 3

blur-text-image_3

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 & Managerial Accounting For Undergraduates

Authors: Jason Wallace, James Nelson, Karen Christensen, Theodore Hobson, Scott L. Matthews

2nd Edition

161853310X, 9781618533104

More Books

Students also viewed these Accounting questions

Question

4.6 Summarize job design concepts.

Answered: 1 week ago

Question

4.5 Explain what competencies and competency modeling are.

Answered: 1 week ago