40col by robandlarac

VIEWS: 48 PAGES: 3

									Your Business, Inc.
The shaded cells are protected regression analysis formulas. Enter your numbers in the unshaded cells.

40 Month Financial Projection
Month 1 $2,000,000 $945,000 Gross profit Expenses Operating expenses Interest Depreciation Amortization Total expenses Operating income Other income and expenses Gain (loss) on sale of assets Other (net) Subtotal $424,000 $16,250 $32,500 $1,250 $474,000 $581,000 $318,000 $16,250 $33,958 $1,250 $369,458 $775,642 $275,600 $16,250 $33,958 $1,250 $327,058 $950,042 $426,141 $16,250 $33,958 $1,250 $477,599 $765,885 $351,941 $16,250 $34,687 $1,250 $404,128 $950,406 $348,344 $16,250 $35,124 $1,250 $400,968 $1,023,311 $344,746 $16,250 $35,562 $1,250 $397,808 $1,096,217 $341,148 $16,250 $35,999 $1,250 $394,647 $1,169,122 $337,551 $16,250 $36,437 $1,250 $391,487 $1,242,028 $333,953 $16,250 $36,874 $1,250 $388,327 $1,314,933 $330,355 $16,250 $37,311 $1,250 $385,167 $1,387,838 $326,758 $16,250 $37,749 $1,250 $382,007 $1,460,744 $323,160 $16,250 $38,186 $1,250 $378,846 $1,533,649 $319,562 $16,250 $38,624 $1,250 $375,686 $1,606,555 $315,965 $16,250 $39,061 $1,250 $372,526 $1,679,460 $312,367 $16,250 $39,498 $1,250 $369,366 $1,752,366 $308,770 $16,250 $39,936 $1,250 $366,205 $1,825,271 $305,172 $16,250 $40,373 $1,250 $363,045 $1,898,177 $301,574 $16,250 $40,811 $1,250 $359,885 $1,971,082 $297,977 $16,250 $41,248 $1,250 $356,725 $2,043,987 $294,379 $16,250 $41,685 $1,250 $353,564 $2,116,893 $290,781 $16,250 $42,123 $1,250 $350,404 $2,189,798 $287,184 $16,250 $42,560 $1,250 $347,244 $2,262,704 $283,586 $16,250 $42,998 $1,250 $344,084 $2,335,609 $279,988 $16,250 $43,435 $1,250 $340,923 $2,408,515 $276,391 $16,250 $43,872 $1,250 $337,763 $2,481,420 $272,793 $16,250 $44,310 $1,250 $334,603 $2,554,325 $269,195 $16,250 $44,747 $1,250 $331,443 $2,627,231 $265,598 $16,250 $45,185 $1,250 $328,282 $2,700,136 $262,000 $16,250 $45,622 $1,250 $325,122 $2,773,042 $258,403 $16,250 $46,059 $1,250 $321,962 $2,845,947 $254,805 $16,250 $46,497 $1,250 $318,802 $2,918,853 $251,207 $16,250 $46,934 $1,250 $315,641 $2,991,758 $247,610 $16,250 $47,372 $1,250 $312,481 $3,064,664 $244,012 $16,250 $47,809 $1,250 $309,321 $3,137,569 $240,414 $16,250 $48,246 $1,250 $306,161 $3,210,474 $236,817 $16,250 $48,684 $1,250 $303,001 $3,283,380 $233,219 $16,250 $49,121 $1,250 $299,840 $3,356,285 $229,621 $16,250 $49,559 $1,250 $296,680 $3,429,191 $226,024 $16,250 $49,996 $1,250 $293,520 $3,502,096 $296,178 $16,250 $41,467 $1,250 $355,144 $2,080,440 $1,055,000 Month 2 $2,010,100 $865,000 $1,145,100 Month 3 $2,110,100 $833,000 $1,277,100 Month 4 $2,190,100 $946,616 $1,243,484 Month 5 $2,245,150 $890,616 $1,354,534 Month 6 $2,312,180 $887,901 $1,424,279 Month 7 $2,379,210 $885,186 $1,494,024 Month 8 $2,446,240 $882,470 $1,563,770 Month 9 $2,513,270 $879,755 $1,633,515 Month 10 $2,580,300 $877,040 $1,703,260 Month 11 $2,647,330 $874,325 $1,773,005 Month 12 $2,714,360 $871,610 $1,842,750 Month 13 $2,781,390 $868,894 $1,912,496 Month 14 $2,848,420 $866,179 $1,982,241 Month 15 $2,915,450 $863,464 $2,051,986 Month 16 $2,982,480 $860,749 $2,121,731 Month 17 $3,049,510 $858,034 $2,191,476 Month 18 $3,116,540 $855,318 $2,261,222 Month 19 $3,183,570 $852,603 $2,330,967 Month 20 $3,250,600 $849,888 $2,400,712 Month 21 $3,317,630 $847,173 $2,470,457 Month 22 $3,384,660 $844,458 $2,540,202 Month 23 $3,451,690 $841,742 $2,609,948 Month 24 $3,518,720 $839,027 $2,679,693 Month 25 $3,585,750 $836,312 $2,749,438 Month 26 $3,652,780 $833,597 $2,819,183 Month 27 $3,719,810 $830,882 $2,888,928 Month 28 $3,786,840 $828,166 $2,958,674 Month 29 $3,853,870 $825,451 $3,028,419 Month 30 $3,920,900 $822,736 $3,098,164 Month 31 $3,987,930 $820,021 $3,167,909 Month 32 $4,054,960 $817,306 $3,237,654 Month 33 $4,121,990 $814,590 $3,307,400 Month 34 $4,189,020 $811,875 $3,377,145 Month 35 $4,256,050 $809,160 $3,446,890 Month 36 $4,323,080 $806,445 $3,516,635 Month 37 $4,390,110 $803,730 $3,586,380 Month 38 $4,457,140 $801,014 $3,656,126 Month 39 $4,524,170 $798,299 $3,725,871 Month 40 $4,591,200 $795,584 $3,795,616 40 Month Average $3,284,115 $848,530 $2,435,585 Sales Sales Cost of sales Gross profit Expenses Operating expenses Interest Depreciation Amortization Total expenses Operating income Other income and expenses Gain (loss) on sale of assets Other (net) Subtotal

Sales Sales Cost of sales

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

$10,000 $20,000 $30,000

Income before tax Please enter a tax percentage Taxes @ 30% Net income

$611,000 $183,300 $427,700

$805,642 $241,693 $563,949

$980,042 $294,013 $686,029

$795,885 $238,765 $557,119

$980,406 $294,122 $686,284

$1,053,311 $315,993 $737,318

$1,126,217 $337,865 $788,352

$1,199,122 $359,737 $839,385

$1,272,028 $381,608 $890,419

$1,344,933 $403,480 $941,453

$1,417,838 $425,352 $992,487

$1,490,744 $447,223 $1,043,521

$1,563,649 $469,095 $1,094,555

$1,636,555 $490,966 $1,145,588

$1,709,460 $512,838 $1,196,622

$1,782,366 $534,710 $1,247,656

$1,855,271 $556,581 $1,298,690

$1,928,177 $578,453 $1,349,724

$2,001,082 $600,325 $1,400,757

$2,073,987 $622,196 $1,451,791

$2,146,893 $644,068 $1,502,825

$2,219,798 $665,939 $1,553,859

$2,292,704 $687,811 $1,604,893

$2,365,609 $709,683 $1,655,926

$2,438,515 $731,554 $1,706,960

$2,511,420 $753,426 $1,757,994

$2,584,325 $775,298 $1,809,028

$2,657,231 $797,169 $1,860,062

$2,730,136 $819,041 $1,911,095

$2,803,042 $840,913 $1,962,129

$2,875,947 $862,784 $2,013,163

$2,948,853 $884,656 $2,064,197

$3,021,758 $906,527 $2,115,231

$3,094,664 $928,399 $2,166,264

$3,167,569 $950,271 $2,217,298

$3,240,474 $972,142 $2,268,332

$3,313,380 $994,014 $2,319,366

$3,386,285 $1,015,886 $2,370,400

$3,459,191 $1,037,757 $2,421,434

$3,532,096 $1,059,629 $2,472,467

$2,110,440 $633,132 $1,477,308

Income before tax Taxes Net income

Detailed Supporting Information Cost of sales Direct labor Materials Other costs $320,000 $500,000 $125,000 $240,000 $500,000 $125,000 $208,000 $500,000 $125,000 $321,616 $500,000 $125,000

© Copyright, 2007, Jaxworks, All Rights Reserved.

© Copyright, 2006, Jaxworks, All Rights Reserved.

Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass documents, that cover a number of financial, accounting and sales functions. These are invalua Also included Free are: - business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books! - comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation; - Altman Z-Score (covering publicly and privately held firms, and small businesses); - and payroll analysis. If you are involved in financial analysis at any level, or want to learn more about MS Excel and site is invaluable.

JaxWorks Small Business Spreadsheet Factory

and spreadsheets, and associated MS Word, PDF and HTML unctions. These are invaluable small business tools.

se guides are in

r financial

ctivity analysis,

more about MS Excel and other applications in the Office suite this

ess Spreadsheet Factory


								
To top