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

Variance and Risk II – Covariance

September 5, 2017 Pat Leave a comment

What is Covariance? Covariance is simply the variance between the observations of two random variables. It should be clear both…

Continue Reading →

Posted in: Foundations, Statistical Methods Filed under: Excel, Finance 101, Portfolio Management, Statistics

Monte Carlo – Simulating Opus Banks Stock Price II

July 31, 2017 Pat Leave a comment

Following up on Part I, we’re going to kill two birds with one stone and learn both how to simulate…

Continue Reading →

Posted in: Capital Markets, Foundations Filed under: Excel, Monte Carlo, VBA

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

ARIMA Models – Part I – Positive Autocorrelation

July 22, 2017 Pat Leave a comment

ARIMA models require some study and application to thoroughly understand. The rewards are well worth it though, if you master…

Continue Reading →

Posted in: Foundations, Statistical Methods Filed under: ARIMA, Excel, Finance 101, Univariate

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

Variance and Risk – Basic Foundations

July 20, 2017 Pat Leave a comment

Risk adjusted returns of investments and variance analysis used in corporate finance and accounting will both depend on understanding some…

Continue Reading →

Posted in: Foundations, Risk Management, Statistical Methods Filed under: Excel, Finance 101, Statistics

Generating normal distributions in Excel

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

Post navigation

Page 1 of 2
1 2 Next →

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 © 2022 440 Analytics