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 metricsaverageloan life1,672Discussadd_shopping_cart free by FinExMod
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
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
Loan Amortization Schedule CalculatorGenerate loan amortization schedules, with breakdown of interest and principal repayments.interestmortgageloanannuityamortization9091add_shopping_cart $3.00 by Jhett Koo
Loan Securitization Model: A Template for Multi-Tranche Structures, Coverage Metrics, and Sensitivity AnalysisA tool used to analyze loan securitization offerings from the view of the notes, Special Purpose Vehicle (SPV), and equity leg if applicable.irrsensitivity analysisfinancial modelloansloan portfolio810Discussadd_shopping_cart $70.00 by Jason Varner
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
Startup Loan Brokerage Financial Model (Mortgage, SBA & CRE + Capital Advisory)This model was built to perform a 5-year financial feasibility study of a new loan brokerage business. It also has the capability to model capital advisory.income statementbalance sheetinvestment bankingfinancial statementsstartup financial model132Discussadd_shopping_cart $70.00 by Jason Varner
Debt 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
Bond Net Yield-to-Maturity CalculatorCalculate the Net Yield-to-Maturity (or to sale date) of a bond, keeping interest rate risk under control.irrdurationinternal rate of returnyield to maturityinterest rate risk771Discussadd_shopping_cart free by Domenico Cristarella
Loan Amortization Schedule Excel SpreadsheetManage Your Loan Payments Yourself, With This Simple Spreadsheet.interestloanprincipalscheduleloan amortization1,092Discussadd_shopping_cart $19.00 by Jatin Goel
Simple Inventory Valuation and Weighted Average CostingAutomated Excel tool for inventory management with user forms, real-time stock reports, and weighted average costing for accurate and efficient tracking.inventory costinginventory valuationstock reportweighted average costinginventory quantity670Discussadd_shopping_cart free by Basit Hussain Qadri
Convertible Loan Term SheetConvertible Loan Template with complimentary Educational Notes to help you.templateterm sheetagreementconvertible loansloans1,690Discussadd_shopping_cart free by Naco Canada
WACC (Weighted Average Cost of Capital) Excel calculatorThe calculator uses the following basic formula to calculate WACC (Weighted Average Cost of Capital).costcorporate financeequitydebtfinancing2,907Discussadd_shopping_cart free by BO Boldtseren
Loan amortisation schedulesLoan amortisation schedule in Microsoft Excel + PDF with explanations.debtexcelloanannuityloan schedule617Discussadd_shopping_cart free by Gary Knott
Loan Amortization Schedule - FreeThis Loan Amortization Schedule - Free is a simple yet dynamic Loan Repayment Schedule creator.financial modelamortization scheduleeasyfreeloan665Discussadd_shopping_cart free by Sadaf Abbas
Home Loan Assessment Excel ModelOne can check its home loan eligibility along with the PMAY Subsidy eligibility by entering some basic inputs.bankershomeloansretailloans1,063Discussadd_shopping_cart free by Rohit Vyas
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