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 6 5a accounting

01/01/2021 Client: saad24vbs Deadline: 14 Days

Pr. 6-5A

Problem 6-5A # Incorrect N-box and B-box entries COUNTIF(B15:G24,"~*")

Name: 0

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

13

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

0

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

Instructions 13

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. Essay answers will not be graded. Notes:

If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "

1. CLAIREMONT CO. For the Year Ended May 31, 2019 If number-entry or blank-entry box is incorrect, returns "*"

Income Statement May 31, 2019

If number-entry or blank-entry box is correct, returns single space, " "

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.

Sales Advertising expense

Cost of merchandise sold Cost of merchandise sold

Gross profit Depreciation expense—office equipment

Expenses: Depreciation expense—store equipment

Selling expenses: Insurance expense


cpence: List these expenses in numerical order, largest to smallest.

Peggy Hussey: List these expenses in numerical order, largest to smallest. Enter as positive amounts. Interest expense

Miscellaneous administrative expense

Miscellaneous selling expense

Office salaries expense

Total selling expenses

cpence: Enter as a positive amount. Office supplies expense

Administrative expenses: Rent expense


Peggy Hussey: List the expenses in numerical order, largest to smallest. Sales

Sales salaries expense

Total administrative expenses

Craig Pence: Enter a positive amount.

Total expenses

Income from operations

Other expense:

Net income

2. CLAIREMONT CO.

Statement of Owner's Equity

Decrease in owner's equity

Kristina Marble, capital, June 1, 2018 Increase in owner’s equity


Peggy Hussey: Enter the item that increases owner's equity first. (You will need information from part 1.) Withdrawals


Mark Sears: Enter the item that decreases owner's equity as a negative value. Net income for the year

Net loss for the year

Kristina Marble, capital, May 31, 2019

3. CLAIREMONT CO.

Balance Sheet

Accounts receivable

Accounts payable

Assets Cash

Current assets: Customer refunds payable


cpence: List current assets in order of liquidity (most liquid first).

cpence: List current assets in order of liquidity (most liquid first). Less accumulated depreciation

Kristina Marble, capital

Kristina Marble, drawing

Estimated returns inventory Merchandise inventory


cpence: List supplies ahead of prepaid insurance. Note payable (current portion)

Note payable (final payment due 2022)

Total current assets Office equipment

Property, plant, and equipment: Office supplies

Office equipment Prepaid insurance


Peggy Hussey: Enter the carrying value of the office equipment. Salaries payable

Store equipment

Store equipment


Peggy Hussey: Enter the carrying value of the store equipment.

Total property, plant, and equipment

Total assets

Liabilities

Current liabilities:


cpence: List current liabilities in descending order by amount.

Note payable (current portion)

Total current liabilities

Long-term liabilities:

Total liabilities

Owner's Equity

Kristina Marble, capital

Total liabilities and owner's equity

4. (Key essay answer here)

Sol

Problem 6-5A

Name: Solution

Section:

Scoring: 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. Essay answers will not be graded.

1. CLAIREMONT CO. For the Year Ended May 31, 2019

Income Statement May 31, 2019

For the Year Ended May 31, 2019

Sales $ 11,343,000

Cost of merchandise sold 7,850,000 Advertising expense

Gross profit $ 3,493,000 Cost of merchandise sold

Expenses: Depreciation expense—office equipment

Selling expenses: Depreciation expense—store equipment

Sales salaries expense

cpence: List these expenses in numerical order, largest to smallest. $ 916,000

Peggy Hussey: List these expenses in numerical order, largest to smallest. Enter as positive amounts. Insurance expense

Advertising expense 550,000 Interest expense

Depreciation expense—store equipment 140,000 Miscellaneous administrative expense

Miscellaneous selling expense 38,000 Miscellaneous selling expense

Total selling expenses $ 1,644,000

cpence: Enter as a positive amount. Office salaries expense

Administrative expenses: Office supplies expense

Office salaries expense $ 650,000 Rent expense

Rent expense 94,000 Sales

Depreciation expense—office equipment 50,000 Sales salaries expense

Insurance expense 48,000

Office supplies expense 28,100

Miscellaneous administrative expense 14,500

Total administrative expenses 884,600

Craig Pence: Enter a positive amount.

Total expenses 2,528,600

Income from operations $ 964,400

Other expense:

Interest expense 21,000

Net income $ 943,400

2. CLAIREMONT CO.

Statement of Owner's Equity

For the Year Ended May 31, 2019

Increase in owner’s equity

Kristina Marble, capital, June 1, 2018 $ 3,449,100 Withdrawals

Net income for the year $ 943,400

Peggy Hussey: Enter the item that increases owner's equity first. (You will need information from part 1.) Net income for the year

Withdrawals (100,000) Decrease in owner's equity

Increase in owner’s equity 843,400

Kristina Marble, capital, May 31, 2019 $ 4,292,500

3. CLAIREMONT CO.

Balance Sheet

May 31, 2019 Accounts receivable

Accounts payable

Assets Cash

Current assets: Customer refunds payable

Cash

cpence: List current assets in order of liquidity (most liquid first). $ 240,000

cpence: List current assets in order of liquidity (most liquid first). Less accumulated depreciation

