Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 4 of 4
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.
Visual Presentation Of Mirr And Mnpv Calculations, Tom Arnold, Joseph Farizo
Visual Presentation Of Mirr And Mnpv Calculations, Tom Arnold, Joseph Farizo
Finance Faculty Publications
Project cash flows and modified cash flows are presented in an illustrative graphic within Excel for the live or virtual classroom. Further, the graphic computes and displays the relevant modified internal rate of return (MIRR) and modified net present value (MNPV), with associated formulas. The presentation allows for a discussion of the reinvestment assumption attributed to the internal rate of return (IRR) and the net present value (NPV) calculations.
Is Fed Policy Still Relevant For Investors?, C. Mitchell Conover, Gerald R. Jensen, Robert R. Johnson, Jeffrey M. Mercer
Is Fed Policy Still Relevant For Investors?, C. Mitchell Conover, Gerald R. Jensen, Robert R. Johnson, Jeffrey M. Mercer
Finance Faculty Publications
Using 38 years of data, we show that U.S. monetary policy has had, and continues to have, a strong relationship with security returns. Specifically, we find that U.S. stock returns are consistently higher and less volatile during periods when the Federal Reserve is following an expansive monetary policy. Further, firms considered to be more sensitive to changes in monetary conditions, such as small firms and cyclicals, exhibit monetary-policy-related return patterns that are much more pronounced than average. Lastly, the influence of U.S. monetary policy is shown to be a global phenomenon, as international indices have return patterns similar to those …