J Curve Excel Template

A proper Excel template allows you to input assumptions (fund size, fee structure, investment pacing) and instantly see the visual trajectory of your returns.

In column A, enter periods from 0 to N (e.g., 0 to 10 years). j curve excel template

| Year | Cash Flow | Cumulative CF | |------|-----------|----------------| | 0 | -100 | -100 | | 1 | -80 | -180 | | 2 | -50 | -230 | | 3 | 20 | -210 | | 4 | 60 | -150 | | 5 | 150 | 0 | | 6 | 200 | 200 | | 7 | 300 | 500 | A proper Excel template allows you to input

| Cell | Label (Column A) | Value (Column B) | | :--- | :--- | :--- | | | Fund Parameters | | | 2 | Fund Size ($M) | 100 | | 3 | Fund Term (Years) | 10 | | 4 | Management Fee (%/yr) | 2.0% | | 5 | Target Gross MOIC | 2.5x | | 6 | Carry (%) | 20% | | 7 | Deployment Schedule | | | 8 | Year 1 Drawdown % | 20% | | 9 | Year 2 Drawdown % | 30% | | 10 | Year 3 Drawdown % | 50% | j curve excel template