The statement of Forecast assumptions and final financial statement

profilesara0309
CopyofSampleFinancialStatementsTemplate18byMonth19-201.xls
Home>Business & Finance homework help>Accounting homework help>The statement of Forecast assumptions and final financial statement

Income Statements

Projected Income Statements Jan -Dec 2018 and all of 2019 & 2020
Company, Inc.
$ in 000's
2018 2018 2019 2020
Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Yr. 2017 Yr. 2018 Yr. 2019
TOTAL SALES
TOTAL COST OF SALES
NET GROSS MARGIN
%
SELL, GEN & ADMIN EXPENSES
Adv. & Prom.
Auto & Truck
Bank Service Charges
Computer & Internet Exp.
Consulting Exp.
Commissions & Salaries Exp.
Credit Card Proc. Fees
Dues, Fees & Licenses
Office Supplies
Postage & Delivery
Printing & Reproduction
Prof. Fees
Rent
Travel Exp.
Miscellaneous
TOTAL SELL, GEN & ADMIN EXPENSES
OPERATING INCOME
OTHER INCOME/(EXPENSE)
Interest Expense
TOTAL OTHER INC. (EXP.)
NET INCOME
4/4/17

Balance Sheets

Company, Inc.
Projected Balance Sheets 12/31/17 thru 12/31/20
$ in 000's
Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
12/31/17 1/31/18 2/28/18 3/31/18 4/30/18 5/31/18 6/30/18 7/31/18 8/31/18 9/30/18 10/31/18 11/30/18 12/31/18 12/31/19 12/31/20
Assets
Current Assets
Cash
Accounts Receivable
Inventory
Deposits
Prepaid Expense
Total Current Assets
Other Assets
Dynatrap Intellectual Property
Total Assets
Liabilities & Equity
Current Liabilities
Accounts Payable
Accrued Expenses
Notes Payable - Bank (Cur. Por.)
Notes Payable - Bank LOC
Notes Payable - Owner
Notes Payable - Other
Total Current Liabilities
Long Term Debt
Notes Payable - Bank (Less Cur. Por.)
Total Liabilities
Equity
Member Investment
Retained Earnings (Prev. Yr.)
Current Year Profit (Loss)
Less Distributions to Members
Total Equity
Total Liabilities & Equity
4/4/17

Cash Flow Statements

Company, Inc.
Statements of Cash Flow Forecast '18-'20
2018 2018 2019 2020
Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd Proj'd
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Yr. 2018 Yr. 2019 Yr. 2020
Net Profit
Add Back Depreciation
Capital Expenditures - Additions
to Fixed Assets at Cost (Addns.)
Working Capital Needs:
Accts. Receivable (Incr.) Decr.
Inventory (Incr.) Decr.
Deposits (Incr.) Decr.
Prepaid Exp. (Incr.) Decr.
Accts. Payable (Decr.) Incr.
Accrued Exp. (Decr.) Incr.
Total Working Capital Needs
Loans (Decr.) Incr.
Member Investment
Member Withdrawals
Cash Flow
Beginning Cash
Ending Cash
4/4/17