Jaxworks: Forecast Analysis Page

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.