Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 2 of 2
Full-Text Articles in Business
Using Excel To Simulate A Financial Calculator And Excel Tvm Formulas, Maura Alexander, Tom Arnold, Joseph Farizo
Using Excel To Simulate A Financial Calculator And Excel Tvm Formulas, Maura Alexander, Tom Arnold, Joseph Farizo
Finance Faculty Publications
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.
Visual Timelines In Excel To Illustrate Tvm Calculations, Maura Alexander, Tom Arnold, Joseph Farizo
Visual Timelines In Excel To Illustrate Tvm Calculations, Maura Alexander, Tom Arnold, Joseph Farizo
Finance Faculty Publications
Time value of money calculations are illustrated through developing a timeline with cash flow graphics in Excel. The cash flow graphics can be used in the live or virtual classroom and as a resource for students outside of the classroom. Further, the graphic is readily adjustable to different scenarios making it useful for multiple time value of money topics.