In a business operation, you have a decision to make in purchasing a set of storage bins that have a 10-year life, an investment that needs to earn 11% and initially cost $250,000 up-front to fund. Develop a TVM table.

Determine the (1) NPV, (2) IRR and (3) is this a good investment and why? Input your (1) total NPV and IRR and be sure to ID if the decision is good or not and why.

Annually the following are the net cash flow values that would come back in to potentially pay for the investment. These are:

Time 0 = today = ($250,000)

Time 1-10 are:

1 45000

2 55000

3 60000

4 70000

5 40000

6 35000

7 30000

8 30000

9 30000

10 40000