Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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|8686RER8TESE

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_2

Step: 3

blur-text-image_3

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

Auditing And Assurance Services An Integrated Approach

Authors: Alvin Arens

13th Edition

0136084737, 9780136084730

More Books

Students also viewed these Accounting questions