Abstract

An Excel template is developed that converts a series of cash flows on a timeline into the associated keystrokes for the TI BAII-Plus financial calculator in order to calculate NPV and IRR. Unlike videos and other presentations, the student is able to see, all at once, the keystrokes required for the financial calculator within the template after the student enters the correct inputs for how the cash flows occur through time. Many times, this crucial link of translating the cash flows through time into the financial calculator is lost. Further exercises are provided to reinforce proficiency.

Document Type

Working Paper

Publication Date

7-23-2024

Publisher Statement

Please do not cite without permission.

Click below to download supplemental content.

NPV-VISUAL-V3.xlsx (23 kB)

Share

COinS