Function: SUM; Formula: Subtract, Multiply; Cell Referencing

Using Excel to Create an Aging Schedule

PROBLEM

Ward Products uses an aging schedule to determine its estimated uncollectible accounts at December $31.$

$\backslash$table$[[\backslash$table$[[$Number of Days$],[$Outstanding$]],\backslash$table$[[$Accounts$],[$Receivable$]],\backslash$table$[[$Estimated Percentage$],[$Uncollectible$]],],[0-30$ days,$$,265,000,1\%$