Example 1

This example illustrates the concept of discounting future cash flows to determine their present value, which is crucial for assessing loan affordability. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a red downward arrow at the start of the timeline, indicating the amount you’re solving for.
• Payments: Represented by blue upward arrows, these are the regular payments you can manage.
• Interest Rate: Although not shown in the diagram, this rate is used to discount the future payments to their present value. It can be based on a best guess or actual lender rate.

Benefits and Implications

Understanding how much you can borrow is vital for making informed financial decisions, especially when considering purchasing significant items. If the calculated loan amount falls short of what you need:

• You might need to contribute additional funds.
• Extend the loan term to lower monthly payments.
• Seek a lender with more favourable rates.

If the calculated amount exceeds your requirements:

• You could opt for lower monthly payments.
• Shorten the loan term to reduce overall interest paid.

This example helps you navigate these decisions by providing a clear financial picture based on your current capacity and market rates.

Example 2

This example illustrates how to determine the contribution required when the value of discounted future cash flows falls short of the full cost of an item. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the full cash price or loan value before your contribution is known.
• Payments:
  • The red up arrow at the start of the time line is the deposit contribution you’re solving for.
  • Those represented by blue upward arrows are the regular payments you can manage.
• Interest Rate: Although not shown in the diagram, this rate is used to discount the future payments to their present value. It can be based on a best guess or actual lender rate.

Benefits and Implications

Understanding how much you may be required to contribute towards the cost of an item is vital for making informed financial decisions, especially when considering purchasing significant items. If the calculated contribution amount exceeds the cash you have on hand:

• Extend the loan term to lower the contribution payment.
• Seek a lender with more favourable rates.

If the calculated amount is lower than what you may wish to contribute:

• You could opt for lower monthly payments.
• Shorten the loan term to reduce overall interest paid.

This example helps you navigate these decisions by providing a clear financial picture based on your current cash resources and market rates.

Example 3

This example illustrates the use of one of two Modes, a core concept in financial calculations, when solving for unknowns. To mix things up, the ‘In arrear’ payments are assigned a quarterly frequency. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the value is known.
• Payments: Represented by red upward arrows, these are the regular quarterly payments. Notice how the first payment in the series occurs at the end of the first quarter after the Advance, and the remaining payments regularly thereafter.

Benefits and Implications

Understanding the impact Modes can have in calculations is important for these reasons:

• Payments ‘In arrear’ increase the overall interest repaid as capital reduction is delayed (as opposed to ‘In Advance’ covered in example 4).
• As a borrower, knowing the mode used in finance quotes allows for accurate comparison; for instance, the implicit rate in a given repayment profile containing the same payment amount can vary significantly based on the repayment Mode, although the gap in the implicit rates tends to narrow as repayment terms lengthen.
• Cash Flow Management: ‘In arrear’ payments can align better with certain cash flow cycles, such as receiving income at the end of a period, which might be more suitable for managing personal or business finances.
• Impact on Total Interest: Understanding how ‘in arrears’ payments affect the total interest paid over the life of a loan can influence decisions on loan terms, especially for longer-term loans where the difference in interest can be substantial.
• Negotiation Power: Knowledge of payment modes can provide leverage when negotiating loan terms with lenders, potentially leading to better rates or terms if you can argue for a mode that suits your financial planning.
• Budgeting: For budgeting purposes, ‘in arrears’ payments allow for one more period of interest accumulation before the first payment, which might require adjustments in short-term financial planning.
• Loan Products: Some loan products, like certain mortgages or business loans, might only offer ‘in arrears’ payment structures, so understanding this mode is crucial for those considering these financial products.

This example helps you navigate these decisions by providing a clear financial picture based on different repayment structures and their implications on your financial health.

Example 4

This example illustrates the use of one of two Modes, a core concept in financial calculations, when solving for unknowns. The ‘In advance’ payments are assigned a monthly frequency to show contrast with the previous example. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the value is known.
• Payments: Represented by red upward arrows, these are the regular monthly payments. Notice how the first payment in the series occurs at the start of the first month coinciding with the Advance, and the remaining payments regularly thereafter.

Benefits and Implications

Understanding the implications of ‘In advance’ payment modes in financial calculations is crucial for these reasons:

• Payments ‘In advance’ reduce the overall interest repaid since capital reduction starts immediately (as opposed to ‘In arrears’ in Example 3).
• As a borrower or investor, recognising the mode helps in comparing financial products more accurately; for example, the effective interest rate can be lower with ‘in advance’ payments due to quicker principal reduction.
• Cash Flow Management: ‘In advance’ payments might require more initial cash on hand but can lead to lower total interest costs, beneficial for those with sufficient cash reserves.
• Savings on Interest: Over the life of the loan, ‘in advance’ can result in significant savings on interest, especially for long-term loans or high-interest scenarios.
• Budget Planning: This mode can affect monthly budgeting, as payments are due from the outset, which might be challenging for those with irregular income patterns.
• Negotiation: Understanding ‘in advance’ can give you an edge in loan term negotiations, possibly securing lower rates or better terms due to the lender’s reduced risk exposure.
• Loan Comparison: When comparing different loan offers, knowing if payments are ‘in advance’ or ‘in arrears’ can significantly alter the perceived cost of borrowing.
• Investment Products: For investments or annuities that pay ‘in advance’, the timing can affect the calculation of return rates, making it advantageous for investors looking for immediate income streams.

