Excel project: historical financial statements | ACCT 370 – Financial Statement Analysis | Liberty University
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.
●
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
