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
