calculate-loan

01 Loan payments

Project Balance Sheet for Bank Loan

Calculator No. 01-23250 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A project balance sheet for a bank loan is a financial statement that shows a project’s assets, liabilities, and equity at a specific point in time, used by lenders to assess the project’s financial health and ability to repay the loan. You prepare it by listing what the project owns, owes, and the owner’s stake, ensuring that assets equal liabilities plus equity. This article explains how to build one, what banks look for, and common mistakes to avoid.

Formula

The balance sheet itself is built on the accounting equation: Assets = Liabilities + Equity. For a project, this means everything the project owns (cash, equipment, inventory, receivables) must equal everything it owes (bank loan, accounts payable, accrued expenses) plus the owner’s investment or retained earnings. The loan payment formula above is separate but related: it calculates the monthly payment and total interest for the debt portion of the balance sheet. The variables are:

  • p – loan principal (amount borrowed), in dollars.
  • apr – annual percentage rate, in percent per year.
  • yrs – loan term, in years.
  • pmt – monthly payment, in dollars, computed as p × (apr/1200) / (1 − (1 + apr/1200)^(−yrs×12)).
  • int – total interest paid over the loan life, in dollars, computed as pmt × yrs × 12 − p.

Worked Example

Using the default values from the calculator: loan amount $20,000, APR 8%, term 5 years.

  1. Monthly rate = 8 / 1200 = 0.0066667.
  2. Number of payments = 5 × 12 = 60.
  3. Payment = 20000 × 0.0066667 / (1 − (1.0066667)^(−60)) = 133.333 / (1 − 0.6712) = 133.333 / 0.3288 = 405.53 (rounded to $405.53).
  4. Total paid = 405.53 × 60 = $24,331.80.
  5. Total interest = 24,331.80 − 20,000 = $4,331.80.

So the monthly payment is $405.53 and total interest is $4,331.80. On the balance sheet, the loan would appear as a liability: initially $20,000, reduced by each payment’s principal portion.

Assumptions

  • Fixed interest rate for the entire term.
  • Payments are made at the end of each month.
  • Interest compounds monthly at APR/12.
  • No fees, taxes, insurance, or prepayment penalties are included.

Why Banks Ask for a Project Balance Sheet

Banks use the balance sheet to evaluate credit risk. They want to see that the project has more assets than liabilities (positive equity) and that it can generate enough cash flow to service the debt. A balance sheet shows the lender the project’s liquidity (cash), solvency (total assets vs. total liabilities), and how much of the project is actually owned versus borrowed. A project with thin equity or heavy short-term debt looks riskier because there is less cushion if revenue falls short. Banks also compare the balance sheet to the income statement and cash flow statement to verify that profits are real and not just paper entries.

How to Build a Project Balance Sheet

To prepare a balance sheet for a specific project (rather than a whole company), you must isolate that project’s transactions. This is easiest if you keep a separate bank account and accounting records for the project. Follow these steps:

  1. List all assets – cash in the project account, accounts receivable from customers, inventory, equipment purchased for the project, and any prepaid expenses.
  2. List all liabilities – the outstanding bank loan balance, accounts payable to suppliers, accrued wages, and any other debts directly tied to the project.
  3. Calculate equity – the owner’s initial investment plus any retained earnings (cumulative profit minus withdrawals). This is the balancing figure.
  4. Verify the equation – total assets must equal total liabilities plus equity. If they don’t, you have a missing transaction or an arithmetic error.
  5. Date the statement – a balance sheet is a snapshot; it is only valid for the specific date shown.

What Lenders Look For in the Balance Sheet

Beyond the basic equation, bankers examine several ratios and line items:

  • Current ratio – current assets divided by current liabilities. A ratio above 1.5 is often preferred, though requirements vary by industry.
  • Debt-to-equity ratio – total liabilities divided by total equity. A high ratio means the project is heavily leveraged, which increases risk.
  • Working capital – current assets minus current liabilities. Positive working capital suggests the project can cover short-term obligations.
  • Cash position – actual cash on hand, not just receivables, because cash is what repays loans.
  • Loan-to-value – if the loan is secured by equipment or property, the lender checks that the asset’s value exceeds the loan balance.

