Start with the money the factory can use

A factory needs cash for fabric before its buyer pays. One lender quotes 8% and another quotes 10%. The lower figure looks attractive, but it does not yet answer the borrowing question. A fee may reduce the first loan's proceeds. The second loan may require principal payments while the order is still in production.

A useful comparison follows the cash from the day it arrives to the day the last obligation ends. It shows how much the factory can spend, when it must repay, and which costs remain uncertain. The quoted interest rate is one input to that comparison, and its value depends on the balance and period to which the lender applies it.

This guide uses fictional loans and currency units, written as CU. The rates are teaching assumptions, not market quotations. Its calculations measure borrowing cost from specified cash flows. They do not claim to produce a legally defined annual percentage rate, or APR, for any country or product.

The British Business Bank's business-loan guide explains the basic obligation: borrowed funds must be repaid with interest over an agreed period. It also distinguishes secured borrowing from loans without business-asset security. A price comparison should sit beside those contractual obligations, because a low-cost offer can still expose an essential asset or require a guarantee.

Put both offers on the same funding basis

Begin with a dated use of funds. Suppose the fabric account needs CU 116,400 at the start of the borrowing period. That cash requirement can differ from the face amount written in a loan agreement, especially when the lender deducts charges before releasing funds.

If a lender deducts a fee before transfer, the factory must borrow more than CU 116,400 to receive that sum. If another lender releases only part of an approved facility, the undrawn limit cannot pay the fabric supplier. A promised facility and cleared usable cash belong in separate columns.

The comparison also needs a common currency, draw date and purpose; loans with different terms may be valid alternatives, provided their differences remain visible. A twelve-month loan that leaves all principal outstanding offers a different cash pattern from one repaid each month.

Ask for the payment schedule as well as the rate. The schedule should identify principal, interest, compulsory charges and any final balance, with the relevant contractual rule beside each amount that can change. A quote labelled “fixed” is incomplete if it does not say what is fixed and for how long.

The original quotation should remain attached to the analysis. A spreadsheet assumption must not silently become a contract term: a model may place a fee at drawdown, while the lender requires payment before approval. Those dates create different funding needs if the application takes several weeks.

A worked comparison with equal usable proceeds

The fictional factory receives both offers on the same date. Each lasts twelve equal monthly periods. There are no taxes, exchange-rate changes, late payments or other charges in this first comparison. Security and guarantee terms are assumed equal, so they do not explain the price difference.

Loan A charges 8% simple interest on its full face amount for the year. The factory pays all principal and interest at maturity, while a 3% arrangement fee is deducted from the initial advance.

Loan B charges a nominal annual rate of 10%, applied at 10% ÷ 12 each month to the opening principal balance. With no arrangement fee, the factory receives the full advance and reduces principal through twelve equal month-end repayments. Equal principal does not mean equal total instalments: the interest portion declines each month.

Contract item

Loan A

Loan B

Face amount

CU 120,000

CU 116,400

Fee deducted at drawdown

CU 3,600

CU 0

Usable cash received

CU 116,400

CU 116,400

Quoted interest basis

8% for one year

10% nominal annual, monthly reducing balance

Principal repayment

All at month 12

CU 9,700 each month

Other charges in this case

None

None

Loan A's advance reconciles as CU 120,000 − CU 3,600 = CU 116,400. Its interest is CU 120,000 × 8% = CU 9,600. The amount due at the end of month twelve is therefore CU 129,600.

Its total financing cost is CU 129,600 − CU 116,400 = CU 13,200. This equals the CU 9,600 interest plus the CU 3,600 fee. Do not subtract the fee from the initial receipt and then add it to the final repayment again. That would charge the factory twice in the model.

Loan B repays CU 116,400 ÷ 12 = CU 9,700 of principal each month. In month one, interest is CU 116,400 × 10% ÷ 12 = CU 970. The first payment is CU 10,670, after which principal falls to CU 106,700.

The same calculation repeats on each new opening balance; although the table shows selected rows, the missing months follow that rule without a payment holiday.

