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

Interest accrued on 6 month note payable

15/10/2021 Client: muhammad11 Deadline: 2 Day

Name:


Course:


Date:


Problem P4-1A, Prepare worksheet, financial statements, and adjusting and closing entries.


Financial Accounting, 8th Edition by Weygandt, Kieso, and Kimmel


Primer on Using Microsoft Excel in Accounting by Rex A Schildhouse


Problem P4-1A, Sherlock Holmes began operations as a private investigator on January 1, 2014. The trial balance columns of the worksheet for Sherlock Holmes, P.I. at March 31 are as follows.



SHERLOCK HOLMES, P.I., INC.


Worksheet


For the Quarter Ended March 31, 2014



Unadjusted Trial Balance

Ref

Adjustments

Ref

Adjusted Trial Balance

Income Statement

Balance Sheet


Debit

Credit


Debit

Credit


Debit

Credit

Debit

Credit

Debit

Credit

Cash


11,410


Accounts Receivable

5,920


Supplies


1,250


Prepaid Insurance

2,400


Equipment

30,000


Notes Payable


10,000


Accounts Payable

12,350


Common Stock


20,000


Dividends

600


Service Revenue

14,200


Salaries and Wages Expense

2,240


Travel Expense

1,300


Rent Expense

1,200


Miscellaneous Expense

230


Totals


56,550

56,550


Supplies Expense


Depreciation Expense


Accumulated Depreciation


Interest Expense


Interest Payable


Insurance Expense


Totals


Net Income


Totals



Other data:


1. Supplies on hand total

$480

(a)


2. Depreciation is

$720

for the quarter

(b)


3. Interest accrued on 6-month note payable, issued January 1,

$300

(c)


4. Insurance expires at the rate of

$200

per month.

(d)


5. Services provided but unbilled at March 31 total

$1,080

(e)



Instructions:


(a) Complete the worksheet.


(b)(1) Prepare an income statement for the quarter ended March 31, 2014.




SHERLOCK HOLMES, P.I., INC.



Income Statement



For the Quarter Ended March 31, 2014



Title



Account title


Amount



Title



Account title


Amount



Account title


Amount



Account title


Amount



Account title


Amount



Account title


Amount



Account title


Amount



Account title


Amount



Account title


Amount



Title


Formula



Title


Formula



(b)(2) Prepare a retained earnings statement for the quarter ended March 31, 2014.




SHERLOCK HOLMES, P.I., INC.



Retained Earnings Statement



For the Quarter Ended March 31, 2014



Title


$0



Title


Amount



Formula



Title


Amount



Title


Formula



(b)(3) Prepare a classified balance sheet for March 31, 2014.




SHERLOCK HOLMES, P.I., INC.



Balance Sheet



March 31, 2014



Assets



Title



Account title


Amount



Account title


Amount



Account title


Amount



Account title


Amount



Total current assets


Formula



Title



Account title


Amount



Less: Account title


Amount

Formula



Title


Formula




Liabilities and Stockholders’ Equity



Title



Account title


Amount



Account title


amount



Account title


amount



Total Current Liabilities


Formula



Title



Account title


Amount



Account title


Amount



Title


Formula



Total Liabilities and Stockholders’ Equity

Formula



(c) Journalize the adjusting entries from the adjustments columns of the worksheet.




Mar 31

Account title


Amount



Account title


Amount



Text explanation




Mar 31

Account title


Amount



Account title


Amount



Text explanation




Mar 31

Account title


Amount



Account title


Amount



Text explanation




Mar 31

Account title


Amount



Account title


Amount



Text explanation




Mar 31

Account title


Amount



Account title


Amount



Mar 31

Account title


Amount



Account title


Amount


(d) Journalize the closing entries from the financial statement columns of the worksheet.




Mar 31

Account title


Amount



Account title


Amount



Account title



Account title


Amount



Mar 31

Account title



Text explanation



Account title



Mar 31

Account title


Amount



Account title



Account title



Account title



Mar 31

Account title


Amount



Account title



Text explanation




Mar 31

Account title



Account title





Mar 31

Account title



Account title










Problem P5-1A, Journalize purchase and sales transactions under a perpetual inventory system.
Financial Accounting, 8th Edition by Weygandt, Kieso, and Kimmel
Primer on Using Microsoft Excel in Accounting by Rex A Schildhouse
This challenge has been modified to a units presentation.
Problem P5-1A, Ready-Set-Go Co. distributes suitcases to retail stores and extends credit terms of 1/10, n/30 to all of
its customers. At the end of June, Ready-Set-Go’s inventory consisted of 120 suitcases purchased at
$10.00 each. During the month of July the following merchandising transactions occurred.
Jul 1 Purchased 150 suitcases on account for $10.00 each from Trunk Manufacturers, FOB
destination, terms 2/10, n/30. The appropriate party also made a cash payment of $100.00 for
freight on this date.
Jul 3 Sold 110 suitcases on account to Satchel World for $20.00 each. The cost of suitcases
sold is $1,400.00
Jul 9 Paid Trunk Manufacturers in full.
Jul 12 Received payment in full from Satchel World.
Jul 17 Sold 70 suitcases on account to Lady GoGo for $20.00 each. The cost of
suitcases sold is $1,010.00
Jul 18 Purchased 190 suitcases on account for $1,900.00 from Holiday Manufacturers, FOB
shipping point, terms 1/10, n/30. The appropriate party also made a cash payment of $125.00
for freight on this date.
Jul 20 Received $300.00 credit (including freight) for 30 suitcases returned to Holiday
Manufacturers.
Jul 21 Received payment in full from Lady GoGo.
Jul 22 Sold 90 suitcases on account to Vagabond for $25.00 each. The cost of suitcases
sold is $1,350.00
Jul 30 Paid Holiday Manufacturers in full.
Jul 31 Granted Vagabond $200.00 credit for 8 suitcases returned costing $120.00

Sansomite's chart of accounts includes the following:
Acct Nbr Account title: Acct Nbr Account title:
101 Cash 401 Sales Revenue
112 Accounts Receivable 412 Sales Returns and Allowances
120 Inventory 414 Sales Discounts
201 Accounts Payable 505 Cost of Goods Sold

Instructions:
Journalize the transactions for the month of July for Ready-Set-Go using a perpetual inventory system.

Date Account titles and explanations Ref Debit Credit
Jul 1 Account title Amount
Account title Amount
Text

3 Account title Amount
Account title Amount
Text

Account title Amount
Account title Amount
Text

9 Account title Amount
Account title Amount
Account title Amount
Text

12 Account title Amount
Account title Amount
Account title Amount
Text

17 Account title Amount
Account title Amount
Text

Account title Amount
Account title Amount
Text

18 Account title Amount
Account title Amount
Text

Account title Amount
Account title Amount
Text

20 Account title Amount
Account title Amount
Text

21 Account title Amount
Account title Amount
Account title Amount
Text

22 Account title Amount
Sales Revenue Amount
Text

Account title Amount
Account title Amount
Text

30 Account title Amount
Account title Amount
Text

31 Account title Amount
Account title Amount
Text

Account title Amount
Account title Amount
Text

Problem P6-2A - Determine cost of goods sold and ending inventory using FIFO, LIFO, and average-cost with analysis.


Financial Accounting, 8th Edition by Weygandt, Kieso, and Kimmel


Primer on Using Microsoft Excel in Accounting by Rex A Schildhouse


Problem P6-2A, Dyna Distribution markets CDs of the performing artist King James. At the beginning of March, Dyna

had in beginning inventory

1,500

King James CDs with a unit cost of

$7.00

During March Dyna

made the following purchases of King James CDs.



Mar 5

3,500

units at

$8.00



Mar 13

4,000

units at

9.00



Mar 21

2,000

units at

10.00



Mar 26

2,000

units at

11.00



During March

10,000

units were sold. Dyna uses a periodic inventory system.



Instructions:


(a) Determine the cost of goods available for sale.




Date:

Quantity


Unit Cost:

Extended Cost:



Mar 1

Quantity

units at

Amount

Formula



5

Quantity

units at

Amount

Formula



13

Quantity

units at

Amount

Formula



21

Quantity

units at

Amount

Formula



26

Quantity

units at

Amount

Formula



Quantity:

Formula

Cost of goods available:

Formula



(b)(1) Determine the ending inventory and cost of goods sold under the First-in, First-out cost flow method. Prove the accuracy of the cost of goods sold.




Ending Inventory


Cost of Goods Sold



Date

Units

Unit Cost

Total Cost


Cost of goods available for sale

Formula



Date

Quantity

Amount

Formula


Title


Formula



Date

Quantity

Amount

Formula


Title


Formula



Formula


Formula




Proof of Cost of Goods Sold



Date

Units

Unit Cost

Total Cost



Date

Quantity

Amount

Formula



Date

Quantity

Amount

Formula



Date

Quantity

Amount

Formula



Date

Quantity

Amount

Formula



Formula


Formula



(b)(2) Determine the ending inventory and cost of goods sold under the Last-in, First-out cost flow method. Prove the accuracy of the cost of goods sold.




