Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Applying Tableau Analytics 1 4 - 0 1 ( Static ) Net Present Value Analysis [ LO 1 4 - 2 ] Skip to question
Applying Tableau Analytics Static Net Present Value Analysis LO Skip to question To complete this exercise, you will need to download and install Tableau on your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableaus short training videos can be found here. The following information applies to the questions displayed below. Jefferson Company is a merchandiser located in western North Carolina. You serve on the companys 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 based on the following net present value analysis NPV: An excel sheet containing columns and rows. Column contains entries, columns to contain dollar values except row which contains values. 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 capital is treated as a $ cash outflow now and a $ 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 $ of working capital for four years. Second, you will create a data visualization that summarizes these calculations. Download the Excel file, which you will use to create the Tableau visualization that aid your explanation. Upload the Excel file into Tableau by doing the following: Upload the Excel file into Tableau by doing the following: Open the Tableau Desktop application. On the lefthand side, under the Connect header and the To a file subheader, click on Microsoft Excel. Choose the Excel file and click Open Since the only worksheet in the Excel File is Calloway Company it will default as a selection with no further import steps needed Applying Tableau Analytics Static Part Assume the companys discount rate of as shown in cell A of the above Excel screen capture represents its opportunity cost of capital. In other words, it represents the annual return that the company could earn if it invested $ in an alternative capital budgeting proposal, rather than committing it to this projects working capital needs. Required: a Without considering the time value of money, how much return could Jefferson earn each of the next four years by investing $ elsewhere in the company? b Considering the time value of money and using the discount factors for years as shown in the above Excel screen capture what is the present value of the annual opportunity costs from requirement
Applying Tableau Analytics Static Net Present Value Analysis LO
Skip to question
To complete this exercise, you will need to download and install Tableau on your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableaus short training videos can be found here.
The following information applies to the questions displayed below.
Jefferson Company is a merchandiser located in western North Carolina. You serve on the companys 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 based on the following net present value analysis NPV:
An excel sheet containing columns and rows. Column contains entries, columns to contain dollar values except row which contains values.
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 capital is treated as a $ cash outflow now and a $ 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 $ of working capital for four years. Second, you will create a data visualization that summarizes these calculations.
Download the Excel file, which you will use to create the Tableau visualization that aid your explanation.
Upload the Excel file into Tableau by doing the following:
Upload the Excel file into Tableau by doing the following:
Open the Tableau Desktop application.
On the lefthand side, under the Connect header and the To a file subheader, click on Microsoft Excel.
Choose the Excel file and click Open
Since the only worksheet in the Excel File is Calloway Company it will default as a selection with no further import steps needed
Applying Tableau Analytics Static Part
Assume the companys discount rate of as shown in cell A of the above Excel screen capture represents its opportunity cost of capital. In other words, it represents the annual return that the company could earn if it invested $ in an alternative capital budgeting proposal, rather than committing it to this projects working capital needs.
Required:
a Without considering the time value of money, how much return could Jefferson earn each of the next four years by investing $ elsewhere in the company?
b Considering the time value of money and using the discount factors for years as shown in the above Excel screen capture what is the present value of the annual opportunity costs from requirement
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started