This example aids in understanding how payment timing affects financial outcomes, enabling better decision-making in personal or business finance scenarios.

Example 5

This example illustrates the use of ‘front loading’ a repayment profile on a proportional basis when solving for unknowns, and makes use of the Payment Weighting calculator feature. The 3+33 repayment structure is common in small business leasing arrangements, and variations on this exist, such as 3+35. This example is designed specifically for Finance Professionals, though it should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the value is known.
• Payments: Represented by red upward arrows, these are the regular payments. Notice though how the first payment in the series coincides with the Advance and is annotated with the x3 annotation. This is the weighted payment, followed by the remaining payments regularly spaced. The timeline continues for a further month after the final payment, suggesting the contract ends at the end of the final payment period. Note however the contract end date may vary between lenders and may also depend on the number of payments taken in advance.

Tip: It is permissible to assign whatever weighting ratio you need to the unknown values of two or more payment rows.

Benefits and Implications

The front loading of a repayment profile is typically used for these reasons:

• Risk Reduction: By securing multiple payments upfront, lenders reduce their risk exposure, especially in cases where there’s a higher likelihood of default early in the loan term.
• Cash Flow Management for Lenders: This structure provides immediate cash flow to the lender, which can be critical for managing liquidity, especially for smaller lending institutions or during economic downturns.
• Encouraging Loan Commitment: Front-loaded payments can incentivise borrowers to commit more seriously to the loan terms, knowing they’ve already made substantial payments at the outset.
• Adjusting for Seasonality: In industries with seasonal income, a 3+33 structure might align better with the financial cycle, allowing for lower payments during off-peak times while capitalising on peak cash flows initially.
• Tax Benefits: For the borrower, this structure might offer tax advantages if the payments are deductible, and making larger payments earlier in the fiscal year can maximise this benefit.
• Tailoring to Client Needs: Lenders can use this feature to customise loan terms to match the cash flow profile of different businesses, offering flexibility in how much is paid upfront versus over time.
• Pricing Strategy: The 3+33 profile might allow for different pricing strategies, where the interest rate or total cost of borrowing might be adjusted based on the reduced risk from front-loaded payments.
• Lease vs. Purchase Decisions: In leasing scenarios, this structure can make the lease more attractive by reducing the upfront cost while still providing the lender with security through immediate payments.

This example helps finance professionals understand how to leverage payment weighting to structure loans that balance risk, cash flow, and client satisfaction in various financial contexts.

Example 6

This example illustrates how to determine the payment value in a repayment schedule which incorporates a balloon or future value at the end of a repayment term. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the value is known.
• Payments: Represented by red upward arrows, these are the regular unknown payments. Coinciding with the final payment is a larger blue up arrow representing the known balloon payment.

Benefits and Implications

Balloon payments are commonly utilised in various financial arrangements, particularly in:

• Asset Financing:

  • Vehicles and Equipment: Often used in car loans or equipment financing where the lender anticipates a significant residual value at the end of the term. This can be structured as an operating lease where the lender guarantees the value of the asset at lease end.
  • Benefits for Borrowers: Allows for lower monthly payments, making high-cost purchases more manageable within cash flow constraints. It might also align with expectations of selling or refinancing the asset at the end of the term.
  • Risks for Borrowers: Requires planning for a large lump sum payment or refinancing at the end, which could be challenging if financial conditions change.

• Business Loans:

  • Small Business: Balloon payments can be part of business loans where the business expects significant revenue or an event like selling the business at the end of the loan term.
  • Strategic Financial Planning: Businesses might use balloon payments to match their cash flow cycles, expecting to pay off the loan with proceeds from future business success.

• Lenders’ Perspective:

  • Risk Management: By structuring a loan with a balloon payment, lenders can manage risk by ensuring a significant portion of the loan is repaid at the end, potentially secured by the asset’s residual value.
  • Lease Rentals: In leases, balloon payments help in calculating rentals that account for the asset’s expected future value, providing a balance between regular payments and end-term value.

• Investment and Savings:

  • Structured Savings Plans: Certain savings or investment plans might use balloon payments to encourage long-term saving or investment, with the balloon representing a maturity or payout amount.

• Market Conditions:

  • Economic Cycles: In fluctuating markets, balloon structures can be adjusted to match economic forecasts, providing flexibility in repayment during uncertain times.