Month

Opening principal

Interest

Principal paid

Total payment

1

116,400.00

970.00

9,700.00

10,670.00

2

106,700.00

889.17

9,700.00

10,589.17

6

67,900.00

565.83

9,700.00

10,265.83

12

9,700.00

80.83

9,700.00

9,780.83

Amounts are CU, displayed to two decimals. The calculation retains full precision, with the final settlement adjusted for any actual currency rounding in a real contract. The sum of the twelve opening balances is CU 756,600. Interest is therefore CU 756,600 × 10% ÷ 12 = CU 6,305. Total repayments are CU 122,705.

Loan B costs fewer currency units in this example, but part of that difference arises because principal returns sooner. It does not provide CU 116,400 for the whole year. By the end of month six, half the original principal has been repaid. The rate comparison needs to recognise that timing.

Calculate an effective rate from the cash flows

For Loan A, there is one receipt now and one payment a year later. Its effective annual borrowing cost is:

Effective annual cost = final payment ÷ net proceeds − 1

= CU 129,600 ÷ CU 116,400 − 1 = 11.34%.

The 8% quotation applies to the face amount, whereas the 11.34% calculation measures the year's cost against the cash the factory actually receives. Both numbers can be correct while answering different questions.

For Loan B, dividing CU 6,305 by CU 116,400 gives about 5.42%. That ratio describes total interest relative to the first advance. It is not an effective annual interest rate, because the full advance is not outstanding for twelve months.

Instead, find the monthly rate that makes the present value of the twelve payments equal CU 116,400. With no fees and the stated reducing-balance calculation, that rate is 10% ÷ 12, or about 0.833333% per month.

Its annual equivalent is:

Effective annual cost = (1 + monthly rate)¹² − 1

= (1 + 0.10 ÷ 12)¹² − 1 = 10.47%.

Loan A is more expensive on this annual effective basis despite its lower headline rate. Loan B also requires substantial cash earlier. If the factory has no reliable source for those monthly payments, the cheaper rate does not solve the funding need. That is a reason to change the financing plan, rather than hide the shortfall inside a cost percentage.

This distinction also protects the investment decision. A borrowing offer should not make a weak equipment project appear attractive merely because its first instalment is small. The project's operating benefits need their own appraisal, such as the uncertainty framework in decision tree analysis for capacity investment.

A flat rate can describe a very different loan

Consider a separate version of Loan B. Although this version advances CU 116,400 and collects twelve equal monthly payments, “10%” now means a flat charge on the original principal for the whole year.

The charge is CU 116,400 × 10% = CU 11,640. Total payments are CU 128,040, or CU 10,670 per month. That happens to equal the first payment under the reducing-balance version, but it does not make the two schedules equivalent.

Solving the cash flows gives a monthly rate of about 1.497666%. Its effective annual equivalent is about 19.53%. The calculation reflects the fact that the lender receives principal back throughout the year while charging on the original amount.

This is why a comparison must state “flat” or “reducing balance” beside the rate. Because the factory returns principal through its instalments, a flat charge divided by the term cannot reproduce the cost of using the declining balance.

The 19.53% figure belongs only to this specified twelve-payment case and should not be reused for every loan quoting a 10% flat rate. A different term, fee, payment date or final balance changes the result.

Build the cash-flow calculation so it can be checked

Microsoft's IRR documentation describes a rate for cash flows at regular intervals. Enter the factory's net receipt as positive and payments as negative. The result uses the interval between rows, so monthly rows produce a monthly rate; reversing every cash-flow sign leaves the solution unchanged.

For Loan A, the model needs an initial CU 116,400, eleven monthly zeros, and a final negative CU 129,600. Removing the zero months would falsely turn a twelve-month loan into a one-period loan. Put numeric zeros in those rows: Microsoft notes that empty cells in an IRR reference are ignored.

For Loan B, use all twelve actual calculated payments after the opening receipt. A formula such as =IRR(B2:B14) returns the monthly rate when those thirteen cells contain the opening amount and twelve month-end flows. Convert it with =(1+monthly_rate)^12-1.

