Cash flow statement
Company Name Date Prepared Starting Balance Cash In Loan/cash injection Sales Sales 1 Sales 2 Sales 3 Other sales Total Sales Plus: Collection of prior credit sales Less: Current month credit sales outstanding Total Cash In Cash Out Cost of Goods Sold COGS 1 COGS 2 COGS 3 COGS-Other Total Cost of Goods Sold Gross Profit Operating Expenses Advertising Books Certifications Equipment Expense Equipment Lease Furniture Insurance Internet Licenses (Business License) Maintenance Meals & Entertainment Membership Miscellaneous Postage Printing Professional Rent Signs Software Sponsorship Subscriptions Supplies Taxes Telephone Travel Utilities Wages Payroll Taxes Total Cash Out - Operations Operating Net Profit Capital Purchases (non recurring) Startup Loan Payment Owner Draws Self Employment Tax @15.3% Ending CASH Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Startup Position Month 1 Amount $0 Month 2 Amount $0 Month 3 Amount $0 Month 4 Amount $0 Month 5 Amount $0 Month 6 Amount $0 Month 7 Amount $0 Month 8 Amount $0 Month 9 Amount $0 Month 10 Amount $0 Month 11 Amount $0 Month 12 Amount $0
11/9/2009
(YEAR) Amount % of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%
-
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
-
0.0%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 1 of 5
Cash flow statement
Company Name Date Prepared Starting Balance Cash In Loan/cash injection Sales Sales 1 Sales 2 Sales 3 Other sales Total Sales Plus: Collection of prior credit sales Less: Current month credit sales outstanding Total Cash In Cash Out Cost of Goods Sold COGS 1 COGS 2 COGS 3 COGS-Other Total Cost of Goods Sold Gross Profit Operating Expenses Advertising Books Certifications Equipment Expense Equipment Lease Furniture Insurance Internet Licenses (Business License) Maintenance Meals & Entertainment Membership Miscellaneous Postage Printing Professional Rent Signs Software Sponsorship Subscriptions Supplies Taxes Telephone Travel Utilities Wages Payroll Taxes Total Cash Out - Operations Operating Net Profit Capital Purchases (non recurring) Startup Loan Payment Owner Draws Self Employment Tax @15.3% Ending CASH Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month 13 Amount $0 Month 14 Amount $0 Month 15 Amount $0 Month 16 Amount $0 Month 17 Amount $0 Month 18 Amount $0 Month 19 Amount $0 Month 20 Amount $0 Month 21 Amount $0 Month 22 Amount $0 Month 23 Amount $0 Month 24 Amount $0 (YEAR) Amount % of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0%
11/9/2009
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
-
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 2 of 5
Cash flow statement
Q1 Year 3 $0 Q2 Year 3 $0 Q3 Year 3 $0 Q4 Year 3 $0 (YEAR 3) Amount % of Sales $0 $0 $0 $0 $0 Cash Out Cost of Goods Sold COGS 1 COGS 2 COGS 3 COGS-Other Total Cost of Goods Sold Gross Profit Operating Expenses Advertising Books Certifications Equipment Expense Equipment Lease Furniture Insurance Internet Licenses (Business License) Maintenance Meals & Entertainment Membership Miscellaneous Postage Printing Professional Rent Signs Software Sponsorship Subscriptions Supplies Taxes Telephone Travel Utilities Wages Payroll Taxes Total Cash Out - Operations Operating Net Profit Capital Purchases (non recurring) Startup Loan Payment Owner Draws Self Employment Tax @15.3% Ending CASH Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0% $0 $0 $0 0.0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0.0% $0 $0 $0 $0 $0 Q1 Year 4 $0 Q2 Year 4 $0 Q3 Year 4 $0 Q4 Year 4 $0 (YEAR 4) Amount % of Sales $0 0.0%
11/9/2009
Starting Balance Cash In Loan/cash injection Sales Sales 1 Sales 2 Sales 3 Other sales Total Sales Plus: Collection of prior quarter credit sales Less: Current quarter credit sales outstanding Total Cash In
$0
$0
$0
-
$0
$0
$0
-
$0
$0
$0
$0
$0
$0
$0
$0
Page 3 of 5
Amortization Table
A simple amortization table covering each payment period of a loan. 1) To use the table, simply change any of the values in the Initial Data area of the worksheet. 2) To print the table, highlight the desired print area, choose File, Set Print Area, then File and Print.
Initial Data
LOAN DATA
Loan amount: Annual interest rate: Term in years: Payments per year: First payment due:
TABLE DATA $0
0.00% 0 0 1/30/2001 Table starts at date: or at payment number: 1
PERIODIC PAYMENT
Entered payment: Calculated payment:
$0.00 $0.00 $0.00
The table uses the calculated periodic payment amount unless you enter a value for "Entered payment".
Beginning balance at payment 1: Cumulative interest prior to payment 1:
CALCULATIONS
Use payment of: 1st payment in table: 1
#DIV/0! #DIV/0!
Table
No. Payment Date Beginning Balance Interest Principal Ending Balance Cumulative Interest
Table
No. Payment Date Beginning Balance Interest Principal Ending Balance Cumulative Interest