Week 8

Finance in Business Activity

Instructions

Note: Watch the Excel tutorial videos linked in this week to learn how to use Excel before attempting the activity. You can use the template provided or you may create your own template based on the one provided.

Complete the following scenario using the templates provided:

1. Select one U.S. publicly traded company and review its most recent annual report. (You may use one of the three companies you selected for your Stock Journal assignment.) 

   Use the Week 8 Finance in Business Excel Template [XLSX] provided to report assets, liabilities, equity, revenue, and net income for your selected company. 

   Note: There are locked cells in the Excel template. The cells have been locked to prevent the formulas from being disturbed. The cells that you will need to use to complete this assignment are not locked. You may create your own templates, however it is recommended that you use the templates provided.

2. Determine changes in assets, liabilities, and equity.
3. Determine changes in total revenue and net income.
4. Describe the changes from the current and prior years in each of these key areas and whether the changes would be positive or negative from an investor/stockholder’s view.
5. Go to the Strayer library search page to locate and incorporate at least two quality sources into this assignment. 

   For stock price information, you may use the New York Stock Exchange, NASDAQ, Yahoo! Finance, or The Wall Street Journal Online.

   Save Time On Research and Writing

   Hire a Pro to Write You a 100% Plagiarism-Free Paper.

   Get My Paper
6. Submit two documents for your Annual Report activity submission by uploading both documents at the same time in the submission area: 

   Completed Week 8 Finance in Business Excel Template [XLSX].
   Completed Week 8 Finance in Business Template [DOC].

Sheet1

$ – 0 $ – 0

$ – 0 $ – 0 $ – 0 ERROR:#DIV/0!

$ – 0 $ – 0 $ – 0 ERROR:#DIV/0!

$ – 0 $ – 0 $ – 0 ERROR:#DIV/0!

$ – 0 $ – 0 $ – 0 ERROR:#DIV/0!

Week 8 Homework Assignment

Name of U.S. Publicly Traded Company:

2020

2019

$ Change

% Change

Balance Sheet:

Assets

$ – 0

ERROR:#DIV/0!

Liabilities

Equity

Income Statement:

Total Revenue

Net Income

NOTE: Explain the changes year-over-year. Would the changes be positive or negative from an investor/stockholder’s view?

Use the Word document template to type your summary.