Page 1 of 1

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
by answerhappygod
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.
Thank You To Whoever Completes This Also Can You Please Include The Formulas In Excel Question Number 2 Says Dont For 1
Thank You To Whoever Completes This Also Can You Please Include The Formulas In Excel Question Number 2 Says Dont For 1 (111.52 KiB) Viewed 29 times
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.