An Excel 2010 worksheet that allows you to fill in the intial investment and cash flows information for up to four five year investments.
The worksheet then shows on separate tabs the Payback period; Average Rate of Return (ARR) and Net Present Value (NPV) of the investments.
The NPV discount rate can be chosen (between 1% & 15%) with a discount factor to 3d.p. used to complete the calcuations.
This can be used to allow the generation and easy checking unlimited practice scenarios.
The worksheet then shows on separate tabs the Payback period; Average Rate of Return (ARR) and Net Present Value (NPV) of the investments.
The NPV discount rate can be chosen (between 1% & 15%) with a discount factor to 3d.p. used to complete the calcuations.
This can be used to allow the generation and easy checking unlimited practice scenarios.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00