Understanding the dynamics of balloon payments is essential for both borrowers and lenders to manage cash flows, plan for future financial obligations, and structure agreements that align with anticipated asset values or business performance. This example provides a foundation for users to understand and navigate these financial structures effectively.

Example 7

This example illustrates how to determine the payment value in a repayment schedule with a separate compounding frequency, in this case monthly repayments with quarterly interest. This example demonstrates the Interest Capitalisation Frequency feature of the calculator and is designed specifically for use by Finance Professionals, though it should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the value is known.
• Payments:
  • The regular unknown payments are represented by red upward arrows.
  • The quarterly interest capitalisation payments cannot be displayed as they have a zero value. However, there is one cash flow diagram notation used in this guide which has not been discussed yet, and that is the payment up arrows also extend for a short distance below the timeline. We use this to signify the payment includes capitalised interest. Note therefore in this example that the line only extends every third payment, when the repayment and interest schedules align.

Benefits and Implications

These types of repayment schedules are often found in consumer products offered by high street banks, with the following benefits and considerations:

• Alignment with Accounting Practices:

  • Simplified Accounting: By aligning interest compounding with accounting cycles (like quarterly reports), it can simplify the tracking and reporting of interest income for banks.
  • Financial Reporting: Easier to match interest income with the periods in which it is earned, which is crucial for accurate financial statements.

• Interest Rate Management:

  • Rate Adjustment: Allows for more frequent adjustments in interest rates based on market conditions if compounded more often than payments are made, potentially benefiting lenders during rising rate environments.

• Consumer Loan Products:

  • Product Flexibility: Can be marketed as offering lower monthly payments while still providing the bank with higher effective interest rates due to compounding.
  • Borrower Perception: Monthly payments might seem more manageable to borrowers, potentially increasing loan uptake despite higher effective interest.

• Risk Management:

  • Interest Capitalisation: Compounding interest increases the amount of interest capitalised, thus increasing the total amount owed more rapidly, which can act as a buffer for lenders against loan defaults.
  • Prepayment Penalties: Structures like this can lead to higher penalties for early loan repayment, protecting lenders’ expected interest income.

• Regulatory Compliance:

  • Disclosure: This setup can affect how interest rates and total loan costs are disclosed to consumers, requiring clear communication to ensure compliance with financial regulations.

• Liquidity Management:

  • Cash Flow Alignment: Might help banks manage liquidity by having a predictable schedule of interest income that doesn’t necessarily align with the outgoings for payments.

• Product Differentiation:

  • Market Positioning: Can be used to differentiate loan products in a competitive market, offering unique repayment structures that cater to specific consumer segments.

Understanding these aspects can help finance professionals tailor loan products that not only meet consumer needs but also align with the strategic financial goals of lending institutions.

Example 8

This example illustrates solving unknown payments on a proportional basis to accelerate capital repayment using a stepped profile. It makes use of the Payment Weighting calculator feature and is designed specifically for Finance Professionals, though it should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the value is known.
• Payments: The regular unknown payments are represented by red upward arrows. As the example uses three 12 monthly payment series with assigned weightings of 1.00, 0.60, and 0.30 respectively, we’ve adjusted the height of the upward arrows to reflect the reduction in payment values over time, and have also used a light grey background to emphasise the stepped profile.

Benefits and Implications

These types of repayment schedules are often found in business lending, with the following benefits and considerations:

• Accelerated Principal Reduction:

  • Risk Mitigation for Lenders: By front-loading payments, the principal is reduced more quickly, thereby lowering the lender’s exposure to credit risk over time.
  • Interest Savings for Borrowers: Paying down the principal faster reduces the total interest paid over the life of the loan, benefiting the borrower financially.

• Alignment with Business Cycles:

  • Cash Flow Management: This structure can be tailored to match expected business income, where higher payments are feasible during peak revenue periods, and lower payments during slower times.
  • Depreciation Matching: For assets that depreciate more rapidly in the early years, this payment structure can align repayments with the asset’s useful life, improving financial reporting and tax planning.

• Incentivising Borrower Performance:

  • Performance-Based Repayments: Can be structured to reward early success or growth in business by allowing for lower payments if certain performance metrics are met.

• Flexibility in Loan Structuring:

  • Customisation: Lenders can customise loan terms to better fit the financial trajectory of the borrowing business, potentially attracting clients with bespoke financial solutions.
  • Negotiation Leverage: Offers a negotiation point where both parties can discuss how the payment schedule reflects actual or projected cash flows.

• Regulatory and Compliance:

  • Transparency: Must be clearly communicated to avoid misunderstandings about payment obligations, which is crucial for maintaining trust and compliance with lending regulations.

• Market Differentiation:

  • Competitive Edge: Lenders offering stepped payment profiles can differentiate themselves in the market, appealing to businesses looking for repayment plans that adapt to their growth patterns.

• Loan Portfolio Management:

  • Diversification: Allows lenders to diversify their loan portfolio with varied repayment structures, potentially spreading risk across different types of loan products.

