No excel working out

2uestion 5 (10 marks) Che parts a ), b), and c) below are independent questions which do not relate to each other. a) A company is considering investing in Project X. The project requires an initial investment of $780,000 and is expected to generate $23,000 in one year, $45,000 in 2 years, and $182,000 at the end of each year from the end of year 5 to the end of year 13 inclusive. The cost of capital is 10% p.a. effective. Using this information answer parts i) and ii) below i) Calculate the net present value (NPV) of the project. You must use the annuity formulas when possible. (Round your answer to the nearest cent). (3 marks) ii) According to your calculation above, should the company invest in Project X? Provide your reason. (1 mark) b) Project Swan requires an initial investment of $550,000 and is expected to generate the following cash flows at year-end. [ Calculate the payback period in years for the project. Round your answer to 2 decimal places. (2 marks) c) Project A and Project B are two mutually exclusive projects with conventional cash flows. The internal rate of return (IRR) for Project A is 17.22%. The internal rate of return (IRR) for project B is 23.92%. The net present value (NPV) for each project are calculated at 5% p.a. effective and 10% p.a. effective cost of capital as shown below: Four companies are considering investing in the projects. The cost of capital for each company is listed below: Pick one piece of advice from the list below for each company. Write the letter in the "Advice" column. (4 marks) A. Project A Only B. Project B Only C. Both Projects D. Neither Projects E. Not Sure. More information is required. 2uestion 5 (10 marks) Che parts a ), b), and c) below are independent questions which do not relate to each other. a) A company is considering investing in Project X. The project requires an initial investment of $780,000 and is expected to generate $23,000 in one year, $45,000 in 2 years, and $182,000 at the end of each year from the end of year 5 to the end of year 13 inclusive. The cost of capital is 10% p.a. effective. Using this information answer parts i) and ii) below i) Calculate the net present value (NPV) of the project. You must use the annuity formulas when possible. (Round your answer to the nearest cent). (3 marks) ii) According to your calculation above, should the company invest in Project X? Provide your reason. (1 mark) b) Project Swan requires an initial investment of $550,000 and is expected to generate the following cash flows at year-end. [ Calculate the payback period in years for the project. Round your answer to 2 decimal places. (2 marks) c) Project A and Project B are two mutually exclusive projects with conventional cash flows. The internal rate of return (IRR) for Project A is 17.22%. The internal rate of return (IRR) for project B is 23.92%. The net present value (NPV) for each project are calculated at 5% p.a. effective and 10% p.a. effective cost of capital as shown below: Four companies are considering investing in the projects. The cost of capital for each company is listed below: Pick one piece of advice from the list below for each company. Write the letter in the "Advice" column. (4 marks) A. Project A Only B. Project B Only C. Both Projects D. Neither Projects E. Not Sure. More information is required