Q2 - 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

$50.00 $70.00 $90.00 $80.00 $100.00 $20.00 $30.00 $40.00 $40.00 $20.00

$175.00 $175.00 $175.00 $175.00 $175.00 $25.00 $25.00 $25.00 $25.00 $25.00

02. Financial Statement Analysis ( min Calculate that is for EACH of the following the categories Brothy, gdy wenyelene were the results Best Buy Statement of Bag heme Statement For the Year Ended Dec 31, 2017 $12.50 Cost of Good S Grohe COGS Adung BZ 1100.00 11S Best Buy UM Statement of Financial Position A Dec 31, 2017 Ac Recet 500.00 370.00 70.00 $100.00 Torrent Assets 522000 173.40 TO SNS Gross Pro Les comercio 250.00 55000 50.00 55.00 500 $100005125000 S SS SS S S Long An $13000 1220.00 120.0 20.00 2 .00 0 .00 Shareholders Co Share To Equity 5318.40 Toint 5520.895 603 $21.50 7.87 02. Financial Statement Analysis ( min Calculate that is for EACH of the following the categories Brothy, gdy wenyelene were the results Best Buy Statement of Bag heme Statement For the Year Ended Dec 31, 2017 $12.50 Cost of Good S Grohe COGS Adung BZ 1100.00 11S Best Buy UM Statement of Financial Position A Dec 31, 2017 Ac Recet 500.00 370.00 70.00 $100.00 Torrent Assets 522000 173.40 TO SNS Gross Pro Les comercio 250.00 55000 50.00 55.00 500 $100005125000 S SS SS S S Long An $13000 1220.00 120.0 20.00 2 .00 0 .00 Shareholders Co Share To Equity 5318.40 Toint 5520.895 603 $21.50 7.87