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
Metal Mining Project Finance ModelMetal Mining Project Finance Model presents the business case of an investment in the construction & development of a mine and the sale of the mining products.financial statementsproject financemininggold miningsilver mining1,374Discussadd_shopping_cart $350.00 by Big4WallStreet
Project Finance Solar PV model with re-financingAn advanced financial model for a project finance solar project and also include the analysis of the financing structure1,0135add_shopping_cart $99.00 by FinExMod
Hydro Project Finance Model (Excel Model & User Guide)The excel model and user manual are designed to assist in the evaluation of typical hydro power projects.sensitivity analysisfinancial modelfinancial modelingproject financehydro2,341Discussadd_shopping_cart $99.00 by FinExMod
Project Finance Solar PV ModelFinancial model for a typical project finance solar project.financial modelproject financesolar pvcash flow analysis2,786Discussadd_shopping_cart $99.00 by FinExMod
Waste to Energy / Biogas Project Finance ModelWaste to Energy Biogas Project Finance Model presents the case of an investment in the construction of a biomass processing plant and the sale of the energy.valuationscenariosfinancial modelkpisproject finance514Discussadd_shopping_cart $349.00 by Big4WallStreet
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
The Minimum Level of Money for saving at Personal life and BusinessEquation of the Minimum Level of Saving (MLS) For Business and Personal Lifebudgetfinancefinancial analysisscenariosmoney452Discussadd_shopping_cart free by Tohamy Adel
Customer Lifetime Value Excel TemplateThis Excel template helps you to calculate the revenue you receive from a customer over their lifetime.forecastcustomer acquisitionsaassoftware as a servicecac4,358Discussadd_shopping_cart free by Ben Murray
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
Loan ScheduleA flexible tool to calculate loan balances and accrued interestdebtinterestfinancingfundingloan schedule892Discussadd_shopping_cart $10.00 by Andrei Okhlopkov
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
Consumer Lifetime Value & Client Acquisition Cost Calculator Free TemplateThis Template is to provide users with a ready-to-use calculator of consumer lifetime value throughout the assumed market inputs.calculatorcost per clickconsumer lifetimecost per consumerfree calculator261Discussadd_shopping_cart free by JL Valuation & Modeling
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
How to shorten the lifespan of a product – Cerami Tiles case studyComparison of different methods to shorten the lifespan of a product. We use as an example ceramic tilesconsumer goods business in excelsmcg businessceramic tileslifespan of a productconsulting project analysis1,064Discussadd_shopping_cart $10.00 by Asen Gyczew
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