Question

In: Accounting

Prepare the Income Statement, Balance Sheet and Statement of Owner's Equity in an Excel File. (1)....

Prepare the Income Statement, Balance Sheet and Statement of Owner's Equity in an Excel File. (1). Mr. Sheng sought an attorney for legal advice to help him start a company, The Sheng Enterprise, which sells native rattan bags. On January 1, 2010, Mr. Sheng invested P2,000,000.00 cash in the business. The attorney advised him to hire an accountant for his bookkeeping. Mr. Sheng paid P1,000.00 for the legal services. However, Mr. Sheng was preoccupied with the product development that was already the end of January before he hired you to straighten out his records. While understanding the business transactions that occurred during January, you discover that: After he invested P2,000,000.00 cash and paid the attorney, P1,000.00, on January 5, Mr. Sheng borrowed P600,000.00 from the bank, where he has to pay the bank a part of the principal and interest monthly for 1 year starting this January 31st. That is, a fixed P50,000.00 from the principal and interest amounting, P1,500.00. On January 13, Mr. Sheng purchased a secondhand delivery truck in the company name, paying P450,000.00 down and financing P300,000.00. The first payment on the truck is due February 15. Apart from this, he also rented an office and paid 3 months’ rent of P36,000.00 in advance, credit purchase of office equipment of P45,000.00, cash purchase of supplies amounting, P15,000.00. On the 24th of January, Mr. Sheng sold P180,000.00 worth of rattan bags- P75,000.00 were credit transactions. Of the credit transactions, P32,000.00 was collected during January 31 and the balance remained to be collected at the end of February. On January 31, the company received a bill of P7,000.00 for the January utility expenses and a check amounting, P6,000.00 from a customer for orders to be completed February. Lastly, wages of P15,000.00 were paid to the employees.

Solutions

Expert Solution


Related Solutions

Prepare the income statement, the statement of owner's equity, and a classified balance sheet. Use proper...
Prepare the income statement, the statement of owner's equity, and a classified balance sheet. Use proper formatting techniques including headings and dollar signs. You opened a new pet supplies store and named it Ozzie’s Pet Supply and Boarding on December 1, 2019. The following information about December’s transactions, accounts, and adjustment data is available. Transactions: Dec. 1 Family members contributed $50,000 cash to the business in exchange for capital. Dec. 2 Purchased $10,800 of equipment for the store paying cash....
Prepare the worksheet, income statement, statement of owner's equity and balance sheet using the following information....
Prepare the worksheet, income statement, statement of owner's equity and balance sheet using the following information. Account Balances of Cross Lumber Account No. 110 Cash 1300 111 Accounts Receivable 1280 112 Merchandise Inventory 4300 113 Lumber Supplies 267 114 Prepaid Insurance 209 121 Lumber Equipment 3300 122 Acc. Dep. Lumber Equipment 530 220 Accounts Payable 1200 221 Wages Payable - 330 J. Cross, Capital 5761 331 J. Cross, Withdrawls 2700 332 Income Summary - 440 Sales 23200 441 Sales Returns...
take the final balances and create an Income Statement, Statement of Owner's Equity and Balance Sheet...
take the final balances and create an Income Statement, Statement of Owner's Equity and Balance Sheet for this company. You can title the company CW Rental Management. On June 1 of the current year, Chad Wilson established a business to manage rental property. He completed the following transactions during June: Opened a business bank account with a deposit of $30,000 from personal funds. Purchased office supplies on account, $1,800. Received cash from fees earned for managing rental property, $10,000. Paid...
Liabilities are reported on the a. balance sheet b. income statement c. statement of owner's equity...
Liabilities are reported on the a. balance sheet b. income statement c. statement of owner's equity d. statement of cash flows
I need the general ledger, trial balance, income statement, statement of owner's equity, and balance sheet...
I need the general ledger, trial balance, income statement, statement of owner's equity, and balance sheet (1) SMITH COMPUTER CENTER GENERAL JOURNAL PAGE 1 Date Account Titles and Description PR Dr. Cr. Sept. 1 Cash 5 6 0 0 Smith C. Capital 5 6 0 0 Owner Investment 1 Equipment 1 8 0 0 Cash 1 8 0 0 Bought equipment for cash 1 Equipment 2 1 0 0 Cash 2 1 0 0 Bought equipment for cash 1 Account...
Prepare T account, trial balance, balance sheet and changes in owner's equity statement. Jan-1 The JW-Corp...
Prepare T account, trial balance, balance sheet and changes in owner's equity statement. Jan-1 The JW-Corp Received $120,000 from Investors in Exchange for 6,000 shares of Common Stock. Jan-2 JW-Corp Borrowed $150,000 from SCHWAB BANK and signed a Note Due in 24 months. Jan-3 JW Corp purchased Office Equipment worth $120,000 (5 year life), with a $40,000 Down payment of Cash and the remainder Due on account to Target-Corp within 9 Months. Jan-4 JW Corp purchased an Office Building for...
1. Prepare an income statement, statement of stockholders' equity and balance sheet The accounting records of...
1. Prepare an income statement, statement of stockholders' equity and balance sheet The accounting records of Campus company for the year ended February 28, 2018 Required: Multiple-step income statement, Statement of changes in stockholder’s equity and Balance Sheet. Use following information: Accumulated depreciation building $200,000 Retained earnings 158,000 Cost of goods sold 4,800,000 Prepaid insurance 10,000 Sales Revenue 7,805,000 Treasury Stocks 351,000 Accounts receivables 445,000 Merchandise Inventory 597,000 Mortgage payable (90,000 of this mortgage is to be pd within a...
I am having trouble making an income statement, Statement of owner's equity, and Balance sheet out...
I am having trouble making an income statement, Statement of owner's equity, and Balance sheet out of this information Chapter 3 Assignment 10-01-2018 1.00 1.00 0.99 Hide or show questions Progress:3/3 items eBook Calculator Adjusting Entries and Adjusted Trial Balances Reece Financial Services Co., which specializes in appliance repair services, is owned and operated by Joni Reece. Reece Financial Services’ accounting clerk prepared the following unadjusted trial balance at July 31, 2019: Reece Financial Services Co. Unadjusted Trial Balance July...
Prepare multiple step income statement and statement of changes in owner's equity for the month Jan-1...
Prepare multiple step income statement and statement of changes in owner's equity for the month Jan-1 The JW-Corp Received $120,000 from Investors in Exchange for 6,000 shares of Common Stock. Jan-2 JW-Corp Borrowed $150,000 from SCHWAB BANK and signed a Note Due in 24 months. Jan-3 JW Corp purchased Office Equipment worth $120,000 (5 year life), with a $40,000 Down payment of Cash and the remainder Due on account to Target-Corp within 9 Months. Jan-4 JW Corp purchased an Office...
The trail balance will be used in preparation of the income statement, statement of owner's equity,...
The trail balance will be used in preparation of the income statement, statement of owner's equity, balance sheet, and statement of cash flow. Specifically how?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT