Skip to content

440 Analytics

Financial analysis and models that everyone can understand and use
  • What’s New
  • Categories
  • Glossary
  • Good Reads
  • Downloads

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

Financial Statements – The Very Basics

Pat Leave a comment

I think the balance sheet is probably the easiest of the major financial statements to understand, so we’ll begin there.…

Continue Reading →

Posted in: Foundations, Fundamental Analysis Filed under: Finance 101

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

Monte Carlo I – Overview

Pat Leave a comment

I confess that Monte Carlo methods confused and to a certain extent intimidated me for a long time. It was…

Continue Reading →

Posted in: Foundations, Fundamental Analysis Filed under: 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

Technical Analysis – What is it?

July 21, 2017 Pat Leave a comment

I’ve heard technical analysis explained and described the following ways: “TA is the analyst attempting to read the mind of…

Continue Reading →

Posted in: Capital Markets, Foundations Filed under: Finance 101, TA

Value at Risk (VaR) Part 1 – An Introduction

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 2 of 3
← Previous 1 2 3 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 © 2023 440 Analytics