This document sets forth a template spreadsheet to calculate the Internal Rate of Return (IRR) on security investments. The investor should enter data about each investment, such as the time frame, yearly fees, entry cost, exit cost, and terminal value. The investor must then insert expected return figures, an investment schedule, and various factors to calculate the weighted average cost of capital, such as the beta, market return, and risk free return. The worksheet then calculates important financial indicators so that the investor can make informed investment choices.
Get Unlimited Access to Our Complete Business Library