Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Pr 9 2a accounting

28/12/2020 Client: saad24vbs Deadline: 3 days

Pr. 9-2A

Problem 9-2A

Name: 0

Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24," ")

76

Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24," ")

0

Key Code: [Key code here] Total SUM(AD13:AD15)

Instructions 76

Answers are entered in the cells with gray backgrounds. Percentage =(AD16-AD13-AD14)/AD16

Cells with non-gray backgrounds are protected and cannot be edited. 0%

An asterisk (*) will appear to the right of an incorrect entry. Notes:

Enter a zero in cells you would otherwise leave blank. If number-entry or blank-entry box is incorrect, returns "*"

1. Number of Days Past Due If number-entry or blank-entry box is correct, returns single space, " "

Customer Due Date Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.

Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.

Adams Sports and Flies May 22, 20Y6

Blue Dun Files Oct. 10, 20Y6

Cicada Fish Co. Sept. 29, 20Y6

Deschutes Sports Oct. 20, 20Y6

Green River Sports Nov. 7, 20Y6

Smith River Co. Nov. 28, 20Y6

Western Trout Company Dec. 7, 20Y6

Wolfe Sports Jan. 20, 20Y7

2., 3. Aging of Receivables Schedule

December 31, 20Y6

Days Past Due

Not Past Over

Customer Balance Due 1 - 30 31 - 60 61 - 90 91 - 120 120

AAA Outfitters $ 20,000 $ 20,000

Brown Trout Fly Shop 7,500 $ 7,500

Zigs Fish Adventures 4,000 4,000

Subtotals $ 1,300,000 $ 750,000 $ 290,000 $ 120,000 $ 40,000 $ 20,000 $ 80,000

Adams Sports and Flies 5,000

Blue Dun Files 4,900

Cicada Fish Co. 8,400

Deschutes Sports 7,000

Green River Sports 3,500

Smith River Co. 2,400

Western Trout Company 6,800

Wolfe Sports 4,400

Totals $ 1,342,400

Percent uncollectible

Mark Sears: Enter percentage as a whole number

Estimate of

uncollectible accounts

Mark Sears: Enter a formula summing the other amounts in this row.

Mark Sears: Enter a formula of percent uncollectible x total amount in this category

4.

5.

On the balance sheet, the omission would cause:

assets to be by

owner's capital to be by

On the income statement, the omission would cause:

expenses to be by

net income to be by

Sol

Problem 9-2A

Name: Solution

Section:

Score: ON

Instructions

Answers are entered in the cells with gray backgrounds.

Cells with non-gray backgrounds are protected and cannot be edited.

An asterisk (*) will appear to the right of an incorrect entry. For correct grading, enter a zero in cells you would otherwise leave blank.

otherwise leave blank.

1. Number of Days Past Due

Customer Due Date

Adams Sports and Flies May 22, 20Y6 223

Blue Dun Files Oct. 10, 20Y6 82

Cicada Fish Co. Sept. 29, 20Y6 93

Deschutes Sports Oct. 20, 20Y6 72

Green River Sports Nov. 7, 20Y6 54

Smith River Co. Nov. 28, 20Y6 33

Western Trout Company Dec. 7, 20Y6 24

Wolfe Sports Jan. 20, 2016 0

2., 3. Aging of Receivables Schedule

December 31, 20Y6

Days Past Due

Not Past Over

Customer Balance Due 1 - 30 31 - 60 61 - 90 91 - 120 120

AAA Outfitters $ 20,000 $ 20,000

Brown Trout Fly Shop 7,500 $ 7,500

Zigs Fish Adventures 4,000 4,000

Subtotals $ 1,300,000 $ 750,000 $ 290,000 $ 120,000 $ 40,000 $ 20,000 $ 80,000

Adams Sports and Flies 5,000 - - - - - 5,000

Blue Dun Files 4,900 - - - 4,900 - -

Cicada Fish Co. 8,400 - - - - 8,400 -

Deschutes Sports 7,000 - - - 7,000 - -

Green River Sports 3,500 - - 3,500 - - -

Smith River Co. 2,400 - - 2,400 - - -

Western Trout Company 6,800 - 6,800 - - - -

Wolfe Sports 4,400 4,400 - - - - -

Totals $ 1,342,400 $ 754,400 $ 296,800 $ 125,900 $ 51,900 $ 28,400 $ 85,000

