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.
Recommended Citation
Arnold, Tom, C., Summer Liu, Cassandra D. Marshall. "Converting NPV and IRR Cash Flows into a Financial Calculator Using an Excel Template," University of Richmond Robins School of Business, (2024): 1-18.