FIN 320 SNHU Apple Inc NASDAQ AAPL Balance Sheet & Income Statement Worksheet I have attached the rubric and also an exampe you can use for the exel presen

FIN 320 SNHU Apple Inc NASDAQ AAPL Balance Sheet & Income Statement Worksheet I have attached the rubric and also an exampe you can use for the exel presentation the company I am choosing to do this on is apple so you would be using apple stock info FIN 320 Module Three Excel Assignment Rubric
This is the first of two Excel assignments you will complete in this course. Before you get started, be sure to watch the Mergent Online video (written
instructions can be found here). For this assignment, consider the stock you own in your TDAU thinkorswim portfolio. Choose one of the companies from your
portfolio and complete the following steps:
1. Financial Reports
For the company you have selected, find the most recent annual balance sheet, annual income statement, and annual statement of cash flows.
Copy each of these three reports to its own worksheet within a single Excel file. The first worksheet should be titled 20XX Balance Sheet; the second, 20XX
Income Statement; the third, 20XX Cash Flow. (Replace the XX with the appropriate year.) The image below illustrates the way the file should be set up.
2. Stock Prices
Create a fourth worksheet within the same Excel file for historical stock prices. (You can name the worksheet Stock Prices.)
? Reference the To Find Historical Stock Prices section of the Mergent Online written instructions to locate the stock prices for your company for
the most recent seven days. In your Excel file, enter those seven prices.
? On the Stock Prices worksheet, use an Excel formula to calculate the stock price’s rate of return over that seven-day period. To do this,
1. Subtract the stock price of the first day from the stock price of the last day.
2. Divide this amount by the stock price from the first day.
3. Multiply by 100 to get the rate of return.
3. Professionalism
Format the data on all worksheets so that the file has a neat and professional appearance.
4. References
At the bottom of each data tab in the spreadsheet, include a link and a properly formatted citation referencing the location of the data used.
Guidelines for Submission: Submit an Excel file that meets the criteria described in the prompt. Citations should be formatted according to APA style.
Critical Elements
Financial Reports
Stock Prices
Professionalism
References
Proficient (100%)
Needs Improvement (75%)
Includes annual balance sheet, annual income Includes annual balance sheet, annual income
statement, and annual statement of cash flows statement, and annual statement of cash flows
for the company selected
for the company selected, but submission is
incomplete or contains inaccuracies
Accurately calculates the stock’s rate of return Calculates the stock’s rate of return over the
over the seven-day period
seven-day period, but calculation contains
inaccuracies
Formats data with a neat and professional
Formats data with a neat and professional
appearance
appearance, but contains some formatting
issues
Includes properly formatted APA-style citations Includes citations and links, but citations
and links with no errors
contain some errors
Not Evident (0%)
Does not include annual balance sheet, annual
income statement, and annual statement of
cash flows for the company selected
Value
25
Does not calculate the stock’s rate of return
over the seven-day period
45
Does not format data with a neat and
professional appearance
15
Does not include properly formatted APA-style
15
citations or include citations and links with
major errors
Earned Total 100%
Company A Name & Stock Symbol
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date
Currency
Audit Status
Consolidated
Scale
Cash & cash equivalents
Restricted cash & marketable securities
Restricted cash
Accounts receivable
Raw materials
Work in process
Finished goods
Service parts
Inventory
Prepaid expenses & other current assets
Total current assets
Operating lease vehicles, net
Machinery, equipment & office furniture
Tooling
Leasehold improvements
Building & building improvements
Land
Computer equipment & software
Construction in progress
Property & equipment, gross
Less: accumulated depreciation & amortization
Property & equipment, net
Restricted cash
Emission credits
Debt issuance costs, net
Other assets
Other assets
Other assets
Total assets
Accounts payable
Accrued warranty, current portion
Build to suit finance obligation, current portion
Accrued interest
Environmental liabilities, current portion
Other accrued expenses
Taxes payable
Accrued purchases
Payroll & related costs
Warranty & other accrued expenses
12/31/2017
USD
Not Qualified
Yes
Thousands
1,196,908
22,628
168,965
528,935
163,830
476,512
108,561
1,277,838
125,229
2,791,568
1,791,403
1,694,910
550,902
338,392
461,303
60,234
175,512
693,207
3,974,460
571,126
3,403,334
31,522
74,633
8,092,460
916,148
101,206
140,540
86,859
94,193
?
Accrued liabilities
Deferred revenue
Resale value guarantee
Capital lease obligations, current portion
Customer deposits
Convertible debt, current portion
Long term debt & capital leases
Total current liabilities
Deferred revenue
Long term debt & capital leases
Resale value guarantee
Capital lease obligations, less current portion
Convertible debt, less current portion
Accrued warranty, less current portion
Deferred rent liability
Deferred tax liabilities
Environmental liabilities, less current portion
Other long-term liabilities
Other long-term liabilities
Other long-term liabilities
Convertible senior notes
Total liabilities
Common stock
Additional paid-in capital
Accumulated other comprehensive income (loss)
Retained earnings (accumulated deficit)
Total stockholders’ equity (deficit)
422,798
423,961
136,831
283,370
633,166
2,816,274
446,105
2,040,375
1,293,741
364,976
42,045
7,003,516
131
3,414,692
-3,556
-2,322,323
1,088,944
Reference (example)
Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here)
Tip: F2 key let’s you easily edit cell data.
Students: You will need three years’ worth of data for the next Excel assignment if you want to download all three year
You will also need more historical stock prices too if you would like to download all available stock price data now.
Use most recent year-end report date available
ink to financial statement here)
Data quality check:
Assets = Liabilities + Equity
8,092,460
8,092,460
Company A Name & Stock Symbol
Exchange rate used is that of the Year End reported date
As Reported Annual Income Statement
Report Date
Currency
Audit Status
Consolidated
Scale
Development services
Automotive sales
Services & other revenues
Total revenues
Development services
Automotive sales
Services & other cost of revenues
Total cost of revenues
Gross profit (loss)
Research & development
Selling, general & administrative
Total operating expenses
Income (loss) from operations
Interest income
Interest expense
Other income (expense), net
Income (loss) before income taxes – domestic
Income (loss) before income taxes – international
Income (loss) before income taxes
Current state income taxes (benefit)
Current foreign income taxes (benefit)
Current income taxes (benefit)
Deferred foreign income taxes (benefit)
Deferred income taxes (benefit)
Provision for income taxes (benefit)
Net income (loss)
Weighted average shares outstanding-basic
Weighted average shares outstanding-diluted
Year end shares outstanding
Net income (loss) per share – basic
Net income (loss) per share – diluted
Number of full time employees
Number of common stockholders
Foreign currency translation adjustments
12/31/2017
USD
Not Qualified
Yes
Thousands
3,740,973
305,052
4,046,025
2,823,302
299,220
3,122,522
923,503
717,900
922,232
1,640,132
-716,629
1,508
118,851
-41,652
-415,694
-459,930
-875,624
525
10,342
10,867
2,172
2,172
13,039
-888,663
128,202
128,202
131,425
-7
-7
13,058
836
-10,999
Reference (example)
Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here)
Company A Name & Stock Symbol
Exchange rate used is that of the Year End reported date
As Reported Annual Cash Flow
Report Date
Currency
Audit Status
12/31/2017
USD
Not Qualified
Consolidated
Yes
Scale
Thousands
Net income (loss)
-888,663
Depreciation & amortization
422,590
Stock-based compensation
197,999
Amortization of discount on convertible debt
72,063
Inventory write-downs
44,940
Write-off of Department of Energy (DOE) loan origination costs
Change in fair value of DOE warrant liability
Fixed asset disposal
37,723
Other non-cash operating activities
26,373
Foreign currency transaction loss (gain)
55,765
Account receivables
46,267
Inventories & operating lease vehicles
-1,573,860
Prepaid expenses & other current assets
-29,595
Other assets
-24,362
Accounts payable
Accrued liabilities
Accounts payable & accrued expenses
263,345
Deferred revenue
322,203
Customer deposits
36,721
Resale value guarantee
442,295
Other long-term liabilities
23,697
Net cash flows from operating activities
-524,499
Purchases of property & equipment excluding capital leases
-1,634,850
Withdrawals out of (transfers into) our dedicated Department of Energy account,
– net
Decrease (increase) in restricted cash
-26,441
Purchase of short-term marketable securities
Maturities of short-term marketable securities
Business acquisition
-12,260
Net cash flows from investing activities
-1,673,551
Proceeds from issuance of convertible debt
Proceeds from issuance of convertible debt & other debt
318,972
Proceeds from issuance of common stock in public
730,000
Proceeds from issuance of warrants
Proceeds from exercise of stock options & other stock issuances
106,611
Proceeds from issuance of common stock in private placements
20,000
Principal payments on DOE loans
Purchase of convertible note hedges
Common stock & convertible debt issuance costs
-17,025
Principal payments on capital leases & other debt
-203,780
Collateralized lease borrowings
568,745
Net cash flows from financing activities
1,523,523
Effect of exchange rate changes on cash & cash equivalents
-34,278
Net increase (decrease) in cash & cash equivalents
Cash & cash equivalents at beginning of period
Cash & cash equivalents at end of period
Interest paid
Income taxes paid
-708,805
1,905,713
1,196,908
32,060
9,461
Reference (example)
Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here)
Company A Name & Stock Symbol
Last 7 Business Day Stock Prices (most recent day listed first)
Date
1/19/2018
1/18/2018
1/17/2018
1/16/2018
1/15/2018
1/12/2018
1/11/2018
Rate Of Return
Close
91.54
93.44
94.88
94.31
93.59
93.96
90.02
1.69 “The stock had a 1.69 percent return over the period January 11th through
Reference (example)
Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here)
e period January 11th through January 19th 2018.”

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
FIN 320 SNHU Apple Inc NASDAQ AAPL Balance Sheet & Income Statement Worksheet I have attached the rubric and also an exampe you can use for the exel presen
Just from $13/Page
Order Essay
Homework On Time
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers