Using Excel to Simulate a Financial Calculator and Excel TVM Formulas

10 Pages Posted: 18 Feb 2021

See all articles by Maura Alexander

Maura Alexander

affiliation not provided to SSRN

Tom Arnold

University of Richmond - E. Claiborne Robins School of Business

Joseph Farizo

University of Richmond - E. Claiborne Robins School of Business

Date Written: January 12, 2021

Abstract

Excel is used to build a simulation of the TI BAII-Plus financial calculator to illustrate the N, I/Y, PV, PMT, and FV inputs. Unlike other financial calculator simulators, this template also displays the corresponding Excel functions to aid in transitioning the student to using Excel for financial analysis.

Keywords: Excel, Financial Calculator, Excel financial functions

JEL Classification: G00, G10, G20

Suggested Citation

Alexander, Maura and Arnold, Thomas M. and Farizo, Joseph, Using Excel to Simulate a Financial Calculator and Excel TVM Formulas (January 12, 2021). Available at SSRN: https://ssrn.com/abstract=3764999 or http://dx.doi.org/10.2139/ssrn.3764999

Maura Alexander

affiliation not provided to SSRN

Thomas M. Arnold (Contact Author)

University of Richmond - E. Claiborne Robins School of Business ( email )

102 UR Drive
University of Richmond, VA 23173
United States
804-287-6399 (Phone)
804-289-8878 (Fax)

Joseph Farizo

University of Richmond - E. Claiborne Robins School of Business ( email )

Richmond, VA 23173
United States

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
166
Abstract Views
800
Rank
375,160
PlumX Metrics