Calculating balance sheet ratios for Ford

Now we will look at a real life example, Ford Inc, a company producing motor vehicles.

We have uploaded a dataset: balance_sheet with the data for Ford Inc's most recent balance sheet. The sales and cost of sales figures have been provided for 2017 with the Key_Figures_Memodataset.

We are only interested in one line on the balance sheet, the Receivables (another name for Debtors), and therefore need to create a filter for this.

Information on important balance sheet ratios:

\(Debtor Days = \frac{Ending\,Balance\,Debtors}{Sales} \times Days\,in\,Financial\,Year\)

The balance_sheet and sales figures are provided.

Set the receivables_metric to a list containing 'Receivables'.
Filter the balance_sheet for rows where metric is in receivables_metric.

Take Hint (-15 XP)

Exercise

Calculating balance sheet ratios for Ford

Instructions 1/2