Accounts receivable 966,000 Kristina Marble, capital

Merchandise inventory 1,690,000 Kristina Marble, drawing

Estimated returns inventory 22,500 Merchandise inventory

Office supplies

cpence: List supplies ahead of prepaid insurance. 13,500 Note payable (current portion)

Prepaid insurance 8,000 Note payable (final payment due 2022)

Total current assets $ 2,940,000 Office equipment

Property, plant, and equipment: Office supplies

Office equipment $ 830,000 Prepaid insurance

Less accumulated depreciation 550,000 $ 280,000

Peggy Hussey: Enter the carrying value of the office equipment. Salaries payable

Store equipment

Store equipment $ 3,600,000

Less accumulated depreciation 1,820,000 1,780,000

Peggy Hussey: Enter the carrying value of the store equipment.

Total property, plant, and equipment 2,060,000

Total assets $ 5,000,000

Liabilities

Current liabilities:

Accounts payable

cpence: List current liabilities numerically, largest to smallest. $ 326,000

Salaries payable 41,500

Customer refunds payable 40,000

Note payable (current portion) 50,000

Total current liabilities: $ 457,500

Long-term liabilities:

Note payable (final payment due 2022) 250,000

Total liabilities $ 707,500

Owner's Equity

Kristina Marble, capital 4,292,500

Total liabilities and owner's equity $ 5,000,000

4. The multiple-step form of income statement contains various sections for revenues and expenses, with intermediate balances, and concludes with net income. In the single-step form, the total of all expenses is deducted from the total of all revenues. There are no intermediate balances.

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:

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

ONLINE

University Coursework Help

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

$102 Chat With Writer
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
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
Best Coursework Help

ONLINE

Best Coursework Help

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

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

Similar Homework Questions

Identity reflection paper - Body shop start up cost - CISB 15 - Religion religions religious smith - 98 364 exam dump pdf - Iss1120 - Nisha multi image filter - Finding your worldview thinking christianly about the world - Sales tax calculator javascript - +91 9928097710 GirlfRiEnD Vashikaran Specialist Molvi ji in Mumbai - The woman who shopped - Please check the doc and respond-24 hours to comp the work - Slip ring motor diagram - Tax return - Anthem for a doomed youth - Daphnia lab report - Husband Wife' +91-9799046502 Divorce LOVE Problem Solution Specialist Molvi Ji. - Stephen robbins organizational behaviour ppt 13th edition - Intake air system leak audi a4 - Readiness for enhanced spiritual well being care plan - Romeo and juliet context - Cherry pink and apple blossom white musical ideas - Enterprise Risk Management - Explaining IDEA and the IEP Process - Hkdse sample paper maths - Oh no inc sells three models - Self amalgamating tape jaycar - Information technology - Incontinency definition hamlet - IOCDQ2 - Seasons come to pass page 244 - Indirect quatation for essay - Engine warning display a320 - Hyundai motor company subsidiaries - Why shaving mirror is concave - Charles law problems worksheet - The power of framing fairhurst pdf - Grim dawn locked trapdoor - Iso iec 26513 2009 - Go-live cutover plan template - Gcf of 180 and 252 - Eitzen (2016) identifies that a fault of adult-organized sport is that it redefines “fun” - How to make oxygen gas in laboratory - Dog breeder contract sample - The power of followership robert kelley - Specific governance plan that exists at a company - The global security policy cmgt 400 - Do blue tongue lizards hibernate in winter - Gateway cengage new account success html - Case Study (350 words) - Liberty online writing center - Juniper power supply status present - How to do a raffle in excel - Peppermints in the parlor lesson plans - Managerial economics and business strategy 8e - Student understanding aid 9th edition solutions - History essay - 1.2 5 clock signals the 555 timer - Mathematical economics chiang 4th edition - All about me speech examples - Ted talk rhetorical analysis - Endangered species brochure template - Radioactive dating game lab worksheet answers - Shoreline stadium case study answers - The Pledge of Allegiance - It infrastructure domains affected by internal use only - Reaction of potassium dichromate with hcl - In the design and development department of China's small and medium-sized electronic game companies, flexible human resource management will have an impact on employee loyalty. - Broward college career fair - Psychology diffusion of responsibility - Zinnia union proposal - Action verb linking verb and helping verb examples - Maternal Nursing & Women Health Practice. - Doctor dolittle learns animal language questions and answers class 7 - Gram staining experiment lab report - Persuasive speech outline on depression - Web server hardware and software - Personal selling in b2b marketing ppt - The walmart effect chapter summary - Analyze the Impact of The Media/Society on Criminal Justice Policy - Cohabitation agreement section 90uc agreement - Hcf bronze plus extras - Accuweather arnold md - Al 6061 t6 density - Consecutive interior angles converse - Fba data collection tool - Slavery expanded with the growth of _____ - Bambang trihatmodjo net worth - Discussion 6 TM - Waste management accounting scandal wikipedia - Acp tablets for horses dosage - Unit 7 the developing manager - Tuckman and jensen's stages of group development - Hca 312 week 1 activity - How many grams is in a quarter pounder - Sec 450 week 1 ilab - Health care delivery in the united states 11th edition pdf - Fundamentals of nursing vital signs ppt - Health finance week 5 - Introduction and background