Ad Hoc Reporting

Model Name

Interval

Choose... Annual Quarterly

---

Line	Account	FY1	FY2	FY3	Sign	Description
Current Assets
1	Cash & Cash Equivalents *				+/-	Cash on hand and in bank accounts plus short term investments (such as money market accounts or marketable securities that can be converted to cash at or near the stated value when needed)
2	Accounts Receivable *				+	Cash owed to your organization from customers purchasing your goods & services on credit terms
3	Inventory *				+	The cash value of all products a company has on hand for sale, including the costs of unfinished items in manufacturing and materials that can be converted to products within a typical production cycle
4	Other Current Assets *				+/-	The remaining other current assets not included above, such as pre-paid expenses, short term investments, for examples
Total Current Assets						This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Balance Sheet report
Long-term Assets
5	Property Plant and Equipment (Net) *				+	Physical property, plant and equipment that is owned by your organization with multiple years of useful life, less (or net of) accumulated depreciation
6	Other Non-current Assets *				+/-	Other includes such line items as long term investments, goodwill, intangibles
Total Assets						This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Balance Sheet report
LIABILITIES & SHAREHOLDER'S EQUITY
Current Liabilities
7	Trade / Accounts Payable *				+	Cash owed by your organization to your vendors for goods and services purchased on credit terms
8	Short-Term Debt *				+	Debt incurred by your organization that is to be paid back to its lender in less than a year. This should include the current portion of long-term debt.
9	Other Current Liabilities *				+/-	Other includes such line items as deferred revenue, income tax payable, accrued expenses
Total Current Liabilities						This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Balance Sheet report
Non-Current Liabilities
10	Long-Term Debt *				+	Long term debt (such as notes payable, mortgages) incurred by your organization, less the portion that is owed during the current year
11	Capital Lease Obligations *				+	Capital Lease liability, less the portion that is owed during the current year
12	Other Liabilities				+/-	Any other long term liabilities not included already above
13	Net Shareholders' Equity *				+/-	Net Shareholders' Equity is the amount of money that represents the company's net value after subtracting the total liabilities from the total assets.
Total Liabilities & Shareholder' Equity						This spreadsheet automatically calculates this number from the data provided. Please verify that the amount in your Balance Sheet report matches the same line item amount.

Income Statement

Line	Account	FY1	FY2	FY3	Sign	Description
INCOME STATEMENT
14	Revenue *				+/-	Total net sales (sales less returns) of goods and services made by your organization
15	Cost of Goods Sold excluding Depreciation and Amortization *				+/-	Costs (material, labor, overhead) incurred by your organization to produce and sell the goods and services sold (not including the non-cash expenses of depreciation and amortization)
16	Impairment / Restructuring Charges *				+/-	Extraordinary items including but not limited to: restructuring charges, fixed asset impairment, intangible asset impairment, goodwill impairment, and other write-offs. This number should be as of this reporting period end date and should NOT include depreciation or amortization
17	Depreciation & Amortization *				+/-	Non-cash expenses to be separated out from Cost of Goods Sold calculated by your organization
18	Selling General & Administrative *				+/-	Expenses that are NOT directly part of the manufacturing of goods and services sold by your organization (examples: sales, administrative, research & development)
19	Other Operating Expense (Income) Net				+/-	Other expense line items not included above, A negative value if there is net income
20	Operating Costs					This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Income Statement report
21	Operating Income (EBIT)					This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Income Statement report
22	Interest Income *				+	The amount of interest income received by your organization. It must be a positive value.
23	Interest Expense *				-	The amount of interest expense paid by your organization. It must be a negative value.
Interest Income (Expense) Net
24	Other Non-Operating Income (Expense) Net				+/-	Gains or income from organization activities not directly tied to the manufacturing of goods and services typical of day to day operations (examples: investments, asset sales, currency exchange)
Pretax Income
25	Income Tax *				+/-	Negative Number if Tax Expense, Positive Number if Tax Benefit
After Tax Income
26	Equity Income (Loss) From Affiliates				+/-	Positive Number if Equity Income, Negative Number if loss
26	Other After Tax Adjustements				+/-	Positive Number if Equity Income, Negative Number if loss
Consolidated Net Income (Loss)

Cash Flow Statement

Line	Account	FY1	FY2	FY3	Sign	Description
CASH FLOW
Cash Flow From Operations
	Net Income (Loss)					This number is provided from the data in another tab. Please verify that it matches your financial statements.
	Depreciation and Amortization					This number is provided from the data in another tab. Please verify that it matches your financial statements.
27	Change in Working Capital				+/-	(Positive Number if Net Increase in Working Capital OR Negative Number if Net Decrease) Found in your organization's Cash Flow Statement, and reflects increases/decreases in assets & liabilities
28	Other Non-cash Items included in Net Income				+/-	Found in your organization's Cash Flow Statement, other than depreciation & amortization (examples: deferred income tax, write-downs of acquired companies, ESOPs)
Net Cash Provided by (used in) Operating Activities						This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Cash Flow Statement report
Cash Flow From Investing
30	Capital Expenditures - Net				+/-	Found in your organization's Cash Flow Statement (examples: purchase or sale of long term fixed assets like property, buildings, building improvements, equipment, vehicles). A negative value if net expense. A positive value if net income from sales.
31	Other Cash Flow Items				+/-	Includes purchases of physical assets, investment or sale of securities or assets. Found in your organization's Cash Flow Statement. A negative value if net expense. A positive value if net income from sales.
Cash Flows from Investing						This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Cash Flow Statement report
Cash Flow From Financing
33	Net Cash from Acquisitions & Divestitures				+/-	Includes purchases or sales of companies. Found in your organization's Cash Flow Statement
34	Change in Debt				+/-	Net result of borrowing (notes, bonds, credit lines) and/or re-paying or re-financing debt. Found in your organization's Cash Flow Statement
35	Cash Dividends Paid				-	Enter dividend payments as a negative value.
36	Issuance or Reduction of Capital Stock				+/-	Net result of issuing (selling) or buying back stock. Found in your organization's Cash Flow Statement
Cash Flows from Financing						This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Cash Flow Statement report
37	Foreign Currency Transaction Net Loss (Gain)				+/-	Net result of gains or losses on financial transactions due to foreign currency fluctuations. Found in your organization's Cash Flow Statement
Net Increase in Cash and Cash Equivalents and Restricted Cash						This number is automatically calculated by this spreadsheet from the data provided. Please verify that it matches the same line item amount in your Cash Flow Statement report