Project Finance - Toll Road - Build and Operate Excel Model with 3 Statements and Valuation

Description
Fin-wiser’s Toll Road Build and Operate model helps user to assess the financial viability of a toll toad 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. Toll Road Length, Number of vehicles per day3. Toll Fee and other sources of revenue4. Variable O&M cost per vehicle (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