In this computer lab assignment, you will use Microsoft Excel to construct an aging schedule of

accounts recelvable and make the year$-$end adjusting entry to estimate future bad debt expense.

See lilustration $5-6$ on page $226$ of our text for a sample completed aging schedule.

Points Passible: $10.$ To recelve full credit, use cell references and Excel formulas In every yellow cell $($except H$55)$ and the Name of the Accounts in your Journal entry Save your file with your name in the file name

Submit the file in Canvas

Use the information on the Given Data worksheet to complete this assignment.

ACCTA $201$ Lab $4$

Instructor: Jeanette Fohn

In this computer lab assignment, you will use Microsoft Excel to construct an aging schedule of

accounts receivable and make the year$-$end adjusting entry to estimate future bad debt expense.

See inustration $\backslash (5-6\backslash )$ on page $226$ of our text for a sample completed aging schedule.

Points Posslble: $10.$ To recelve full credit, use cell references and Excel formulas in every yellow cell $($ except H$55)$ and the Name of the Accounts in your journal ortry

Save your flile with your mame in the file name

Submit the file in Canvas

Use the information on the Given Data worksheet to complete this assignment.

Tokal AR

Explimated Aprourt

tinoditectibie.