In: Accounting
Prepare trial balance. Unadjusted/adjusting/adjusted trial balances.
The following transactions occurred during the first twelve months of operations: | |||||||||
January 1st | Common stock is issued in exchange for cash in the amount of ………….………….……………………… | 295,000 | |||||||
February 8th | The company purchases and pays for 160 units of gourmet dog food at a price of $25 per unit ………….. | 4,000 | |||||||
March 1st | The company pays cash for a one-year insurance policy in the amount of ……………….………………………..….. | 9,300 | |||||||
March 31st | Rent on a retail space for 12 months is paid in the amount of …..……….……………………………………… | 12,480 | |||||||
April 1st | Grooming and boarding equipment with a useful life of 2 years is purchased for cash in the amount of …… | 18,000 | |||||||
April 10th | Grooming supplies purchased on account in the amount of …………..…………………………………………… | 1,450 | |||||||
May 15th | The company purchases and pays for another 370 units of gourmet dog food at a price of $29 per unit ….. | 10,730 | |||||||
May 30th | Grooming services are performed on account in the amount of …………………………………………………………..………… | 13,625 | |||||||
June 1st | The company pays for advertisements to be run for the next 12 months in the amount of ………………………. | 864 | |||||||
June 30th | The company issues a 5-year bond with a face value of $100,000 and a stated annual rate of 6%. | ||||||||
Interest is due on June 30th each year. The market rate is 8% on the date of issuance ……………………………. | 100,000 | ||||||||
July 25th | Dog-walking services are performed on account in the amount of …...……………………………..………… | 14,225 | |||||||
July 31st | 95 units of gourmet dog food are sold for $70 per unit with terms 2/10, n/30. The sale is recorded using | ||||||||
the gross method in the amount of (see note c for cost flow assumptions) ……………………………………………………………………………………. | 6,650 | ||||||||
August 2nd | Boarding services are provided on account in the amount of ………………………………………………………………. | 6,280 | |||||||
August 6th | The company receives full payment from the customer for the July 31st sale ……………………………………… | 6,517 | |||||||
September 15th | Pet sitting services are performed on account in the amount of ……………………..…………………………….………….. | 6,245 | |||||||
September 29th | Customer payments are received for services previously provided in the amount of ……………………………….. | 1,250 | |||||||
October 13th | 100 units of gourmet dog food are sold for $73 per unit with terms 2/10, n/30. The sale is recorded using | ||||||||
the gross method in the amount of ………………………………………………………………………………………. | 7,300 | ||||||||
October 29th | The company receives payment for half of the October 13th sale ……………………………………………………… | 3,650 | |||||||
November 1st | Equipment originally purchased on April 1st for $2400 is sold for $2000 cash | ||||||||
November 15th | A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation | ||||||||
December 15th | The bookkeeper is paid $3,500 for the previous month's services | 3,500 |
Additional information: | ||||||||
Grooming supplies on hand at the end of the month are as follows: ……………………………………. | 870 | |||||||
The year-end balance reported at the end of the year for the Allowance for Doubtful Accounts | ||||||||
is estimated as 4% of outstanding receivables at the end of the year | ||||||||
The Company uses a perpetual inventory system and accounts for costs using the First-In-First-Out cost | ||||||||
flow assumption. On December 31st, a count of ending inventory reveals that there are 335 bags of dog | ||||||||
food on hand. | ||||||||
All revenue is recorded in the "Sales Revenue" account and reported net of cash discounts on the income statement. | ||||||||
The effective interest method is used to amortize bond premiums and discounts | ||||||||
Adjustments are made at the end of the year for prepaid insurance, rent, advertising, depreciation, and interest expense. | ||||||||
The bookkeeper is paid a salary of $3,500 on the 15th of every month. | ||||||||
The company declared dividends of $650 for the year | ||||||||
Assume selling expenses include advertising and supplies expense. All other expenses, other than depreciation | ||||||||
and interest expense, are considered general & administrative. |
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||||
Date | Account | Debit | Credit | |
Jan 1 | Cash | $295,000 | ||
Jan 1 | Common Stock | $295,000 | ||
Feb 8 | Inventory | $ 4,000 | ||
Feb 8 | Cash | $ 4,000 | ||
Mar 1 | Prepaid Insurance | $ 9,300 | ||
Mar 1 | Cash | $ 9,300 | ||
Mar 31 | Prepaid Rent | $ 12,480 | ||
Mar 31 | Cash | $ 12,480 | ||
Apr 1 | Equipment | $ 18,000 | ||
Apr 1 | Cash | $ 18,000 | ||
Apr 10 | Supplies | $ 1,450 | ||
Apr 10 | Accounts Payable | $ 1,450 | ||
May 15 | Inventory | $ 10,730 | ||
May 15 | Cash | $ 10,730 | ||
May 30 | Accounts Receivable | $ 13,625 | ||
May 30 | Service Revenue | $ 13,625 | ||
Jun 1 | Prepaid Advertising | $ 864 | ||
Jun 1 | Cash | $ 864 | ||
Jun 30 | Cash | $ 92,016 | ||
Jun 30 | Discounts on Bond Payable | $ 7,984 | ||
Jun 30 | Bond Payable | $100,000 | ||
PVf/Pvaf | Amount | PV | ||
Present Value of 100000 (n 5, i 8%) | 0.6806 | $100,000 | $ 68,060 | |
Present Value of Interest 100000*6% | 3.9927 | $ 6,000 | $ 23,956 | |
Bond Issure Price | $ 92,016 | |||
Jul 25 | Accounts Receivable | $ 14,225 | ||
Jul 25 | Service Revenue | $ 14,225 | ||
Jul 31 | Accounts Receivable | $ 6,650 | 95*70 | |
Jul 31 | Sale Revenue | $ 6,650 | ||
Jul 31 | Cost of Goods Sold | $ 2,375 | ||
Jul 31 | Inventory | $ 2,375 | ||
Aug 2 | Accounts Receivable | $ 6,280 | ||
Aug 2 | Service Revenue | $ 6,280 | ||
Aug 6 | Cash | $ 6,517 | ||
Aug 6 | Sales Discount | $ 133 | 6650*2% | |
Aug 6 | Accounts Receivable | $ 6,650 | ||
Sep 15 | Accounts Receivable | $ 6,245 | ||
Sep 15 | Service Revenue | $ 6,245 | ||
Sep 29 | Cash | $ 1,250 | ||
Sep 29 | Accounts Receivable | $ 1,250 | ||
Oct 13 | Accounts Receivable | $ 7,300 | 100*73 | |
Oct 13 | Sale Revenue | $ 7,300 | ||
Oct 13 | Cost of Goods Sold | $ 2,640 | ||
Oct 13 | Inventory | $ 2,640 | ||
Oct 29 | Cash | $ 3,650 | ||
Oct 29 | Accounts Receivable | $ 3,650 | ||
Nov 1 | Depreciation Expense | $ 700 | 2400/2*7/12 | |
Nov 1 | Accumulated Depreciation | $ 700 | ||
Nov 1 | Cash | $ 2,000 | ||
Nov 1 | Accumulated Depreciation | $ 700 | ||
Nov 1 | Gain on Sale of Equipment | $ 300 | ||
Nov 1 | Equipment | $ 2,400 | ||
Dec 15 | Salaries Expense | $ 3,500 | ||
Dec 15 | Cash | $ 3,500 | ||
Adjusting: | ||||
1 | Supplies Expense | $ 580 | 1450-870 | |
1 | Supplies | $ 580 | ||
2 | Bad Debt Expense | $ 1,711 | ||
2 | Allowance for Doubtful Accounts | $ 1,711 | ||
Sale/Service | $ 54,325 | |||
Less: Collection | $ 11,550 | |||
Unadjusted Balance | $ 42,775 | |||
Bad Debt 4% | $ 1,711 | |||
4 | Interest Expense | $ 6,000 | ||
4 | Discount on Bond Payable | $ 480 | ||
4 | Interest Payable | $ 5,520 | ||
5 | Insurance Expense | $ 7,750 | 9300/12*10 | |
5 | Prepaid Insurance | $ 7,750 | ||
6 | Rent Expense | $ 9,360 | 12480/12*9 | |
6 | Prepaid Rent | $ 9,360 | ||
7 | Advertising Expense | $ 504 | 864/12*7 | |
7 | Prepaid Advertising | $ 504 | ||
8 | Depreciation Expense | $ 1,950 | (18000-2400)/2*3/12 | |
8 | Accumulated Depreciation | $ 1,950 | ||
9 | Salaries Expense | $ 3,500 | ||
9 | Salaries Payable | $ 3,500 | ||
10 | Dividends | $ 650 | ||
10 | Dividend Payable | $ 650 |
Normal | Adjustments | Adjusted | ||||
Debit | Credit | Debit | Credit | Debit | Credit | |
Cash | $ 341,559 | $341,559 | ||||
Accounts Receivable | $ 42,775 | $ 42,775 | ||||
Allowance for Doubtful Accounts | $ 1,711 | $ 1,711 | ||||
Inventory | $ 9,715 | $ 9,715 | ||||
Prepaid Advertising | $ 864 | $ 504 | $ 360 | |||
Prepaid Insurance | $ 9,300 | $ 7,750 | $ 1,550 | |||
Prepaid Rent | $ 12,480 | $ 9,360 | $ 3,120 | |||
Supplies | $ 1,450 | $ 580 | $ 870 | |||
Equipment | $ 15,600 | $ 15,600 | ||||
Accumulated Depreciation | $ - | $ 1,950 | $ 1,950 | |||
Accounts Payable | $ 1,450 | $ 1,450 | ||||
Interest Payable | $ 5,520 | $ 5,520 | ||||
Salaries Payable | $ 3,500 | $ 3,500 | ||||
Dividend Payable | $ 650 | $ 650 | ||||
Bond Payable | $100,000 | $100,000 | ||||
Discounts on Bond Payable | $ 7,984 | $ 480 | $ 7,504 | |||
Dividends | $ 650 | $ 650 | ||||
Common Stock | $295,000 | $295,000 | ||||
Sale Revenue | $ 13,950 | $ 13,950 | ||||
Sales Discount | $ 133 | $ 133 | ||||
Service Revenue | $ 40,375 | $ 40,375 | ||||
Gain on Sale of Equipment | $ 300 | $ 300 | ||||
Cost of Goods Sold | $ 5,015 | $ 5,015 | ||||
Depreciation Expense | $ 700 | $ 1,950 | $ 2,650 | |||
Salaries Expense | $ 3,500 | $ 3,500 | $ 7,000 | |||
Supplies Expense | $ 580 | $ 580 | ||||
Bad Debt Expense | $ 1,711 | $ 1,711 | ||||
Interest Expense | $ 6,000 | $ 6,000 | ||||
Rent Expense | $ 9,360 | $ 9,360 | ||||
Insurance Expense | $ 7,750 | $ 7,750 | ||||
Advertising Expense | $ 504 | $ 504 | ||||
Total | $ 451,075 | $451,075 | $ 32,005 | $ 32,005 | $464,406 | $464,406 |