Leveraged Procurement Model

An Excel file that teaches how to perform Leveraged Procurement Model operation.

Excel Leveraged Procurement Model

Purchase price and debt ratios are being parameterized. The interest and amortization schedule is being calculated. Cash flow is being tested in debt service. Sensitivity analysis is being conducted using scenarios. Outputs are summarized in an investor view.

Hope it is useful.