Tabellab

Credit Analyst Interview Practice: Ratio Questions, Cash Flow Coverage, Leverage, Working Capital, Debt Capacity, Covenant Tests, Collateral Coverage, Risk Grades & a Timed Mock Case

Practise 20 hands-on labs of credit analyst interview and take-home tasks on fictional loan applicants – spread a P&L and balance sheet, test leverage and debt service coverage, read working capital days, size debt capacity, price a loan with PMT, apply collateral haircuts and covenant tests, grade risk with a scorecard, compare peers, write a memo box and finish a timed mock case – with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

Credit analyst interviews and take-home tests check whether you can turn a loan application into a few clear numbers and a decision. In 20 hands-on labs you work through short practice cases on fictional applicants: you screen 16 companies with three ratio tests, spread a P&L and three balance sheets, separate gross and net leverage, compare interest cover with debt service coverage, read working capital days, bridge EBITDA to the cash left for lenders, size debt capacity by two limits, price loans with PMT, apply collateral haircuts and covenant tests, re-check a junior's spread, grade risk with a points scorecard, compare peers, run a stress table and fill a credit memo box. A timed mock case brings it all together.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. The Screening Exhibit: Leverage, Cover and Liquidity for 16 ApplicantsLabFree
  2. Spreading Question 1: From P&L Lines to EBITDA and MarginsLab Locked
  3. Spreading Question 2: Three Years of Liquidity and GearingLab Locked
  4. Leverage Question: Debt/EBITDA vs Net Debt/EBITDALab Locked
  5. Coverage Question: Interest Cover and Debt Service CoverageLab Locked
  6. Working Capital Question: DSO, DIO, DPO and the Cash CycleLab Locked
  7. Growth Follow-Up: Working Capital Needed When Sales GrowLab Locked
  8. Free Cash Flow Question: From EBITDA to Cash for LendersLab Locked
  9. Debt Capacity Question: How Much More Can They Borrow?Lab Locked
  10. Loan Payment Question: PMT for Four Loan StructuresLab Locked
  11. Amortisation Question: Balance, Interest and Principal by YearLab Locked
  12. Collateral Question: Lending Values After HaircutsLab Locked
  13. Covenant Test Question: Four Quarters, Two TestsLab Locked
  14. Spot-the-Error Question: Re-Check a Junior Analyst's SpreadLab Locked
  15. Scorecard Question 1: Points from Ratio BandsLab Locked
  16. Scorecard Question 2: From Total Points to Risk GradeLab Locked
  17. Peer Comparison Question: The Applicant vs Six PeersLab Locked
  18. Stress Follow-Up: How Far Can EBITDA Fall?Lab Locked
  19. Credit Memo Question: Summary Box and RecommendationLab Locked
  20. Final Project: A Timed Mock Case – Approve, Refer or Decline?Lab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy