FIN 100 Excel Spreadsheet Week 8, accounting homework help

I NEED THIS ON EXCEL SPREADSHEET IF YOU DO THIS WOULD BE VERY HAPPY.

I have decided to conduct my analysis on the company, Apple. The statistics/data provided below is based upon the years of 2015 and 2016’s current assets, liabilities, and equity. Also included is the total revenue as well as the net income within the income statements and balance sheets.

ASSETS

CURRENT ASSETS

Cash and Equivalents

14.26 B

13.84 B

Receivables

20.64 B

27.22 B

Inventories

1.76 B

2.11 B

Other Current Assets

6.88 B

9.81 B

Total Current Assets

73.29 B

68.53 B

The chart listed above showcases 2015 & 2016.

The organization missed on income and surpassed desires on profit per share. I trust Apple is an incredible interest over the long haul, and would prescribe it to anybody yet from the details the stock has fallen more than five focuses in the previous year.

LIABILITIES

CURRENT Liabilities

Accounts Payable

22.37 B

30.20 B

Short Term Debt

6.31 B

Current Deferred Revenue

7.44 B

9.55 B

Other Current Liabilities

8.64 B

9.71 B

Total Current Liabilities

43.66 B

63.45 B

The organization missed on income and surpassed desires on profit per share. It is the greatest drop of the previous four years for Apple offers. Macintosh keeps on confronting exceptional edge weight, especially as the iPhones and iPads keep on losing in incomes per unit. Without the arrival of some amazing stunner new items, it will be troublesome for Apple to proceed with sails.

SHAREHOLDER EQUITY

Preferred Stock Equity

Common Stock Equity

123.55 B

111.55 B

Additional Paid in Capital

19.76 B

Retained Earnings

104.26 B

87.15 B

Treasury Stock

Other Equity Adjustments

(471.00 M)

1.08 B

TOTAL EQUITY

123.55 B

111.55 B

Income Statement

2013

2014

Revenue

170.91 B

182.80 B

Cost of Goods Sold

99.85 B

104.31 B

Gross Profit

71.06 B

78.48 B

TOTAL NET INCOME

37.04 B

39.51 B

Apples income statement can be clarified in these 3 explanations. They exceeded their production network. I feel Apple has developed so expansive that it’s been killings its own particular generation limit. The contenders are replicating its operational model with achievement. Investigate Microsoft which has removed a page appropriate from Apple’s own book and has been opening stores in high volume shopping centers around the U.S. with high achievement. Furthermore, the desires of financial specialists are imperfect or implausible. Apple’s gadgets have changed the way we work, yet we dishonestly expect that it will be the main improving organization to presence.