Back To Table of Contents

Forecast Analysis
 
PLEASE NOTE:
The only information on this page that will resemble your financial statements are the numbers in blue italic.
The remaining information contains forecasted values using regression analysis. Accuracy out greater than 2 years is limited, however, it serves as a trend.
 
Year

1994

1995

1996

1997

1998

1999

2000

2001

Alert

Income Statement

Current

Forecast

 
Sales

$1,902,433

$1,866,066

$2,440,353

$2,180,971

$2,449,931

$2,590,921

$2,731,911

$2,872,901

 
Cost of Goods Sold

$1,425,286

$1,477,469

$1,826,494

$1,699,002

$1,899,606

$2,016,623

$2,133,641

$2,250,658

 
Gross Profit (Margin)

$477,147

$388,597

$613,859

$481,969

$550,325

$574,298

$598,271

$622,243

 
G&A

$172,671

$93,143

$271,823

$170,080

$219,656

$236,747

$253,837

$270,928

 
Operating Expenses

$1,868,358

$1,850,247

$2,359,987

$2,123,571

$2,369,386

$2,496,923

$2,624,461

$2,751,999

 
EBIT*

$57,400

$80,366

$15,819

$34,075

$80,546

$93,998

$107,450

$120,902

 
Net Income After

$42,822

$61,078

$11,864

$25,557

$80,546

$93,998

$107,450

$120,902

 
Ownership**

$247,475

$155,084

$405,127

$286,028

$364,854

$401,424

$437,994

$474,565

 
Balance Sheet

Current

Forecast

 
Current Assets

$300,307

$289,813

$407,103

$404,474

$457,872

$500,851

$543,830

$586,809

 
Inventory

$23,539

$30,876

$20,158

$16,116

$14,426

$11,127

$7,828

$4,529

X

Other Assets

$5,000

$10,000

$20,000

$25,000

$32,500

$39,500

$46,500

$53,500

 
Total Assets

$537,538

$516,984

$674,742

$673,520

$742,122

$798,692

$855,263

$911,833

 
Current Liabilities

$173,282

$152,966

$243,649

$230,735

$265,919

$292,223

$318,527

$344,831

 
Non-current Liabilities

$1,000

$3,000

$4,000

$10,000

$11,500

$14,300

$17,100

$19,900

 
Total Liabilities

$174,282

$155,966

$247,649

$240,735

$277,419

$306,523

$335,627

$364,731

 
Equity

$240,863

$232,015

$355,997

$382,266

$439,833

$494,652

$549,471

$604,290

 
Cash Flow

Current

Forecast

 
Net Cash Flow

$14,578

$19,288

$3,955

$8,518

$0

$0

$0

$0

 
Breakeven

Current

Forecast

 
Breakeven

$1,336,355

$1,278,232

$1,759,153

$1,765,083

$1,975,397

$2,155,715

$2,337,655

$2,521,029

 
B/E %

70.24%

68.50%

72.09%

80.93%

80.63%

83.20%

85.57%

87.75%

X

DAY OF B/E

256.39

250.02

263.11

295.40

294.30

303.69

312.33

320.29

X

DATE OF B/E

Sep 12

Sep 06

Sep 19

Oct 21

Oct 20

Oct 29

Nov 07

Nov 15

X

Key Ratios

Current

Forecast

 
Current Ratio

1.73

1.89

1.67

1.75

1.72

1.71

1.71

1.70

X

Quick Ratio

1.60

1.69

1.59

1.68

1.67

1.68

1.68

1.69

 
Debt Ratio

0.32

0.30

0.37

0.36

0.37

0.38

0.39

0.40

 
Asset Turnover

3.54

3.61

3.62

3.24

3.30

3.24

3.19

3.15

X

Net Income/Sales

2.25%

3.27%

0.49%

1.17%

3.29%

3.63%

3.93%

4.21%

 
Debt/Equity

72.36%

67.22%

69.56%

62.98%

63.07%

61.97%

61.08%

60.36%

X

Return on Assets

17.71%

25.99%

3.30%

6.52%

17.85%

18.47%

18.96%

19.37%

 
Working Capital

$127,025

$136,847

$163,454

$173,739

$191,954

$208,628

$225,303

$241,978

 
Sales/Working Capital

14.98

13.64

14.93

12.55

12.76

12.42

12.13

11.87

X

Market Value

Current

Forecast

 
Book Market Value

$363,256

$361,018

$427,093

$432,785

$464,704

$492,170

$519,636

$547,102

 
Plus Ownership**

$610,731

$516,102

$832,220

$718,813

$829,558

$893,594

$957,630

$1,021,667

 
*EBIT is Earnings Before Interest and Taxes
**Ownership is the Total Reward for being the owner=Owner Salary + Bonus + Net Income + Other

***ALERT-An "X" in this column represents an area for investigation.

Copyright, 2007, Jaxworks, All Rights Reserved.

Back To Table of Contents