Real dates may not follow equal periods. A first payment can fall early, a fee can be due before drawdown, or a maturity date can move. Microsoft's XIRR function uses amounts paired with dates and a 365-day discounting basis. It returns an annual rate rather than a monthly rate that needs multiplication or further annual conversion.

Use =XIRR(amount_range,date_range) for that dated schedule. The first date must anchor the full sequence, including an earlier fee if there is one. Confirm that each amount still matches its date after sorting. A later advance or a refundable deposit can create extra changes of sign, so inspect the cash-flow pattern and check the computed result against the present-value equation.

A rate alone is not the audit trail. Retain the full schedule, its total receipts and payments, and the final principal reconciliation. The calculation should show zero principal remaining when the loan is fully settled. A positive residual can reveal a missing balloon payment even when a spreadsheet returns a plausible rate.

Check the interest day-count rule separately

Because the lender's interest calculation and the annual comparison may use different denominators, first reproduce the contractual cash payment from its stated rules. Then calculate the annual cost of that payment on a stated basis.

For example, suppose a separate loan advances CU 100,000 for exactly 90 elapsed days. There are no fees or interim payments. Its quoted simple annual interest rate is 9%, and all principal and interest are due together at the end.

If the hypothetical contract uses actual days divided by 365, the interest is CU 100,000 × 9% × 90 ÷ 365 = CU 2,219.18. If it instead uses actual days divided by 360, the interest is CU 2,250. The difference is CU 30.82 for the same principal, quote and elapsed days. Neither convention should be guessed from the word “annual”.

Using the first contract's unrounded cash payment, the 365-day effective annual rate is about 9.31%. It is calculated as (1 + 0.09 × 90 ÷ 365) raised to the power 365 ÷ 90, minus one. This is an annual equivalent of a specified 90-day cost, not a claim that the lender will renew the loan on identical terms.

For a real schedule, also confirm which dates count, how weekends affect settlement, and when rounding occurs. Reproducing one interest line from the lender's schedule is a useful check before extending the calculation across a whole facility.

Distinguish fees from money temporarily locked away

Suppose Loan A also requires CU 6,000 in a non-interest-bearing deposit at drawdown. In this separate hypothetical variation, the full deposit is released at maturity and the base loan's other terms remain unchanged.

The factory can now use CU 116,400 − CU 6,000 = CU 110,400 at the start. At maturity, it pays CU 129,600 and receives the CU 6,000 back. The net final outflow is CU 123,600. Its effective annual cash cost becomes CU 123,600 ÷ CU 110,400 − 1 = 11.96%.

The deposit is not a permanent CU 6,000 charge in this case, so treating it as a fee would omit its recovery and overstate cost. Ignoring it would overstate usable funding. Record both movements and the conditions for release. If release occurs later, or interest is earned, those dates and amounts belong in the revised schedule.

This financing comparison is also distinct from financial-statement measurement. The IFRS Foundation's IFRS 9 overview describes how directly attributable transaction costs affect initial measurement for instruments outside fair value through profit or loss. That accounting requirement does not mean every cash item in this decision model receives the same accounting treatment. The accountant must classify the actual fee, deposit and liability under the applicable framework.

A tax saving does not make interest disappear

Interest relief can reduce the cost of debt where tax law permits it and the business can use the deduction. ACCA's capital-structure discussion explains that principle alongside the extra financial risk created by debt. It does not justify borrowing without considering the remaining cost.

Take a separate, simple profit illustration. Operating profit before interest and tax is CU 80,000. The assumed tax rate is 25%. All interest is deductible immediately, there are sufficient taxable profits, and there are no other adjustments or fees.

Profit calculation

No interest

With CU 9,600 interest

Operating profit

80,000

80,000

Interest expense

0

9,600

Profit before tax

80,000

70,400

Tax at the assumed 25%

20,000

17,600

Profit after interest and tax

60,000

52,800

Tax falls by CU 2,400, but profit after interest and tax falls by CU 7,200. Those two amounts add to the CU 9,600 interest. The saving partly offsets the expense; it does not turn the expense into extra profit.

The table holds operating profit constant to isolate the financing effect; any extra operating earnings from the funded investment belong in a separate project forecast. Leaving interest out of the final profit line would overstate the benefit even if the investment itself were worthwhile.

The familiar expression “interest rate × (1 − tax rate)” depends on its assumptions. Fees, restricted deductions, losses and tax-payment delays can prevent it from describing the full cash cost.

Return to Loan A and assume that CU 2,400 of interest tax relief reduces a tax payment exactly at loan maturity, while its fee receives no relief. The combined final outflow is CU 129,600 − CU 2,400 = CU 127,200. Against CU 116,400 received, the after-tax cash cost is 9.28%. Simply multiplying the pre-tax 11.34% by 75% would give about 8.51%, incorrectly extending the assumed relief to the fee.

Actual eligibility is jurisdiction-specific. For example, HMRC's current UK Corporate Interest Restriction guidance describes limits on relief for net interest and other financing costs. It is a UK rule, not a global deduction promise. Establish the applicable rules, usable relief and payment dates before adding tax benefits to a factory's borrowing model.

Test the terms that can change the result

A floating-rate quote needs a reset rule. Identify the benchmark, margin, reset dates and any contractual floor. Then calculate a base path and a higher-rate path with the same principal schedule. Do not add a rate shock to repaid principal. Likewise, do not assume that a change in the benchmark reaches the next payment immediately if the contract resets later.

An early-settlement scenario requires a fresh settlement amount. Because principal, accrued interest, refunds and break charges can follow different rules, a factory expecting early buyer payment should obtain the lender's actual six-month settlement terms. Dividing a full-year cost in half is not a substitute.

Currency creates another boundary. A loan priced in one currency cannot be compared directly with another by reading their interest rates. Convert each forecast payment using explicit exchange-rate assumptions. If protection against exchange movements is being priced, include its actual cash costs and terms rather than assuming it is free.

Then test the operating cash available on each payment date. In Loan B, the first CU 10,670 instalment falls due while most principal remains outstanding, which puts immediate pressure on available operating cash. A buyer's promise to pay near month twelve cannot fund that first instalment unless another cash source bridges the gap. The maturity payment under Loan A deserves the same scrutiny.

Suppose the factory has no opening buffer and, after other required payments, only CU 9,500 is available for the first instalment. It is CU 1,170 short. A further CU 12,000 becomes available at the second payment date. Across the two dates, the CU 21,500 available exceeds the first two instalments by CU 240.83. That combined surplus does not cure the earlier missed payment. With CU 1,170 of extra opening cash, the first payment would leave zero and the second would leave CU 1,410.83. Any borrowing used to create that opening cash brings its own terms into the plan.

The assumptions should reflect evidence from past collections, rather than a single optimistic promise. The method in forecast accuracy with MAE, WAPE and signed bias can help a team review its forecasting errors. The resulting borrowing test still needs actual payment dates and available cash; an accuracy percentage cannot replace them.

Present a decision that management can trace

The final comparison should state usable proceeds, total scheduled charges, the annual effective cash cost and the largest payment. Beside those figures, describe the security, guarantees, early-settlement terms and conditions that might change cost or access to funds.

Keep a clear distinction between a signed term and an assumption awaiting confirmation. A missing fee is not a zero fee. An expected tax deduction is not cash available for this month's wages. A facility that requires further approval is not the same as a committed advance.

For the fictional offers, Loan B has the lower effective annual cost and lower total financing charge. Loan A delays principal repayment until maturity. Management must assess that timing difference against a dated funding plan. If neither offer supports the factory's cash needs, choosing the smaller percentage will not fix the mismatch.

The strongest borrowing comparison can be rebuilt from the contract and a cash schedule. Every receipt has a date, every payment has a basis, and every assumed benefit has a stated condition. That makes the choice explainable when the first payment falls due, rather than only when the loan is approved.

References