Question

In: Accounting

Part 1 – Instruction - You will prepare the following in excel: 1. General Journal a....

Part 1 – Instruction - You will prepare the following in excel: 1. General Journal

a. Journal entries – full proper journal entry with descriptions

b. Post entries to ledger

2. Ledger – T accounts a. Show beginning balance b. Post all activity – make sure to include reference to journal entry c. Show ending balance

3. Trial Balance a. Unadjusted Trial Balance

The following transaction occurred for Agape Pet Supply Co. during the period ended 12/31/x1.

They provide services to customers and sell products.

March 1 The company was formed with$1,000,000 share authorized - $1 par value.

March 20 The company issued stock for $150,000 at par value.

April 7 Purchased supplies for $4,000 on account.

April 28 Paid $1,200 to get a patent on their special pet leases.

May 10 Purchased inventory for $60,000 on account. The company uses the FIFO method under a perpetual system to account for inventory

May 19 Purchase equipment with a Note Payable of $30,000 due in 5 years. The company used the straight-line method for depreciation.

May 31 Purchase two parcels of land for 55,000 - Parcel A was $30,000 and Parcel B was $25,000. It was thought they would use this land to build a warehouse.

June 1 Purchased two years of Insurance for $6,000. June 26 Provided goods to a customer worth $18,000. Inventory had a cost of $9,200. The customer paid $8,000 cash and rest on account.

July 7 Provided goods of $3,000 to a customer for cash. Inventory had a cost of $1,400. July 26 Paid employee wages of $4,000. August 9 Customer paid $5,000 for goods to be provided in the future.

August 17 Received $12,000 on account for goods provided. Inventory had a cost of $6,700.

Sept 10 Invested $10,000 of excess cash in securities – intend to hold them for several years.

Sept 21 Collected $5,000 from a customer that owed you money for goods previously provided.

Sept 29 It was determined that the land previously purchase to build a warehouse. They sell parcel A for $45,000. Parcel B they decide to hold as an investment.

Oct 1 Paid rent for the period of $12,000 for the next year.

Oct 19 Received Interest income on investments of $850 Nov 8 Received a utility bill for $2,000 for utility services received. (Paid on account)

Nov 27 Paid $2,500 of the amount owed for supplies.

Dec 15 Paid dividend of $3,000.

Solutions

Expert Solution

a)

b)

c)


Related Solutions

Part 1 – General Journal – Post the following journal entries to the general journal.   ...
Part 1 – General Journal – Post the following journal entries to the general journal.    Trans. Date Description 1 May 1 Sell 50,000 shares of common stock for $50,000 to obtain the funds necessary to start your business. 2 May 1 Borrow $20,000 from the local bank and sign a note promising to repay the full amount of the debt in 5 years. 3 May 1 Issue 1,500 shares of $2 par value preferred stock at $30/share. 4 May...
Prepare journal entries to record the December transactions in the General Journal Tab in the excel...
Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense. 1-Dec Began business by depositing $6500 in a bank account in the name of the company in exchange for 650 shares...
Prepare General Journal Entries for the following transactions. Then post the journal entries to the General...
Prepare General Journal Entries for the following transactions. Then post the journal entries to the General Ledger provided and then prepare an Unadjusted Trial Balance. March 1​Dunlop invested $30,000 cash and buildings worth $150,000 in the company March 2​The company rented equipment by paying $2,000 cash for the first month’s (March) rent. March 5​The company purchased $2,400 of office supplies for cash. March 10​The company paid $7,200 cash for the premium on a 12-month insurance policy. Coverage begins on March...
Part 2 – General Journal (LO3-2) – Post the following journal entries to the general journal....
Part 2 – General Journal (LO3-2) – Post the following journal entries to the general journal. ? Trans: May 1 Sell 100,000 shares of common stock for $100,000 to obtain the funds necessary to start your business. ? May 1 Borrow $50,000 from the bank and sign a note promising to repay the full amount of the debt in 5 years. ? May 1 Issue 1,000 shares of $2 par value preferred stock at $30/share. ? May 1 ? Purchase...
Prepare journal entries in general journal format to record the following transactions for the City of...
Prepare journal entries in general journal format to record the following transactions for the City of Dallas General Fund (subsidiary detail may be omitted) 1. The budget prepared for the fiscal year included total estimated revenues of $4,693,000, appropriations of $4,686,000 and estimated other financing uses of $225,000. 2. Purchase orders in the amount of $451,000 were mailed to vendors. 3. The current year’s tax levy of $4,005,000 was recorded; uncollectible taxes were estimated to be 2% of the tax...
#1. Prepare journal entries to record the December transactions in the General Journal Tab in the...
#1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense. 1-Dec Began business by depositing $10500 in a bank account in the name of the company in exchange for 1050...
#1. Prepare journal entries to record the December transactions in the General Journal Tab in the...
#1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense. 1-Dec Began business by depositing $6500 in a bank account in the name of the company in exchange for 650...
Prepare entries in general journal form to record the following transactions in General Fund general ledger...
Prepare entries in general journal form to record the following transactions in General Fund general ledger accounts for fiscal year 2019. Use modified accrual accounting for the General fund only -The legal budget for the year provided for $900,000 of estimated revenues, $800,000 appropriations, and $50,000 transfer out to debt service fund. -Issued $ 250,000 of purchase orders outstanding for office supplies. -Property taxes were levied in the amount of $400,000. It is estimated that 2 percent of the taxes...
QUESTION 1 Required: #1. Prepare journal entries to record the December transactions in the General Journal...
QUESTION 1 Required: #1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense. 1-Dec Began business by depositing $8500 in a bank account in the name of the company in...
Prepare journal entries in general journal format to record the following transactions for the 2020 fiscal...
Prepare journal entries in general journal format to record the following transactions for the 2020 fiscal year for the City of Portage General Fund (Subsidiary detail may be omitted.). The budget prepared for the fiscal year included estimated revenues of $3,774,000, appropriations of $3,695,000 and estimated other financing uses of $35,000. Purchase orders in the amount of $838,000 were mailed to vendors The current year’s tax levy of $3,005,000 was recorded; uncollectibles taxes were estimated to be 2% of the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT