Posted: August 1st, 2022

EXCEL PROJECT

ExcelProject-HistoricalFinancialStatementsAssignmentGradingRubric ExcelProjectHistoricalFinancialStatementsAssignmentInstructions x

 EXCEL PROJECT: HISTORICAL FINANCIAL STATEMENTS
ASSIGNMENT INSTRUCTIONS
OVERVIEW

Company Information (Tab 1), and Historical Income Statements, Balance Sheets, and Cash
Flows (Tabs 2-4)
INSTRUCTIONS

Choose

one

of

the

3

companies

listed

in

your

Instructor’s

Module

1:

Week

1

Excel

Project Announcement.

Go

to
the

Securities

and

Exchange

Commission’s

EDGAR

database

and

access

your

chosen

company’s

most

recent

Form

10-K

(annual

report).
  (
For

help

with

this

process,

see

the
Module
1:
Week
1

presentation,

“Downloading

Financial

Statements

from

the

SEC EDGAR Database.”
)

Create an Excel workbook, including data for your chosen company as follows:
o

The

1
st

tab

(worksheet)

in
your
Financial

Statement

Analysis

Template

must

be

labeled

Company

Information
.

The

following

information

must
be

included:

 

Company Name and ticker symbol

Industry

Products or services offered

Major competitors

An example of this tab is provided in Exhibit A.
o
The

2
nd

tab
in
your
Financial
Statement
Analysis
Template
must
be
labeled

Historical Income Statements
.

Include the

latest

three

years

based on SEC filings.

Ensure that the worksheet includes a header with:

Company Name

Financial Statement Name (Income Statements)

Financial Statement Dates

ACCT 370
Page
2

of
4

Denomination level ($s in millions or thousands, etc.)
o
The

3
rd

tab
in
your
Financial
Statement
Analysis
Template
must
be
labeled

Historical Balance Sheets.

Include

the
latest

three

years

based

on

SEC

(10-K)

filings.
  (
Note:

Some

10-Ks

only

provided

2
years
of

balance

sheet

data.
  You

may

need

to

download

the

second

most
recent
10-K

for

your

company

in

order

to
 

obtain 3 years of balance sheet data.)

Ensure that the worksheet includes a header with:

Company Name

Financial Statement Name

Financial Statement Dates

Denomination level ($s in millions or thousands, etc.)

A partial balance sheet example is provided in Exhibit B.
o
The
4
th

tab

in your Financial Statement Analysis Template must be labeled
Historical Statement of Cash Flows.

Include the latest
three years

based on SEC (10-K) filings.

Make sure that the Income Statement, Balance Sheet, and Cash Flows
Statement tie in as follows:

Net Income from Income Statement agrees with Net Income on
the Statement of Cash Flows.

Ending Cash Balance from Statement of Cash Flows agrees with
Cash in the Balance Sheet.

Ensure that the worksheet includes a header with:

Company Name

Financial Statement Name

Financial Statement Dates

ACCT 370
Page
3

of
4

Denomination level ($s in millions or thousands, etc.)
o
Other instructions:

The Excel workbook should be professionally formatted.  Professional
formatting includes:

All

numbers

are

formatted

similarly.
  The

use

of

decimals,

commas for thousands, and other formatting is consistent.

Dollar

signs

are

included

in
the

first

and

last

numbers
of

each

column.

Sub

totals

and
totals
are

preceded

by
a

single

underline.
  Totals

are followed by a double underline.

All

extraneous

information
is

removed

from
the

spreadsheet.

Sometimes,

files

downloaded

from
the
SEC

website

contains

extra characters or other things that need to be deleted.  

Line
descriptions

are

indented/bolded

in
a

manner

that

makes

the spreadsheet easy to read.  

All

totals
and

subtotals

should

be

calculated

using

formulas
.
  For

an

example of which cells may need formulas, please see Exhibit B.
Note: Your assignment will be checked for originality via the Turnitin plagiarism tool 

Criteria Ratings Points

Content/Accuracy –
Tab 1 – Company
Information

10 to >8.

0 pts

Advanced

Content/Accuracy – Tab 1
– Company Information

8 to >6.0 pts

Proficient

Tab included the required
information, including
company name, ticker
symbol, industry, products or
services offered, and major
competitors, with only minor
exceptions.

6 to >0.0 pts

Developing

Tab was missing
a significant
amount of the
required
information,
and/or the
information
presented was
incorrect.

0 pts

Not
Present

Not
present

10 pts

Content/Accuracy –
Tab 2 – Historical
Income Statements

20 to >17.0 pts

Advanced

Three years of historical
income statements for the
primary company are
included in the
submission, and are
based on 10-K reports
from the SEC EDGAR
database.

17 to >13.0 pts

Proficient

Three years of historical
income statements for the
primary company are
included in the submission,
and are based on 10-K
reports from the SEC EDGAR
database. Only minor
exceptions are noted.

13 to >0.0 pts

Developing

Major
components of
the three years
of historical
income
statements are
missing, and/or
are based on
incorrect
sources.

0 pts
Not
Present
Not
present

20 pts

Content/Accuracy –
Tab 3 – Historical
Balance Sheets

20 to >17.0 pts
Advanced

