Juniper Trace Technology Services
60-Minute Clean-Sheet Three-Statement LBO
A sponsor is considering a founder-owned IT services business. Model the acquisition and its financing, follow the cash through a recession, and calculate what the sponsor receives at exit.
Link an income statement, balance sheet and cash flow statement.
$39 · One-time purchase
From the current candidate assignment.
What you receive to start
- Juniper Trace - Blank Workbook.xlsx
- Juniper Trace - Read Before Starting.txt
- Juniper Trace LBO Exercise.docx
- Juniper Trace LBO Exercise.pdf
What you decide
- A sponsor is considering a founder-owned IT services business. Model the acquisition and its financing, follow the cash through a recession, and calculate what the sponsor receives at exit.
What you submit
- One printable five-year integrated three-statement LBO built from a blank sheet.
- Base and a personally underwritten Year 2 recession, with sponsor MOIC and IRR shown for each.
What’s included
Download the candidate materials, open the guided walkthrough in your browser, and compare your work with the reference files in Review. Each case also includes an offline walkthrough.
The worked-answer packet includes scoring criteria for reviewing your attempt.
Where the worked answer comes from
- Authored worked example. The issued blank-sheet test and a timed submission survive. The worked answer uses the existing two-sheet teaching model.
For access help or a satisfaction refund within 30 days, email [email protected] from your purchase address. Terms of Use.
Software Extract each ZIP before opening its files. Use desktop Excel for workbooks and a browser for the guided walkthrough.
A sponsor is considering a founder-owned IT services business. Model the acquisition and its financing, follow the cash through a recession, and calculate what the sponsor receives at exit.
See the 3 download packages
- Candidate packetJuniper Trace - Blank Workbook.xlsx, Juniper Trace - Read Before Starting.txt, Juniper Trace LBO Exercise.docx, Juniper Trace LBO Exercise.pdf
- Worked answerAfter-attempt scorecard.pdf, Juniper Trace - Answer Guide and Rubric.pdf, Juniper Trace - Checkpoint 1.xlsx, Juniper Trace - Checkpoint 2.xlsx, Juniper Trace - Solved LBO Model.xlsx, Untimed guided practice/Juniper Trace - Guided Shell.xlsx
- Guided walkthrough5 lessons, with the matching case files.
60-Minute Clean-Sheet Three-Statement LBO
A sponsor is considering a founder-owned IT services business. Model the acquisition and its financing, follow the cash through a recession, and calculate what the sponsor receives at exit.
$39 · One-time purchase