• Encouraging Financial Discipline:

  • Discipline in Borrowing: Encourages businesses to manage their finances more stringently in the early stages of the loan, fostering a culture of financial discipline.

This stepped payment approach provides a strategic tool for both lenders and borrowers to manage financial obligations in a manner that supports business growth while minimising risk exposure for the lender. It’s a nuanced approach that requires careful consideration but can offer significant benefits when structured correctly.

Example 9

This example illustrates how to incorporate frequent token or contact payments into a repayment structure that has larger, less frequent repayments. It is designed specifically for Finance Professionals, though it should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: This is shown by a blue downward arrow at the start of the timeline, indicating the value is known.
• Payments: The frequent monthly contact payments are represented by blue upward arrows, and the larger, less frequent annual payments are represented by red upward arrows. Note that each annual payment coincides with the 12th consecutive contact payment, so in practice, these are lumped together as a single payment.

Benefits and Implications

This payment structure is particularly beneficial in scenarios where cash flows are seasonal or irregular:

• Seasonal Income Alignment:

  • Agricultural and Seasonal Businesses: Matches repayment with harvest or sales seasons, ensuring payments are made when income is highest.
  • Cash Flow Management: Small token payments keep the loan from defaulting or accruing excessive interest during low-income periods, while larger payments clear substantial portions of the principal when funds are available.

• Interest Management:

  • Reducing Compounding Interest: Token payments serve to partially pay down interest, reducing the amount of interest that compounds over time, thus saving on total interest costs.

• Risk Mitigation for Lenders:

  • Consistency: Regular small payments provide a steady, albeit minor, cash flow, reducing some risk of default by keeping the loan active.
  • Security: Larger periodic payments act as checkpoints to ensure the loan remains on track, providing security against the risk of non-payment over longer intervals.

• Borrower Flexibility:

  • Budgeting: Helps in budgeting for both borrowers and lenders, as small payments are predictable and manageable, with the larger payments planned around anticipated income spikes.

• Encouraging Loan Commitment:

  • Engagement: Frequent small payments can psychologically commit the borrower more to the loan, reducing the likelihood of default.

• Tax and Financial Planning:

  • Deductions: For borrowers, regular payments might offer more consistent tax deductions, while the larger payments can be planned around fiscal year ends for tax advantages.

• Customisation for Borrower Needs:

  • Tailored Solutions: Lenders can offer this structure to cater specifically to industries or clients with known seasonal cash flow patterns, enhancing customer satisfaction and loyalty.

• Market Expansion:

  • Market Fit: This structure can open up lending to sectors traditionally seen as high risk due to their income cycles, by adapting the repayment schedule to their financial rhythm.

• Regulatory and Compliance:

  • Transparency: Ensures clarity in loan agreements, detailing when and how much will be paid, aiding in compliance with consumer protection laws.

Implementing such a repayment structure requires careful planning but can lead to a win-win situation where both lenders manage risk effectively, and borrowers manage their cash flows in alignment with their business cycles.

Example 10

This example covers the topic of 0% and low-interest finance schemes from the perspective of a 0% finance lender. Examples 11 and 12 cover the same topic with slight variations from the perspective of a cash buyer seeking a discount, and a borrower wanting to use a 3rd party lender.

0% finance profiles can be characterised as containing disclosed and non-disclosed cash flows.

• The disclosed cash flows, which a borrower is aware of, are the full retail cost (advance) of the financed item and the payment cash flows which contain principal only; the sum of payment cash flows equals the item cost (advance), hence 0% interest.
• The non-disclosed cash flows are the direct transactions between supplier and lender, usually a cash discount to offset the financing costs of the lender.

This example, and the next two, should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: The full retail cost of the financed goods is shown as a blue downward arrow at the start of the timeline.
• Payments: The known borrower payments are represented by blue upward arrows. The supplier discount required to offset the financing costs is shown by a red upward arrow above the borrower’s upfront deposit at the start of the timeline.
• Interest Rate: Although not shown in the diagram, the rate should reflect the return required by the lender.

Benefits and Implications

• Mutual Benefits for Lender and Supplier:

  • New Lending Opportunities: For lenders, 0% finance deals are a way to expand their loan portfolio without directly charging interest to the borrower, instead getting compensated by the supplier.
  • Improved Stock Turnover: Suppliers benefit from quicker sales cycles as financing makes their products more attractive, reducing inventory holding costs.

• Marketing Strategy:

  • Competitive Edge: Offering 0% finance can be a significant marketing tool for both parties, attracting customers who might not purchase otherwise due to cost concerns.

• Cost Management:

  • Discount as Compensation: The supplier discount is essentially the cost of capital for the lender, which must be calculated to ensure the deal remains profitable for both parties.

• Customer Acquisition:

  • Lower Barrier to Purchase: By removing interest costs, these deals lower the entry barrier for customers, potentially increasing sales volume.

