Cash Flow Calculator


Cash Flow Calculator

The cash flow calculator will help you determine how much cash you will need to start a business. You can use the calculator for free. To use the cash flow calculator you first fill out three short forms which will build your Company’s Start Up Statements. To build the start up statements you will need to know the following:

  • Your expenses related to starting the company.
  • The assets (cash, equipment, etc.) that you will invest in the company.
  • The money that you will owe for the assets listed above.

After you build the Start Up Statements you then forecast for your Company’s first year of business. After you do this, forecast financial statements will be generated. The statements will show your companies cash balances for the first 12 months of business. To forecast the financial statements you must know the following:

  • The type of business your are in. You can select from a list of the following:
    • General Business
    • Accounting / CPA
    • Advertising / PR
    • Architecture
    • Construction / Contracting
    • Consulting
    • Farming / Ranching
    • Graphic Design / Printing
    • Healthcare
    • Insurance
    • Legal
    • Manufacturing
    • Manufactures / Sales Rep
    • Property Management
    • Real Estate Broker
    • Restaurant
    • Retail
    • Service
    • Wholesale / Distribution
    • Writer / Artist
  • Your company’s projected first month sales and expenses.
  • Your company’s projected monthly growth rate.
  • The amounts and dates of any forecasted equipment purchases (i.e. instance, automobiles, manufacturing equipment, etc.)
  • The terms of your sales. If your company sells to other businesses, then you will likely have to offer your business customers credit terms. You will have to provide them will your Company’s goods and/or services, then send them a bill and wait for them to pay you. Most retail businesses do not offer credit terms to individuals. You’ll need to know the percentages of sales that will be sold on credit and how many days after the sale you will receive the money. Note: Don’t confuse “credit card sales” with “credit sales”. With credit card sales, the credit card company is offering your customer credit, but will immediately deposit the money in your company’s bank account regardless of when or even if the customer ever pay their credit card bill.
  • The terms of your monthly expenses. Most venders offer businesses (your company) credit so you can pay for goods and services after you receive them. You will likely have to pay for rent in advance, but you might be able to negotiate 30, 60 or even 90 day terms for the inventory you stock..

When you are done entering the information, you will be able to see your company’s monthly cash balances for its first year. If the cash balance is negative or below what you consider to be a safe amount, then you will need to either find equity investors or obtain a loan. The cash flow calculator will allow you to enter equity and/ or a loan.

Finally when your are done you can download the reports in excel or view them on line.

Below are the steps involved. Some steps you can just skip, but you should start at the top and work your way down.

Start Up Statements
1 Start Here
Set up
Enter general information which will appear at the top of the reports.
2 Start-Up Expense Statement Enter expenses related to starting your company.
3 Beginning Balance Sheet Enter the assets and liabilities for your companies first day of business.
First Year Statements
4 Chart of Accounts Select the industry for your company and the approximate sales and expenses for your first month of operations.
5 Month 1 & Monthly Growth Add / delete expense accounts, adjust sales and expense amounts for the first month of operations and set the growth rates.
6 Months 1 – 12 Make adjustments to the sales and expense amounts for months 1 – 12.
7 Balance Sheet Assumptions Enter balance sheet assumptions for accounts receivable, inventory and accounts payable.
8 Fixed Asset Purchases Enter fixed asset purchases (equipment, furniture, etc.) and assumptions for depreciation expense.
9 Equity Investments Enter equity investments and withdrawals.
10 Other Balance Sheet Items If necessary, enter the following balance sheet items: Other Short-term Assets, Other Long-term Assets, Other Short-term Liabilities, and / or Other Long-term Liabilities.
11 View Financial Statements View the Income Statement, Balance Sheet and Statement of Cash Flows.
Reports
12 Formatting / Output Select the report formatting options and download the reports.
Loan Amortization Schedule
Loan Enter loan amount, term and interest rate.

Below is a chart that shows the steps involved for determining how much cash you will need to start your company. The boxes below are hyperlinked, so if you click on a box you will be sent directly to that step.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s