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.
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
