Split and Join Cells in ExcelThis excel file along with the yutube video, demonstrates how to split or join cell contents in excel.tipsexceltrickssplitsplit and join184Discussadd_shopping_cart free by Big4WallStreet
Real Estate Joint Venture financial ModelReal Estate Joint Venture Financial Model in Microsoft Excel for download.roicirrreal estatefinancial modeljoin venture311Discussadd_shopping_cart $20.00 by Finmodelhub
Joint Venture Single Tenant Real Estate ModelAnalyze investment opportunities for single tenant joint venture real estate.joint venturereal estateindustrial real estatesingle tenantnnn155Discussadd_shopping_cart $45.00 by Jason Varner
Multi-family Real Estate - Joint Venture Model - IRR Hurdles, Refinancing, and Exit AssumptionsModel up to a 10 year annual pro forma that caters to the specific assumptions related to multifamily real estate.joint venturewaterfallpro formacap ratereal estate model731Discussadd_shopping_cart $45.00 by Jason Varner
Choice-Based Conjoint Analysis in ExcelIdentify utility and importance of products' characteristics and market share of prospective products.conjoint analysischoice-based conjoint analysiscustomers' preferencescustomers' choice1,277Discussadd_shopping_cart $20.00 by Alberto Scappini
Joint Venture Template BundleIncludes soft and hard preferred equity as well as a preferred return, multi-family real estate, and self storage template.joint venturepreferred returndistribution waterfallself storagepreferred equity749Discussadd_shopping_cart $189.00 by Jason Varner
Conjoint Analysis Excel TemplateIdentify product attribute customer preferences, customer's willingness to pay, and product market share.analysistemplateexcelpricemethods4,237Discussadd_shopping_cart $3.00 by Alberto Scappini
10-Year Joint Venture Excel Real Estate Model with Refi LogicA detailed real estate model designed to be used to estimate future cash flows to the sponsor and investor(s).irrreturn on investmentroipro formaexcel1,9464add_shopping_cart $45.00 by Jason Varner
Cumulative Distribution Hurdles: 6 Tiers - Joint VentureEasily plug in distributable cash flow and the waterfall model does the rest for how much cash should be split between the LP and GP each period.joint venturewaterfalllpcash distributionhurdles258Discussadd_shopping_cart $70.00 by Jason Varner
How to Identify Your Riskiest Business Model AssumptionsHow to spot risky business model presumptions so that you can de-risk the model before asking future co-founders to joinriskbusiness modelassumptionsfoundersderisk293Discussadd_shopping_cart free by Ash Maurya
2 Hurdle Preferred Equity Waterfall - Repay Equity>Attain ROI TargetA dynamic joint venture waterfall model with 3 cash flow splits across 2 hurdles. Up to 10 years on an annual basis. Main hurdle is MOIC.joint venturenpvwaterfall modeldcf analysisequity multiple573Discussadd_shopping_cart $95.00 by Jason Varner
Self Storage Equity Ramping through Multiple Funds: Excel Financial ModelSelf storage investment analysis for up to 6 separate joint ventures displayed individually and in aggregate for LP/GP.joint venturecash flowwaterfall distributionself storageirr hurdles352Discussadd_shopping_cart $45.00 by Jason Varner
Senior Living Real Estate Underwriting ModelModel the acquisition of a senior care facility, operations, and exit. Includes joint venture waterfall, two SBA loan options, and a REFI / exit configuration.joint venturereal estateunderwritingrefiassisted living357Discussadd_shopping_cart $70.00 by Jason Varner
Buying Real Estate Units (up to 10) - Improvement Construction / Rent PSF LogicA user friendly real estate acquisition model built off of per unit drivers. Includes exit valuation, IRR, joint venture capable.acquisitionjoint ventureirrterminal valuereal estate model187Discussadd_shopping_cart $45.00 by Jason Varner
Hotel Deal Analysis Template (Advanced)A tool to analyze various types of hotel deals, including acquisitions or new construction. Joint venture capable and detailed sources and uses.joint venturewaterfallsensitivity analysisfinancial modelacquisitions228Discussadd_shopping_cart $70.00 by Jason Varner
Advanced Promote Waterfall with IRR or MOIC MilestoneA unique waterfall that is useful to joint ventures containing a preferred return and a single IRR / MOIC hurdle.joint venturepreferred returnirr waterfall modeldistribution cash flowsexcel jv waterfall template114Discussadd_shopping_cart $40.00 by Jason Varner
Your Best PracticeHave a Best Practice to share?Publish your Best PracticeLearn more about digital publishing
3 hours agoDaily, Weekly, and Monthly Routine Planner ChecklistOrganize your tasks and routines with this comprehensive daily, weekly, and monthly plannergantt chartchecklisttrackerplannerexcel tracker1,950Discussadd_shopping_cart $10.00 by Mubbasshir AR
3 hours agoConstruction Financing Options ComparisonThis tool allows you to compare two different financing options for your construction projectbudgetinterestfinancingconstructionconstructionbudget820Discusslibrary_add free by Nadine Popova
3 hours agoConstruction - Work in Progress Excel TemplateWork in progress (WIP) is an essential financial tool and accurate way to know the true profitability of the company.profitabilitywork in progressconstruction5,5222add_shopping_cart free by ECF Consultancy
3 hours agoCalculation of Interest during the construction periodThe tool calculates Interest during construction period by applying five different methods of equity injection and debt.constructionidcinterest during constructionrandom numbers5,268Discussadd_shopping_cart free by Sumit Barua, CFA (ICFAI), PMP
3 hours agoCash Runway ModelThis Cash Runway Model is an instantly downloadable, ready-to-use tool helping you to forecast your start-up expenses.forecaststartupincomeexpenditurecash runway1,963Discussadd_shopping_cart free by Ben Murray
3 hours agoExcel for Financial Modeling - Functions & Formulas Practice WorkbookThe Excel functions every financial modeler needs, in one interactive workbook.financial modelingexcelexcel skillsexcel functions151Discussadd_shopping_cart free by FinExMod
3 hours agoThe Berkus Method- Valuing the Early Stage InvestmentThe Updated Berkus Method for Early Stage Startup Financial Valuationvaluationstartupventure capitalmethodonline1,500Discussadd_shopping_cart free by Dave Berkus
4 hours agoIntegrated Financial Statements5-Year Forecast with Integrated Financial Statements and Schedulesincome statementbalance sheetcash flow statementintegrated financial statementfinancial forecast model3,2252library_add free by ExcelFinModels
4 hours agoDebt / Loan Calculation Excel TemplateCalculates key debt metrics including instalment, interest expense, interest rate sensitivity and impact of prepaymentsdebtsensitivityinterestmortgagecalculator1,883Discussadd_shopping_cart free by Projectify
4 hours agoIncome Statement - Excel Model TemplateThis is an Income Statement template to help present your business’ profit and loss over time.businessincome statementvaluationdebtdcf1,262Discussadd_shopping_cart free by Wall Street Oasis
4 hours 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,598Discussadd_shopping_cart free by FinExMod
4 hours agoSensitivity and Scenario Analysis Excel Template with VBAThis workbook and this manual are designed to help you build a sensitivity analysis into your models using VBA.sensitivity analysisfinancial modelingscenario analysisvba7,4213add_shopping_cart free by FinExMod
4 hours agoCAPEX and Depreciation Projections Excel Model TemplateGet control of future capital expenditure with this CAPEX and Depreciation Projections Model.projectionsbudgetplanningfinancial planningcapital expenditure10,469Discussadd_shopping_cart free by Andrew Grigolyunovich, CFA, CFM, FMVA
4 hours agoLeveraged Buyout LBO Model TemplateA full Leveraged Buyout LBO model template for a project to understand its different components and work with your own.financevaluationleveraged buyoutdcfwacc11,2863add_shopping_cart free by John P. Burns
4 hours agoFinancial Projections Excel TemplateOur financial projections template provides everything needed to create 5 year startup financial projections.income statementbusiness planbalance sheetstartupfinancial projections8,5493add_shopping_cart free by Plan Projections
4 hours agoCombination ModelA 22 section excel model to assess the impact on the financials of the combination of companiescombinationimpactfinancemergersm&a10,5636add_shopping_cart free by John P. Burns
4 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,260Discussadd_shopping_cart free by Prof. Ed Bodmer
8 hours agoWarehouse Inventory Management Excel TemplateExcel template for warehouse inventory tracking and managementtemplateexcelinventory managementstock managementinventory tracker38,4911add_shopping_cart free by App Sheet
8 hours agoAutomated 5g Function TestingHow to automate testing 5g functionsfinancial modeltestingfinancial modelingfinancial modellingdynamic array357Discussadd_shopping_cart free by Craig Hatmaker
8 hours agoBXL Table of Contents Creator/Manager Add-inEffortlessly add the table of contents gold standard to any Excel project.financial modelexceladd-inbeyond excelbxl854Discussadd_shopping_cart free by Craig Hatmaker