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

United States History: Stamp Act Congress Resolutions - Mil h 6000 hose - Real and complex analysis solutions pdf - HRMT PAPER - Formula for aluminum phosphate - EDD - Essay - Principles of electromagnetics sadiku 6th edition solutions pdf - Determination of ka of weak acids post lab answers - Winmend folder hidden password hack - Psychology and life zimbardo pdf - Colonoscopy prefix and suffix - Notice for breach of duty to landlord of rented premises - Assignment #5 - Art appreciation essay topics - Meaning of dog day afternoon - Reflection worksheet --- Due in 2 hours - Bankwest change of name form - Anterior compartment of arm - Unequal tie rod length - 10- to 12-slide presentation with speaker notes due october 7th 2020 - Writing assignment - Discussion - Pricing strategy of nestle chocolates - Finance - Billionaire card game kmart - Walmart global ethics online complaint form - Sos friends for life - The iconic hunter boots - Essay - 2018 business management exam - Let's put dollar amounts on the flows - How to find discount on bonds payable - Is ethanol ionic or covalent - Java blackjack source code - Round robin algorithm in data structure - Litweb norton - Patient education - Mr tapp princess royal hospital - Write 26 as a fraction in simplest form - Agent loki international man of mayhem - 11 tain dr great neck - What does wwf stand for animals - How to write a social story - Building shared services at rr communications case study - Business Stat Proposal - TM Discussion 1 - Pandemic Voting - Sociology# 8 - Blue skin family in kentucky - Coca cola inputs transformation process and outputs - Thomas and chess's classic temperamental categories - Senior network engineer resume doc - First fast food in malaysia - Diego compró el anillo ring para - Steve jobs stanford speech - From ancient grudge break to new mutiny meaning - Unit 4 IP Motivation, Incentive, and Conflict Resolution - Present level of Performance - Mgmt_Economics - Reflection, Discussion and Research Paper - Shadow health mental health answers - The very secret diary of aragorn - Tuggerah station to gosford station - Post horn gallop brass band - Strange fruit questions and answers - Wembley lumberjack stress relief ball - Kid snippets driving to grandma's - Please make sure before taking Research paper(5-7)to complete all the mentioned requirement with APA format, proper reference and no plagiarism - Buscopan for nausea and vomiting - Benchmark - Article Critique - Why is being organised important - Slough to gerrards cross bus 353 - Module 6 Sociology - Meeting a new team member british council - Triangle similarity aa sss sas - Kelly pitney comprehensive problem solution - Caux round table principles for business - Good kings bad kings by susan nussbaum summary - Chapter 28 the affluent society outline - What does gattaca code for - Sikhism cosmogony origin of the universe - Walmart compliance issues - Royal canin breeders club - HR_GLOB_FIN (U2_RPLx2) - Ghtf sg3 n18 2010 - How to make portfolio for internship - What is blanket overhead rate - Stamped concrete driveway cost - ConferenceRegistrationForm-02 , -VaccinationSchedule-04, WD2016-Capstone- - Leadership Theory and Process - B46 28 gower street summer hill - Create a formula in cell c13 that calculates annual sales - The heating curve of an unknown chemical - Crucial conversations training adelaide - The pink floyd experience - Value of Auctions - How jack welch changed ge - IDST 2050C - Chess holding statement commsec - +91-8890675453 love marriage problem solution IN Khammam