A B C D 1 Use the following table for your calculations. (See hints below - starting in row 65.) 2 3 Data 4 Annual discount Rate 5 Cash Flow Year 0 (Initial Investment) 6 Cash Flow Year 1 7 Cash Flow Year 2 8 Cash Flow Year 3 9 Cash Flow Year 4 10 Cash Flow Year 5 11 Useful Life in years 12 Residual value 0.12 (100,000) 25,000 29,000 26,000 28,000 35,000 5 0 13 14 15 Requirement 1 16 17 18 E F H J Compute the Accounting Rate of Return (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Data table or if you type the numbers in, you will be marked wrong. Enter all amounts as positive values.) Average amount Accounting Rate of 19 Average annual operating income invested Return -ARR 20 21 22 Requirement 2 23 24 25 The first period is shown as an example. 26 Compute the net present value of the investment using Excel's PV function. Note: PV function calculates the present value as a negative amount. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Data table or if you type the numbers in, you will be marked wrong.) 27 28 29 30 31 32 33 34 35 36 37 38 Period 1 2 3 4 5 Present value of net cash flows Cost of Asset Net Present Value Cash Flows (22,321)