• Home
• About
  • Pricing Information
  • Site Information
  • Contact Information
  • Personnel
  • Site Map
  • Terms of Use
  • Privacy Policy
• Models
  • Financial Forecast Demo
  • Financial Forecast Model - Established Businesses
  • Financial Forecast Model - Early Stage Businesses
  • Financial Forecast Model - Start-Up Businesses
  • LBO Valuation Model
  • Private Equity Placement Model
  • Single-Year Forecast Model
  • Public Company Analysis Model
• Members
• Help
  • Notes
  • Glossary
  • Site Information
  • Technical Support

Estimate and Forecast Balance Sheets
Tom's Machinery Co. Inc.
Multi-Year Scenario #1
(Dollars and Shares in Thousands, Except Per Share Amounts)

	Estimate			Forecast
	12 Months 06/30/09			12 Months 06/30/10		12 Months 06/30/11		12 Months 06/30/12		12 Months 06/30/13		12 Months 06/30/14
Assets:
Cash	9.6%			8.4%		7.4%		6.5%		5.7%		5.0%
Accounts Receivable	24.9%			25.3%		25.7%		26.1%		26.1%		26.4%
Inventory	34.5%			34.7%		35.2%		35.2%		35.5%		35.6%
Other Current Assets	2.3%			2.4%		2.4%		2.3%		2.3%		2.4%
	71.3%			70.8%		70.6%		70.2%		69.7%		69.5%
Property, Plant and Equipment	21.1%			24.5%		27.3%		30.1%		32.6%		34.5%
Accumulated Depreciation	0.0%			(3.0)%		(5.6)%		(8.1)%		(10.3)%		(12.2)%
	21.1%			21.5%		21.7%		22.0%		22.3%		22.3%
Intangibles	2.7%			2.7%		2.7%		2.6%		2.8%		2.8%
Investments	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
Other Assets	5.0%			5.1%		5.0%		5.2%		5.3%		5.4%
Total	100.0%			100.0%		100.0%		100.0%		100.0%		100.0%
Liabilities and Owners' Equity:
Line of Credit	11.1%			10.0%		6.6%		1.9%		(2.7)%		(7.5)%
Current Maturities	4.2%			4.4%		4.4%		4.4%		4.6%		4.6%
Other Current Obligations	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
Accounts Payable	14.9%			14.8%		15.1%		15.1%		15.1%		15.2%
Accrued Expenses	15.3%			14.5%		14.2%		14.3%		14.4%		14.2%
Taxes Payable	0.4%			0.3%		0.3%		0.3%		0.2%		0.2%
Other Current Liabilities	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
	46.0%			44.1%		40.6%		36.1%		31.7%		26.7%
Term Loan	14.6%			14.8%		15.2%		15.5%		15.6%		15.5%
Subordinated Debt	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
Other Long Term Obligations	7.7%			7.1%		7.1%		7.3%		7.3%		7.4%
Other Liabilities	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
Common Stock	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
Preferred Stock	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
Treasury Stock	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
Retained Earnings	31.8%			34.0%		37.2%		41.2%		45.4%		50.2%
Other Equity	0.0%			0.0%		0.0%		0.0%		0.0%		0.0%
	31.8%			34.0%		37.2%		41.2%		45.4%		50.2%
Total	100.0%			100.0%		100.0%		100.0%		100.0%		100.0%