Page 2 of 3
month AFTER the last payment on the existing loan. For the new loan that will be taking its place, the month
payments start date will be the same as the Refinance Month. (Example: Existing loan paid off in February and
assuming the February payment will still be made then enter March (3) as the Refinance Month. (Enter this on
the Loan Amortization tab for the new loan.)
Note: Only NEW debt and assets should be entered on the cash flow statement, not the refinanced amount.
Existing Lines, Notes CC Amortizations
The Existing Lines, Notes CC Amortizations sheet is used to develop the amortization schedules for short-term
Lines of Credit, Notes Payable, and Credit Cards Payable. Enter the information requested and Y or N for
Interest Only.
Debt Schedule
The Debt Schedule pulls the existing loan amortizations together in one simple form that can be presented in a
loan package.
Sales Projections
On the Sales Projections sheet, enter a target sales amount for each month in YR 1 Sales. Enter each individual
product (up to 10), the percentage of total sales for each product and the expected Cost of Goods Sold for each
product. Entering a price-per-unit for each product will identify the number of sales for each product necessary
to achieve the level of sales in each month.
Sales Projections sheets for the next two years carry forward the product names, percentage of sales per
product, and percentage of sales per month. This can be changed if the company expects changes. Enter new
sales goals and Cost of Goods Sold percentages in year’s two and three.
Income Statement
Sales and Cost of Goods Sold data transfers from the Sales Projections sheet to the Income Statement for each
year. Enter monthly expenses beginning with January. The amounts will be automatically copied across all
months and totaled at year end. Changes can be made to each individual month by overriding the formula.
Amortization, Depreciation, and Interest Expense are calculated automatically based on entries on prior sheets.
Merchant Credit Card Fees (MCCF) are calculated after entering the percentage of sales made by credit cards
and the percentage fee charged in the blue fields to the right of the MCCF line. Enter Balance Sheet
Assumptions - Days Receivable and Days Payable at the top of the Income Statement.
Cash Flow Statement
The Cash Flow Statement takes into account data entered on all prior sheets and records the monthly change in
cash. If entering a beginning balance sheet you must enter the starting cash in cell C444 in YR 1 CF.
Blue fields allow for manual entries to record changes client anticipates in the various asset, liability and equity
accounts. There is an “Out of Balance” line in gray below Ending Cash. Check this to ensure that Ending Cash
Balance on the Cash Flow Statement matches Cash balance on the Balance Sheet each month.
Note: Enter the loan, equity and capital expenditure amounts on the appropriate cash flow statements in the
months funds will be disbursed. This will usually be one month prior to the first payment.