Optimal Portfolio - Markowitz Efficient Frontier (With Short Selling Option) Excel ModelUse this tool uses Efficient Market Hypothesis to determine the optimized portfolio allocation.diversificationmarkowitzefficent market hypothesisportfolio theory1,6021add_shopping_cart $5.00 by Kenton Parrott, CFA, MBA
Portfolio Optimization Excel Model with Harry Markowitz's Modern Portfolio TheoryFind the efficient frontier of optimal portfolios, the Capital Allocation Line, tangent portfolio and moreinvestmentpersonal financewealth managementoptimizationportfolio8,6097add_shopping_cart $5.00 by Jhett Koo
MARKOWITZ PORTFOLIO OPTIMIZATION USING MONTE CARLO SIMULATIONA stochastic simulation is performed based on the Monte Carlo method to obtain an optimal portfolio after evaluating thousands of possible combinations.financialmodel568Discussadd_shopping_cart $20.00 by Deon de Wet-Roos
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