• Risk Management:

  • Credit Risk: Lenders might take on more risk since they’re not charging interest directly to the consumer, but they mitigate this through the discount from the supplier.
  • Supplier Risk: The supplier must ensure the discount doesn’t erode too much profit, balancing between sales volume and profit margin.

• Market Dynamics:

  • Pricing Strategy: This model can influence market pricing, where suppliers might adjust their list prices knowing discounts will be given to offset financing.

• Regulatory Considerations:

  • Disclosure: Both lenders and suppliers must navigate regulations regarding how such deals are advertised and disclosed to consumers to avoid misleading marketing.

• Financial Planning:

  • Cash Flow: Suppliers need to plan for the immediate cash outflow due to discounts, while lenders must manage the timing of their cash inflows from repayments.

• Consumer Perception:

  • Value Perception: The perception of getting “free” financing can lead to increased customer satisfaction and loyalty, even if the product’s list price might be adjusted to account for this.

This arrangement highlights a strategic partnership between suppliers and lenders, where careful calculation and transparency in undisclosed cash flows are crucial for maintaining a beneficial relationship while providing value to the end consumer.

Example 11

This example covers the topic of 0% and low-interest finance schemes from the perspective of a buyer wishing to secure the financial benefits associated with 0% finance when paying cash. Examples 10 and 12 cover the same topic with slight variations from the perspective of a 0% finance lender, and a borrower wanting to use a 3rd party lender.

This example, like the previous and the next, should be informative for all users.

As a cash buyer, it is important to understand how 0% finance works as it is from the analysis of the financial cash flows that the value of a potential cash discount can be derived and used as a starting point in supplier negotiations. The results and schedules produced by the calculator beyond that single discount figure are of little relevance, so can be safely ignored. With that covered, let’s move on!

0% finance profiles can be characterised as containing disclosed and non-disclosed cash flows.

• The disclosed cash flows, which a borrower is aware of, are the full retail cost (advance) of the financed item and the payment cash flows which contain principal only; the sum of payment cash flows equals the item cost (advance), hence 0% interest.
• The non-disclosed cash flows are the direct transactions between supplier and lender, usually a cash discount to offset the financing costs of the lender.

There is no need to be concerned about the non-disclosed cash flows; the calculation will use your best guess interest rate as a proxy to calculate this. How you obtain the disclosed cash flow information is simple. It is usually advertised by a supplier, and if it is not, request a finance quote… before you start talking discounts!

The diagram below visualises the cash flow dynamics for a hypothetical finance quote:

Example Calculation Inputs

• Advance: The full retail cost of the goods (before discount) is shown as a blue downward arrow at the start of the timeline.
• Payments: The quoted payments are represented by blue upward arrows. The supplier discount, derived by discounting these future payments, is shown by a red upward arrow at the start of the timeline.
• Interest Rate: Although not shown in the diagram, the rate should reflect the market rate for a similar transaction. Sometimes this can only be based on guesswork, so perform a range of calculations to obtain a sense of what may be a good figure to aim for.

Benefits and Implications

For the Cash Buyer:

• Negotiation Power: Understanding this calculation empowers cash buyers to negotiate discounts that effectively replicate the benefits of 0% financing.
• Immediate Savings: The buyer gets the financial benefit upfront rather than over time, potentially improving cash flow management.
• Avoidance of Financing Risks: By paying cash, buyers avoid any potential risks associated with financing, like changes in credit status or interest rates.
• Simplified Purchase: No need to deal with loan documents, credit checks, or repayment schedules, simplifying the buying process.

For the Supplier:

• Cash Flow Improvement: Immediate cash payment can improve the supplier’s cash flow, allowing for better inventory management or investment opportunities.
• Supplier Not Losing Out: The discount given to the cash buyer is equivalent to what would have been given to the lender, maintaining the same profit margin.
• Increased Sales Volume: Offering cash discounts can lead to more sales, especially if it matches or beats the appeal of 0% financing deals.
• Customer Loyalty: Providing competitive discounts can foster customer loyalty, encouraging repeat business.
• Reduced Administrative Costs: Less paperwork and administration associated with financing arrangements, potentially reducing operational costs.
• Follow-on Opportunities: With the sale secured, suppliers can look forward to subsequent sales from maintenance, servicing, or related products, which are often more lucrative.
• Market Positioning: Can position the supplier as flexible and customer-focused, appealing to buyers who prefer cash transactions or are wary of financing.

This approach demonstrates how understanding finance structures can lead to mutual benefits, where the cash buyer secures immediate financial benefits, and the supplier maintains profitability while potentially increasing customer satisfaction and future business opportunities.

Example 12

This example covers the topic of 0% and low-interest finance schemes from the perspective of a borrower wishing to secure the financial benefits associated with 0% finance when using own lender finance. Examples 10 and 11 cover the same topic with slight variations from the perspective of a 0% finance lender, and a cash buyer.

