(Please write out correct answer and whether it's A,B,C or D).

A capital investment under consideration requires an initial investment of $100,000. The asset purchased will be used for 5 years. Depreciation is computed using straight-line, with no residual value. Income from operations, depreciation expense, and net cash inflows for each of the five years is: Year Net cash inflows 11 $40,000 2 35,000 3 55,000 4 80,000 5 62,000 Which is the correct way to enter this information into an Excel spreadsheet to compute internal rate of return? O A 1 40,000 2 35,000 3 55,000 4 80,000 5 62,000 6 100,000 1 100,000 2. -40,000 3 -35,000 4 -55,000 5 -80,000 6 -62,000 A 1 62,000 2 80,000 3 55,000 4 35,000 5 40,000 6 A 1 - 100,000 2 40,000 3 35,000 4 55,000 5 80,000 6 62,000