Homework Answers
| COSTCO WHOLESALE | ||||
| FINANCIAL ANALYSIS 2013-2016 | ||||
| $ US Number in Millions,except EPS and where indicated | ||||
| 2013 | 2014 | 2015 | 2016 | |
| INCOME STATEMENT | ||||
| Total Revenue (Actual) | $ 105,156,000,000.00 | $ 112,640,000,000.00 | $ 116,199,000,000.00 | $ 118,719,000,000.00 |
| Total Revenue (in millions) | $ 105,156.00 | $ 112,640.00 | $ 116,199.00 | $ 118,719.00 |
| Total Revenue (in billions) | $ 105.16 | $ 112.64 | $ 116.20 | $ 118.72 |
| Revenue CAGR 2013-2016 | 3.08% | |||
| Revenue 1 year growth rate | 7.12% | 3.16% | 2.17% | |
| Merchandise Cost | $ 91,948.00 | $ 98,458.00 | $ 101,065.00 | $ 102,901.00 |
| Gross Profit | $ 13,208.00 | $ 14,182.00 | $ 15,134.00 | $ 15,818.00 |
| Gross Margin | 12.56% | 12.59% | 13.02% | 13.32% |
| Operating Income | $ 3,053.00 | $ 3,220.00 | $ 3,624.00 | $ 3,672.00 |
| Operating Margin | 2.90% | 2.86% | 3.12% | 3.09% |
| Net Income (NI) | $ 2,039.00 | $ 2,058.00 | $ 2,377.00 | $ 2,350.00 |
| NI 1 year growth rate | 0.93% | 15.50% | -1.14% | |
| Return on Sales (ROS) | 1.94% | 1.83% | 2.05% | 1.98% |
| Total Assets | $ 30,283.00 | $ 33,024.00 | $ 33,440.00 | $ 33,163.00 |
| Total Shareholders Equity | $ 11,012.00 | $ 12,515.00 | $ 10,843.00 | $ 12,079.00 |
| Return on Asset (ROA) | 6.73% | 6.23% | 7.11% | 7.09% |
| Return on Equity (ROE) | 18.52% | 16.44% | 21.92% | 19.46% |
| Earnings Per Share (EPS) | $ 4.63 | $ 4.65 | $ 5.37 | $ 5.33 |
| 2013 | 2014 | 2015 | 2016 | |
| BALANCE SHEET | ||||
| Current Assets | $ 15,840.00 | $ 17,588.00 | $ 17,299.00 | $ 15,218.00 |
| Inventories | $ 7,894.00 | $ 8,456.00 | $ 8,908.00 | $ 8,969.00 |
| Current Liabilities | $ 13,257.00 | $ 14,412.00 | $ 16,540.00 | $ 15,575.00 |
| Current Ratio | $ 1.19 | $ 1.22 | $ 1.05 | $ 0.98 |
| Quick Ratio | $ 0.60 | $ 0.63 | $ 0.51 | $ 0.40 |
| Total Assets | $ 30,283.00 | $ 33,024.00 | $ 33,440.00 | $ 33,163.00 |
| Total Shareholders Equity | $ 11,012.00 | $ 12,515.00 | $ 10,843.00 | $ 12,079.00 |
| Total Debt | $ 19,271.00 | $ 20,509.00 | $ 22,597.00 | $ 21,084.00 |
| Long Term Debt | $ 4,998.00 | $ 5,093.00 | $ 4,864.00 | $ 4,061.00 |
| Debt to Asset Ratio (D/A) | 63.64% | 62.10% | 67.57% | 63.58% |
| Long Term Debt to Assets | 16.50% | 15.42% | 14.55% | 12.25% |
| Debt to Equity Ratio | 175.00% | 163.88% | 208.40% | 174.55% |
| Property & Equipment , Net | $ 13,881.00 | $ 14,830.00 | $ 15,401.00 | $ 17,043.00 |
| Fixed Asset Turnover | $ 7.58 | $ 7.60 | $ 7.54 | $ 6.97 |
| Total Assets Turnover | $ 3.47 | $ 3.41 | $ 3.47 | $ 3.58 |
| Merchandise Costs | $ 91,948.00 | $ 98,458.00 | $ 101,065.00 | $ 102,901.00 |
| Inventory | $ 7,894.00 | $ 8,456.00 | $ 8,908.00 | $ 8,969.00 |
| Inventory Turnover | $ 11.65 | $ 11.64 | $ 11.35 | $ 11.47 |
| Working Note: | ||
| Step1: | ||
| Actual Turnover = Total revenue (in million) * 1000,000 | ||
| Step 2: | ||
| Total Revenue (in billions) = Total revenue (in million) / 1000 | ||
| Step 3: | ||
| CAGR = (Ending Balance / Beginning Balance) 1/no.of year minus 1 | ||
| ie = | (118719 / 105156)^.25 - 1 | |
| Step 4: | ||
| Growth rate = (Year 1 - Year 0 ) / Year 0 * 100 | ||
| Step 5: | ||
| Gross Margin = Gross Profit / Revenue *100 | ||
| Step : 6 | ||
| Operating Margin = Operating Income / Revenue *100 | ||
| Step: 7 | ||
| Return on Sales (ROS) = Net Income / Revenue *100 | ||
| Step: 8 | ||
| Return on Asset (ROA) = Net Income / Asset *100 | ||
| Step: 9 | ||
| Return on Equity (ROE) = Net Income / Shareholders Equity | ||
| Step: 10 | ||
| Debt to Asset Ratio (D/A) = Debt / Total Asset | ||
| Step: 11 | ||
| Long Term Debt to Assets = Long term debt / Assets | ||
| Step: 12 | ||
| Debt to Equity Ratio = Debt / Equity | ||
| Step: 13 | ||
| Fixed Asset Turnover = Turnover / Fixed Asset | ||
| Step: 14 | ||
| Total Assets Turnover = Turnover/Total Assets | ||
| Step: 15 | ||
| Inventory Turnover = Merchandise Cost / Inventory | ||
Add Answer to:
Hello, I need help filling in all available green spaces with
regard to both the Income...
I need help filling in the green spaces for both the Income Statement and Balance Sheet....
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...
need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit;...
need help ?
Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $52.900; total assets, $229,400; common stock, $88,000; and retained earnings. $32,712.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 450, 600 Cost of goods sold 297,650 Gross profit 152,950 Operating expenses 99, 100 Interest expense 3,800 Income before taxes 50,050 Income taxes 20. 162 Net Income $ 29,888 $ 16,500...
Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income...
Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income for your firm was $10,000 last year. The depreciation expense was $2,500; accounts receivable increased $1,250; accounts payable increased $800; and inventories increased by $2,000. Identify the sources and uses of cash • What was the total cash flow from operations for the period? Operating activities = Net Income + Depreciation + Source (inflow) - Use foutflow) b) i) Prepare the 2018 common-size Income...
I was provided both the Balance Sheet and Statement of income from which I am supposed...
I was provided both the Balance Sheet and Statement of income
from which I am supposed to calculate the inventory turnover ratio.
But the balance sheet only has the inventory values for 2016 and
2015, while the statement of income only states the cost of sales
for 2015, 2014, and 2013.
So:
Merchandise inventory (from balance sheet):
January 30, 2016 = $5,506
January 31, 2015 = $5,417
Cost of Sales (from income statement):
2015 = $16,496
2014 = $16,863
2013...
Help!! I am in need of assitance with this problem. Please fill in the grey spaces...
Help!! I am in need of assitance with this problem.
Please fill in the grey spaces and provide some details for the
Dupont for 2019 & 2018
12 Months Ended Dec. 31, 2019 Dec. 31, 2018 Dec 31, 2017 $ 5,586,369 $4,864,985 $ 4,476,412 Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands Consolidated Statements of Income [Abstract] Revenue Restaurant operating costs (exclusive of depreciation and amortization shown separately below): Food, beverage and packaging Labor Occupancy...
pls help? Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit,...
pls help?
Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit, selected balance sheet amounts at December 31 of the prior year were inventory, $53,900, total assets, $239,400, common stock, $86,000, and retained earnings. $43,018.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $452,600 Cost of goods sold 297,750 Gross profit 154,850 Operating expenses 98,500 Interest expense 4,300 Income before taxes 52,050 Income tax expense 20,968 Net income 31.082 Assets Cash Short-term...
Seved Help Sav Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit,...
Seved Help Sav Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit, selected balance sheet amounts at December 31, 2016, were inventory, S49.900, total assets, $219,400: common stock, $83,000: and retained earnings. $54.354.) 452.60 298,450 Cost of goods sold Groas profi Operating expenses 30,246 Assets Cash Liabilities and Eqaity 15,500 3, 700 64,400 18,000 Accounts payable ,,00ง Moored wages payable 30,200 Inoone taxes payable Accounts receivable, net Sotes receivable (trade)* Merehand ise inventory 40.150 tong-term note...
Question 15 (1 point) The following data pertain to Keahi Inc.: Net Revenue $245,000 Net Income $...
Question 15 (1 point) The following data pertain to Keahi Inc.: Net Revenue $245,000 Net Income $22,050 Total Assets $188,462 Total Liabilities $70,673 Stockholders’ Equity $117,789 Calculate the Return on assets (ROA), return on sales (ROS), total asset turnover (TA), and the financial leverage (LEV) for Keahi. Question 15 options: 1) ROA: 62.5%; ROS: 10.0%; TA: 8.5; LEV: : 1.6; 2) ROA: 10.0%; ROS: 10.0%; TA: 2.5; LEV: : 2.5; 3) ROA: 18.7%; ROS: 9.0%; TA: 1.6; LEV: : 1.3;...
Need Help filling in all yellow blocks. Thank you in advance! 2 Joshua & White Technologies:...
Need Help filling in all yellow blocks. Thank you in
advance!
2 Joshua & White Technologies: December 31 Balance Sheets 3 Thousands of Dollars) 2016 21,000 3,759 52,500 Assets 6 Cash and cash equivalents Short-term investments 8 Accounts Receivable g Inventories 10 Total current assets 11 Net fixed assets 12 Total assets 2015 20,000 3,240 48,000 84000 56.000 $161,259 $127,240 218400 200,000 $379,659 $327 240 4 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current...
I need help calculating the statement of cash flows and common size income statement for the...
I need help calculating the statement of cash flows and common
size income statement for the following:
Below are Protek's balance sheet and income statement for two years. The company sold no stock and paid no dividends. Numbers in the statements are in millions. (1) Calculate the difference in balance sheet accounts and (2) use the appropriate differences to construct the indirect method statement of cash flows in proper form for 20X2 in the area to the right. Video- Balance...
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...
need help ?
Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $52.900; total assets, $229,400; common stock, $88,000; and retained earnings. $32,712.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 450, 600 Cost of goods sold 297,650 Gross profit 152,950 Operating expenses 99, 100 Interest expense 3,800 Income before taxes 50,050 Income taxes 20. 162 Net Income $ 29,888 $ 16,500...
Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income for your firm was $10,000 last year. The depreciation expense was $2,500; accounts receivable increased $1,250; accounts payable increased $800; and inventories increased by $2,000. Identify the sources and uses of cash • What was the total cash flow from operations for the period? Operating activities = Net Income + Depreciation + Source (inflow) - Use foutflow) b) i) Prepare the 2018 common-size Income...
I was provided both the Balance Sheet and Statement of income
from which I am supposed to calculate the inventory turnover ratio.
But the balance sheet only has the inventory values for 2016 and
2015, while the statement of income only states the cost of sales
for 2015, 2014, and 2013.
So:
Merchandise inventory (from balance sheet):
January 30, 2016 = $5,506
January 31, 2015 = $5,417
Cost of Sales (from income statement):
2015 = $16,496
2014 = $16,863
2013...
Help!! I am in need of assitance with this problem.
Please fill in the grey spaces and provide some details for the
Dupont for 2019 & 2018
12 Months Ended Dec. 31, 2019 Dec. 31, 2018 Dec 31, 2017 $ 5,586,369 $4,864,985 $ 4,476,412 Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands Consolidated Statements of Income [Abstract] Revenue Restaurant operating costs (exclusive of depreciation and amortization shown separately below): Food, beverage and packaging Labor Occupancy...
pls help?
Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit, selected balance sheet amounts at December 31 of the prior year were inventory, $53,900, total assets, $239,400, common stock, $86,000, and retained earnings. $43,018.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $452,600 Cost of goods sold 297,750 Gross profit 154,850 Operating expenses 98,500 Interest expense 4,300 Income before taxes 52,050 Income tax expense 20,968 Net income 31.082 Assets Cash Short-term...
Seved Help Sav Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit, selected balance sheet amounts at December 31, 2016, were inventory, S49.900, total assets, $219,400: common stock, $83,000: and retained earnings. $54.354.) 452.60 298,450 Cost of goods sold Groas profi Operating expenses 30,246 Assets Cash Liabilities and Eqaity 15,500 3, 700 64,400 18,000 Accounts payable ,,00ง Moored wages payable 30,200 Inoone taxes payable Accounts receivable, net Sotes receivable (trade)* Merehand ise inventory 40.150 tong-term note...
Need Help filling in all yellow blocks. Thank you in
advance!
2 Joshua & White Technologies: December 31 Balance Sheets 3 Thousands of Dollars) 2016 21,000 3,759 52,500 Assets 6 Cash and cash equivalents Short-term investments 8 Accounts Receivable g Inventories 10 Total current assets 11 Net fixed assets 12 Total assets 2015 20,000 3,240 48,000 84000 56.000 $161,259 $127,240 218400 200,000 $379,659 $327 240 4 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current...
I need help calculating the statement of cash flows and common
size income statement for the following:
Below are Protek's balance sheet and income statement for two years. The company sold no stock and paid no dividends. Numbers in the statements are in millions. (1) Calculate the difference in balance sheet accounts and (2) use the appropriate differences to construct the indirect method statement of cash flows in proper form for 20X2 in the area to the right. Video- Balance...
Most questions answered within 3 hours.
-
Extended exposure can cause hearing loss. Is this
sensorineural hearing loss or conduction hearing loss? Explain....
asked 2 minutes ago -
a
conducting spherical shell of inner radius a and outer radius b has
a point charge...
asked 1 minute ago -
If a family spends its entire budget in a given time frame, the
family can afford...
asked 3 minutes ago -
Q. A buffer solution prepared by mixing 50.00 mL of 0.200 M
acetic acid and 50.00...
asked 18 minutes ago -
PLEASE DO BOTH OF THESE IN PYTHON!!! AND MAKE SURE THAT
I CAN COPY THE CODE....
asked 16 minutes ago -
While fishing you discover two types of mullet. Some
of the mullet jump out of the water...
asked 13 minutes ago -
4. How could the Fed "finance the government's debt"? How does
that work, exactly?
5. In...
asked 20 minutes ago -
The x component of the velocity of an object vibrating
along the x-axis obeys the equation...
asked 1 hour ago -
A junction box contains two trade size 2 raceways on the left
side, and two trade...
asked 1 hour ago -
Atmospheric Mass
Venus and Earth have about the same mass and radius, but the
atmospheric pressure...
asked 2 hours ago -
5. Discuss the use of fault tree analysis (FTA) for risk
assessment (maximum one paragraph).
asked 3 hours ago -
Given that a sample of aluminium oxide has a Young's modulus of
393 GPa and a...
asked 5 hours ago