Three years of historical
balance sheets for the
primary company are
included in the
submission, and are
based on 10-K reports
from the SEC EDGAR
database.

17 to >13.0 pts
Proficient

Three years of historical
balance sheets for the
primary company are
included in the submission,
and are based on 10-K
reports from the SEC EDGAR
database. Only minor
exceptions are noted.

13 to >0.0 pts
Developing

Major
components of
the three years
of historical
balance sheets
are missing,
and/or are based
on incorrect
sources.

0 pts
Not
Present
Not
present
20 pts

Excel Project: Historical Financial Statements Assignment Grading
Rubric | ACCT370_B06_202230

Criteria Ratings Points

Content/Accuracy –
Tab 4 – Historical
Cash Flows

20 to >17.0 pts
Advanced

Three years of historical
cash flows for the primary
company are included in
the submission, and are
based on 10-K reports
from the SEC EDGAR
database.

17 to >13.0 pts
Proficient

Three years of historical cash
flows for the primary
company are included in the
submission, and are based
on 10-K reports from the SEC
EDGAR database. Only
minor exceptions are noted.

13 to >0.0 pts
Developing

Major
components of
the three years
of historical cash
flows are
missing, and/or
are based on
incorrect
sources.

0 pts
Not
Present
Not
present
20 pts

Excel
Functions/Formulas

15 to >13.0 pts

Advanced

Excel formulas are
utilized to calculate all
totals and subtotals in the
historical financial
statements.

13 to >10.0 pts

Proficient

Excel formulas are utilized to
calculate all totals and
subtotals in the historical
financial statements, with
only a few minor exceptions.

10 to >0.0 pts

Developing

The submission
is missing most
of the Excel
formulas
required.

0 pts
Not
Present
Not
present

15 pts

Style and
Formatting

15 to >13.0 pts
Advanced

The submission is
professionally formatted.
All tabs include
appropriate headings with
the required information.
Totals and subtotals are
identified with properly
placed underlines.
Numbers are formatted
consistently, including the
use of commas and
decimals. The submission
is consistent, neat, and
easy to read.

13 to >10.0 pts
Proficient

The submission is
professionally formatted, with
only minor exceptions to the
following: All tabs include
appropriate headings with the
required information. Totals
and subtotals are identified
with properly placed
underlines. Numbers are
formatted consistently,
including the use of commas
and decimals. The
submission is consistent,
neat, and easy to read.

10 to >0.0 pts
Developing

The submission
lacks in
professional
formatting. It is
missing
headings,
appropriately
placed
underlines,
and/or consistent
formatting. The
submission is
messy, hard to
read, or
substantially
inconsistent in
formatting.

0 pts
Not
Present
Not
present
15 pts

Total Points: 100

Excel Project: Historical Financial Statements Assignment Grading
Rubric | ACCT370_B06_202230

ACCT 370

Excel Project: Historical Financial Statements Assignment Instructions

Overview

Company Information (Tab 1), and Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4)

Instructions

· Choose one of the 3 companies listed in your Instructor’s Module 1: Week 1 Excel Project Announcement.

· Go to the Securities and Exchange Commission’s EDGAR database and access your chosen company’s most recent Form 10-K (annual report). (For help with this process, see the Module 1: Week 1 presentation, “Downloading Financial Statements from the SEC EDGAR Database.”)

· Create an Excel workbook, including data for your chosen company as follows:

· The
1st tab
(worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included:

· Company Name

and ticker symbol

· Industry

· Products or services offered

· Major competitors

· An example of this tab is provided in Exhibit A.

· The
2nd tab
in your Financial Statement Analysis Template must be labeled Historical Income Statements.

· Include the latest
three years
based on SEC filings.

· Ensure that the worksheet includes a header with:

· Company Name

· Financial Statement Name

(Income Statements)

· Financial Statement Dates

· Denomination level ($s in millions or thousands, etc.)

· The
3rd tab
in your Financial Statement Analysis Template must be labeled Historical Balance Sheets.

· Include the latest
three years
based on SEC (10-K) filings.

(Note: Some 10-Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.)

· Ensure that the worksheet includes a header with:
· Company Name
· Financial Statement Name
· Financial Statement Dates
· Denomination level ($s in millions or thousands, etc.)

· A partial balance sheet example is provided in Exhibit B.

· The
4th tab
in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flows.

· Include the latest
three years
based on SEC (10-K) filings.

· Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows:

· Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows.

· Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet.

· Ensure that the worksheet includes a header with:
· Company Name
· Financial Statement Name
· Financial Statement Dates
· Denomination level ($s in millions or thousands, etc.)

· Other instructions:

· The Excel workbook should be professionally formatted. Professional formatting includes:

· All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.

· Dollar signs are included in the first and last numbers of each column.

· Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.

· All extraneous information is removed from the spreadsheet. Sometimes, files downloaded from the SEC website contains extra characters or other things that need to be deleted.

· Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.

· All totals and subtotals should be calculated using formulas.  For an example of which cells may need formulas, please see Exhibit B.

Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.

Exhibit A: Example Company Information Tab

Exhibit B: Example Historical Balance Sheets Tab


(IMPORTANT NOTE: Only Partial Balance Sheet shown. Your Balance Sheet should include Liabilities and Stockholders’ Equity as well.)

Page 2 of 2

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00