Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help Use data table function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%,

help
image text in transcribed
image text in transcribed
image text in transcribed
Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 3% 1 -2 53 64 65 66 4% 5% 6% 7% 8% 9% 10% 11% 12% 67 68 69 70 71 72 73 74 75 76 77 78 79 A B D 1 2 Question 2: (60%) Your firm is considering two projects with the following cash flows. 3 4 WACC 12% 12% 5 year 0 Project A 6 -55,000 25,000 19,000 17,000 11,000 10,000 Project B -70,000 25,000 21,000 19,000 14,000 12,000 8 2 9 3 10 4 11 5 12 a. Calculate NPV and IRR for both projects 13 (10%) 14 NPV 15 IRR 7,233.34 (1,707.30) 11% 18% 16 17 b Spin button (20%) Calculate the NPV for project A again then create a spin button to change the value of WACC to get various NPVs accordingly. Limit the WACC value from 5% to 15% with 18 1% incremental. 19 20 21 Project A year Faste ili nsert B I U A $ % 9 68 -28 Format as Table Cell Styles Delete -7 x fx b Spin button (20%) Format D H Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 -70,000 -80,000 -90,000 . 2 3 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 5 56 57 69 70 71 72 73 74 75 76 77 28 79 81 83 Sheet3 Sheet2 new + Shooti Pivot A Pivot B Pivot Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 3% 1 -2 53 64 65 66 4% 5% 6% 7% 8% 9% 10% 11% 12% 67 68 69 70 71 72 73 74 75 76 77 78 79 A B D 1 2 Question 2: (60%) Your firm is considering two projects with the following cash flows. 3 4 WACC 12% 12% 5 year 0 Project A 6 -55,000 25,000 19,000 17,000 11,000 10,000 Project B -70,000 25,000 21,000 19,000 14,000 12,000 8 2 9 3 10 4 11 5 12 a. Calculate NPV and IRR for both projects 13 (10%) 14 NPV 15 IRR 7,233.34 (1,707.30) 11% 18% 16 17 b Spin button (20%) Calculate the NPV for project A again then create a spin button to change the value of WACC to get various NPVs accordingly. Limit the WACC value from 5% to 15% with 18 1% incremental. 19 20 21 Project A year Faste ili nsert B I U A $ % 9 68 -28 Format as Table Cell Styles Delete -7 x fx b Spin button (20%) Format D H Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 -70,000 -80,000 -90,000 . 2 3 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 5 56 57 69 70 71 72 73 74 75 76 77 28 79 81 83 Sheet3 Sheet2 new + Shooti Pivot A Pivot B Pivot

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Changing Academics Quality Audit And Its Perceived Impact

Authors: Ming Cheng

1st Edition

3639134273, 978-3639134278

More Books

Students also viewed these Accounting questions

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago