• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Other

Simple 3-Statement Financial Model Practice

Document preview thumbnail
Preview 1 out of 4 pages

This excel worksheet is yet another practice exercise designed to help with deriving assumptions/drivers and then forecasting the company's financials. It incorporates a blend of accounting acumen with managerial finance application.

Content preview

HISTORICAL FINANCIAL STATEMENTS PROJECTED FINA
($ in millions) Fiscal Year E
2017A 2018A 2019A 2020P
Income Statement
Revenues $34,350 $36,397 $39,117
Cost of sales $19,038 $20,441 $21,643
Gross profit $15,312 $15,956 $17,474
Demand creation expense $3,341 $3,577 $3,753
Operating Overhead Expense $7,222 $7,934 $8,949
Total selling and administrative $10,563 $11,511 $12,702
Interest expense (income), net $59 $54 $49
Other (income) expense, net ($196) $66 ($78)
Income before income taxes $4,886 $4,325 $4,801
Income tax expense $646 $2,392 $772
Net income $4,240 $1,933 $4,029

Balance Sheet
Assets
Current Assets:
Cash and cash equivalents $4,249 $4,466
Short-term investments $996 $197
Accounts receivable, net $3,498 $4,272
Inventories $5,261 $5,622
Prepaid expenses and other current assets $1,130 $1,968
Total current assets $15,134 $16,525
Property plant and equipment, net $4,454 $4,744
Identifiable intangible assets, net $285 $283
Goodwill $154 $154
Deferred income taxes and other assets $2,509 $2,011
Total Assets $22,536 $23,717
Liabilities and Stockholders' Equity
Current liabilities:
Current portion of long-term debt $6 $6
Notes payable $336 $9
Accounts payable $2,279 $2,612
Accrued liabilities $3,269 $5,010
Income taxes payable $150 $229
Total current liabilities $6,040 $7,866
Long-term debt $3,468 $3,464
Deferred income taxes and other liabilities $3,216 $3,347
Stockholders' equity:
Common stock at stated value:
Class A convertible
Class B $3 $3

Document information

Uploaded on
June 22, 2025
Number of pages
4
Written in
2023/2024
Type
Other
Person
Unknown
$9.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Sold
0
Followers
0
Items
16
Last sold
-




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions