Select Page
  

 Select one U.S. publicly traded company and review its most recent annual report. 

  • 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.
  1. Determine changes in assets, liabilities, and equity.
  2. Determine changes in total revenue and net income.
  3. 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.
  4. Submit two documents for your Annual Report activity submission by uploading both documents at the same time in the submission area:

***This is a template. Please type over/delete all items in red prior to submitting your assignment.

Week 8 Homework: The Annual Report

By Type Your Name Here

FIN100: Principles of Finance

Enter the Name of Your Instructor Here

Type the Date Here (ex. February 10, 2020)

Week 8 Homework

Instructions: Use the Excel template provided to report assets, liabilities, equity, revenue, and income for your selected company.

Use this template to briefly describe changes year-to-year (current and prior years) for assets, liabilities, equity, revenue, and income. Determine if the changes would be positive or negative from an investor/stockholder’s view.

*Use black, size 12, Times New Roman, Arial, Courier, or Calibri fonts. Double-space your paragraph. Use paragraph headers as necessary to express your results. See the formatting instructions and samples under the Strayer Writing Standards link in the Course Shell.


*AFTER COMPLETING YOUR WORK, DELETE ALL ITEMS IN RED. Your font must be black.

Sources

Sample formatting for an online source:

1. Anya Kamenetz. July 10, 2015. The Writing Assignment That Changes Lives. https://www.npr.org/sections/ed/2015/07/10/419202925/the-writing-assignment-that-changes-lives

Please provide your source list below:

1. Website 1

2. Website 2

3. Website 3

PAGE

2

Week 8 Homework

Finance 100
Week 8 – Finance in Business Activity
Please complete ONLY the light blue fields.
Your Name:
Name of the U.S. Publicly Traded Company you chose:
Balance Sheet: 2020 2019 $ Change % Change
Assets
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.
.
Legend: ONLY Light blue fields can be edited.