Search results: countifs

A REFERENCE SHEET on why and how Finance Models are constructed

This model estimates the probability of defaults on financial instruments, for financing reporting purpose.

Comparable Companies Analysis Excel Template- IB & PE Standards

A Trading Multiples/Comparables excel file with detailed company and industry margin analysis, growth analysis, and valuations analysis template.

DCF and Comparables Valuation Model (Capital IQ Plug-in) for TMX Group Limited.

Free Simple Excel bookkeeping spreadsheet

This tool can be used for calculating the size and voltage drop for bus bar.

MS Excel Spreadsheet helping you to easily calculate fault current.

Explains array formulas and shows how they can be used in financial analysis

Explains the basics of building professional quality charts in Excel

A set of Excel VBA macros aimed at enhancing user interface

Connecting Excel to Outlook programmatically

This post explains how to run full Monte Carlo analysis in Excel without macros

An Excel utility to draw indifference curves for two inputs in a financial model

Financial models use dates and timelines very extensively, so it is important to become familiar with relevant functions

The publication explains the general principles of building financial models with practical examples

Multiple round cap table with investor returns

A template to perform cost-volume-profit (CVP, or breakeven) analysis

A set of techniques for working with data in Excel

An overview of form controls, ActiveX controls and hyperlinks used in financial models.