2 - Financial Statement Analysis (50 min)

Calculate at least 4 ratios for EACH of the following ratio categories (profitability, liquidity, solvency, efficiency) Intepret the results.

Computers

Phones

Software & Gaming Total Revenue

Cost of Goods Sold (COGS) Gross Profit

Operating Expenses

Advertising & Marketing General & Administrative Research, IT, & Development Depreciation & Amortization Total Operating Expenses

Operating Income

Interest Expense

Pre-tax Income

Income Taxes

Net Income (Loss)

Assets 2013

Accounts Receivable

Inventory

Total Current Assets $220.00

Gross Property Plant & Equipment Less: Accumulated Depreciation

2017

$275.97

$150.00 $75.00 $50.00

$172.50 $150.00 $62.50

$198.38 $228.13 $210.00 $294.00 $78.13 $97.66

$262.35 $411.60 $122.07

Best Buy Ltd.

Statement of Earnings (Income Statement) For the Year Ended Dec 31, 2017

In millions of dollars

Revenue

2013

$275.00

$96.25

$178.75

$27.50 $41.25 $30.00 $25.00

$123.75

$55.00

$9.00

$46.00

$9.20

$36.80

2014

$385.00

$134.75

$250.25

$38.50 $57.75 $34.50 $25.00

$155.75

$94.50

$9.00

$85.50

$17.10

$68.40

2015

$486.50

$165.41

$321.09

$48.65 $72.98 $39.68 $25.00

$186.30

$134.79

$9.00

$125.79

$25.16

$100.63

2016

$619.79

$204.53

$415.26

$61.98 $92.97 $45.63 $25.00

$225.57

$189.68

$9.00

$180.68

$36.14

$144.55

2017

$796.02

$238.81

$557.21

$79.60 $119.40 $52.47 $25.00 $276.48

$280.74

$9.00

$271.74

$54.35

$217.39

Cash $60.00 $13.40 $4.03 $33.58 $85.97

Buy Ltd. At Dec 31, 2017

In millions of dollars

2014 2015 2016

$173.40 $154.03 $203.58

Best

Statement of Financial Position

$60.00 $70.00 $70.00 $100.00 $130.00 $100.00 $90.00 $80.00 $70.00 $60.00

$250.00 $350.00 $450.00 $500.00 $600.00

-$50.00 -$75.00 -$100.00 -$125.00 -$150.00

Net Property, Plant, & Equipment Intangible Assets

Total Long-Term Assets

Total Assets

Liabilities

Account Payable Accrued Liabilities Current Liabilities Long-term Debt

Total Liabilities

Shareholder's Equity

Common Shares Preferred Shares Retained Earnings Total Equity

Total Liabilities & Equity

$200.00 $275.00

$100.00 $120.00

$300.00 $395.00 $520.00 $568.40

$70.00 $100.00

$150.00 $150.00

$220.00 $250.00

$100.00 $118.40

$300.00 $318.40 $520.00 $568.40

$350.00 $375.00

$140.00 $140.00

$490.00 $515.00 $644.03 $718.58

$130.00 $120.00

$150.00 $150.00

$280.00 $270.00

$164.03 $248.58

$364.03 $448.58 $644.03 $718.58

$450.00

$150.00

$600.00 $875.97

$120.00

$150.00

$270.00

$405.97

$605.97 $875.97