Tutorial: Discounted Cash Flow

Level:

Intermediate

Requires:

Any Edition of Business Functions

Contents

Introduction

n This tutorial introduces the DCF functions of the Basic Edition.

n We start by quickly looking at NPV calculations, pointing out where Excel's functions may not be quite what you want.

n We go on to introduce the various families of DCF function.

n Note that this tutorial contains functions contained in the Excel Analysis Kit, which you should ensure is installed through Tools/AddIns.