Waste Water Treatment Plant FM with 3 Statements, Cash Waterfall, NPV & IRR, Construction and Operation Phase

Description
Fin-wiser’s Waste Water Concession model helps user to assess the financial viability of a waste water concession by capturing all the essential inputs related to construction, operation, and financing.The Model includes assumptions related to:1. Development cost, Construction costs and Developer’s Fee2. Plant Capacity and Capacity utilization profiled over contract life3. Fixed & Variable Capacity Charge, Electricity Charge and other sources of revenue4. Variable O&M cost per m3 (divided into 8 sub heads such as staff, electricity, consumables, transport and fuel) and other fixed costs (SPV, insurance, land lease, community payment, management fee & more)5. Flexible Funding Profile – Cash equity, Bridge Loan, Bank Debt, DSRA and Bank overdraft 6. Working Capital Assumptions related to accounts receivables and payables7. Straight Line and Accelerated Depreciation option8. Annuity, Sculpted Debt and Even Principal Repayment options9. Inflation and Indexation10. VAT during construction and operations phase11. Decommissioning cost and reserve, if requiredModel Output includes:1. Project IRR & NPV2. Equity IRR & NPV3. Minimum and Average DSCR4. LLCR and PLCR5. Equity Payback Period6. Cash Waterfall7. Debt Service Profile8. Integrated Financial Statements9. Fully Integrated DashboardModel Package includes:1. Excel based financial model (Excel binary format i.e. xlsb)2. Model Heat Map (FWA Maps) – The file includes heat map of the model with color codes on F: Unique formula