Step Instructions

$1$ Go to the $$Netflix Growth$$ worksheet. Note: The worksheet is blank as you will be building it$.$

$2$ "Enter the following data in the indicated cells:

$$ A$1$: Netflix

$$ B$2$: Value in Thousands of USD

$$ B$4,$ C$4,$ D$4=2018,2019,$ Growth$\%$

$$ A$5$:C$5=$ Revenue, $15794341,20156447$

$$ A$6$:C$6=$ Net Income, $1211242,1866916"$

$3$ In column D$,$ use a formula to calculate the firm's revenue and net income growth rate from $2018$ to $2019.$ Note: Growth rate is a simple calculation of new rate minus the old rate divided by the old rate.

$4$ Format the growth rates as percentage values with one decimal.

$5$ Format dollar values in Accounting format, US Dollars, no decimals.

$6$ Bold everything that is not a number.

$7$ Right justify the header Growth $\%$ in D$4.$

$8$ Autofit column width for cells in rows $4$ through $6.$

$9$ Save the worksheet as Netflix Growth$\_$Answer

$10$ Go to the Drexler worksheet. Note: This $($fictional$)$ partially complete worksheet shows Product, Cost, and the number of that Product that has been Manufactured.

$11$ Use this partial data to complete each of the following steps. First, In D$5,$ calculate Expenses as Cost of an item multiplied by the quantity Manufactured.

$12$ In D$5,$ calculate Expenses as Cost of an item multiplied by the quantity Manufactured.

$13$ Copy the formula in D$5$ down through D$8.$

$14$ In G$5,$ calculate Revenue as items Sold multiplied by Price.

$15$ Copy the formula in G$5$ down through G$8.$

$16$ In H$5,$ calculate Profit$/$Loss for Purple Leather Pants as that product's Revenue minus Expenses.

$17$ Copy the formula in H$5$ down through H$8.$

$18$ Total the units Manufactured in C$9.$

$19$ Total the Expenses in D$9.$

$20$ Total the number of items Sold in F$9.$

$21$ Total the Revenue in G$9.$

$22$ Total the Profit$/$Loss in H$9.$

$23$ Add the label 'AVERAGE' in cell A$10.$

$24$ In B$10,$ use a function to calculate Average Cost in B$5$ through B$8.$

$25$ In E$10,$ use a function to calculate Average Price of E$5$ through E$8.$

$26$ In F$10,$ use a function to calculate the Average number of units Sold in F$5$ through F$8.$