Array Formulas in Excel
Explains array formulas and shows how they can be used in financial analysis
4,667Discussadd_shopping_cart
free
by Andrei Okhlopkov
Search results: array formula
by Andrei Okhlopkov
Tool solving multiple indices on excel
Solves the problem of repeat hits in a VLOOKUP in excel260Discusslibrary_addfree
by consultants
Seasonality Forecasting with Time Series Decomposition
Data forecasting with analysis of periodic variation in predicted data projections.1,088Discussadd_shopping_cartBiogas Plant (Waste to Energy) Financial Model with 3 Statements, Cash Waterfall, NPV, & IRR and Flexible Timeline
Biogas Plant Model is a Project Finance Model for construction and operations of a biogas plant.2,1364add_shopping_cart$149.00
by Finwiserr
Wind Farm - 3 Statements Financial Model with Flexible Timeline, NPV, IRR, Debt Covenants and Cash Waterfall
Wind Farm FM is a Project Finance Model for construction and operations of a Wind Farm1,6024add_shopping_cart$149.00
by Finwiserr
Solar PV Plant 3 Statements Financial Model with Flexible Timeline, NPV, IRR, Debt Covenants and Cash Waterfall
Solar Park FM is a Project Finance Model for construction and operations of a Solar Park.1,0082add_shopping_cart$149.00
by Finwiserr
Detailed Hotel Project Valuation- Construction and Operation Phase with NPV & IRR calculations
Hotel construction & operation FM is a project finance model for investment appraisal of a hotel business954Discussadd_shopping_cart$149.00
by Finwiserr
Amusement Park- 3 statement Financial Model with Cash Waterfall, NPV & IRR, Construction and Operation Phase
Amusement/Theme Park Excel Model helps user asses financial viability of building and operating an amusement park802Discussadd_shopping_cart$149.00
by Finwiserr
Solid Waste Treatment Plant - Build and Operate 3 Statement Financial Model with Valuation
Solid Waste Treatment Plant Model is a project finance model for construction and operations of a waste treatment plant.428Discussadd_shopping_cart$149.00
by Finwiserr
Dynamic Arrays in Excel
Dynamic Array Examples that make working with multiple values at the same time easy.820Discussadd_shopping_cartfree
by Big4WallStreet
Call Center Descriptive Analytical Dashboard in Microsoft Excel 365
Call Center Descriptive Analytical Dashboard (Dynamic) in Microsoft Excel 365 with Dynamic Array Fromulas463Discusslibrary_addExcel Based Automated Accounting System
Excel Based Automated Accounting System -Modern Excel and Dynamic Array532Discussadd_shopping_cart$40.00
by Folorunso Lala
Dynamic Arrays Financial Model
Dynamic Arrays Financial Model generates the three financial statements, valuation and charts.603Discussadd_shopping_cart$129.00
by Big4WallStreet
Corporate Finance Formulas
A Corporate Finance Formula Sheet (e.g. NPV, WACC...) to download in PDF Format.1,063Discussadd_shopping_cartfree
by Mo ModelPro
RefTreeAnalyser, Excel formula auditing made easy
The formula auditing options Excel offers have some severe limitations which RefTreeAnalyser resolves. It offers a much improved formula dependents navigation.630Discussadd_shopping_cartBXL DAN - FREE: Create dynamic array names and more
Easily name dynamic arrays. Add pseudo "Structured References" to 2 dimensional arrays w/headers making them Power Query up-loadable. Extend formatting.1,0621add_shopping_cartfree
by Craig Hatmaker
- Your Best Practice
Have a Best Practice to share?
Publish your Best Practice
Learn more about digital publishing
Last downloaded
- 20 minutes ago
Public SaaS / Software Company Operating & Valuation Model Template
Comprehensive Public Company SaaS Operating & Valuation Model5,5291add_shopping_cartfree
by AJ Ross
- 1 hour ago
High Growth Firms Valuation Model
Value tough-to-value firms, with negative earnings, high growth in revenues and few comparables1,208Discussadd_shopping_cartfree
by Aswath Damodaran
- 1 hour ago
Financial Model Detective Book: Hints and Tricks on how to Review Project Finance models
This book describes how to carry out a financial model review in a systematic and methodical way.2,218Discussadd_shopping_cart$9.50
by FinExMod
- 2 hours ago
Network Optimization: How to perform a Greenfield Analysis
This document and toolkit work to enable accurate Greenfield Scenarios, customizable and quick.420Discussadd_shopping_cartfree
by Ben Unpingco
- 2 hours ago
Free Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)1,331Discussadd_shopping_cart - 2 hours ago
Combination Model
A 22 section excel model to assess the impact on the financials of the combination of companies10,6836add_shopping_cartfree
by John P. Burns
- 2 hours ago
Excel for Financial Modeling - Functions & Formulas Practice Workbook
The Excel functions every financial modeler needs, in one interactive workbook.268Discussadd_shopping_cartfree
by FinExMod
- 2 hours ago
McKinsey's Strategic Control Map Framework Model Template
An editable PowerPoint Template Slide of McKinsey's Strategic Control Map Framework Model, to help organisations maximise their market capitalization.2,450Discussadd_shopping_cartfree
by Tim Demoures
- 2 hours ago
Acquisition Schedule - Excel Model Template
This is an Excel Template of the Acquisition Schedule2,841Discussadd_shopping_cartfree
by Wall Street Oasis
- 2 hours ago
How to use history in making an acquisition analysis
An extensive excel tool for acquisition analysis, and how to use history when making an acquisition analysis.1,285Discussadd_shopping_cartfree
by Prof. Ed Bodmer
- 4 hours ago
KISS Debt Version
KISS stands for Keep It Simple Security: Debt Version legal document template.547Discussadd_shopping_cartfree
by 500 Startups
- 4 hours ago
KISS Equity Version
KISS: Keep it Simple Security; Downloadable Equity Version Template.1,178Discussadd_shopping_cartfree
by 500 Startups
- 13 hours ago
Investment Thesis - Powerpoint Template
Powerpoint template guiding the user to create an investment strategy presentation4,303Discussadd_shopping_cartfree
by Wall Street Oasis
- 18 hours ago
Employee Overtime Tracker
Time tracking spreadsheet template, to track employee worked hours, and overtime work, weekly employee time tracking report481Discussadd_shopping_cartfree
by Nisrine LAHRECHE
- 19 hours ago
TOWS Matrix Excel Template Free Download
The model has build to helps the user to form a SWOT analysis and TOWS matrix as a strategic roadmap for the business in excel template3,546Discussadd_shopping_cartfree
by ECF Consultancy
- 20 hours ago
YouTube Investment Memo - Analysis
Overview and analysis of an Investment Memo made for YouTube1,424Discussadd_shopping_cartfree
by Miles Grimshaw
- 20 hours ago
Absorbers Excel Workbook
Absorbers Excel Workbook created to align with Chapter 4: 'Absorbers' of textbook "Rules of Thumb for Engineers."1,229Discussadd_shopping_cartfree
by Stephen Hall
- 22 hours ago
Chart of Accounts Excel Template for ERP
A structured, ready-to-use chart of accounts covering 4 major classes (Assets, Liabilities, Expenses, Revenues)57Discussadd_shopping_cartfree
by model based
- 23 hours ago
Rent vs Mortgage Excel Template
Rent vs Mortgage is an excel tool that calculates the payments to a house mortgage loan and compares it to renting.1,041Discussadd_shopping_cartfree
by Big4WallStreet
- 1 day ago
Sensitivity and Scenario Analysis Excel Template with VBA
This workbook and this manual are designed to help you build a sensitivity analysis into your models using VBA.7,5253add_shopping_cartfree
by FinExMod