Percent uncollectible 1% 2% 10% 30% 40% 80%

Estimate of

uncollectible accounts 121,000

Mark Sears: Enter a formula summing the other amounts in this row. $ 7,544

Mark Sears: Enter a formula of percent uncollectible x total amount in this category $ 5,936 $ 12,590 $ 15,570 $ 11,360 $ 68,000

4.

Bad Debt Expense 124,600

Allowance for Doubtful Accounts 124,600

5.

On the balance sheet, the omission would cause:

assets to be overstated by $ 124,600

owner's capital to be overstated by $ 124,600

On the income statement, the omission would cause:

expenses to be understated by $ 124,600

net income to be overstated by $ 124,600

Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Hand
Homework Guru
University Coursework Help
Top Essay Tutor
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$100 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$102 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$102 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$105 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Discussion Post - The sculptor a0 oversaw building and decorating the parthenon - Lavazza blue lb 4700 - 3930 sunforest court toledo ohio - Wk 4 – Apply: Message of Change [due Mon] Wk 4 – Apply: Message of Change [due Mon] - Medicaid Medicare - Usa 1919 41 revision notes - Why do americans say the pledge of allegiance - Chemistry Lab - Freedcamp tutorial - Athletic apparel industry financial ratios - Simple machine rube goldberg - Self care eco map - Booms and bitner marketing mix - My antonia literary analysis essay - John moores uni open day - HRM 652 EVALUATING RESULTS AND BENEFITS - Requerimiento of 1510 - Wib web server in a box - Dettol product company name - Pups in peril groves texas - Bright child learning center - What is the sum of mc003-1.jpg and mc003-2.jpg? - If we must die by claude mckay analysis - Using Business Visuals - Rigor mortis occurs after death because - Shared services sa login - Discussion 6051 M-3 - Elizabeth chadwick akashic records - Evidence Base in Design - Student portal preston college - Bank lockers for jewellery anz - Critique of an economic evaluation using the drummond checklist - First cirque du soleil show 1984 - Jainism vs sikhism worksheet rel 133 - 700words: Effective leadership - Sicilian ice cream cake crossword - Circular flow in a simple economy - Engineering mathematics john bird 8th edition pdf - Dynamic characters in pride and prejudice - Systems understanding aid solutions 9th edition - The product design group of iyengar electric supplies - Waterfall strategy in international marketing - Fbc h005 blood test - Intuition pumps and other tools for thinking epub - Hp deskjet 1010 printer - International islamic university malaysia - Four principles of interpersonal communication - Project 1 - Bygone japanese camera brand that merged with konica - How to use timer resolution - Tutor Account On Sale - Quarterstaff of entwined serpents - Symbols in a circuit - Dimensions involved in the development of expertise - The tendency to revert to a fixed (or modal) action pattern is called instinctive drift. - Eit napier free courses - 2 page assignment - Extinction in operant conditioning involves - Buddhist temple ulverston cumbria - How accurate is the apea predictor exam - 1957 vincent black lightning - Texas government -27 - Value line publishing october 2002 case analysis - Bodyline pilates port macquarie - Philosophy - Citizens advice bureau blaby - Mr dutoit was asked by his psychotherapist - 24/7 gatorbait message board - Psycho 6 - Conflict in rip van winkle - Ms andrews hotel video - Traci lords 1000 fires review - Sherwood rival hockey stick costco - What is the best point estimate of the population mean - Strengths and limitations of visually interpreting histograms - Vector addition worksheet pdf - Muerte : nacimiento :: divorciarse de : - Which promotional activity will sell the most products - Defining crime: graphic or visual - Virtual fetal pig dissection worksheet answers - Critical Comparison essay (first year English level) - Brooklyn dreams hollywood knights - Organized retailing in india ppt - Maths made easy edexcel - MGT312T Week 2 Discussion - Longest word with no vowels - University of central missouri data science - How to find average issue price of common stock - Harry garlick warehouse earby - Yakima roof rack installation - Short response - Bulk billing psychiatrist ballarat - $24 for work - Psychological first aid questions and answers - Jamie eason live fit meal plan - You hear: ¿qué es la piña? you choose: fruta - To his coy mistress poem annotations - Daviess county detention center - Neo-mercantilists equate political power with economic power and economic power with