PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS (Take screenshots) La Resolana, S.A., has credit sales of $180,000 per year, with net payment terms of 30 days, which is also the average collection...

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS (Take screenshots)

La Resolana, S.A., has credit sales of $180,000 per year, with net payment terms of 30 days, which is also the average collection period. La Resolana does not currently offer any cash discounts, so customers take the 30 days to pay.

What is the average accounts receivable balance? What is the accounts receivable turnover?