Thank you to whoever completes this. Also can you please include the formulas in excel. Question number 2 says "dont for
Posted: Wed Apr 27, 2022 11:23 am
Thank you to whoever completes this. Also can you please include
the formulas in excel. Question number 2 says "dont forget to
include the salvage value in year 5.
2. Complete the following timeline to compute the net present value of the future cash flows for this project. Don't forget to include the salvage value in year Year 1 2 3 $ 0 (1,750,000.00) 1.000 Net cash flow Discount Factor = 1/((1+r)^n) Present value of the cash flows Net present value 3. Use Excel's NPV function to compute the present value of the cash flows from years 1-5. Do not include the original investment at time zero. NPV of Cash Flows from Years 1-5 Deduct the cost of the investment Net present value Write an if/then statement to ACCEPT or REJECT the project based on NPV 4. Use Excel's IRR function to compute the project's internal rate of return Write an if/then statement to ACCEPT or REJECT the project based on IRR years 5. Compute the project's payback period. 5. Compute the project's accounting rate of return. F G B с D E pute the net present value of the future cash flows for this project. Don't forget to include the salvage value in year 5. Year 0 2 3 $ (1,750,000.00) 1.000 4 5 e present value of the cash flows from years 1-5. Do not include the original investment at time zero. JECT the project based on NPV project's internal rate of return JECT the project based on IRR years return.
the formulas in excel. Question number 2 says "dont forget to
include the salvage value in year 5.
2. Complete the following timeline to compute the net present value of the future cash flows for this project. Don't forget to include the salvage value in year Year 1 2 3 $ 0 (1,750,000.00) 1.000 Net cash flow Discount Factor = 1/((1+r)^n) Present value of the cash flows Net present value 3. Use Excel's NPV function to compute the present value of the cash flows from years 1-5. Do not include the original investment at time zero. NPV of Cash Flows from Years 1-5 Deduct the cost of the investment Net present value Write an if/then statement to ACCEPT or REJECT the project based on NPV 4. Use Excel's IRR function to compute the project's internal rate of return Write an if/then statement to ACCEPT or REJECT the project based on IRR years 5. Compute the project's payback period. 5. Compute the project's accounting rate of return. F G B с D E pute the net present value of the future cash flows for this project. Don't forget to include the salvage value in year 5. Year 0 2 3 $ (1,750,000.00) 1.000 4 5 e present value of the cash flows from years 1-5. Do not include the original investment at time zero. JECT the project based on NPV project's internal rate of return JECT the project based on IRR years return.