- Please Help With An Explanation Using Excel 1 (36.21 KiB) Viewed 28 times
Please help with an explanation using excel.
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Please help with an explanation using excel.
Please help with an explanation using excel.
QUESTION 1 0 4 8 9 Suppose you are considering the two mutually exclusive projects summarised below: Year 11 2 31 5 6 A -4001 5501 5001 450 400 350 300 B -1100 3501 385 4201 455 490 525 7 250 560 200 595 1501 6301 10 100 665 a. In your spreadsheet, plot the NPV curves and identify the switching discount rate. Be sure to fully label your diagram including any relevant intercepts, axis etc. Switching discount rate = % Provide your answer to two decimal places. Do not include % in your answer. b. If the discount rate is 12%, which project should we undertake? Explain your answer in detail = Project c. In your spreadsheet, provide an intuitive explanation why we would switch between projects. Answer = (provide up to 5 key words) Provide a detailed explanation in your spreadsheet of the comparison of the projects. Marks will be deducted if you do not explain your answers.
QUESTION 1 0 4 8 9 Suppose you are considering the two mutually exclusive projects summarised below: Year 11 2 31 5 6 A -4001 5501 5001 450 400 350 300 B -1100 3501 385 4201 455 490 525 7 250 560 200 595 1501 6301 10 100 665 a. In your spreadsheet, plot the NPV curves and identify the switching discount rate. Be sure to fully label your diagram including any relevant intercepts, axis etc. Switching discount rate = % Provide your answer to two decimal places. Do not include % in your answer. b. If the discount rate is 12%, which project should we undertake? Explain your answer in detail = Project c. In your spreadsheet, provide an intuitive explanation why we would switch between projects. Answer = (provide up to 5 key words) Provide a detailed explanation in your spreadsheet of the comparison of the projects. Marks will be deducted if you do not explain your answers.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!