Corporate Debt Lab · LFS
Liquidity & Funding Simulator
LFS is a planning tool for individuals and companies that need to fund a large payment. It compares four ways to obtain the money: use available cash, sell investments, borrow against an investment portfolio, or combine these sources.
You enter the payment, available cash, the reserve you want to keep, investments, loan terms and any expected future receipt. LFS calculates the funding available, interest and fees, month-end cash balances, investments retained and debt left to repay over your chosen period.
You can compare the plans side by side and test a delayed receipt, falling collateral values and tighter lending terms. The results flag plans that cannot fund the payment, a cash reserve that is breached and collateral-related repayments. UK and US examples provide starting points; optional tax effects use assumptions you enter.
The practical question is: “How can I fund this payment while keeping enough cash if my plans change?”
LFS uses your assumptions, not bank offers or forecasts. It models one person or company in one currency, at monthly intervals. Tax profiles are not country tax calculators, and lender demands can occur sooner than the model’s monthly steps.
Assumptions and what to test
YOUR COMPARISON
Funding comparison
Start with the comparison below. Each plan funds the same payment, but uses different resources. Compare the cost, cash reserve and remaining assets together.
Four funding plans at a glanceCompare two funding plans
Read the status alongside the figures. A lower cost alone does not make a plan preferable.
Analysis — what this scenario tells you
What this scenario tells you
A lower interest-and-tax figure is not automatically the better outcome. Repaying principal reduces debt; it is not a financing cost. Tax deferred on investments is not tax permanently saved. These results explain the chosen assumptions, not a personalised recommendation.
START WITH THE END RESULT
What is left after selling the investments and settling the debt?
How we get to the final cash — no double counting
At what investment return do selling and borrowing break even?
Uses the selected scenario, horizon, tax and loan terms. Constant capital growth is compounded monthly; a combined-stress shock is applied on top. Dividends, distributions, cash interest and disposal fees are excluded. The threshold is a scenario calculation, not a forecast or guaranteed return. A cash or collateral shortfall on the way is not cured by a good final result.
Threshold calculation and limits
Compares final cash after selling all remaining investments, applying the entered effective tax rate to positive gains and settling all remaining debt and initial sale tax. Includes fees, interest and only tax benefits received by the horizon. Searches annual capital growth from −90% to +100% in one-percentage-point intervals, then refines detected sign changes. Displays detected crossings; narrow or tangential crossings can be missed. Constraints are rerun for every tested return. No root in this range does not prove that no break-even exists elsewhere.
Tax sensitivity is available when tax assumptions are included. Open the Tax tab, enter your assumptions and compare again.
Does the sell-or-borrow comparison depend on tax?
Vary the effective gain-tax rate while keeping the selected scenario, tax basis and timing unchanged. This checks selling against borrowing; it does not rank all four funding plans.
See tested rates, costs and constraints
The initial range is the entered rate ±10 percentage points, limited to 0–99%. It is a test range, not a confidence interval or country tax range. Eleven evenly spaced rates are sampled, plus your entered rate if within range. Unchecked rates may differ. Tax deferred is not tax permanently saved; future prices and law are not predicted.
Compare every measure — with explanations
Read across a row to compare the same measure. “Not funded” means the plan cannot make the initial payment with the specified resources; its projected outcome is excluded.
When does the cash buffer become tight?
The solid line is spendable cash at each month-end. The dashed line is the reserve you want to retain; crossing it is a reserve breach, not necessarily a cash shortfall. Cash below zero means additional funds are required. Tax set aside is excluded. Intra-month timing is not modelled.
Trace the calculation month by month
“Principal repaid” reduces the loan balance; “Interest” is a cost. “Tax held” is money set aside and unavailable to spend. Collateral headroom is the assumed lending value of the remaining portfolio minus debt; a negative figure is an uncured shortfall, not a cash balance.
Inputs and tax assumptions used in this result
HOW TO USE THIS TOOL
Using the simulator
Enter your financial position
The payment, cash, minimum reserve and investments. Add an expected future receipt if it could repay the loan.
Set the loan and alternatives
Enter a quoted or assumed interest rate and lending limit. For the combined plan, choose the cash and net sale proceeds; the rest is borrowed.
Compare, then test the risks
Click Compare funding plans. Review all four plans, then switch between the base case, a delayed receipt and combined stress.
Before you begin: use figures for one person or one company, in one currency. Keep personal and company resources separate. You do not need names, account details or documents. Tax is optional; the tool does not select investments or obtain a loan offer.
Method and scope
A single-entity, single-currency comparison of one payment, one expected receipt, monthly net cash flow, a proportional investment sale and an interest-only secured loan. Fees are financed and grossed up. Interest is paid monthly. On receipt, cash above your reserve repays debt; remaining debt stays visible.
Calculation method, tax boundaries and limitations
Net sale = gross sale minus estimated gain tax. Gross loan = (net loan needed + fixed fee) / (1 − percentage fee). Tax is set aside at sale and cannot finance other payments. Cash cost = sale tax + interest + loan fees − modelled interest tax benefit. It excludes principal and the payment funded.
Collateral is the remaining portfolio times the assumed lending percentage. Excess debt is cured from available cash, even if this uses your reserve. Any uncured amount is flagged; forced sales are not simulated. Demand repayment and discretionary lender actions can occur outside this formula.
End net position = cash + tax set aside + portfolio − debt − unpaid sale tax. The final-cash comparison assumes all remaining investments are sold at the horizon and all remaining debt and modelled sale taxes are settled. It applies the entered flat rate to remaining positive gains, with no loss credit or disposal costs. This closing sale is a comparison assumption, not an actual scheduled transaction or tax liability due now. The asset or benefit acquired with the payment is excluded equally from all plans.
Tax profiles are parameters, not jurisdictional legal engines. No personal tax bands, share-matching rules, tax losses, participation exemptions, group relief, withholding taxes, treaties, foreign exchange, transfer pricing, tax filing or automatic legal eligibility. Cross-border structures require a separate validated model. No taxes are included when tax mode is off.
All amounts use one display currency; no conversion. No market data, dividends or cash distributions, inflation, discounting, daily interest or intramonth cash movements. The entered annual capital growth is compounded monthly and combined with the selected price shock; it is an assumption, not predicted performance. Inputs and outputs are scenario estimates, not a market forecast, loan approval or investment/tax recommendation.
Your figures are processed in this page, with no account, document upload or automatic storage. Downloads are saved only when you choose. Ordinary hosting access logs may record page requests. CDL privacy.
WORK THROUGH THE DECISION
Worked example
The published UK company cases remain unchanged. The US example above uses separate illustrative assumptions, before tax.
Read the case study →Sell or borrow: practical case studies
Explore the UK worked cases, then use the simulator to test your own assumptions. Each article states its tax treatment and stress inputs.
LFS-1 · Sell investments or borrow?
LFS-2 · Portfolio loan collateral calls