Read chapter 3
The whole of chapter three, free. About 8 min. Turn the pages with the arrows, your keyboard, or a swipe.
Chapter 3
Building Realistic Financial Projections
Turn Sales Assumptions Into a Bank-Readable Forecast
A busy plumbing company can still run short of cash when its forecast counts every approved job as money already collected. A gym can show strong membership sales while monthly bank deposits lag because customers pay late, cancel, or join under discounted offers. Lenders look past the sales total. They want to know how you built it, when the cash arrives, and whether the business can make each loan payment.
Before you begin, gather your recent sales records, price list, customer or job pipeline, supplier invoices, payroll schedule, rent and utility bills, tax calendar, and proposed loan terms. A spreadsheet works well because it lets you change one assumption and see the effect across sales, cash, and repayment.
The key distinction matters: profit measures whether sales exceed expenses, while cash flow shows whether money sits in the bank when bills come due. Your forecast must connect both. The Assumption-to-Cashflow Chain does that by moving from a measurable business activity to revenue, cash collection, expenses, ending cash, and loan repayment. Each link should answer a lender’s basic question: “What supports this number?”
Start with facts you can check. If you run a cleaning company, count crews, jobs per crew, average jobs per week, price per job, and collection timing. If you sell products, count units, selling price, supplier cost, and payment terms. Avoid starting with a desired annual revenue figure and working backward to create unsupported monthly sales.
Ask yourself: could another person open your records and trace this forecast to a real operating measure? If not, strengthen the assumption before you present the numbers. The practical takeaway is simple: forecast activity first, then turn that activity into dollars.
Build the Assumption-to-Cashflow Chain
Build the forecast in a fixed order so you do not confuse sales with cash. Use the following sequence:
1. Set the operating assumption. Record the number of jobs, customers, appointments, or units you expect to sell. 2. Calculate sales. Multiply the activity by the actual price, separating full-price work from discounts. 3. Schedule collections. Show when customers will pay, not merely when you issue an invoice. 4. List direct costs. Include materials, product purchases, subcontractors, card fees, and other costs tied directly to each sale. 5. Add fixed costs. Include wages, rent, insurance, utilities, software, taxes, and other regular payments. 6. Add the proposed loan payment. Use the lender’s expected principal, interest rate, and term, or clearly label your estimate. 7. Calculate ending cash. Begin with opening cash, add collections, subtract every cash payment, and review the lowest balance.
Consider a small commercial cleaning company with two crews. Each crew can complete four jobs per week, and the company operates four weeks each month. That creates a capacity of 32 jobs monthly. The owner forecasts 24 jobs in the first three months while adding customers, then 28 jobs from month four onward. The average job brings in $450, but the company offers a $50 introductory discount on four jobs each month during the first three months.
The monthly sales calculation looks like this:
| Period | Jobs | Price calculation | Sales | |---|---:|---:|---:| | Months 1-3 | 24 | 20 × $450 + 4 × $400 | $10,600 | | Months 4-12 | 28 | 28 × $450 | $12,600 |
The owner then separates sales from collections. Commercial customers pay 30 days after invoicing. If the company invoices $10,600 in January and had no earlier invoices, January collections equal $0 from those new jobs. February collections include January’s $10,600, while February’s new invoices wait until March. That timing changes the cash picture immediately.
Direct costs equal $110 per job for cleaning supplies and subcontracted specialty work. At 24 jobs, direct costs total $2,640. The company also pays $4,900 each month for crew wages, rent, insurance, software, utilities, and other overhead. Before financing, the operating cash result for a month with $10,600 collected is:
• Collections: $10,600 - Direct costs: $2,640 - Fixed costs: $4,900 - Cash available before debt payment: $3,060
Suppose the proposed loan requires a monthly payment of $1,050. The company retains $2,010 before taxes and owner withdrawals. However, during the first month, collections from new jobs equal zero, so the company must cover $7,540 in direct and fixed cash costs plus the loan payment from opening cash or another source. That shortfall belongs in the plan. Hiding it makes the forecast less credible; explaining the needed working capital makes the request more useful.
For the repayment test, calculate the lowest projected ending cash and compare it with the required payment. Also create a slower-sales case. If the company completes only 20 jobs instead of 24 during the first three months, sales fall to $8,800 before discounts, and direct costs fall to $2,200. Because customers still pay 30 days later, the cash shortage appears before the lower sales fully show up in collections. A lender can then see the pressure point and the owner’s response, such as delaying equipment purchases, limiting owner withdrawals, or keeping a defined cash reserve.
Use a separate line for taxes and irregular payments. A quarterly tax payment, annual insurance renewal, or equipment repair can turn a positive monthly result into a negative bank balance. Record the month when each payment leaves the account. A forecast that averages a $12,000 annual insurance bill across 12 months may look smooth, but the bank statement will show the full payment in one month.
Review the chain from left to right: activity, sales, collections, costs, cash, and debt payment. If a number changes, update every later link. The practical takeaway is that a defensible forecast does not promise perfect accuracy; it shows the assumptions, timing, and consequences clearly.
Test the Forecast With a Hands-On Cash Schedule
Create a 12-month spreadsheet for a mobile auto-detailing business seeking $30,000 for a van and equipment. Prepare these materials:
• Last 12 months of bank deposits, if the business already operates - Price list showing an average service price of $180 - Capacity estimate of five appointments per day, 22 working days per month - Booking records showing 80 appointments in the first forecast month - Supplier quote showing $35 in materials per appointment - Monthly fixed costs of $6,200 - Proposed loan payment of $720 - Collection rule: customers pay at the appointment
Enter 80 appointments at $180, producing $14,400 in sales and immediate collections. Direct materials equal 80 × $35, or $2,800. Subtract fixed costs of $6,200 and the loan payment of $720. The projected cash remaining before taxes and owner withdrawals equals $4,680.
Now test a slower month with 60 appointments. Sales and collections fall to $10,800, while materials fall to $2,100. After fixed costs and the loan payment, the business retains $1,780. The payment still fits, but the cushion is much smaller. Next, test a month with 45 appointments. Collections equal $8,100, materials equal $1,575, and cash remaining falls to negative $395. Mark that month as a warning point rather than adjusting the numbers to make the result look better.
Write an action beside the warning point. The owner might pause paid advertising, reduce temporary labor, postpone nonessential equipment purchases, or draw from a documented opening cash balance. Do not claim that sales will recover without identifying the action that could produce the recovery. If the loan funds the van, show how the van increases appointment capacity or reduces travel time, and state when that improvement enters the forecast.
Complete the spreadsheet by checking three outcomes. First, verify that every sales figure comes from appointments multiplied by price. Second, verify that collections follow the actual payment pattern. Third, verify that the lowest ending cash balance remains positive after the loan payment, taxes, and planned withdrawals. If it does not, revise the request, timing, expenses, or owner contribution before submitting the plan.
Your finished schedule should let a lender trace the $30,000 request to a specific purchase, the purchase to added capacity, the added capacity to appointments, and the appointments to cash available for repayment. That trace is the practical test of the Assumption-to-Cashflow Chain.
Correct Forecast Errors Before a Lender Finds Them
Counting invoices as cash
A business records a $20,000 month because it invoiced customers for $20,000, then assumes it can spend the same amount. The cause usually involves confusing the sale date with the collection date. That error can make a loan payment appear affordable even when the bank account reaches its lowest point before customers pay.
Do this: Create separate rows for invoices and collections. Apply the actual payment terms, such as payment at purchase, 30 days after billing, or partial deposits.
Not this: Treat every invoice as a deposit in the same month.
Ask yourself whether your projected bank balance matches the timing shown on recent bank statements. If it does not, fix the collection schedule before changing the sales forecast.
Using capacity as a sales forecast
A landscaping company can complete 40 jobs per month, so the owner enters 40 jobs for every month. Capacity shows the maximum possible output, not the number of paying customers. The cause may be pressure to present fast growth or a failure to review booked work.
Do this: Start with confirmed work, repeat-customer patterns, lead records, seasonality, and the time required to win each new customer. Use capacity as a ceiling, then explain how sales reach that ceiling.
Not this: Fill every available appointment simply because the schedule allows it.
A forecast that rises from 18 jobs to 36 jobs should identify the added marketing, staff, equipment, or customer contracts that support the increase.
Leaving out the repayment stress test
A forecast shows enough annual profit to cover the loan, but it never tests a slow month, a delayed customer payment, or an unexpected repair. The cause comes from reviewing totals instead of timing and downside risk.
Do this: Run at least one slower-sales case and one delayed-collection case. Identify the lowest ending cash balance and list the specific spending decision that protects repayment.
Not this: Present only the best case and describe the loan payment as affordable because annual revenue exceeds annual expenses.
A strong submission makes the pressure visible and explains the response. When your assumptions connect to deposits, expenses, and repayment month by month, the lender can judge the request on evidence rather than optimism. That clear chain gives the rest of the business plan a financial foundation worth taking seriously.
End of chapter three. 2 more chapters and about 9,110 words in the full book.
Swipe or use the arrows to turn the page
What's inside: 5 chapters
- 1. Understanding Bank Lending Criteria
- 2. Researching Your Market and Customers
- 3. Building Realistic Financial Projections
- 4. Explaining the Loan Request
- 5. Assembling a Lender-Ready Plan
About this book
"The Bank-Ready Business Plan" is a how-to guide book by ONYEBUCHI STEPHEN with 5 chapters and approximately 9,110 words. Writing a clear, credible business plan for bank lenders.
This book was created using Inkfluence AI, an AI-powered book generation platform that helps authors write, design, and publish complete books. It was made with the AI Ebook Generator.
Frequently Asked Questions
What is "The Bank-Ready Business Plan" about?
Writing a clear, credible business plan for bank lenders
How many chapters are in "The Bank-Ready Business Plan"?
The book contains 5 chapters and approximately 9,110 words. Topics covered include Understanding Bank Lending Criteria, Researching Your Market and Customers, Building Realistic Financial Projections, Explaining the Loan Request, and more.
Who wrote "The Bank-Ready Business Plan"?
This book was written by ONYEBUCHI STEPHEN and created using Inkfluence AI, an AI book generation platform that helps authors write, design, and publish books.
How can I create a similar how-to guide book?
You can create your own how-to guide book using Inkfluence AI. Describe your idea, choose your style, and the AI writes the full book for you. It's free to start.
Write your own how-to guide book with AI
Describe your idea and Inkfluence writes the whole thing. Free to start.
Start writingCreated with Inkfluence AI