can some body help, Im confuse with this problem
Required Information The following information apples to the questions displayed below Jefferson Company is a merchandiser located in western North Carolina You serve on the company's capital budgeting review committee whose purpose is to evaluate all capital investment proposals and then provide an accept or reject recommendation to the CEO. Recently, your committee provided a "reject" recommendation on a specific proposal besed on the following net present value analysis (NPV) i hu 50.0001 Wp $ 100.000 3 170.000 5 120.000 30.000 120.000 5 Pret 50.000 w $ 100.000 + S $7.000 5.170.000 $120.000 $ 10.000 50.000 ON 100000 03 6.57810 $7.000 100.000 19517 5 1732 The group of employees that submitted this request is disappointed that you provided a "reject recommendation for its proposal. The group does not understand why working capitais treated as a $100.000 cash outflow now and a $100.000 cash inflow at the end of the project. To explain your accounting for working capital in the NPV analysis shown above, you decide to proceed in two steps. First, you will explain how to calculate the annual opportunity costs that arise from tying up $100.000 of working capital for four years. Second, you will create a data visualization that summarizes these Calculations Download the Excel file, which you wn use to create the Tableau visualization that is your explanation Upload the Excel file into Tableau by doing the following 1 Open the Tableau Desktop application 2. On the len-hand side, under the Connect header and the To a file sub header click on "Microsoft Excel 4. Since the only worksheet in the Excel Fleis Calloway Company will default as a selection with no further import steps needed Assume the company's discount rate of 20% (as shown in cel A9 of the above cel screen capture represents its opportunity cost of capital in other words, it represents the annual return that the company could earn it invested $100.000 in an alternative capital budgeting proposal rather than committing it to this project's worlding capital needs Required: 1e. Without considering the time value of money, how much return could Jefferson cam each of the next four years by investing 16. Considering the time value of money and using the discount factors for years 14 as shown in the above Excel screen captures what is the present value of the annual opportunity costs from requirement 12 Anna oportunity cost fundiscounted 16. Present value of annual opportunity cost Yeart (16.857 Year 2 Year 13.08013 11,543 Year 2045 Required Information The following information apples to the questions displayed below Jefferson Company is a merchandiser located in western North Carolina You serve on the company's capital budgeting review committee whose purpose is to evaluate all capital investment proposals and then provide an accept or reject recommendation to the CEO. Recently, your committee provided a "reject" recommendation on a specific proposal besed on the following net present value analysis (NPV) i hu 50.0001 Wp $ 100.000 3 170.000 5 120.000 30.000 120.000 5 Pret 50.000 w $ 100.000 + S $7.000 5.170.000 $120.000 $ 10.000 50.000 ON 100000 03 6.57810 $7.000 100.000 19517 5 1732 The group of employees that submitted this request is disappointed that you provided a "reject recommendation for its proposal. The group does not understand why working capitais treated as a $100.000 cash outflow now and a $100.000 cash inflow at the end of the project. To explain your accounting for working capital in the NPV analysis shown above, you decide to proceed in two steps. First, you will explain how to calculate the annual opportunity costs that arise from tying up $100.000 of working capital for four years. Second, you will create a data visualization that summarizes these Calculations Download the Excel file, which you wn use to create the Tableau visualization that is your explanation Upload the Excel file into Tableau by doing the following 1 Open the Tableau Desktop application 2. On the len-hand side, under the Connect header and the To a file sub header click on "Microsoft Excel 4. Since the only worksheet in the Excel Fleis Calloway Company will default as a selection with no further import steps needed Assume the company's discount rate of 20% (as shown in cel A9 of the above cel screen capture represents its opportunity cost of capital in other words, it represents the annual return that the company could earn it invested $100.000 in an alternative capital budgeting proposal rather than committing it to this project's worlding capital needs Required: 1e. Without considering the time value of money, how much return could Jefferson cam each of the next four years by investing 16. Considering the time value of money and using the discount factors for years 14 as shown in the above Excel screen captures what is the present value of the annual opportunity costs from requirement 12 Anna oportunity cost fundiscounted 16. Present value of annual opportunity cost Yeart (16.857 Year 2 Year 13.08013 11,543 Year 2045
