Old MathJax webview

Smallville Company was organized on January 1, 2020. It is authorized to issue 103000 shares of $110 par value common stock. At the beginning of April, the ledger of Smallville Company carried the following balances to their respective accounts.

Cash-$57000, Merchandise Inventory- $75300, Prepaid Insurance-$5000, 10% Notes Payable-$25500, Equipment-$140000, Accumulated Depreciation: Equipment-$3500, Common Stock-$124000, Paid in capital in excess of par value: Common Stock-$23000, and Retained Earnings-$101300.

The following transactions took place in Smallville Company during April of the current year (2020).

April 1 - Issued 2600 new shares of common stock for $336000

April 3 - Purchased merchandise of $7900 on account from Prescott Co., terms FOB destination, 3/10, n/30. The appropriate party paid the freight charge of $300.

April 4 - Sold merchandise for cash, $89500. The cost of the merchandise sold was $48000.

April 5 - Purchased merchandise on account from Stafford Co., $21000, terms FOB shipping point, 3/10, n/30. The appropriate paid the freight charge of $710.

April 6 - Returned $560 of merchandise purchased on April 3 from Prescott Co.

April 13 - Paid Prescott Co. on account for purchase of April 3.

April 15 - Paid Stafford Co. on account for purchase of April 5.

April 17 - Purchased merchandise for cash $1400.

April 20 - Received refund for poor quality merchandise from supplier on cash purchase $190.

REQUIREMENTS: download the excel file given at the link below and answer the follow questions and then upload the completed excel file via link given at the bottom of the page: (1) Journalize the transactions for the month of April. (Assume that the company follows perpetual inventory system). (2) Post the April journal entries to the ledger. (Remember, the ledger accounts should start with the beginning balances (if any) (3) Prepare a trial balance on April 30, 2020.

Additional Information on Smallville Company:

A review of the ledger of Smallville Company at April 30, 2020, produces the following data pertaining to the preparation of monthly adjusting entries.

(a) Notes Payable $25500. This balance consists of a note for 6 months at an annual interest rate of 15%, dated January 1, 2020. (b) There are five workers in Smallville Company who are paid wages weekly. The five workers are paid $890 each for a 5-day work week (Monday to Friday). April 30 is a Tuesday and workers are paid on Fridays. (c) Annual depreciation is $12400 on equipment. (d) Physical check reveals inventory actually on hand on April 30, 2020 is $54209.8.

(4) Journalize the adjusting entries at April 30, 2020. (5) Prepare an adjusted trial balance. (6) Using the balances from the adjusted trial balance, prepare a multi-step income statement and owners equity statement for the one month ended April 30. (Assume that the company falls under 20% tax bracket).

Plz answer all this short questions by using this format

Smallville Company Book of Journals Date Particulars/Account titles Ref Dr Cr Total Smallville Company Ledger Cash Ref. Dr Cr Date Explanation Balance ($) Balance is Dr/Cr? Merchandise Inventory Ref. Dr Cr Date Explanation Balance ($2 Balance is Dr/Cr? Prepaid Insurance Ref. Dr Cr Date Explanation Balance $ Balance is Dr/Cr? 10% Notes Payable Ref. Dr Cr Date Explanation Balance ($) Balance is Dr/Cr? Equipment Ref. Dr Cr Date Explanation Balance ($) Balance is Dr/Cr? Accumulated Depreciation Equipment Ref. Dr Cr Balance ($) Date Explanation Balance is Dr/Cr? Common Stock Ref. Dr Cr Date Explanation Balance ($) Balance is Dr/Cr? Paid in capital in excess of par-Common Stock Ref. Dr Cr Balance ($) Date Explanation Balance is Dr/Cr? Retained Earnings Ref. Dr Cr Date Explanation Balance ($) Balance is Dr/Cr? Accounts Payable Ref. Dr Cr Date Explanation Balance ($) Balance is Dr/Cr? Sales Revenue Ref. Dr Cr Date Explanation Balance ($) Balance is Dr/Cr? Cost of Goods Sold Smallville Company Trial Balance Serial No. Account Titles Dr Cr Total Smallville Company Adjusting Entries Particulars/Account titles 1 Date Serial Ref Dr Cr N 3 3 4 Total Smallville Company Adjusted Trial Balance Serial No. Account Titles Dr op Cr Total Smallville Company Income Statement Smallville Company Statement of Stockholders' Equity