I NEED A QUALITY ANSWER IN 2 HOURS. NO LATE SUBMISSION.

profilemarlenepetreaus931
income_statement.xlsx
Home>Business & Finance homework help>Financial markets homework help>I NEED A QUALITY ANSWER IN 2 HOURS. NO LATE SUBMISSION.

Sheet1

Profitability Ratios
Target Versus Wal-Mart
Financial Year 2015
Gross Margin
Gross Margin=Gross Profit/Net Sales*100
Target Wal-Mart
Gross Profit 21340 120565
Net Sales 72618 485651
Ratio 0.2938665345 0.2482544049
Operating Margin
Operating Margin=Operating Profit/Net Sales*100
Target Wal-Mart
Operating Profit 4535 27147
Net Sales 72618 485651
Ratio 0.0624500812 0.0558981656
Return on Asset
Return on Assets=Net Income/Assets*100
Target Wal-Mart
Net Income -1636 16363
Assets 41404 203706
Ratio -0.0395130905 0.080326549

Sheet2

Income Statement Analysis
MicroStrategy, Inc
MicroStrategy, Inc MicroStrategy, Inc
2015 2014 Increase/Decrease Percentage 2014 2013 Increase/Decrease Percent
Total Revenue 529869 579830 -49961 -8.6164910405 579830 575888 3942 0.6845080988 The Gross Profit dropped in 2015 by 3.6% even though the cost of revenue dropped by 25.22%. There is a mixed trend since the gross profit in 2014 had increased by 1.7% from 2013
Cost of Revenue 101108 135210 -34102 -25.221507285 135210 138569 -3359 -2.4240631021
Gross Profit 428761 444620 -15859 -3.5668660879 444620 437319 7301 1.6694906921
Operating Expense
R&D 65206 103355 -38149 -36.9106477674 103355 98056 5299 5.4040548258
Selling and Admin 229254 321429 -92175 -28.6766284312 321429 319823 1606 0.5021527532
Non Recurring 279 14732 -14453 -98.1061634537 14732 14,732 0 0
Others
Total Operating Expense
Operating Income or Loss 134022 5104 128918 2525.8228840125 5104 19440 -14336 -73.7448559671
Income from Cont. operations
Total Other Income/Expenses 3842 5947 -2105 -35.3959979822 5947 -2689 8636 -321.1602826329
Earnings Before Interest And Taxes 137864 11051 126813 1147.5251108497 11051 16751 -5700 -34.0278192347
Interest Expense 0 0 0 0 0 0
Income Before Tax 137864 11051 126813 1147.5251108497 11051 16751 -5700 -34.0278192347
Income Tax Expense 31933 6016 25917 430.8011968085 6016 -9799 15815 -161.3940197979
Minority Interest 0 0 0 0 0 0
Net Income From Continuing Ops 105931 5035 100896 2003.8927507448 5035 26550 -21515 -81.0357815443
Non-recurring Events 0 0 0 0 0 0
Discontinued Operations 0 0 0 0 56782 -56782 -100
Net Income 105931 5035 100896 2003.8927507448 5035 83332 -78297 -93.9579033265 In relation to the Net income, there is a mixed trend over the three years. In the year 2014 the net profit had dropped by 94% due to a drop of 81% in the net income from continuing operations. In the year 2015 profits went up by 2003.89% due to a similar percentage increase from net income from continuing operations

Sheet3

Balance Sheet Analysis
Target Versus Wal-Mart
Wal-Mart Target
2015 % 2014 % 2015 % 2014 %
Assets
Current Assets
Cash And Cash Equivalents 9135000 4.484403994 7281000 3.5560265884 2210000 5.3376485364 670000 1.5038269028
Short Term Investments
Net Receivables 6778000 3.3273443099 6677000 3.2610341341
Inventory 45141000 22.1598774705 44858000 21.9085621071 8790000 21.2298328664 8278000 18.5801180616
Other Current Assets 2224000 1.091769511 2369000 1.1570151062 3087000 7.4558013718 2625000 5.8918591341
Total Current Assets 63,278,000 31.0633952854 61185000 29.8826379358 14087000 34.0232827746 11573000 25.9758040985
Long Term Investments
Property Plant and Equipment 116655000 57.266354452 117907000 57.5855551377 25958000 62.6944256594 26412000 59.2822032186
Goodwill 18102000 8.8863361904 19510000 9.5286469907
Intangible Asset
Accumulated Amortization
Other Assets 5671000 2.7839140722 6149000 3.0031599357 1359000 3.282291566 6568000 14.7419926829
Deferred Long Term Asset Charges
Total Assets 203706000 100 204751000 100 41404000 100 44553000 100
Liabilities
Current Liabilities
Accounts Payable 58583000 28.7586030848 57174000 27.9236731445 11542000 27.8765336682 10945000 24.5662469418
Short/Current Long Term Debt 6689000 3.2836538934 12082000 5.9008258812 91000 0.219785528 1143000 2.5654838058
Other Current Liabilities 103000 0.248768235 689000 1.5464727403
Total Current Liabilities 65272000 32.0422569782 69345000 33.8679664568 11,736,000 28.3450874312 12777000 28.678203488
Long Term Debt 43692000 21.4485582163 44559000 21.7625310743 12705000 30.6854410202 11429000 25.6525935403
Other Liabilities 1645000 3.9730460825 2767000 6.2105806567
Deferred Long Term Liability Charges 8805000 4.3224058202 8017000 3.9154875922 1321000 3.1905129939 1349000 3.0278544655
Minority Interest 4543000 2.2301748598 5084000 2.483015956
Negative Goodwil
Total Liabilities 122312000 60.0433958744 127005000 62.0290010794 27407000 66.1940875278 28322000 63.5692321505
Stockholders' Equity
Misc Stocks Options Warrants 1491000 0.7282015717
Redeemable Preferred Stock
Preferred Stock
Common Stock 323,000 0.1585618489 323000 0.1577525873 53000 0.1280069558 53000 0.1189594416
Retained Earnings 85777000 42.1082344163 76566000 37.394689159 9644000 23.2924355135 12599000 28.2786793257
Treasury Stock 0
Capital Surplus 2462000 1.2086045575 2362000 1.1535963194 4899000 11.8321901266 4470000 10.0329944112
Other Stockholder Equity -7168000 -3.5187966972 -2996000 -1.4632407168 -599000 -1.4467201237 -891000 -1.9998653289
Total Stockholder Equity 81394000 39.9566041256 76255000 37.242797349 13997000 33.8059124722 16231000 36.4307678495
Net Tangible Assets 63292000 31.0702679352 56745000 27.7141503582 13997000 33.8059124722 16231000 36.4307678495