Back To Table of Contents


Download This Excel Worksheet Free - Click Here

40 Month Financial Projection

                                                                        
This sheet incorporates Regression Analysis, Moving Averages, Trend Analysis, Smoothing, and Box-Jenkins to Project out 40 Months. It is very sensitive to accurate baseline information and should be customized to industry idiosyncrasies.                                                                
                                                                                     
     

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month

Month
Sales    

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40
  Sales  

$2,000,000

$2,010,100

$2,110,100

$2,190,100

$2,245,150

$2,312,180

$2,379,210

$2,446,240

$2,513,270

$2,580,300

$2,647,330

$2,714,360

$2,781,390

$2,848,420

$2,915,450

$2,982,480

$3,049,510

$3,116,540

$3,183,570

$3,250,600

$3,317,630

$3,384,660

$3,451,690

$3,518,720

$3,585,750

$3,652,780

$3,719,810

$3,786,840

$3,853,870

$3,920,900

$3,987,930

$4,054,960

$4,121,990

$4,189,020

$4,256,050

$4,323,080

$4,390,110

$4,457,140

$4,524,170

$4,591,200

  Cost of sales

$945,000

$865,000

$833,000

$946,616

$890,616

$887,901

$885,186

$882,470

$879,755

$877,040

$874,325

$871,610

$868,894

$866,179

$863,464

$860,749

$858,034

$855,318

$852,603

$849,888

$847,173

$844,458

$841,742

$839,027

$836,312

$833,597

$830,882

$828,166

$825,451

$822,736

$820,021

$817,306

$814,590

$811,875

$809,160

$806,445

$803,730

$801,014

$798,299

$795,584

 

Gross profit

$1,055,000

$1,145,100

$1,277,100

$1,243,484

$1,354,534

$1,424,279

$1,494,024

$1,563,770

$1,633,515

$1,703,260

$1,773,005

$1,842,750

$1,912,496

$1,982,241

$2,051,986

$2,121,731

$2,191,476

$2,261,222

$2,330,967

$2,400,712

$2,470,457

$2,540,202

$2,609,948

$2,679,693

$2,749,438

$2,819,183

$2,888,928

$2,958,674

$3,028,419

$3,098,164

$3,167,909

$3,237,654

$3,307,400

$3,377,145

$3,446,890

$3,516,635

$3,586,380

$3,656,126

$3,725,871

$3,795,616

Expenses                                                                                    
Operating expenses

$424,000

$318,000

$275,600

$426,141

$351,941

$348,344

$344,746

$341,148

$337,551

$333,953

$330,355

$326,758

$323,160

$319,562

$315,965

$312,367

$308,770

$305,172

$301,574

$297,977

$294,379

$290,781

$287,184

$283,586

$279,988

$276,391

$272,793

$269,195

$265,598

$262,000

$258,403

$254,805

$251,207

$247,610

$244,012

$240,414

$236,817

$233,219

$229,621

$226,024

  Interest  

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

$16,250

  Depreciation  

$32,500

$33,958

$33,958

$33,958

$34,687

$35,124

$35,562

$35,999

$36,437

$36,874

$37,311

$37,749

$38,186

$38,624

$39,061

$39,498

$39,936

$40,373

$40,811

$41,248

$41,685

$42,123

$42,560

$42,998

$43,435

$43,872

$44,310

$44,747

$45,185

$45,622

$46,059

$46,497

$46,934

$47,372

$47,809

$48,246

$48,684

$49,121

$49,559

$49,996

  Amortization  

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

$1,250

 

Total expenses

$474,000

$369,458

$327,058

$477,599

$404,128

$400,968

$397,808

$394,647

$391,487

$388,327

$385,167

$382,007

$378,846

$375,686

$372,526

$369,366

$366,205

$363,045

$359,885

$356,725

$353,564

$350,404

$347,244

$344,084

$340,923

$337,763

$334,603

$331,443

$328,282

$325,122

$321,962

$318,802

$315,641

$312,481

$309,321

$306,161

$303,001

$299,840

$296,680

$293,520

Operating income

$581,000

$775,642

$950,042

$765,885

$950,406

$1,023,311

$1,096,217

$1,169,122

$1,242,028

$1,314,933

$1,387,838

$1,460,744

$1,533,649

$1,606,555

$1,679,460

$1,752,366

$1,825,271

$1,898,177

$1,971,082

$2,043,987

$2,116,893

$2,189,798

$2,262,704

$2,335,609

$2,408,515

$2,481,420

$2,554,325

$2,627,231

$2,700,136

$2,773,042

$2,845,947

$2,918,853

$2,991,758

$3,064,664

$3,137,569

$3,210,474

$3,283,380

$3,356,285

$3,429,191

$3,502,096

Other income and expenses                                                                              
Gain (loss) on sale of assets

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

  Other (net)

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

$20,000

 

Subtotal

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

$30,000

Income before tax

$611,000

$805,642

$980,042

$795,885

$980,406

$1,053,311

$1,126,217

$1,199,122

$1,272,028

$1,344,933

$1,417,838

$1,490,744

$1,563,649

$1,636,555

$1,709,460

$1,782,366

$1,855,271

$1,928,177

$2,001,082

$2,073,987

$2,146,893

$2,219,798

$2,292,704

$2,365,609

$2,438,515

$2,511,420

$2,584,325

$2,657,231

$2,730,136

$2,803,042

$2,875,947

$2,948,853

$3,021,758

$3,094,664

$3,167,569

$3,240,474

$3,313,380

$3,386,285

$3,459,191

$3,532,096

  Please enter a tax percentage                                                                              
  Taxes @

30%

$183,300

$241,693

$294,013

$238,765

$294,122

$315,993

$337,865

$359,737

$381,608

$403,480

$425,352

$447,223

$469,095

$490,966

$512,838

$534,710

$556,581

$578,453

$600,325

$622,196

$644,068

$665,939

$687,811

$709,683

$731,554

$753,426

$775,298

$797,169

$819,041

$840,913

$862,784

$884,656

$906,527

$928,399

$950,271

$972,142

$994,014

$1,015,886

$1,037,757

$1,059,629

                                                                                     
 

Net income

$427,700

$563,949

$686,029

$557,119

$686,284

$737,318

$788,352

$839,385

$890,419

$941,453

$992,487

$1,043,521

$1,094,555

$1,145,588

$1,196,622

$1,247,656

$1,298,690

$1,349,724

$1,400,757

$1,451,791

$1,502,825

$1,553,859

$1,604,893

$1,655,926

$1,706,960

$1,757,994

$1,809,028

$1,860,062

$1,911,095

$1,962,129

$2,013,163

$2,064,197

$2,115,231

$2,166,264

$2,217,298

$2,268,332

$2,319,366

$2,370,400

$2,421,434

$2,472,467

                                                                                     
Detailed Supporting Information