Projections Input Worksheet

For a Business Projection Analysis:

Company ID:
Country:
Postal or Zip Code:
Organization Type:
NAICS Industry Code:
Projection Type:
(Monthly, Quarterly or Annually)
Projection Length:
(Up to 36 Months, 12 Quarters, or 10 Years)

Income Statement Data:

Period End Date-
Sales (Income): / $ / $ / $ / $ / $
Cost of Sales (COGS): / $ / $ / $ / $ / $
Gross Profit: / $ / $ / $ / $ / $
Depreciation: / $ / $ / $ / $ / $
Amortization: / $ / $ / $ / $ / $
Interest Expense: / $ / $ / $ / $ / $
Overhead or S,G,&A Expense: / $ / $ / $ / $ / $
Payroll / Wages / Salary : / $ / $ / $ / $ / $
Rent: / $ / $ / $ / $ / $
Advertising: / $ / $ / $ / $ / $
Other Operating Income: / $ / $ / $ / $ / $
Other Operating Expenses: / $ / $ / $ / $ / $
Net Profit before Taxes: / $ / $ / $ / $ / $
Adjusted Owner's Compensation: / $ / $ / $ / $ / $
Adjusted Net Profit before Taxes: / $ / $ / $ / $ / $
Other Income: / $ / $ / $ / $ / $
Other Expenses: / $ / $ / $ / $ / $
Taxes Paid: / $ / $ / $ / $ / $
Net Income: / $ / $ / $ / $ / $


Balance Sheet Data:

Cash (Bank Funds): / $ / $ / $ / $ / $
Accounts Receivable: / $ / $ / $ / $ / $
Inventory: / $ / $ / $ / $ / $
Other Current Assets: / $ / $ / $ / $ / $
Total Current Assets: / $ / $ / $ / $ / $
Gross Fixed Assets: / $ / $ / $ / $ / $
Accumulated Depreciation: / $ / $ / $ / $ / $
Net Fixed Assets: / $ / $ / $ / $ / $
Gross Intangible Assets: / $ / $ / $ / $ / $
Accumulated Amortization: / $ / $ / $ / $ / $
Net Intangible Assets: / $ / $ / $ / $ / $
Other Assets:
/ $ / $ / $ / $ / $
Total Assets: / $ / $ / $ / $ / $
Accounts Payable: / $ / $ / $ / $ / $
Notes Payable / Current Portion of Long Term Debt:
/ $ / $ / $ / $ / $
Other Current Liabilities:
/ $ / $ / $ / $ / $
Total Current Liabilities:
/ $ / $ / $ / $ / $
Notes Payable / Senior Debt: / $ / $ / $ / $ / $
Notes Payable / Subordinated Debt: / $ / $ / $ / $ / $
Other Long Term Liabilities: / $ / $ / $ / $ / $
Long Term Liabilities: / $ / $ / $ / $ / $
Total Liabilities: / $ / $ / $ / $ / $
Preferred Stock: / $ / $ / $ / $ / $
Common Stock: / $ / $ / $ / $ / $
Additional Paid-in Capital: / $ / $ / $ / $ / $
Other Stock / Equity: / $ / $ / $ / $ / $
Ending Retained Earnings: / $ / $ / $ / $ / $
Total Equity: / $ / $ / $ / $ / $
Total Liabilities + Equity: / $ / $ / $ / $ / $

Statement of Equity:

Preferred Stock: / $ / $ / $ / $ / $
Common Stock: / $ / $ / $ / $ / $
Additional Paid-in Capital: / $ / $ / $ / $ / $
Other Stock / Equity: / $ / $ / $ / $ / $
Total Stock: / $ / $ / $ / $ / $
Beginning Retained Earnings: / $ / $ / $ / $ / $
Net Income: / $ / $ / $ / $ / $
Dividends Paid / Withdrawals: / $ / $ / $ / $ / $
Ending Retained Earnings: / $ / $ / $ / $ / $
Total Equity: / $ / $ / $ / $ / $
Actual Equity from Balance Sheet: / $ / $ / $ / $ / $
Difference (Unexplained Change in Equity) / $ / $ / $ / $ / $

Current Business Loans (Optional):

Description:
Type of Loan (Term, Mortgage, Line of Credit):
Financing (Senior or Subordinated)
Approximate Current Balance:
Approximate Monthly Payment:
Interest Rate:
Remaining Term:

Proposed Loans (optional):

Please use this area to adjust loans and terms and such for the forecast. We will use any information that you enter on this screen in the projection. Keep in mind that this area is probably slightly more complicated than other parts of the program because we are balancing the requirement to forecast loans and debt service with our objective of keeping the program intuitive and easy to use. This is an optional area that is not required -- any loans that you leave blank will be ignored by the program.

Description:
Type of Loan (Term, Mortgage, Line of Credit):
Financing (Senior or Subordinated)
First Payment Date:
Interest Rate:
Remaining Term:
Approximate Current Balance:
Choose A Loan To Refinance: