Project Finance Debt Metrics (Manual and Template)This manual and workbook are designed to help you build metrics required by lenders for project finance transactions.project financedscrllcrdebt metricsaverage loan life1,672Discussadd_shopping_cart free by FinExMod
Debt / Loan Calculation Excel TemplateCalculates key debt metrics including instalment, interest expense, interest rate sensitivity and impact of prepaymentsdebtsensitivityinterestmortgagecalculator1,981Discussadd_shopping_cart free by Projectify
Debt / Loan Fair Value Calculation Excel TemplateUser-friendly model to extract remaining debt / loan cash flows, derive market rates used to discount cash flows in order to determine the fair value of loanamortising loan debtloan debt durationloan debt bulletloan debt fair valueloan debt market value3,8688add_shopping_cart $35.00 by Projectify
Equity Return Metrics in a Project Finance Structure: Equity IRR (Excel Template and PDF Guide)This template and guideline aims to show different equity IRR calculation in a project finance transactionfinancial modelproject financeequity irrproject finance modelblended equity irr1,721Discussadd_shopping_cart free by FinExMod
Debt Fundraising Model & Assumptions SummaryThis model features an Excel financial projection and a Word assumption explanation, designed for debt fundraising discussions with financial institutions.metricsfinancial statementdebt fundingfinancial summaryassumption forecast226Discussadd_shopping_cart $149.00 by ECF Consultancy
Debt/Loan Analysis Excel Template BundleDebt/Loan analysis model bundle combining 3 templates at a 25% discount compared to their separate list pricesanalysisprojectiondebtinterestfinancial analysis1,216Discussadd_shopping_cart $65.00 by Projectify
Investment Banking Grade LBO Model Template: Dynamic Multi-Tranche Debt, Cash Sweep Logic, and Scenario AnalysisInvestment Banking-grade LBO model with dynamic multi-tranche debt, cash sweep, and NOL tracking. Essential for PE/IB interviews and deal analysis.valuationleveraged buyoutirrfinancial modeldebt schedule3601add_shopping_cart $149.00 by Anubhav Agrawal
Debt Collection Agency Financial Model (5 Yrs. DCF and Valuation)Ultimate 5-Year Debt Collection Agency Financial Model providing detailed analysis, financial projections, and valuation.budgetfinancedebtfinancial modeldebt collection308Discussadd_shopping_cart $215.00 by Big4WallStreet
Multi-Year M&A / Merger Model — Accretion/Dilution, 5-Year Debt Schedule, PPA & EPS Bridge (Excel + Google Sheets)A 9-tab Excel & Google-Sheets merger model: 5-year accretion/dilution on GAAP and cash-EPS bases, a debt schedule with no circular references, the as-reported Ccorporate financeinvestment bankingexcel financial modelm&a modelmerger model114Discussadd_shopping_cart $199.00 by Hoda Elmorshidy
Powerful and Customizable Debt Module Excel ModelPowerful, highly customization and free debt calculations module.debtinterestexcelspreadsheetprincipal3,7291add_shopping_cart $19.00 by Alex Martyanov
Debt/Loan Refinancing Analysis Excel ToolUser-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilitiesfinancialtoolmodeldebtexcel2,916Discussadd_shopping_cart $35.00 by Projectify
Debt Sizing and Debt Sculpting in Project Finance: A Step-by-Step Guide (One Tranche of Senior Debt)Debt sizing and sculpting in project finance financial models with Case studiesproject finance modelingdebt sizingdebt sculpting785Discussadd_shopping_cart $19.00 by FinExMod
Project Finance Excel Model - Senior Debt & RepaymentFlexible Project Finance Model with the detailed senior debt assessment.financial modelfinancial modellingproject financesenior debtvba709Discussadd_shopping_cart $39.00 by ModeLoop
Total Debt/Loan Composition Analysis Excel ToolHighly versatile Excel tool for analysing composition of debt facilities & financial impact of changes to facilities.analysisfinancialprojectiondebtexcel9954add_shopping_cart $35.00 by Projectify
Transaction Services – FDD Net Debt & Debt-Like Items Analysis ModelThis FDD workbook for Transaction Services enables clear, detailed Net Debt analysis, highlighting key drivers and providing a comprehensive view.balance sheetnet debtfinancial due diligencetransaction servicesleverage ratios474Discussadd_shopping_cart $10.00 by Finance Model Hub
Bad Debt Provision Calc TemplateThis template will allow you to effectively control and compute the debts in your Accounts Receivable aging and consider making a provision for bad/doubtful debaccountingliabilitiesaccounts receivableifrsbad debts518Discusslibrary_add free by Excel Templates & Dashboards
Your Best PracticeHave a Best Practice to share?Publish your Best PracticeLearn more about digital publishing
20 minutes agoFinancial Model Assumption BookFinancial model assumption and reference sheet template to be linked to the modelfinancial modelproject financeauditassumption bookdata book6,025Discussadd_shopping_cart free by FinExMod
21 minutes agoQ&A Tracking Sheet for a Financial Model (Excel)This is sheet can be inserted with the financial model to keep track of Q&As on the financial model.financial modelauditproductivityq&afinancial model review11,292Discussadd_shopping_cart free by FinExMod
22 minutes agoFinancial Model Version TrackerFinancial model tracker is a tool enables you to keep a track of the changes through multiple versionstoolfinancial modelscenario analysisproductivityversion tracker1,733Discussadd_shopping_cart free by FinExMod
23 minutes agoDebt Service Reserve Account (Manual & Excel Template)Free Excel template and detailed manual covering the concept and structure of Debt Service Reserve Account.debtfinancial modelingtemplateproject financedebt service reserve account2,697Discussadd_shopping_cart free by FinExMod
25 minutes agoProject Finance Debt Metrics (Manual and Template)This manual and workbook are designed to help you build metrics required by lenders for project finance transactions.project financedscrllcrdebt metricsaverage loan life1,672Discussadd_shopping_cart free by FinExMod
26 minutes agoModeling different principal debt repayment methodsThis Excel file runs through five methods for modelling debt principal repaymentfinancial modelingproject financedebt repaymentprincipal debt repaymentdebt service2,161Discussadd_shopping_cart free by FinExMod
28 minutes agoTypical Cash Flow Waterfall (Excel Template and PDF manual)Contains a typical cash flow waterfall and covers the concept of cash flow waterfallcash flowfinancial modelingproject financewaterfall modelcash flow waterfall5,9071add_shopping_cart free by FinExMod
29 minutes agoBuilding Integrity Checks in Project Finance Models (Manual & Template)This is a spreadsheet that can be integrated in any project finance model. It contains most common integrity checks.financial modelproject financeauditchecks2,7094add_shopping_cart free by FinExMod
33 minutes agoFinancial Model audit check list - spreadsheetThis is an audit or productivity tool that you can use while reviewing someone else’s models.financial modelingtoolsproductivityfinancial modelersfinancial model audit9,2756add_shopping_cart free by FinExMod
2 hours agoIFRS 9 Stage 1 ECL EstimationThis model estimates the probability of defaults on financial instruments, for financing reporting purpose.pdifrseclexpected credit lossesprobability of default3,6271add_shopping_cart free by Roger Loh Kit Seng
2 hours agoECL IFRS 9Expected Credit Loss (ECL) is a forward-looking estimate of potential losses from credit risk over the life of a financial asset, required under IFRS 9.ifrseclexpected credit lossesallowance for doubtful debts990Discussadd_shopping_cart free by Mo ModelPro
3 hours agoPortfolio Variance ModelA simple model to learn and play with portfolio variance in Excelmatrixriskfinancevarianceportfolio1,864Discussadd_shopping_cart free by Risk Prep
3 hours agoSimple Asset Allocation ModelBasic guidance on how to structure your asset portfolio, for safe and effective investment strategyinvestmentreal estateprivate equityhedge fundsbonds832Discussadd_shopping_cart free by Domenico Cristarella
3 hours agoHow to use history in making an acquisition analysisAn extensive excel tool for acquisition analysis, and how to use history when making an acquisition analysis.acquisitionhistoryanalysism&aacquisition analysis1,304Discussadd_shopping_cart free by Prof. Ed Bodmer
3 hours agoDue Diligence Report (FREE)Gain Financial Insights & Mitigate Investment Risksstrategyinvestmentsfinanceprivate equitym&a1,116Discusslibrary_add free by P
3 hours agoCombination ModelA 22 section excel model to assess the impact on the financials of the combination of companiescombinationimpactfinancemergersm&a10,7576add_shopping_cart free by John P. Burns
3 hours agoStartup SaaS Financial Model Template – 3 Tier SubscriptionThis is a 3 Statement financial Model Template for a SaaS Startupsaassubscription modeltiered subscription modelsubscription financial modelstartup subscription model420Discussadd_shopping_cart $4.00 by DY Consultants
4 hours agoDebt Schedules For Several Loans With Different TermsLoans schedule template assuming you have several loans with different termsdebt scheduleloan scheduleseveral loansloan templatedebt modelling template326Discussadd_shopping_cart $4.00 by DY Consultants
4 hours agoDue Date Pop-up Alert & Tracker with Color Change Notifications in Microsoft ExcelDue Date Pop-up Alert in Excel - Date Due Tracker - Due Date Color Change Notificationsexceltrackerformulaautomation2,183Discusslibrary_add free by Rahim Zulfiqar Ali
4 hours agoSaaS Cohort Analysis ModelA simple cohort analysis spreadsheet to understand how you are doing on your KPIs (Churn, Customer Lifetime etc.)startupssaasconversionsoftware as a servicechurn5,905Discussadd_shopping_cart free by Christoph Janz