I need help filling in the green spaces for both the Income Statement and Balance Sheet Below is Exhibit 1 (Financial and Operating Data for Cosco) TIP use n 3 for the CAGR calculation Please explain using an Excel spreadsheet, formulas, and a step by step analysis explanation Any help would be appreciated EXHIBIT 1 Please use these financial ratio equations Liquity Ratios 544 53 EXHIBIT 1 Selected Financial and Operating Data for Costco Wholesale Corp , Fiscal Years 2000, 2005, 2011, and 2013 2016 ($ in millions, except for per share data) Fiscal Years Ending on Sunday Closest to August 31 Selected Income Statement Data 2016 2015 2014 2013 2011 2005 2000 Net sales $116,073 $113,666 $110,212 $102,870 $87,048 $51,862 $31,621 Membership fees 2 646 2,533 2,428 2 ,286 1 867 1,073 Total revenue 118 719 116,199 112,640 105,156 88,915 52,935 32,164 Operating expenses Merchandise costs 102,901 101,065 98,458 91,948 77,739 46,347 28,322 Selling, general, and administrative 12,068 11,445 10,899 1 0,104 8,682 5,044 2 755 Preopening expenses 78 65 63 51 46 42 Provision for impaired assets and store closing costs 7 3,624 Operating income 3,220 2439 3,053 Other income (expense) Interest expense (133) (124) (113) (99) (116) (34) (39 Interest income and other 80 97 54 Income before income taxes 3,619 3,604 3,197 3,051 2 383 1,549 1 052 1,243 1,109 1,195 990 Provision for income taxes 841 486 $ 2,350 $ Net income 2,377 $ 2,058 $ 2,039 $ 1 462 $ 1 063 $ 5,33 $ 5 37 $ 4 65 $ Diluted net income per share 4 63 $ 3 30 $ 2 18 $ 1 35 Dividends per share (not including spe cial dividend of $5 00 in 2015 and $ 1 70 $ $7 00 in 2013) 1 51 $ 1 33 $ 1 17 $ 0 89 $ 0 43 0 00 Millions of shares used in per share 441 3 442 7 4425 calculations 440 5 4 43 1 492 0 475 7 Balance Sheet Data $ 3,379 $ 4,801 $5,738 $ 4,644 Cash and cash equivalents $4,009 $ 2 063 3,672 1,037 104 60 109 421 Fiscal Years Ending on Sunday Closest to August 31 Selected Income Statement Data 2016 2015 2014 2013 2011 2005 2000 8,969 15,218 15,575 17,043 33,163 4,061 8,908 17,299 16,540 15,401 33 440 4,864 10 843 8 456 17,588 14 412 14,830 33,024 5,093 12,515 7,894 15,840 13,257 13,881 30,283 4,998 11,012 6,638 13,706 12,050 12,432 26,761 2 153 12,573 4,015 8 238 6,761 6,761 7 790 16,514 711 8,881 2 490 3,470 3,404 4,834 8,634 790 4 240 12 079 $3,292 $4,285 $3,984 $3,437 $3,198 686 663 634 608 $1,773 417 21 $1,070 292 25 33 26 30 26 24 Merchandise inventories Current assets Current liabilities Net property and equipment Total assets Long term debt Stockholders' equity Cash Flow Data Net cash provided by operating activities Warehouse Operations Warehouses at beginning of year New Warehouses opened (including relocations) Existing warehouses closed (including relocations) Warehouses at end of year Net sales per warehouse open at year end (in millions) Average annual growth at warehouses open more than a year Members at year end Businesses (000s) Gold Star members (000s) Add on cardholders (employees of busi ness members, spouses of Gold Star members) Total cardholders (3) (5) 0 634 (4 313 715 686 663 592 $147 1 433 $1198 $161 0 $165 7 $164,0 $162 0 $101 0 4 7 6 10 7 11 7,300 36,800 7 100 34,000 6,900 31,600 6,600 28,900 6,300 25,000 5,000 16,200 4,200 10,500 na na 42,600 86,700 40,200 81,300 37 900 76,400 35,700 71 200 32,700 64 000 Prior to 2011, the company's warehouses 30 of which were opened in 2007 and two others in 2008 2009 were consolidated and reported as part of Cosico's total operations at the beginning of fiscal 2011 Sales for new warehouses opened during the year are annualized Note Some totals may not add due to rounding and the fact that some line items in the company's statement of income were not included in this summary, for reasons of simplicity Sources Company 10 K reports for fiscal years 2000, 2005, 2011, 2013, 2015 and 2016 WN COSTCO WHOLESALE FINANCIAL ANALYSIS 2013 2016 $ US Numbers in Millions, except EPS and where indicated 2013 2014 2015 2016 on 7 INCOME STATEMENT 9 Total Revenue (actual) 10 Total Revenue (in millions) 11 Total Revenue (in billions) $105,156,000,000 00 $105,156 00 $105 billion $112,640 00 $116,199 00 $118,719 00 13 Revenue CAGR 2013 2016 15 Revenue 1 Year Growth Rate 7 12 17 Merchandise Costs 18 Gross Profit 19 Gross Margin $91,948 00 $13,208 00 12 56 $98,458 00 $14,182 00 $101,065 00 $15,134 00 $102,901 00 $15,818 00 $3,053 00 2 90 $3,220 00 $3,624 00 21 Operating Income 22 Operating Margin $3,672 00 $2,039 00 $2,058 00 0 93 $2,377 00 24 Net Income (NI) 25 NI 1 Year Growth Rate $2,350 00 27 Return on Sales (ROS) 1 94 29 Total Assets 30 Total 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 32 Return on Assets (ROA) 6 73 18 52 34 Return on Equity (ROE) 36 Earnings per Share (EPS) $4 63 $4 65 $5 37 $5 33 2013 2014 2015 2016 Sheet1 2013 2014 2015 2016 40 BALANCE SHEET 42 Current Assets 43 Inventories 44 Current Liabilities $15,840 00 $7,894 00 $13,257 00 D$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 45 1 19 46 Current Ratio 47 Quick Ratio 0 6 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 53 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 7 58 60 Fixed Asset Turnover (FAT) 61 Total Asset Turnover (TAT) 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 11 65 Sheet Growth Rates One Year Growth Rate (End Value Begin Value) Begin Value Growth Rate Report as Example 5 67 (Ending Value Beginning Value) VN 1 CAGR Compound Annual Growth Rate (Use for Multiple Years) Report as Example 4 75 Profitability Ratios Gross Margin (Sales Cost of Goods Sold) (Sales) GM Report as Example 15 75 Operating Margin (Profits Before Interest and Taxes) (Sales) HOM Report as Example 11 67 Return on Sales (Net Income) (Sales) ROS Report as Example 6 45 Return on Assets (Net Income) (Total Assets) ROA Report as Example 4 45 Return on Equity (Net Income) (Total Shareholder's Equity) ROE Report as Example 3 45 Earnings per Share (Net Income) (Wof Common Shares Outstanding) EPS Report as $ Share Example S1 07 Share Lluny NALUS Current Ratio (Current Assets) (Current Liabilities) Current Report as Ratio Example 2 13 Quick Ratio (Current Assets Inventory) (Current Liabilities) Quick Report as Ratio Example 1 87 Leverage Ratios Debt to Assets Ratio (Total Debt) (Total Assets) D A Report as Example 45 89 Debt to Equity Ratio 38 (Total Debt) (Total Shareholder's Equity) D E Report as Example 143 29 Activity Ratios Fixed Asset Turnover (Sales) (Property, Plant Equipment, Net) FAT Report as Ratio Example 3 57 Total Asset (Sales) (Total Assets) TAT Report as Ratio Example 23 84 3 Inventory Turnover (Cost of Goods Sold) (Inventory) Inventory Turn Report as Ratio Example 28 34 Valuation Ratio Price Earnings Ratio (Market Price per Share) (Earnings per Share) P E Ratio

Question

I need help filling in the green spaces for both the Income Statement and Balance Sheet  Below is Exhibit 1 (Financial and Operating Data for Cosco)  TIP  use n   3 for the CAGR calculation  Please explain using an Excel spreadsheet, formulas, and a step by step analysis explanation  Any help would be appreciated  EXHIBIT 1 Please use these financial ratio equations  Liquity Ratios  544 53 EXHIBIT 1 Selected Financial and Operating Data for Costco Wholesale Corp , Fiscal Years 2000, 2005, 2011, and 2013 2016 ($ in millions, except for per share data) Fiscal Years Ending on Sunday Closest to August 31 Selected Income Statement Data 2016 2015 2014 2013 2011 2005 2000 Net sales $116,073 $113,666 $110,212 $102,870 $87,048 $51,862 $31,621 Membership fees 2 646 2,533 2,428 2 ,286 1 867 1,073 Total revenue 118 719 116,199 112,640 105,156 88,915 52,935 32,164 Operating expenses Merchandise costs 102,901 101,065 98,458 91,948 77,739 46,347 28,322 Selling, general, and administrative 12,068 11,445 10,899 1 0,104 8,682 5,044 2 755 Preopening expenses 78 65 63 51 46   42 Provision for impaired assets and store closing costs 7 3,624 Operating income 3,220 2439 3,053 Other income (expense) Interest expense (133) (124) (113) (99) (116) (34) (39 Interest income and other 80 97 54 Income before income taxes 3,619 3,604 3,197 3,051 2 383 1,549 1 052 1,243 1,109 1,195 990 Provision for income taxes 841 486 $ 2,350 $ Net income 2,377 $ 2,058 $ 2,039 $ 1 462 $ 1 063 $ 5,33 $ 5 37 $ 4 65 $ Diluted net income per share 4 63 $ 3 30 $ 2 18 $ 1 35 Dividends per share (not including spe  cial dividend of $5 00 in 2015 and $ 1 70 $ $7 00 in 2013) 1 51 $ 1 33 $ 1 17 $ 0 89 $ 0 43 0 00 Millions of shares used in per share 441 3 442 7 4425 calculations 440  5 4 43 1 492 0 475 7 Balance Sheet Data $ 3,379 $ 4,801 $5,738 $ 4,644 Cash and cash equivalents $4,009 $ 2 063 3,672 1,037 104 60 109 421 Fiscal Years Ending on Sunday Closest to August 31 Selected Income Statement Data 2016 2015 2014 2013 2011 2005 2000 8,969 15,218 15,575 17,043 33,163 4,061 8,908 17,299 16,540 15,401 33 440 4,864 10 843 8 456 17,588 14 412 14,830 33,024 5,093 12,515 7,894 15,840 13,257 13,881 30,283 4,998 11,012 6,638 13,706 12,050 12,432 26,761 2 153 12,573 4,015 8 238 6,761 6,761 7 790 16,514 711 8,881 2 490 3,470 3,404 4,834 8,634 790 4 240 12 079 $3,292 $4,285 $3,984 $3,437 $3,198 686 663 634 608 $1,773 417 21 $1,070 292 25 33 26 30 26 24 Merchandise inventories Current assets Current liabilities Net property and equipment Total assets Long term debt Stockholders' equity Cash Flow Data Net cash provided by operating activities Warehouse Operations Warehouses at beginning of year New Warehouses opened (including relocations) Existing warehouses closed (including relocations) Warehouses at end of year Net sales per warehouse open at year  end (in millions) Average annual growth at warehouses open more than a year Members at year end Businesses (000s) Gold Star members (000s) Add on cardholders (employees of busi  ness members, spouses of Gold Star members) Total cardholders (3) (5) 0 634 (4 313 715 686 663 592 $147 1 433 $1198 $161 0 $165 7 $164,0 $162 0 $101 0 4  7  6  10  7  11  7,300 36,800 7 100 34,000 6,900 31,600 6,600 28,900 6,300 25,000 5,000 16,200 4,200 10,500 na  na  42,600 86,700 40,200 81,300 37 900 76,400 35,700 71 200 32,700 64 000 Prior to 2011, the company's warehouses 30 of which were opened in 2007 and two others in 2008 2009 were consolidated and reported as part of Cosico's total operations at the beginning of fiscal 2011 Sales for new warehouses opened during the year are annualized  Note  Some totals may not add due to rounding and the fact that some line items in the company's statement of income were not included in this summary, for reasons of simplicity Sources  Company 10 K reports for fiscal years 2000, 2005, 2011, 2013, 2015 and 2016  WN COSTCO WHOLESALE FINANCIAL ANALYSIS 2013 2016 $ US Numbers in Millions, except EPS and where indicated 2013 2014 2015 2016 on 7 INCOME STATEMENT 9 Total Revenue (actual) 10 Total Revenue (in millions) 11 Total Revenue (in billions) $105,156,000,000 00 $105,156 00 $105 billion $112,640 00 $116,199 00 $118,719 00 13 Revenue CAGR 2013 2016 15 Revenue 1 Year Growth Rate 7 12  17 Merchandise Costs 18 Gross Profit 19 Gross Margin $91,948 00 $13,208 00 12 56  $98,458 00 $14,182 00 $101,065 00 $15,134 00 $102,901 00 $15,818 00 $3,053 00 2 90  $3,220 00 $3,624 00 21 Operating Income 22 Operating Margin $3,672 00 $2,039 00 $2,058 00 0 93  $2,377 00 24 Net Income (NI) 25 NI 1 Year Growth Rate $2,350 00 27 Return on Sales (ROS) 1 94  29 Total Assets 30 Total 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 32 Return on Assets (ROA) 6 73  18 52  34 Return on Equity (ROE) 36 Earnings per Share (EPS) $4 63 $4 65 $5 37 $5 33 2013 2014 2015 2016 Sheet1 2013 2014 2015 2016 40 BALANCE SHEET 42 Current Assets 43 Inventories 44 Current Liabilities $15,840 00 $7,894 00 $13,257 00 D$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 45 1 19 46 Current Ratio 47 Quick Ratio 0 6 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 53 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 7 58 60 Fixed Asset Turnover (FAT) 61 Total Asset Turnover (TAT) 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 11 65 Sheet   Growth Rates  One Year Growth Rate (End Value   Begin Value)   Begin Value   Growth Rate Report as   Example  5 67  (Ending Value Beginning Value) VN 1   CAGR Compound Annual Growth Rate (Use for Multiple Years) Report as   Example 4 75  Profitability Ratios  Gross Margin (Sales   Cost of Goods Sold)   (Sales)   GM Report as   Example 15 75  Operating Margin (Profits Before Interest and Taxes)   (Sales) HOM Report as   Example 11 67  Return on Sales (Net Income)   (Sales)   ROS Report as   Example 6 45  Return on Assets (Net Income)   (Total Assets)   ROA Report as   Example 4 45  Return on Equity (Net Income)   (Total Shareholder's Equity)   ROE Report as   Example 3 45  Earnings per Share (Net Income)   (Wof Common Shares Outstanding)  EPS Report as $  Share Example S1 07 Share Lluny NALUS  Current Ratio (Current Assets)   (Current Liabilities)   Current Report as Ratio Example 2 13 Quick Ratio (Current Assets   Inventory)   (Current Liabilities)   Quick Report as Ratio Example 1 87 Leverage Ratios  Debt to Assets Ratio (Total Debt)   (Total Assets)   D A Report as   Example 45 89  Debt to Equity Ratio 38 (Total Debt)   (Total Shareholder's Equity)   D E Report as   Example 143 29  Activity Ratios  Fixed Asset Turnover (Sales)   (Property, Plant   Equipment, Net)  FAT Report as Ratio Example 3 57 Total Asset (Sales)   (Total Assets)   TAT Report as Ratio Example 23 84 3 Inventory Turnover (Cost of Goods Sold)   (Inventory)   Inventory Turn Report as Ratio Example 28 34 Valuation Ratio  Price Earnings Ratio (Market Price per Share)   (Earnings per Share)   P E Ratio

Accepted Answer

The Answer is in the image, click to view ...

Question

I need help filling in the green spaces for both the Income Statement and Balance Sheet. Below is Exhibit 1 (Financial and Operating Data for

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Multinational Financial Management

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question