Ending Inventory


Cost of Goods Sold



Date

Units

Unit Cost

Total Cost


Title


Amount



Date

Quantity

Amount

Formula


Title


Amount



Date

Quantity

Amount

Formula


Title


Formula



Formula


Formula




Proof of Cost of Goods Sold



Date

Units

Unit Cost

Total Cost



Date

Amount

Amount

Formula



Date

Amount

Amount

Formula



Date

Amount

Amount

Formula



Date

Amount

Amount

Formula



Formula


Formula



(b)(3) Determine the ending inventory and cost of goods sold under the Average Cost cost flow method.



Total units purchased cost:

Amount



Title


Quantity



Average unit cost =

Formula

(Set to four decimal places.)




Ending inventory quantity:


Quantity



Ending inventory value:


Amount



Cost of goods sold:


Formula



Cost of goods available for sale


Formula



(c)(1) Which cost flow method results in the highest inventory amount for the balance sheet?


Enter text answer here.






(c)(2) Which cost flow method results in the highest cost of goods sold for the income statement?

Enter text answer here.

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:

Solution Provider
Top Grade Essay
Top Class Engineers
Assignments Hut
Helping Hand
Essay Writing Help
Writer Writer Name Offer Chat
Solution Provider

ONLINE

Solution Provider

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$36 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$42 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$16 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$44 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$24 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

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

Feed by mt anderson characters - Developing person through childhood and adolescence tenth edition - Powerpoint Presentation - Is booklocker worth it - Which phase of mitosis does cytokinesis overlap with - 2015 qcs writing task - Country selection - Case study - The art of metacommentary they say i say - It service management policy template - Creating a company culture for security design document - Teaming at disney animation - Corpse bride death scene - Andy cano menendez death - 10th grade math test - Context of great gatsby - NSCI 100- CALCULATIONS - Child development theories chart - Discussion - National institute of oceanography kochi - Hr policies of nike ppt - Analysis/Critique of Major Event Paper - Answer to essay-200 words minimum. YRP - Building goodwill is important to converting new customers to committed lifetime customers. - Battle of salamis timeline - Terror Two - Paper - A periodic celebration mystic words - Disaster Preparation Activities - Nursing - Full disclosure principle definition - Accountants in east london - Full ppt on organizational behaviour - IA week5 DB - Convert atn to xml - Texas assessment practice the poor and their betters answers - Cloud computing assignment questions pdf - Causes of world war 1 crossword answer key - Suppose that xtel currently is selling - Vroom's participative decision making model ppt - Difference between ohmic and non ohmic resistor - 6538 celestial drive baton rouge la - Discussion Social Problems - Persuasive speech about no homework policy - Ikea's process for developing a new product - The mean incubation time of fertilized eggs is - The crowding out effect of expansionary fiscal policy suggests that - 0.457 as a fraction - Psychology - Bus 475 final exam 100 questions - Experiment 2 tracking chromosomal dna movement through mitosis - Bio rad precision plus - Functional theory of attitudes katz - 16831 dancing ava selma tx - Discussion question - 75m offshore patrol vessel - Bupa change of details form - Controlled substances act of 1970 - Snhu it 210 milestone 2 - Liebeck v mcdonald's case brief - Steep turns common errors - Rocket sled physics classroom worksheet answers - Vocabulary for gifted students - Many customers get their first impression of your company from - Rosa dias costume designer - Aesthetic and creative development - Viscosity of sugar solution - Management leading and collaborating in a competitive world pdf - Nike cost of capital case study solution - Movie recommendation system source code java - Interaction design beyond human computer interaction 4th edition slides - Aboriginal lesson plans year 3 - Vce psychology units 3 and 4 study design - Le morte d arthur reading check answers - How is atp resynthesised - Caroline bowen minimal pairs - Olivia backseat lovers tab - Math - Unit 1 Scholarly Activity - Vox tonelab le software - Uif declarations email address - Activity-1(Project Management) - Od practitioner case studies - Assignment - Growth vs fixed mindset essay - Understanding the entity and its environment auditing - Lab 6 pressure temperature and volume of gases - Government - What are the disadvantages of buying a franchise comparing to setting up a new business ? - 5.53 km in miles - Jabra pc suite download - What two purposes are accomplished by recording closing entries - Assassin's creed origins the tax master underground entrance - Cu oh 2 ksp - Hertfordshire county council training courses - Body glove expanse ii fins - Excel sam capstone project 1 campus fitness center - To win us to our harm - Capital budgeting mini case solution - Where does rand water go once it has been abstracted