Question: 1) Directions Using the A/R data to the right for Stark Industries, Inc,you are to prepare an A/R Aging Report and record the adjustment for

1) Directions Using the A/R data to the right for Stark Industries, Inc,you are to prepare an A/R Aging Report and record the adjustment for the company's allowance for doubtful accounts (AFDA). 2) Allowance for Doubtful Accounts account The balance of AFDA prior to your adjustment is a debit balance of $2,500. 3) Uncollectible Accounts by Aging Interval Using historical experience, the A/R clerk, Pepper Potts, has determined that collectible amounts by aging interval are as follows: 0 - 30 days old (i.e., Current): 99% 31 - 60 days old: 93% 61 - 90 days old: 65% Over 90 days old: 4% 4) Customer invoice and amounts outstanding at shown in the data table to the right. 5) Requirements a) Prepare, in good form, an A/R Aging Report that shows the aging intervals in Item 3 above. You must prepare your report in Excel. b) Use only Arial 10 font to prepare your work. b) Calculate and show the amount of uncollectible A/R by aging interval. Then show the total estimated uncollectible amount. c) Prepare the general journal entry Pepper should record to adjust AFDA to the proper amount. d) Prepare the A/R section of Stark's balance sheet showing the gross A/R, the AFDA, and net realizable value. e) Do not use this Excel file to prepare your assignment. Instead, copy the data set above to a worksheet in a new Excel file and complete your assignment there. Customer ID Customer Name Invoice Date Invoice # Invoice Amount CHOT72 Chotchkie's Co. 2/7/2021 46-21049 5,105 BRAW23 Brawndo, Inc. 1/12/2021 46-21025 1,517 SWIN22 Swingline Staplers, LLC 1/30/2021 46-21039 8,318 VAND54 Vandelay Industries, Inc. 4/5/2021 46-21088 7,925 PLAY82 Play Now, Inc. 3/9/2021 46-21074 5,057 CHOT72 Chotchkie's Co. 4/4/2021 46-21086 3,454 BRAW23 Brawndo, Inc. 4/28/2021 46-21099 2,896 SWIN22 Swingline Staplers, LLC 12/22/2020 46-21012 6,098 VAND54 Vandelay Industries, Inc. 12/26/2020 46-21015 2,164 PLAY82 Play Now, Inc. 4/8/2021 46-21090 9,452 KRUG52 Kruger Industrial Smoothing, LLC 1/23/2021 46-21034 6,227 BEND14 Bendini, Lambert & Locke, P.C. 12/22/2020 46-21013 7,928 WNYX78 WNYX, LLC 1/31/2021 46-21042 4,362 OSCO83 Oscorp, SpA 1/22/2021 46-21032 9,692 CONS25 Consumer Recreation Services, GmbH 3/2/2021 46-21063 8,707 CHOT72 Chotchkie's Co. 1/11/2021 46-21024 3,665 CHOT72 Chotchkie's Co. 1/2/2021 46-21018 6,183 BRAW23 Brawndo, Inc. 1/3/2021 46-21020 4,033 SWIN22 Swingline Staplers, LLC 12/11/2020 46-21005 5,142 VAND54 Vandelay Industries, Inc. 2/6/2021 46-21047 3,953 PLAY82 Play Now, Inc. 2/21/2021 46-21058 3,289 CHOT72 Chotchkie's Co. 12/11/2020 46-21006 5,470 BRAW23 Brawndo, Inc. 2/5/2021 46-21046 4,185 SWIN22 Swingline Staplers, LLC 1/22/2021 46-21033 4,971 VAND54 Vandelay Industries, Inc. 1/30/2021 46-21040 7,091 PLAY82 Play Now, Inc. 3/12/2021 46-21075 2,195 KRUG52 Kruger Industrial Smoothing, LLC 3/4/2021 46-21070 2,845 BEND14 Bendini, Lambert & Locke, P.C. 2/7/2021 46-21050 8,631 WNYX78 WNYX, LLC 12/21/2020 46-21011 5,109 OSCO83 Oscorp, SpA 3/25/2021 46-21082 1,787 CHOT72 Chotchkie's Co. 4/26/2021 46-21097 9,672 BRAW23 Brawndo, Inc. 2/23/2021 46-21061 4,573 SWIN22 Swingline Staplers, LLC 3/20/2021 46-21078 1,621 VAND54 Vandelay Industries, Inc. 3/20/2021 46-21079 4,866 PLAY82 Play Now, Inc. 1/31/2021 46-21043 1,004 CHOT72 Chotchkie's Co. 12/20/2020 46-21010 3,394 BRAW23 Brawndo, Inc. 2/18/2021 46-21055 9,906 SWIN22 Swingline Staplers, LLC 2/13/2021 46-21052 5,383 VAND54 Vandelay Industries, Inc. 12/3/2020 46-21000 7,289 PLAY82 Play Now, Inc. 1/6/2021 46-21021 8,026 KRUG52 Kruger Industrial Smoothing, LLC 1/16/2021 46-21028 9,555 BEND14 Bendini, Lambert & Locke, P.C. 3/6/2021 46-21072 1,608 WNYX78 WNYX, LLC 2/26/2021 46-21062 4,300 OSCO83 Oscorp, SpA 2/3/2021 46-21045 5,924 CONS25 Consumer Recreation Services, GmbH 3/3/2021 46-21066 3,631 CHOT72 Chotchkie's Co. 1/19/2021 46-21030 4,479 CHOT72 Chotchkie's Co. 3/22/2021 46-21080 5,479 BRAW23 Brawndo, Inc. 4/25/2021 46-21095 9,186 SWIN22 Swingline Staplers, LLC 4/29/2021 46-21100 3,086 VAND54 Vandelay Industries, Inc. 4/30/2021 46-21101 5,325 PLAY82 Play Now, Inc. 2/18/2021 46-21056 4,621 CHOT72 Chotchkie's Co. 2/14/2021 46-21053 4,804 BRAW23 Brawndo, Inc. 1/16/2021 46-21029 9,357 SWIN22 Swingline Staplers, LLC 4/19/2021 46-21094 8,348 VAND54 Vandelay Industries, Inc. 3/3/2021 46-21067 5,641 PLAY82 Play Now, Inc. 12/27/2020 46-21016 5,588 KRUG52 Kruger Industrial Smoothing, LLC 1/14/2021 46-21027 2,275 CHOT72 Chotchkie's Co. 3/30/2021 46-21083 2,706 BRAW23 Brawndo, Inc. 3/19/2021 46-21077 9,295 SWIN22 Swingline Staplers, LLC 2/21/2021 46-21059 5,467 VAND54 Vandelay Industries, Inc. 2/20/2021 46-21057 4,233 PLAY82 Play Now, Inc. 3/3/2021 46-21068 2,624 CHOT72 Chotchkie's Co. 3/2/2021 46-21064 4,878 BRAW23 Brawndo, Inc. 2/2/2021 46-21044 5,370 SWIN22 Swingline Staplers, LLC 4/2/2021 46-21085 2,435 VAND54 Vandelay Industries, Inc. 1/26/2021 46-21036 6,229 PLAY82 Play Now, Inc. 12/5/2020 46-21002 9,512 KRUG52 Kruger Industrial Smoothing, LLC 4/26/2021 46-21098 7,306 BEND14 Bendini, Lambert & Locke, P.C. 4/6/2021 46-21089 9,074 WNYX78 WNYX, LLC 12/5/2020 46-21003 9,614 OSCO83 Oscorp, SpA 4/16/2021 46-21092 2,223 CONS25 Consumer Recreation Services, GmbH 4/8/2021 46-21091 6,934 CHOT72 Chotchkie's Co. 12/19/2020 46-21009 1,601 CHOT72 Chotchkie's Co. 1/30/2021 46-21041 6,068 BRAW23 Brawndo, Inc. 12/3/2020 46-21001 6,508 SWIN22 Swingline Staplers, LLC 1/26/2021 46-21037 8,131 VAND54 Vandelay Industries, Inc. 12/16/2020 46-21008 2,074 PLAY82 Play Now, Inc. 1/9/2021 46-21023 1,422 CHOT72 Chotchkie's Co. 4/16/2021 46-21093 8,738 BRAW23 Brawndo, Inc. 12/7/2020 46-21004 5,623 SWIN22 Swingline Staplers, LLC 12/29/2020 46-21017 1,737 VAND54 Vandelay Industries, Inc. 3/12/2021 46-21076 1,937 PLAY82 Play Now, Inc. 1/23/2021 46-21035 9,227 KRUG52 Kruger Industrial Smoothing, LLC 2/6/2021 46-21048 4,057 BEND14 Bendini, Lambert & Locke, P.C. 2/22/2021 46-21060 7,184 WNYX78 WNYX, LLC 4/4/2021 46-21087 2,794 OSCO83 Oscorp, SpA 2/15/2021 46-21054 8,446 CHOT72 Chotchkie's Co. 3/23/2021 46-21081 7,013 BRAW23 Brawndo, Inc. 3/31/2021 46-21084 8,415 SWIN22 Swingline Staplers, LLC 12/15/2020 46-21007 3,217 VAND54 Vandelay Industries, Inc. 3/8/2021 46-21073 2,783 PLAY82 Play Now, Inc. 1/2/2021 46-21019 3,413 CHOT72 Chotchkie's Co. 3/2/2021 46-21065 8,867 BRAW23 Brawndo, Inc. 12/24/2020 46-21014 9,306 SWIN22 Swingline Staplers, LLC 1/21/2021 46-21031 2,830 VAND54 Vandelay Industries, Inc. 1/29/2021 46-21038 7,238 PLAY82 Play Now, Inc. 3/5/2021 46-21071 8,186 KRUG52 Kruger Industrial Smoothing, LLC 4/25/2021 46-21096 1,117 BEND14 Bendini, Lambert & Locke, P.C. 3/3/2021 46-21069 9,162 WNYX78 WNYX, LLC 1/7/2021 46-21022 1,539 OSCO83 Oscorp, SpA 2/11/2021 46-21051 2,777 CONS25 Consumer Recreation Services, GmbH 1/12/2021 46-21026 9,404

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

