Tobleou Instructlons:

For this case, you will create a calculation and produce the debt to equity ratio to allow you to compare and contrast the two

companies.

Follow these steps to create the charts you'll use for this case:

Download the Excel file $"$GPS$\_$Tru$\_$Financials."

Open Tableau and connect to the Excel file.

Starting on the Sheet $1$ tab, drag "Company" and "Year" to the Columns shelf. Change "Year" to ;discrete by right$-$clicking and

selecting "Discrete." Select "Show "Filter"" and uncheck all the years except $2015-2021.$ Click $"$OK$."$

Drag "Capital lease liability". "Lease liability $-$ operating lease". "Lease liability $-$ finance lease" under Measure Names into the

Rows shelf.

Add labels to the bars by clicking on "Label" under the Marks card and clicking the box "Show mark label." Format the labels

according to preference and edit the color of the years on the Marks card if desired by dragging "Year" on to the Color Marks

card from the filter card.

Change the title of the sheet to be "Lease Liability" by double$-$clicking the tab at the bottom of the page and typing the new title

Click on the New Worksheet tab on the lower left $("$Sheet $2"$ should open$)$ and follow the procedure outlined above for the

company and year.

Drag "Total liabilities" under Measure Names to the Rows shelf. Change to "Discrete" data and uncheck "Show Header" to

eliminate the number from view.

Drag "Total shareholders" equity" under Measure Names to the Rows shelf, change to "Discrete" data, and uncheck "Show

Header:"

Create a calculated field by clicking the "Analysis" tab at the top of the screen and selecting "Create Calculated field." Name the

calculation "Debt to Equity Ratio." In the Calculation Editor window, drag "Total liabilities" from the Rows shelf, typing a division

sign for division, then drag "Total shareholders" equity" from the Rows shelf. Make sure the calculation is valid and click OK$.$

Drag the newly created "Debt to Equity Ratio" to the Rows shelf. Click on the "Show Me$"$ and select "side$-$by$-$side bars." Add

labels to the bars by clicking on "Label" under the Marks card and clicking the box "Show mark labels." Format the labels

according to preference and edit the color on the Marks card if desired.

Change the title of the sheet to be "Debt to Equity Ratio" by double$-$clicking the tab at the bottom of the page and typing the ne

title.

Format all other labels according to preference.

Save your work.

Requlred:

Based upon your output, answer the following questions:

A$.$ Is GPS$\text{'}$s pattern of leasing facilities as evidenced by its capital lease liability $($a$)$ increasing. $($b$)$ decreasing, or $($c$)$ remaining

relatively the same over the period $2015-2018?$

B$.$ What is the capital lease liability for GPS in $2020?$

C$.$ Is Tru's operating lease liability $($a$)$ increasing. $($b$)$ decreasing, or $($c$)$ remaining relatively the same over the period $2019-2021?$

D$.$ Is GPS technically in violation of its debt covenant during the period $2019-2021?$

Answer is not complete.