Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Calculate Sunnyland Snacks' receivables turnover and average collection period for 2021 and 2020. Receivables turnover, 2021 Receivables turnover, 2020 Average collection period, 2021 Average

image text in transcribedimage text in transcribedimage text in transcribed a. Calculate Sunnyland Snacks' receivables turnover and average collection period for 2021 and 2020. Receivables turnover, 2021 Receivables turnover, 2020 Average collection period, 2021 Average collection period, 2020 b. Indicate whether each of the receivables t period is better or worse in 2021. Receivables turnover Average collection period times times days Accounts Receivable Accounts Payable Cash Cost of Goods Sold Interest Expense Interest Income Interest Payable Interest Receivable Inventory Notes Receivable Sales a. Calculate Sunnyland Snacks' receivables turnover and average collection period for 2021 and 2020. Receivables turnover, 2021 Receivables turnover, 2020 Average collection period, 2021 Average collection period, 2020 b. Indicate whether each of the receivables t period is better or worse in 2021. Receivables turnover Average collection period Accounts Receivable Accounts Payable Cash Cost of Goods Sold Interest Expense Interest Income Interest Payable Interest Receivable Inventory Notes Receivable Sales Function: IF, AVERAGE; Formula: Divide; Cell Referencing Using Excel to Calculate Ratios PROBLEM Sunnyland Snacks Inc. reported the following selected information (in thousands) for the three years ended December 31, 2021, 2020, and 2019: Trade receivables (gross) Allowance for expected credit losses Sales \begin{tabular}{|c|c|c|c|c|c|} \hline & 2021 & r & 2020 & r & 2019 \\ \hline$ & 125,000 & $ & 118,200 & $ & 125,600 \\ \hline & 2,100 & & 1,900 & & 3,200 \\ \hline & 4,520,400 & & 4,300,600 & & 3,940,500 \\ \hline \end{tabular} Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. a. Calculate Sunnyland Snacks' receivables turnover and average collection period for 2021 and 2020. Receivables turnover, 2021 Receivables turnover, 2020 Average collection period, 2021 Average collection period, 2020 b. Indicate whether each of the receivables turnover and average collection period is better or worse in 2021. Receivables turnover Average collection period

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Scientist Audits The Earth

Authors: Stuart L Pimm

1st Edition

0813535409, 978-0813535401

More Books

Students also viewed these Accounting questions