Best Practice to aggregate data from several tabs in excelLooking to aggregate the data of multiples tabs into one clean tab? Look no further, this allows you to do just that!mappingfinancial analysisfp&afinancial due diligenceexcel modelling646Discusslibrary_add free by HEURTEBIZE
Automatic update of excel tab names - unlockedThis is a useful tool for the advanced and expert excel user to get an automatic update of a tab name change in a cellexceladvanced excelindirect functionindirecttab names331Discussadd_shopping_cart $5.00 by consultants
Excel Index Match Vs IndirectThis is to demonstrate the difference between INDEX MATCH vs INDIRECTexceladvanced excelindirect functionexcel tutorialindex match2,887Discusslibrary_add free by consultants
RefTreeAnalyser, Excel formula auditing made easyThe formula auditing options Excel offers have some severe limitations which RefTreeAnalyser resolves. It offers a much improved formula dependents navigation.excelauditformulacircular referencesdependents567Discussadd_shopping_cart free by Jan Karel Pieterse
Array Formulas in ExcelExplains array formulas and shows how they can be used in financial analysisfinancial analysisfinancial modelingexcelarray formulas4,618Discussadd_shopping_cart free by Andrei Okhlopkov
Risk Premium Formula: Calculator (with Excel Template)Calculator in Excel and formula in PDF to allow you to work out risk premium.investmentsriskrisk premiuminvestorscalculator1,097Discussadd_shopping_cart free by Dheeraj Vaidya CFA FRM
DuPont FormulaThe Du Pont formula aims to help us understand Return on Equity in detail.income statementreturn on equityassetsnet incomebalance sheet470Discussadd_shopping_cart free by Dheeraj Vaidya CFA FRM
Cash Flow Projections Template - Indirect | Direct | FCFFCash Flow Projections Template using 3 different methods (Indirect, Direct, FCFF)investmentcash flowfinancingoperatingfinancial statements224Discussadd_shopping_cart $59.00 by Profit Vision
Leverage Analysis FormulaDetailed analysis and evaluation of the Leverage Analysis Formula.contributionprofitleverageebitleverage analysis304Discuss free by CA N Raja Natarajan
Excel shortcuts and formula training excercisesThree comprehensive excel based excercises to teach common excel shortcuts and advanced formula useformulaslearningscourseexcel learningteach excel285Discussadd_shopping_cart $25.00 by ModellingGuy
Corporate Finance FormulasA Corporate Finance Formula Sheet (e.g. NPV, WACC...) to download in PDF Format.corporate financefinancial managementcorporate finance formula925Discussadd_shopping_cart free by Mo ModelPro
Excel Cheat Sheet: 100+ Formulas, Shortcuts, Advanced Charts + Google Sheets Cheat SheetWhether you're a beginner or an experienced Excel user, this Excel Cheat Sheet 100+ Formulas is the perfect tool to help you master Excel and save time.cheat sheetexcel chartsexcel formulasexcel cheat sheetexcel functions list133Discussadd_shopping_cart$8.00 $6.40 by Adnan Harysatria
How to Apply and Combine INDIRECT Excel Function with VLOOKUPLearn how to apply and combine INDIRECT Excel Function with VLOOKUP.dataexceldata sciencemicrosoft exceladvanced excel2251add_shopping_cart free by 365 Data Science
Calculating Annual Churn Rate in SaaS and Subscription Businesses: Methods, Formulas, and Forecasting FrameworkDiscover essential methodologies and formulas for calculating annual churn rates in SaaS and subscription businesses with recurring contracts.financial modelsaas modelcustomer churn rateannual churn ratesubscription modeling185Discussadd_shopping_cart $40.00 by Jason Varner
Option Value with Black-Scholes formulaFind the value of puts, calls, and combinations of options using the Black-Scholes formula. financeoption pricingputcalloption value6,1091add_shopping_cart free by Richard L. Smith
How to Calculate the DCF Terminal Value FormulaThis is tool will help the user to calculate the DCF terminal value formula using perpetual growth or exit multiple.dcfterminal valuediscounted cash flowexit multipleperpetual growth1,4311add_shopping_cart free by financialmodeling.org
Your Best PracticeHave a Best Practice to share?Publish your Best PracticeLearn more about digital publishing
40 minutes agoThe All-in-One Task Tracking SystemThe All-in-One Task Tracking System is a simple and organized framework designed to help you manage, monitor, and complete your tasks efficiently. It allows youdashboardexceltasks740Discusslibrary_add free by Rahim Zulfiqar Ali
4 hours agoStartup Pro-forma Profit and Loss statement (P&L) TemplateMade to help you construct a high level operation plan for your startup. cogsstatementexpensesstartuptemplate38,7231add_shopping_cart free by Charlie Tillett
6 hours agoSeat Booking with Interactive Floor Plan Excel Template, Office Space Reservation, Space Management, Seat HighlightingSeat Booking Excel Template with Interactive Floor Plan & Occupancy Statuses - Very easy for Admin to setup and maintain.excel templatespreadsheet templateseat bookingseat booking templateoffice space management1,043Discussadd_shopping_cart $12.00 by Kacharuk Marukpitak
7 hours agoSimple FCFF Model (Free Cash Flow for the Firm)A complete FCFF model that allows for changing margins and has default assumptions built infinancevaluationfcffpresent valuefree cash from for the firm972Discussadd_shopping_cart free by Aswath Damodaran
8 hours agoValuation: Free Cash Flow to Firm (FCFF) vs Free Cash flow to Equity (FCFE) Excel ModelExcel Valuation model that reconciles FCFF (Free Cash Flow to the Firm) and FCFE (Free Cash Flow to Equity)financevaluationfcfffcfereconcile8,537Discussadd_shopping_cart free by Aswath Damodaran
13 hours agoValuation of PremiumsA model to value the premium you should pay for growth in either an intrinsic valuation or a relative valuation.growthfinancevaluationpremiumsintrinsic838Discussadd_shopping_cart free by Aswath Damodaran
14 hours agoValue of Control in a Firm - Excel ModelThis Excel model analyzes the value of control in a firm.control valuefinancemodelvaluationfirm2,038Discussadd_shopping_cart free by Aswath Damodaran
14 hours agoThree-Stage Dividend Discount ModelValue the equity in a firm with three stages of growthgrowthfinancevaluationequitystable growth4,343Discussadd_shopping_cart free by Aswath Damodaran
14 hours agoWalmart Financial ModelWalmart Financial Modelaswath damodaranwalmart financial modeloperational financial model1,609Discussadd_shopping_cart free by S Uddanti
14 hours agoEvaluating Financial Performance and ForecastingSet of worksheets related to financial analysis and forecastingevaluationfinancefinancial performanceforecastingfinancial analysis1,651Discussadd_shopping_cart free by Matt Evans
14 hours agoSaaS Revenue Forecasting ModelFull-packed revenue forecasting model to help SaaS founders take better decisions with key indicators. key performance indicatorssalesrevenuesforecastingstartups3,1401add_shopping_cart free by Noah Barr
14 hours agoExcel Revolving Credit Calculator for annual modelsAn automatic excel algebraic approach for revolving loan facility in annual financial models (no macro & circular links)financedebt schedulefinancial modelingcredit calculatordebt structure8,211Discussadd_shopping_cart free by Ivan Klykov
14 hours agoFinancial Model Assumption BookFinancial model assumption and reference sheet template to be linked to the modelfinancial modelproject financeauditassumption bookdata book5,847Discussadd_shopping_cart free by FinExMod
14 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,771Discussadd_shopping_cart free by Christoph Janz
14 hours agoSaaS Revenue Waterfall Excel Chart TemplateA SaaS Excel Model to help you forecast revenue waterfall in simple, automated charts.revenuewaterfallsaassoftware as a servicemrr13,775Discussadd_shopping_cart free by Ben Murray
14 hours agoSales Team Headcount Forecast Excel TemplateThis Excel spreadsheet template will help you forecast your sales team headcount while scaling bookings.forecastsaassoftware as a serviceexcelheadcount forecast7,832Discussadd_shopping_cart free by Ben Murray
19 hours agoEV Charging Hub Financial Model Template - one page modelA dynamic one page EV Charging Hub financial model (up to 25 years), showing investor returnsinvestorforecastforecastingfinancial modelfundraising407Discussadd_shopping_cart $59.00 by numberslides
19 hours agoDue Diligence P&L - Exhaustive Revenue and Costs analysis templateFinancial Due Diligence exhaustive P&L model for Revenue & Costs Analysis. Big-4 like checklist of financial due diligence analyses.acquisitioninvestmentfinancial analysisdue diligencedue diligence report2,692Discussadd_shopping_cart $249.00 by HEURTEBIZE
20 hours agoBurn Rate CalculatorSimple and easy to use tool for calculating the cash burn rate of your businesscash flowburn ratecash burn rateburn rate calculatorexpenditure4,201Discussadd_shopping_cart free by Gusto
20 hours agoBurn Rate CalculatorThis burn rate calculator will help you work out when your business will run out of money.cash flowcalculatorburn ratecash burn rateburn rate calculator1,307Discussadd_shopping_cart free by Commerce Bank