(CMA, adapted) The Kuhl Brothers own a frozen custard ice cream shop. The brothers currently are using a machine that has been in use for the last 4 years. On January 1, 2017, the Kuhl Brothers are...

Module 1, Topic 3 Case Study: The Anderson Bat Company (ABC) You have just been hired as the Chief Risk Office (CRO) for The Anderson Bat Company (ABC). Although you have been responsible for risk...

Practice Set Directions: You, as the main accountant for Indiana Jones, Inc., are responsible for recording all the transactions during the year, as well as the adjusting entries at the end of the...

Practice Set Workbook Download Info X Cluse - 700M + count chboard Courses Page 07 0 Practice Set Directions: You, as the main accountant for Indiana Jones, Inc., are responsible for recording all...

There is a case question (very last question) in the document below and i would like to know how to resolve it properly University of Toronto Faculty of Arts and Science and Rotman School of...

Read ALL instructions before getting started! ABC Corporation is a new company that buys and sells office supplies. Business began on January 1, 2016. Given on the first two tabs are ABC's 12/31/16...

Sarbanes-Oxley Act (SOX) of 2002 As the junior auditor for a regional audit/assurance services firm, you have been tasked with auditing the Accounts Receivable process for a mid-size retail company....

As a small group, discuss the following statements. "Data preparation is a time-consuming process. In projects with severe time constraints, data preparation should be circumvented."

Calculating Present Values Imprudential, Inc., has an unfunded pension liability of $700 million that must be paid in 20 years. To assess the value of the firms stock, financial analysts want to...

JJP Enterprises seeks to entice one of its star managers to move to Iraq to oversee a construction project. The firm will most likely offer a _ _ _ _ _ _ _ _ because of the difficult living and...

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...