Business Finance Homework Help

DeVry Return Accounting Rate & Following Investment Payback Period Worksheet

 


Requirements: Using Microsoft Excel to calculate and analyze the Net Present Value (NPV), Internal Rate of Return (IRR), Accounting Rate of Return and Payback Period of the following investment (chapter 20, text).

Initial investment

$ 12,950

Estimated life

10 years

Annual cash inflows

$ 3,000

Cost of capital

12%