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.
Sentiment-Scaled Capm And Market Mispricing, John A. Doukas, Xiao Han
Sentiment-Scaled Capm And Market Mispricing, John A. Doukas, Xiao Han
Finance Faculty Publications
This study explores the conditional version of the capital asset pricing model on sentiment to provide a behavioural intuition behind the value premium and market mispricing. We find betas (β) and the market risk premium to vary over time across different sentiment indices and portfolios. More importantly, the state β derived from this sentiment-scaled model provides a behavioural explanation of the value premium and a set of anomalies driven by mispricing. Different from the static β-return relation that gives a flat security market line, we document upward security market lines when plotting portfolio returns against their state βs and portfolios …