Open Access. Powered by Scholars. Published by Universities.®

Physical Sciences and Mathematics Commons

Open Access. Powered by Scholars. Published by Universities.®

Articles 1 - 2 of 2

Full-Text Articles in Physical Sciences and Mathematics

Improving Pro Forma Analysis Through Better Terminal Value Estimates, Tom Arnold, David S. North, Roy A. Wiggins Oct 2005

Improving Pro Forma Analysis Through Better Terminal Value Estimates, Tom Arnold, David S. North, Roy A. Wiggins

Finance Faculty Publications

Basic pro forma analysis often estimates the terminal value input using a simple growing perpetuity assumption. While this assumption is easy to implement, it potentially creates an upward bias in some inputs leading to lower firm or project value outputs. The purpose of this paper is to demonstrate a more accurate way to estimate the terminal value input. Further, by allowing for multiple sales growth rates and by not restricting other input variables to necessarily grow at these same rates, a more accurate, flexible, compact, and thorough analysis is possible.


An Excel Application For Valuing European Options With Monte Carlo Analysis, Tom Arnold, Stephen C. Henry Apr 2005

An Excel Application For Valuing European Options With Monte Carlo Analysis, Tom Arnold, Stephen C. Henry

Finance Faculty Publications

By developing the basic intuition of how Monte Carlo simulation works within an Excel spreadsheet framework, this paper allows the undergraduate student to use Monte Carlo simulation techniques to price European style options without additional sophisticated software. Further, the skills and intuition developed provide the basis for much more complex simulation techniques.