Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use a formula with VLOOKUP function to determine the amount of Allowance for doubtful receivables (in dollars) at H15:H35. The table for allowance percentage by
Use a formula with VLOOKUP function to determine the amount of Allowance for doubtful receivables (in dollars) at H15:H35. The table for allowance percentage by each aging group can be found in J14:K18
A D F K 11 12 Enter your name 13 Outstanding Days Outstanding Days Allowance for Doubtful Receivables Allowance 14 % Invoice No. Amount Status Account Customer Name Transaction Date 15 031 16 031 17 034 18 129 255 $63.41 $1.27 0 0% CPM Interiors 4/21/19 70 Late $239.87 2% CPM Interiors 262 5/21/19 40 Current 61 Rennovations 256 $164.23 Late 5% 4/5/19 91 4/24/19 $267.99 10% Court Interiors 250 67 Late 121 19 135 20 135 21 304 22 341 23 341 24 341 25 456 26 456 27 563 28 576 29 643 30 643 31 710 32 902 33 902 34 902 35902 36 267 5/1/19 $734.97 Decorator World 60 Current Decorator World $123.57 265 3/23/19 99 Late O'Brien Inc 252 1/13/19 $123.40 168 Late Roseville Hardware S1,450.00 249 1/30/19 151 Late 3/24/19 $1,134.65 Roseville Hardware 254 98 Late Roseville Hardware VanHornbeck's VanHornbeck's $1,367.99 261 1/24/19 157 Late 269 S456.78 5/21/19 40 Current 253 $956.34 1/3/19 178 Late S1,245.67 Zeitlers 260 4/24/19 Late Larson Designs Interiors Inc 257 5/5/19 56 $1.27 $1,268.89 Current 4/4/19 $435.78 263 Late Interiors Inc $3,456.89 Late 259 4/24/19 67 $341.67 Hirschfield 270 4/1/19 90 Late Henderson 1/20/19 $578.91 266 161 Late $462.84 Henderson 251 4/14/19 77 Late Henderson 1/14/19 $4,357.99 264 167 Late $2,373.75 Henderson 268 5/4/19 57 Current 37 38 Totals: 39 $21,605.59 40 6188|8686RER8TESEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started