Part III

Use the following key figures for Buzz Co$.$ and Lightyear Co$.$

$($$ in millions$)$

Buzz Co$.$ Lightyear Co$.$

Current year Prior year

Current year Prior

year

Accounts receivable $ $123,685,$$$117,760$

$ $122,926$$

$123,186$

Net sales

$1,562,111$

$1,274,472$

$1,213,837$

$1,228,623$

Using Excel, compute days sales uncollected $($rounded to one decimal$)$ for the current year and the year prior year for Buzz and Lightyear. See Exhibit $6\mathrm{.}8$ in your text.

Use the figures provided and do not add $\text{'}000\text{'}$s$.$ You will be graded on the formulas you create in Excel. Typing in results will result in zero points.

Organize your work in Excel so that it's easy to read $-$ providing headings, appropriate font sizes, and so forth.

Using Word, which company had more success collecting receivables. Explain,

Use professional terminology and format in your explanation.