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.
- 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
- The Screening Exhibit: Leverage, Cover and Liquidity for 16 ApplicantsFree
- Spreading Question 1: From P&L Lines to EBITDA and Margins Locked
- Spreading Question 2: Three Years of Liquidity and Gearing Locked
- Leverage Question: Debt/EBITDA vs Net Debt/EBITDA Locked
- Coverage Question: Interest Cover and Debt Service Coverage Locked
- Working Capital Question: DSO, DIO, DPO and the Cash Cycle Locked
- Growth Follow-Up: Working Capital Needed When Sales Grow Locked
- Free Cash Flow Question: From EBITDA to Cash for Lenders Locked
- Debt Capacity Question: How Much More Can They Borrow? Locked
- Loan Payment Question: PMT for Four Loan Structures Locked
- Amortisation Question: Balance, Interest and Principal by Year Locked
- Collateral Question: Lending Values After Haircuts Locked
- Covenant Test Question: Four Quarters, Two Tests Locked
- Spot-the-Error Question: Re-Check a Junior Analyst's Spread Locked
- Scorecard Question 1: Points from Ratio Bands Locked
- Scorecard Question 2: From Total Points to Risk Grade Locked
- Peer Comparison Question: The Applicant vs Six Peers Locked
- Stress Follow-Up: How Far Can EBITDA Fall? Locked
- Credit Memo Question: Summary Box and Recommendation Locked
- Final Project: A Timed Mock Case – Approve, Refer or Decline? Locked
Learner reviews
Be the first to review this course.