In the Chapter $11$ Applying Tableau, you compared the relative age of two companies$$ assets. In this case you continue in your role as an analyst conducting research into the relative merits of investing in one or both of these companies. This time assess the extent to which the companies invest in equity securities on a long$-$term basis. To do so$,$ you should evaluate the percentage of noncurrent assets invested in equity securities$.$ The investments in equity to noncurrent assets formula is total equity investments$/$ total noncurrent assets. Tableau Instructions: For this case, you will create a calculation and produce a bar chart of the percentage of noncurrent assets invested in equity securities ratio to allow you to compare and contrast the two companies$$ investments. Use the following steps to create the charts you$$ll need for this case: Download the Excel file $$Discount$\_$Goods$\_$Big$\_$Store$\_$Financials.$$ Open Tableau and connect to the Excel file. Click on the $$Sheet $1$ tab at the bottom of the canvas and drag $$Company$$ and $$Year$$ to the Rows shelf. Change $$Year$$ to discrete by right$-$clicking and selecting $$discrete$.$ From the same menu, select $$Filter$,$ click $$None$.$ And click only $2018,2019,2020,$ and $2021.$ Drag the "Investments in Equity Securities" and "Total Noncurrent Assets" under Measure Names to the Rows shelf. Change each to discrete. Right$-$click on the drop$-$down menu of each of the accounts and uncheck "Show Header" so they are not visible in the field. Under the Analysis tab, select Create Calculated Field. Create a measure named "Investments in Equity to Noncurrent Assets" by dragging "Total Investments in Equity Securities" from the Rows shelf to the Calculation Editor window, typing a division sign for division, and then dragging "Total Noncurrent Assets" from the Rows shelf beside it$.$ Make sure the calculation is valid and click OK$.$ Drag the newly created "Investments in Equity to Noncurrent Assets" from Measure Names to the Rows shelf. Click on the "Show Me$"$ tab in the upper right corner and select "side$-$by$-$side bars." You should now see the investments in equity securities for the four years; for each company. Add labels to the bars by clicking on "Label" under the Marks card and clicking the box "Show mark labels." Right click next to "AGG Investments in $.."$ and select Format. Click on the drop$-$down arrow of "Fields" at the top of the format box and select AGG $("$Investments in Equity to Noncurrent Assets"$).$ Format the number to a percentage with two decimal places. Change the title of the sheet to be "Investments in Equity to Noncurrent Assets Bar Chart" by double$-$clicking the tab at the bottom of the page and typing the new title. Save your work. Required: Based upon your output, answer the following questions: What is the percentage of noncurrent assets invested in equity securities for $(1)$ Big Store and for $(2)$ Discount Goods in $2021?$ Note: Round your answers to $1$ decimal place. When comparing the percentage of noncurrent assets invested in equity securities ratios over the most recent four$-$year period, is Discount Good$$s equity investment $($a$)$ generally increasing, $($b$)$ roughly the same, or $($c$)$ generally decreasing from year to year? In general, which company invests the higher amount in equity securities as a percentage of its noncurrent asset during the most recent four$-$year period? This account does not allow editing on your device. For an account with full access, contact your organization about your subscription plan.

Sign in

$f_x|32516\mathrm{.}6666666667$

$\backslash$table$[[4,$A$,$B$,$C$,$D$,$E$,$F$,$G$,$H$,$I,J$,$K$],[1,$Company,Year,$\backslash$table$[[$Cash and$],[$cash$],[$equivalents$]],\backslash$table$[[$Receivables$,],[$net$]],$Inventory,$\backslash$table$[[$Assets of$],[$discontinued$],[$operations$]],\backslash$table$[[$Prepaid$],[$expenses and$],[$other$]],\backslash$table$[[$Total current$],[$assets$]],\backslash$table$[[$accounts$],[$receivable$],[($net$)]],$Land,$\backslash$table$[[$Buildings and$],[$improvements$]]],[2,$Big Store,$2012,6,867,5,835,43,046,0,1,941,57,689,6,934,26,026,117,567],[3,$Big Store,$2013,8,705,5,624,44,469,0,1,441,60,239,5,730,25,659,115,907],[4,$Big Store,$2014,9,135,6,778,45,141,0,2,224,63,278,6,201,25,722,116,194],[5,$Big Store,$2015,7,281,6,677,44,858,460,1,909,61,185,6,728,25,098,113,373],[6,$Big Store,$2016,7,781,6,768,43,803,0,1,588,59,940,6,723,24,045,108,615],[7,$Big Store,$2017,6,550,5,937,40,714,0,1,774,54,975,6,353,22,475,101,526],[8,$Big Store,$2018,7,395,5,089,36,318,131,2,960,51,893,5,513,21,545,97,323],[9,$Big Store,$2019,7,907,4,144,32,713,140,1,473,48,032,4,617,19,988,90,290],[10,$Big Store,$2020,8,569,5,986,46,523,-211,3,625,64,491,5,065,26,931,121,653],[11,$Big Store,$2021,6,851,3,613,32,724,-150,2,958,45,996,4,800,18,748,84,688],[12,$Discount Goods,$2012,7,257,3,908,36,929,307,4,889,53,289,5,582,27,138,117,116],[13,$Discount Goods,$2013,4,871,6,294,45,044,1,431,5,160,62,800,5,101,27,222,113,701],[14,$Discount Goods,$2014,7,727,3,438,37,724,5,924,7,796,62,609,4,866,27,231,115,719],[15,$Discount Goods,$2015,10,122,1,042,28,604,3,524,8,143,51,436,2,240,27,302,135,17$