This example, like the previous two, should be informative for all users.

As with cash buyers, it is important for a borrower wanting to use their own lender facilities to understand how 0% finance works as it is from the analysis of the financial cash flows that the value of a potential cash discount can be derived and used as a starting point in supplier negotiations. Similarly, the results and schedules produced by the calculator beyond that single discount figure are of little relevance, so can be safely ignored. With that covered, let’s move on!

0% finance profiles can be characterised as containing disclosed and non-disclosed cash flows.

• The disclosed cash flows, which a borrower is aware of, are the full retail cost (advance) of the financed item and the payment cash flows which contain principal only; the sum of payment cash flows equals the item cost (advance), hence 0% interest.
• The non-disclosed cash flows are the direct transactions between supplier and lender, usually a cash discount to offset the financing costs of the lender.

There is no need to be concerned about the non-disclosed cash flows; the calculation will use your own lender interest rate as a proxy to calculate this. In this way, you can be assured the discount will leave you financially neutral. What this means is the total cost of finance using your own lender will be equal to or better than the total repayable under a 0% finance arrangement, provided the repayment profile remains unchanged. How you obtain the disclosed cash flow information is simple. It is usually advertised by a supplier, and if it is not, request a finance quote… before you start talking discounts!

The diagram below visualises the cash flow dynamics for a hypothetical finance quote:

Example Calculation Inputs

• Advance: The full retail cost of the goods (before discount) is shown as a blue downward arrow at the start of the timeline.
• Payments: The quoted payments are represented by blue upward arrows. The supplier discount, derived by discounting these future payments, is shown by a red upward arrow above the quoted upfront deposit at the start of the timeline.
• Interest Rate: Although not shown in the diagram, the rate should reflect what your own lender has quoted.

Benefits and Implications

For the Own Lender Borrower:

• Flexibility in Repayment Terms: Ability to negotiate different repayment terms with your own lender, which might offer better personal or business alignment than standard 0% finance terms (though this might alter the financial comparison).
• Utilisation of Existing Credit: Make use of already approved credit lines, potentially avoiding additional credit checks or delays in securing finance.
• Relationship Maintenance: Strengthen or maintain a good relationship with your existing lender, which can be beneficial for future financing needs.
• Control Over Financing: Greater control over the financing process, including potentially lower interest rates or more favourable conditions than those offered in 0% schemes.
• Customisation: Tailor the financing to match specific cash flow needs, potentially reducing overall interest costs if the loan term is adjusted accordingly.

For the Supplier:

• Cash Flow Improvement: Receiving a cash discount from the supplier to the borrower’s lender can still improve the supplier’s cash flow similar to a cash deal.
• Maintaining Profit Margins: The discount effectively goes to the borrower’s lender instead of a third-party finance provider, maintaining the supplier’s profit margin.
• Increased Sales Volume: Offering competitive discounts can still lead to higher sales as it matches or beats the appeal of 0% financing, even if the buyer uses their own financing.
• Customer Loyalty: Providing flexibility in finance options can foster customer loyalty, encouraging repeat business, even if the immediate transaction doesn’t directly benefit from the 0% finance deal.
• Market Positioning: Can position the supplier as adaptable and customer-centric, appealing to buyers who value flexibility in their financing options.
• Simplified Sales Process: Potentially fewer complications in sales agreements since the financing terms are handled externally by the buyer’s lender, reducing administrative overhead.

This setup allows borrowers to leverage their existing financial relationships while still securing discounts comparable to 0% finance schemes, providing a strategic advantage in purchasing decisions.

Example 13

This example illustrates how a lender can leverage a strong supplier relationship and make arrangements to defer settlement on equipment supplied to the borrower at the conclusion of a financing arrangement. In very many cases, the borrower is unaware of this arrangement, yet still enjoys the benefits of deferral in the form of a lower interest rate and reduced repayments.

Furthermore, this example demonstrates usage of the Deferred Settlements calculator feature to determine borrower repayments, using a lender’s desired return and taking into account the deferred settlement. In Examples 14 and 15, we show you how to calculate the Nominal Annual Rate (NAR) of interest implicit within the repayment profile from the Borrower and Lender perspective respectively. This feature is designed specifically for use by Finance Professionals, though the example should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: The cost of the goods (advance) is shown as a blue downward arrow. In this example, the Advance arrow has been shifted from the start of the timeline, which is the Borrower’s perspective of the repayment profile, to the point in time the amount becomes due. This shift is illustrated by the light green arrow and reflects the financing arrangement from the Lender’s Perspective.
• Payments: The unknown payments are represented by red upward arrows.

In the calculator input screen, at the foot of the Advances section, is a dropdown to select the perspective to use in solving the unknown payment value. As the lender is passing on the benefits of the deferral to the borrower, ensure the Lender’s Perspective option is selected so the calculation is performed with reference to the Settlement Date.

Benefits and Implications

For the Borrower:

• Reduced Rates/Repayments: The deferral can result in lower interest rates or smaller payment amounts, making the financing more affordable or attractive.
• Enhanced Affordability: Lower payments can make high-cost items more accessible or allow for better cash flow management.
• Unaware Advantage: Borrowers benefit from the arrangement without needing to understand the underlying commercial relationships, potentially increasing their satisfaction with the financing terms.

For the Lender:

• Maintains Yield: By deferring the settlement, the lender can maintain or even increase their yield without altering the interest rate visible to the borrower, as the cost savings from deferral are passed on.
• Competitive Edge: This can be a strategic tool in competitive markets, allowing lenders to offer better terms without compromising their profitability.
• Relationship Building: Strengthens ties with suppliers, which can lead to exclusive deals or better terms in future transactions.

For the Supplier:

• Improved Stock Turnover: Deferring payment terms can help move inventory more quickly, especially for high-value or slow-moving items, reducing holding costs.
• Sales Security: Securing sales under deferred terms is often preferable to keeping items in stock, potentially avoiding depreciation or obsolescence.
• Market Positioning: Can position suppliers as flexible partners willing to negotiate terms to close deals, appealing to lenders and borrowers alike.
• Cash Flow Management: While the payment is deferred, the sale is secured, allowing for better cash flow forecasting and management.

This deferred settlement scheme exemplifies how strategic partnerships can lead to mutual benefits, allowing for more cost-effective financing solutions while maintaining profitability and liquidity across the chain from supplier to lender to borrower.

Example 14

This example demonstrates usage of the Deferred Settlements calculator feature to illustrate how a lender can calculate the Nominal Annual Rate (NAR) of interest implicit in a repayment profile containing payments that already take into account the deferral of a supplier settlement. In Example 14, we illustrated how a Lender calculates this unknown payment value under a deferred settlement arrangement. In Example 15, we’ll show how a lender can confirm the Nominal Annual Rate (NAR) of interest implicit in a repayment profile aligns with the original yield used to calculate the unknown payment value.

The Deferred Settlement feature is designed specifically for use by Finance Professionals, though the example should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: The cost of the goods (advance) is shown as a blue downward arrow. As this cash flow diagram shows the financial arrangement from the Borrower’s Perspective, the arrow is positioned at the beginning of the timeline.
• Payments: The known payments are represented by blue upward arrows. In the calculator, enter the result obtained in Example 13 into the payment fields.
• Interest Rate: As this is what we are solving, clear the calculator input field.

In the calculator input screen, at the foot of the Advances section, is a dropdown to select the perspective to use in solving the unknown interest rate. As we are determining the NAR from the Borrower’s Perspective, ensure that option is selected so the calculation is performed with reference to the Documented Date.

Benefits and Implications

• Transparency: This calculation provides borrowers with a clear understanding of their effective interest rate, fostering transparency in financial dealings.
• Comparison: Helps in comparing different financing options by understanding the true cost of borrowing under deferred settlement terms.

Example 15

This example illustrates the use of the Deferred Settlements calculator feature to verify that the Nominal Annual Rate (NAR) of interest implicit in a repayment profile, which accounts for the deferral of a supplier’s settlement, aligns with the original yield used to calculate the unknown payment value in Example 13. While Example 14 calculated the NAR from the borrower’s perspective, here we focus on the lender’s view to ensure financial consistency.

The Deferred Settlement feature is designed specifically for use by Finance Professionals, though the example should be informative for all users. The diagram below visualises the cash flow dynamics:

Example Calculation Inputs

• Advance: The cost of the goods (advance) is shown as a blue downward arrow, located on the timeline when the supplier settlement occurs.
• Payments: The known payments are represented by blue upward arrows. In the calculator, enter the result obtained in Example 13 into the payment fields.
• Interest Rate: As this is what we are solving, clear the calculator input field.

In the calculator input screen, at the foot of the Advances section, is a dropdown to select the perspective to use in solving the unknown interest rate. As we are determining the NAR from the Lender’s Perspective, ensure that option is selected so the calculation is performed with reference to the Settlement Date.

Benefits and Implications

• Verification of Yield: Ensures the lender’s expected return or yield is accurately reflected in the payment schedule, even after accounting for deferred settlements.
• Financial Oversight: Provides a mechanism for lenders to double-check their financial models, ensuring all calculations align with their financial strategy.

Example 16

Understanding the Nominal Annual Rate (NAR) is crucial for anyone dealing with finance, as it reveals the true cost of borrowing or the effective return on lending. This example serves as a foundational guide for calculating NAR in a repayment profile, equipping users with the knowledge to assess the economics of any loan or investment, from the simplest to the most complex structures.

The diagram below visualises the cash flow dynamics of a standard repayment profile in Arrears:

Example Calculation Inputs

• Advance: Depicted by a blue downward arrow at the start of the timeline, this represents the full cash price or loan value, known from the outset.
• Payments: The blue upward arrows signify regular payments made in arrears, which means at the end of each payment period.
• Interest Rate: Since we’re solving for this, ensure the calculator’s interest rate field is empty.

Benefits and Implications

• Transparency in Finance: Calculating NAR gives you a clear picture of the actual cost of borrowing or the yield on lending, promoting transparency in financial dealings.
• Comparative Analysis: Use this skill to compare different financial products. Even small differences in NAR can lead to significant savings or costs over time.
• Educational Value: This exercise is excellent for financial education, helping users understand how interest rates work across different conventions, which is vital when dealing with international finance where standards might differ.
• Negotiation Tool: Armed with this knowledge, you’re better positioned to negotiate loan terms or investment opportunities, ensuring you’re not overpaying or undervaluing your financial engagements.
• Spotting Discrepancies: By calculating NAR, you can quickly spot if an advertised rate doesn’t align with the repayment terms, which is crucial for consumer protection and informed decision-making.

This example not only sharpens your analytical skills but also empowers you to navigate the financial landscape with greater confidence and accuracy.

Example 17

This example illustrates the use of Effective Annual Rate (EAR) day count conventions and is included for the benefit of users outside the European Union who need a substitute method for calculating an Annual Percentage Rate (APR). The EAR conventions often mirror legally defined APR methods, providing a good proxy. Understanding the Effective Annual Rate (EAR) is crucial for anyone dealing with finance, as it reveals the true annualised cost of borrowing.

This example serves as a foundational guide for calculating EAR in a repayment profile, equipping users with the knowledge to assess the economics of any loan or investment, from the simplest to the most complex structures.

The diagram below visualises the cash flow dynamics of a standard repayment profile in Arrears:

Example Calculation Inputs

• Advance: Depicted by a blue downward arrow at the start of the timeline, this represents the full cash price or loan value, known from the outset.
• Payments: The blue upward arrows signify regular payments made in arrears, meaning at the end of each payment period.
• Interest Rate: Since we’re solving for this, ensure the calculator’s interest rate field is empty.

Benefits and Implications

• Global Financial Literacy: Understanding EAR provides a universal language for discussing the cost of borrowing, especially useful in regions where APR isn’t standardised.
• Accurate Comparison: Use EAR to accurately compare financial products from different countries or financial systems, ensuring you’re comparing apples to apples.
• Consumer Advocacy: By calculating EAR, consumers can advocate for themselves, ensuring they’re not misled by nominal rates that don’t reflect the true cost of borrowing.
• Financial Planning: Knowing the EAR helps in long-term financial planning, giving a clearer picture of how much borrowing will cost over a year, influencing decisions on loan terms or investment strategies.
• Educational Tool: This example serves as an educational tool to understand how compounding affects the effective cost of loans, particularly when dealing with different compounding frequencies or additional fees.

This exercise not only enhances your ability to work with financial calculations but also deepens your understanding of how various elements of a loan or investment can impact your financial decisions.

Example 18

This example is invaluable for anyone dealing with consumer finance within the European Union, as it illustrates how to calculate the Annual Percentage Rate (APR) implicit in repayment profiles, including any charges. Understanding the APR is essential as it encapsulates the total cost of borrowing, providing a standardised metric for comparing different loans.

The diagram below visualises the cash flow dynamics of a standard repayment profile in Arrears, including a single charge:

Example Calculation Inputs

• Advance: Depicted by a blue downward arrow at the start of the timeline, this represents the full cash price or loan value, known from the outset.
• Payments: The blue upward arrows signify regular payments made in arrears, meaning at the end of each payment period. The large blue upward arrow coinciding with the final payment represents a balloon payment, often used to align with the residual value of an asset or to defer a significant portion of the repayment.
• Charges: There is one charge due at the outset of the contract, represented by a green up arrow, which could include fees like an origination fee or setup costs.
• Interest Rate: Since we’re solving for this, ensure the calculator’s interest rate field is empty.

Benefits and Implications

• Consumer Protection: By calculating the APR, consumers can make informed decisions, ensuring they understand the full cost of loans, including all associated charges.
• Regulatory Compliance: This example adheres to EU standards, helping financial institutions comply with consumer credit directives, ensuring transparency in lending practices.
• Loan Comparison: APR is a universal measure for comparing different loan offers, especially when they include various fees or charges, making it easier to choose the most cost-effective option.
• Financial Literacy: Educates users on how charges affect the overall cost of borrowing, promoting better financial decision-making.
• Negotiation: Knowing how to calculate APR gives borrowers leverage in negotiations, particularly when discussing how fees and charges should be structured or reduced.
• Business Decisions: For businesses offering credit, understanding how to calculate APR ensures they can price their loan products competitively while still covering costs and maintaining profitability.

This example not only teaches you to compute APR but also highlights its importance in the broader context of consumer finance within the EU, empowering both lenders and borrowers to navigate the financial landscape more effectively.