ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Cash Flow Analysis for Business Startups
2
created by the Northland Small Business Development Center
3
www.northlandsbdc.org
4
Revised April 23, 2024
5
6
Note, this sheet is shared in a View Only format. To use the sheet for your projects, you or your client will need to click File - Make a Copy of the sheet and save on your own Google Drive. Note that to use this version, the user must have a Google account and be able to access Google Sheets.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Items in red below apply to multiple sheets and need to be entered in this tab!
22
General instructions:
23
Blue cells must be input by user. All other cells are calculated.
24
25
26
Sheet: Start Up Expenses
27
Start Up Expenses will calculate one-time expenses related to starting up a new business venture.
28
Under Sources, enter the starting cash and loans to fund the business startup or current cash and loans for existing businesses. Loan names will automatically pull into the Loans sheet.
29
Under uses, Assets should be business assets only. Start-up costs includes a list of typical business start up costs. Your business may not have all of the expenses listed. The list may be edited.
30
31
32
Sheet: Loans
33
Enter the lender name, original principal, interest rate (does not accomodate variable interest rates), and loan term in YEARS. This will calculate the monthly loan payment for use in the cash flow sheets.
34
35
36
Sheet: Cash Flow - Year 1 through Year 3
37
Enter income and expenses per month for Year 1 first. Payroll Tax, Loan Payments, and Credit Card Fees are automatically filled in for you. See below for credit card fee information.
38
The calculated Loan Payments are only for those 3 listed on the Sources page. You can add an additional expense line item for additional loan payments if applicable.
39
Cash Income (Income 1 through Income 3) represent different incomes such as different products or services. All income may be entered into one row if preferred.
40
Cash Paid Out includes typical expenses a business may incur. Not all expense types will be applicable.
41
The spreadsheet assumes that expenses in January are carried throughout the year by default. All expenses may be manually entered to account for variability through the year.
42
Cells B3 through B55 are tan may be used for notes to clarify monthly expenses
43
44
Cash Flow - Credit Card Fees
45
The Cash Flow sheets will automatically calculate credit card fees based on your total income and the inputs below. You may manually overwrite these calculations if you prefer.
46
0%
Average credit card fee for income run through a credit card. Recommended values from 2% to 4%.
47
0%
Percent of all income run through credit cards.
48
49
Cash Flow - Expenses for Year 2 and Year 3
50
You must manually enter income for Year 2 and Year 3 per month.
51
You may manually enter expenses for Year 2 and Year 3 if you wish. The instructions below will allow you to copy expenses from Year 1 to Year 2 and 3 and include an annual inflationary increase.
52
53
IMPORTANT! Any manual edits to Years 2 and 3 will replace the formula for inflation. If Year 2 or Year 3 are manually edited, changes to previous years will not cary through and must be manually updated.
54
55
0%
Assumed Expense Annual Inflation Rate (cost increase for expenses from year to year). Reccommended values from 0% to 3% per annum. Enter in this sheet to apply to Year 2 and Year 3
56
57
*Note, the function to copy Year 1 expenses to Years 2 and 3 with inflation assumes that there are expenses starting in January. Manual entry will need to be completed for Year 2 if the project starts in a later month in Year 1. If you edit the formula in Years 2 and 3, those sheets will not update automatically based on additional changes to previous years expenses.
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100