Lenders also look for consistency: a balance sheet that changes wildly from month to month may signal poor record-keeping or unstable operations.

Common Mistakes and How to Avoid Them

Several errors frequently appear on project balance sheets, and they can delay or derail a loan application:

  • Mixing personal and project finances – if you use one account for both, the balance sheet will be inaccurate. Keep separate records.
  • Forgetting accrued expenses – unpaid bills for utilities, rent, or salaries are liabilities even if the invoice hasn’t arrived. Include them.
  • Overstating asset values – using the purchase price of old equipment instead of its current market value inflates assets. Use realistic, supportable values.
  • Ignoring depreciation – equipment loses value over time. If you don’t subtract accumulated depreciation, your assets are overstated.
  • Double-counting the loan – when you receive a loan, cash increases and the loan liability increases. Later, when you buy equipment, cash decreases and equipment increases. Don’t record the loan twice.
  • Using a single date – a balance sheet from six months ago may not reflect the current situation. Provide the most recent statement possible.

How the Loan Payment Fits Into the Balance Sheet

The loan payment calculator above shows the monthly obligation, but on the balance sheet, only the principal portion reduces the liability. The interest portion is an expense on the income statement, not a reduction of the loan balance. For example, with a $20,000 loan at 8% for 5 years, the first month’s payment of $405.53 consists of about $133.33 in interest and $272.20 in principal. After that first payment, the loan liability on the balance sheet is $19,727.80. Over time, the interest portion shrinks and the principal portion grows. If you need to show the loan balance at any point, use the formula: balance after k payments = p × (1 + r)^k − pmt × ((1 + r)^k − 1) / r, where r is the monthly rate.

Alternatives to a Traditional Balance Sheet

If you cannot produce a full project balance sheet, some lenders accept alternative documentation, especially for smaller loans:

  • Cash flow projections – a month-by-month forecast of income and expenses showing how the loan will be repaid.
  • Personal financial statement – for sole proprietors, a statement of personal assets and liabilities may substitute for a project-level balance sheet.
  • Collateral documentation – proof of ownership and value of assets pledged as security.
  • Business tax returns – these provide historical financial data even without a formal balance sheet.

However, for larger loans or commercial projects, a formal, audited or accountant-prepared balance sheet is usually required.

Frequently Asked Questions

Do I need a separate balance sheet for each project?

Yes, if the project is a distinct venture with its own revenue and costs. Banks want to see that the specific project can repay its own loan, not that the broader business is profitable. A separate balance sheet isolates the project’s assets and liabilities, making it easier for the lender to assess risk.

What if my project has negative equity?

Negative equity means liabilities exceed assets. This is a red flag for lenders because it indicates the project owes more than it owns. You may still get a loan if you have strong cash flow, a personal guarantee, or collateral, but expect higher scrutiny or a higher interest rate. You can improve the balance sheet by injecting more owner capital or converting some debt to equity.

How often should I update the balance sheet?

For loan applications, provide the most recent month-end statement. For ongoing loan covenants, banks often require quarterly or annual updates. Internally, updating monthly helps you spot cash shortages early and keeps records clean for future borrowing.

Can I include the loan I’m applying for as a liability?

No. The balance sheet reflects the current state, not future events. The new loan is not a liability until you actually receive the funds. However, you can prepare a pro-forma balance sheet that shows what the balance sheet would look like after the loan is received and spent, which some lenders request.

What is the difference between a balance sheet and a cash flow statement?

A balance sheet is a snapshot of what you own and owe at one date. A cash flow statement shows how cash moved in and out over a period. Both are needed: the balance sheet shows whether the project is solvent, while the cash flow statement shows whether it generates enough cash to make loan payments on time.

Is the loan payment calculator enough to convince a bank?

No. The calculator gives you the payment amount and total interest, which helps you plan, but the bank will also want to see the full balance sheet, income statement, and cash flow projections. The payment is just one number; the bank needs to verify that the project can afford it over the entire term.

The figures from this calculator are estimates for planning purposes; the lender’s formal disclosure will state the exact payment, interest, and fees for your specific loan.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →