Latest / ModeLoop: Financial Modelling in Excel

Sizing and sculpting debt to a DSCR target | P3E19
Synthetic teaching example: size and sculpt a three-year loan to a 1.50x DSCR target, then check the unpaid maturity balance. All figures and financing terms are invented for teaching, not a live deal or a lender offer.CFADS: £90k, £120k and £150k. Initial debt: £200k. Interest: 10% on opening balances, year-end payments. The target ratios can all pass while £5.6k remains at maturity. The episode separates debt capacity, repayment timing, coverage tests and cash shortfalls.Designed illustrations and two-voice synthetic narration. Illustrative calculations, not a live AI or Excel…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.