EXCEL PROJECT

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