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

Problem 6 5a accounting

28/12/2020 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.

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
Top Essay Tutor
University Coursework Help
Homework Guru
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.

$230 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.

$235 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$232 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.

$232 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

Seoul national university business - Medieval history essay topics - Energy required to melt ice - Bank robber's advance man crossword - Electromagnetic induction physics lab report - Analysis of an aluminum zinc alloy answers - Google scholar gcu - Management of Technology Innovation case study - The campbell company is considering adding a robotic paint - Salford university pmc submission - Health Services - Critical theory of communication in organizations - Finding the precise median for a continuous variable - U.S. Film And Theater Studies - Aws direct connect gateway icon - Mintzberg's modes of strategic decision making - Research Process & Methodology - This i believe essay ideas - Little red midnight remember - History article - Route 53 interview questions - Aged pension application form sa369 - Charge and discharge of a capacitor lab report - 4 pages needed due by 15 hours - Unistart foundation studies program - Bt 81 newgate street - Borders solicitors property centre - Pilates by amanda bergin los angeles - Eukaryotic animal cell 3d model - Which of the following are disadvantages of biometrics - Where is eileen franklin lipsker now - History of Art through the Middle Ages (Project) - As nzs 3500.3 2015 free download - Bible - Cash flow forecast definition tutor2u - Rinnai solar 20 pilot light - List and briefly define five file organizations - Self assessment - Disturbed family process care plan - Annie's case study - Castle view house east lane runcorn - Innovations and strategy 3000 words - Post investment hold up definition - Guest and chrimes valves - How to prevent lateral torsional buckling - Which of the following statements is true about ethical decision making in business? - U pick cherries melbourne - Capitol taxi vernon bc - Access module 1 sam textbook project - ____ the format painter button allows it to remain active until you turn it off. - Real time business intelligence at continental airlines - The great gatsby chapter 7 literary devices - Geography Due Today - Frank and lillian gilbreth contribution to management pdf - Positive effects of hidden curriculum - Nursing interventions for impaired skin integrity related to cellulitis - Research topic and write - 48 bridgewood drive beaumont hills - Indicator reagent data - Term Paper on the dangers of USB Thumb drives - Research Project - Direct and indirect labor journal entries - BIO 141 - Difference between physical and chemical digestion - Comparing and contrasting transition words - What is the role of the kinetochores and the microtubules - Principles of person centred counselling - Http owl english purdue edu owl resource 545 1 - Masters of space operations - Operation and project management - Discussion - HW - Ib standard level math formula booklet - Hey whipple squeeze this chapter 1 summary - The dog lodge roborough - Consecutive odd and even integers - Interaction types instructing conversing manipulating exploring - Course Paper Prep: Interview Planning Assignments Submit Assignment - Social media friend or foe by kara woodridge - Whatever happened to crazy eddie - Marketing Reseach - My creature from the black lagoon stephen king - Finance questions-6 - Faculty of political science ankara university - Hospital admission letter template - Sunflower nutraceuticals simulation paper - Arinc 429 standard labels - But 1 ene hbr - Definition needed asap now - A lightweight pallet has a load of identical - Sodium hydrogen sulfite acid or base - What are analogous structures - Dharma and the heroic - Derivatives using power rule worksheet answers - Research paper - Autism spectrum rating scales asrs - Butler systems case study - First they came poem questions - Cover Letter Draft for Peer Review - Www parks vic gov au wilsons prom