asaprock

.xlsx

School

Kent State University *

*We aren’t endorsed by this school

Course

36085

Subject

Accounting

Date

Feb 20, 2024

Type

xlsx

Pages

4

Uploaded by LieutenantDinosaur3611

Report
Receivables and Revenue Evaluate collectibility using the allowance for uncollectible accounts The following data is given for Autumn Corporation for the end of the current year (before a Accounts Receivable $ 76,000 Allowance for Uncollectible Accounts (credit balance) $ 11,000 Service revenue for the year (all on credit) $ 490,000 2% of credit s $ 21,000 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Requirements 1 a. Enter all amounts as positive values. 2 a. Enter all amounts as positive values. b. Consider this situation independently from the previous one. Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial sprea b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Summary 4 Within Score Summary window, click on Download (upper right) to download the spreadsh Estimated uncollectible-account expense rate (Requirement 1 assumption) Estimated Allowance for Uncollectible Accounts credit balance (Requirement 2 assumption) Always use cell references and formulas where appropriate to receive full credit. If you copy/p you will be marked wrong. Using the percent-of-sales method, calculate the amount of Uncollectible-Account Expense estimated uncollectible-account expense rate identified in the data table. What is the endi Uncollectible-Accounts under this scenario? Now assume that Autumn Corporation uses the aging-of-receivables method. Using the es Allowance for Uncollectible Accounts identified in the data table, calculate the amount of i Expense. What is the ending balance of the Allowance for Uncollectible Accounts under thi For help completing the requirements, watch the video walk through.
adjusting entries). sales adsheet heet with feedback paste from the Instructions tab e using Autumn Corporation's ing balance of the Allowance for timated credit balance in its its Uncollectible-Account is scenario?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help