Skip to content
440 Analytics
Financial analysis and models that everyone can understand and use
  • What’s New
  • Categories
  • Glossary
  • Good Reads
  • Downloads

Tag: Excel Functions

Monte Carlo – Simulating Opus Banks Stock Price I

July 30, 2017 Pat Leave a comment

In parallel to our ongoing series introducing different Monte Carlo techniques I thought it would be fun to incorporate more…

Continue Reading →

Posted in: Capital Markets, Foundations Filed under: Excel, Excel Functions, Finance 101, Monte Carlo

Monte Carlo III – A Simple Example with VBA

July 29, 2017 Pat Leave a comment

If you haven’t read the first two posts introducing the concept of Monte Carlo simulations and running through a basic,…

Continue Reading →

Posted in: Code & Automation, Foundations, Risk Management Filed under: Excel, Excel Functions, Finance 101, Monte Carlo, VBA

Monte Carlo II – A Simple Example

July 26, 2017 Pat Leave a comment

For a quick overview of Monte Carlo simulations, I recommend you check out Part I. Example: Suppose we work for…

Continue Reading →

Posted in: Foundations, Fundamental Analysis Filed under: Excel, Excel Functions, Finance 101, Monte Carlo

NPV and IRR – Criteria for Making an Investment

July 23, 2017 Pat Leave a comment

The two most common measures applied to proposed projects (for everything from expansion to replacing old equipment) are net present…

Continue Reading →

Posted in: Foundations, Fundamental Analysis Filed under: Excel, Excel Functions, Finance 101, IRR, NPV

Value at Risk (VaR) Part 1 – An Introduction

July 21, 2017 Pat Leave a comment

VaR, or Value at Risk is another one of many concepts in finance that sounds much more intimidating to some…

Continue Reading →

Posted in: Foundations, Risk Management Filed under: Excel, Excel Functions, Finance 101

Generating normal distributions in Excel

July 20, 2017 Pat Leave a comment

Arguably the simplest approach towards generating normal distributions using pseudo-random numbers is through a combination of RAND and Norm.S.Inv. Norm.S.Inv…

Continue Reading →

Posted in: Foundations Filed under: Excel, Excel Functions, Finance 101

Building Frequency Distributions Part I – COUNTIF/S

Pat Leave a comment

When it comes to Excel, the phrase “there’s more than one way to skin a cat” applies in almost every…

Continue Reading →

Posted in: Foundations Filed under: Excel, Excel Functions, Finance 101

Using Excel Random Numbers in Uniform Distributions

Pat Leave a comment

Excel can be used to return pseudo random numbers using the RAND function. This function has no arguments, and simple…

Continue Reading →

Posted in: Foundations Filed under: Excel, Excel Functions, Finance 101

Recent Posts

  • Swaytest
  • Unusual and Exotic Futures – Quick Summaries
  • Intro Python 1: Functions & String Formatting

Archives

  • May 2018
  • March 2018
  • October 2017
  • September 2017
  • August 2017
  • July 2017
Copyright © 2023 440 Analytics