For the cash flow data provided above the three mutually exclusive investment alternatives, please answer the following questions showing all your work on your own paper. please number each of your answers carfully and show every step used in the analysis note row 23-64 are omitted for space considerations however the amounts in the missing rows are the same with the exception oth the discounted individual cash flows colums. these values represent the present value of the net annual benefit at the MARR provided in Cell B8
1. How was the amount in cell E20 determined?
2. How was the amount in cell E21 determined?
3. How was the amount in cell E22 determined?
4. is option 1 an acceptable alternative at a MARR of 10% why or why not
5. is option 2 an acceptable alternative at a MARR of 10% why or why not
6. Assume the data above was a pre-tax cash flow what would be the effect on the cash flow data ONLY as a result of the depreciation only: if you were allowed to use the SL depreciation method for 50 years? if you used the DB method of Depreciation ? Provide at least on example of the amount the cash flow would change for both depreciation methods
7. Show the work needed to calculate the values in cell B71
8. show the work needed to calculate the values in cell B69
9. is option 1 an acceptable altenative at MARR of 15% why or why not ?
10. Is option 2 an acceptable alternative at a MARR of 15% why or why not?