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.
Please note that downloads of this working paper are for private/personal use only. Do not cite without permission.
Alexander, Maura, Tom Arnold, and Joseph Farizo. “Using Excel to Simulate a Financial Calculator and Excel TVM Formulas.” University of Richmond, (January 12, 2021): 1-10.
Click below to download supplemental content.FIN-CALCULATOR-SIMULATION-PAPER.xlsx (12 kB)
Financial Calculator Simulation in Excel