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                                                                              
                                                                                     
Enter Cost of sales                                                                                  
 

Direct labor

$320,000

$240,000

$208,000

$321,616

                                                                       
 

Materials

$500,000

$500,000

$500,000

$500,000

                                                                       
 

Other costs

$125,000

$125,000

$125,000

$125,000

                                                                       

Back To Table of Contents

Copyright, 2014, JaxWorks, All Rights Reserved.