How to use this template
Download the Excel workbook and replace the clearly marked amber example inputs with your figures. Formulas calculate the results automatically. Every workbook includes a Formula guide tab showing each calculation, its cell reference and a plain-English explanation. Save your completed workbook privately; this page does not upload your information.
- Include only committed funds as committed; mark all other amounts as proposed.
- Include reserves, fees and contingencies in uses.
- Total sources must equal total uses before the transaction is fully funded.
- Avoid counting a deposit twice if it is credited toward the purchase price.
What it helps establish
A clear package lets a capital provider ask specific questions about the asset, sponsor and proposed structure. Reconcile the summary with the underlying records and label estimates. The template supports an initial review; the diligence requirements for the actual transaction may be different.