Portobello Co.- Reconstructing the income statement and balance sheet. Portobello Co., a retailer, is in its 10th year of operation. On December 28, 2008, three days before the close of its fiscal year, a Category 5 hurricane devastated the company's administrative office and destroyed almost all of its accounting records. The company saved the balance sheet on December 31, 2007 (see Exhibit 1 on the next page), the checkbook, the bank statements, and some soggy remains of the specific accounts receivable and accounts payable balances. Based on a review of the surviving documents and a series of interviews with company employees, you obtain the following information i. The company's insurance agency advises that a four-year insurance policy has six months to run as of December 31, 2008. The policy cost $12,000 when the company paid the four-year premium during 2005. ii. During 2008, the company's board of directors declared $6,000 of dividends, of which the firm paid $3,000 in cash to shareholders during 2008 and will pay the remainder during 2009. Early in 2008, the company also paid dividends of $1,800 cash that the board of directors had declared during 2007 iii. On April 1, 2008, the company received from Appleton Co. $10,900 cash, which included principal of $10,000 and interest, in full settlement of Appleton's nine-month note dated July 1, 2007. According to the terms of the note, Appleton was required to and paid all interest at maturity on April 1, 2008. a. The amount owed by the company to merchandise (inventory) suppliers on December 31, 2008, was $16,000. During 2008, the company paid $115,000 to merchandise suppliers. The cost of merchandise inventory on December 31, 2008, based on a physical count, was $40,000. The cost of goods sold was correctly calculated at $88,000. This amount was debited to the Cost of Goods Sold account and credited to the Merchandize inventory account. v. a. The company purchased delivery trucks on March 1, 2008, for $60,000. The delivery trucks have an expected useful life of 10 years and an estimated salvage value of $6,000. The company uses the straight-line depreciation method. b. To finance the acquisition of the truck, it gave the seller a $60,000 four-year note that bears interest at 10% per year. The company must pay interest on the note each six months, beginning September 1, 2008. On September 1, the company made the required interest payment of $3,000 (60,000x10% x 6/12)) for the 6 month period (3/1-9/1) and recorded it accordingly. vi. The company's computer system has a six-year total expected life and zero expected salvage value. vii. a. The company makes all sales on account and recognizes revenue at the time of shipment to customers. During 2008, the company received $210,000 cash from sales to customers. A close examination revealed that $1,400 of the $210,000 cash from its customers cash received from customers during 2008 applies to merchandise that the company will not ship until 2009. The company's accountant reconstructed the Accounts Receivable subsidiary ledger, the detailed record of the amount owed to the company by each customer. It showed that customers owed the company $51,000 on December 31, 2008. b. The beginning balance in the "Advances from Customers" account reflects $600 received in advance from customers during 2007 for merchandise shipped in 2008. viii. a. The company paid $85,000 in cash to employees during 2008. Of this amount, $6,500 relates to services that employees performed during 2007 and reflected in the "Salaries Payable" account at the beginning of the period. $4,000 relates to advance payment to employees for services to be performed during 2009. Advance payments to employees were debited to "Advances to Employees" account. Employees performed the remainder of the services during 2008. b. On December 31, 2008, the company owes employees $1,300 for services performed during the last several days of 2008. The amount has not been recorded. ix. a. The company paid $27,000 in cash for property and income taxes during 2008. Of this amount, $10,000 relates to income taxes applicable to 2007, and $3,000 relates to future property taxes applicable to 2009. b. The company owes and has yet to record $4,000 in income taxes on December 31, 2008. On December 9, 2008, Portobello Co. entered into a contract with a management consulting firm for consulting services at a cost of $48,000 per year. The consulting firm had performed 10% of the estimated total consulting services under the contract by December 31, 2008. However, the accountant at Portobello Co. forgot to record an adjusting entry on December 31, 2008 for the consulting expenses incurred during the period. Portobello Co. Balance Sheet December 31, 2007 $ 18,600 33,000 10,000 600 22,000 4.500 $ 88,700 Cash Accounts Receivable Notes Receivable Interest Receivable Merchandise Inventories Prepaid Insurance Total Current Assets Computer System: At Cost Less Accumulated Depreciation Net Computer System. Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Accounts Payable for Merchandise Dividend Payable Salaries Payable Taxes Payable.. Advances from Customers. Total Liabilities Common Stock Retained Earnings. Total Shareholders' Equity. Total Liabilities and Shareholders' Equity. $ 78,000 (26,000) $ 52,000 $140,700 $ 36,000 1,800 6,500 10,000 600 $ 54,900 $ 40,000 45,800 $ 85,800 $140.700 REQUIRED: Determine the missing amounts in the T accounts provided in the following pages using information provided in the above transactions Transactions provided in bold have not been recorded in the T accounts. Prepare a Trial Balance for the period ended December 31, 2008. Use the template provided on page 6 of this exercise. Bal. (vii) Homework Assignment 2 Team Assignment 1 Solution Template 1-Cash 2-Accounts Receivable 18,600 Bal. 33,000 (ili) 10,900 1,800 (ii) (vii.) 226,600 208,600 (vii.a)* 210,000 115,000 (iv) (210.000-1.400) 3,000 (ii) Bal. 51.000 85,000 (viii.a) 27,000 (ix) 3,000 (v.b) Bal. 4,700 Bertran Arna C... Team Assignment.... * sh (V1) Homework Assignment 2 Team Assignment 1 Solution Template 1-Cash _ 2-Accounts Receivable Bal. 18,600 Bal. 33,000 1 (iii) 10,900 1,800 (ii) (vii.) 226,600 208,600 (vii.a)* (vii) 210,000 115,000 (iv) (210.000-1.400) 3,000 (ii) Bal. 51,000 85,000 (viii.a) 27,000 (ix) 3.000 (v.b) Bal. 4.700 Bal. 3-Notes Receivable 10,000 ? Bal. 5-Interest Receivable 600 ? (iii) (iii) Bal. Bal. 7-Prepaid Insurance 4,500 $? Bal. (iv.a) (iv.b) Bal. 6-Merchandise Inventory 22,000 Bal. 95,000 $88,000(iv.) COGS (i) Bal. Bal. (iv.a) (iv.b) Bal. 7-Prepaid Insurance 4,500 6-Merchandise Inventory 22,000 Bal. 95,000 $88,000(iv.) COGS ? Bal. (iv) 8-Accounts Payable (A/P) 36,000 Bal. 115,000 95,000 (iv.a) 16,000 Bal. 9-Notes Payable 0 Bal. 60,000 (v.b) 60,000 Bal. 11. Prepaid Taxes 10-Advances to Employees (Prepaid Wages) Bal. Bal. (viii.a) 4,000 (ix.a) Bal. 4.000 Bal. 12-Computer System (at Cost) Bal. 78,000 13-Accumulated Depreciation- Computer System 26,000 Bal. 13,000 (vi) 39,000 Bal. Bal. 78,000 12-Computer System (at Cost) Bal. 78,000 13-Accumulated Depreciation- Computer System 26,000 Bal. 113,000 (vi) 39,000 Bal. Bal. 78,000 14-Delivery Trucks Bal. 15-Accumulated Depreciation- Delivery Trucks 0 Bal. 4,500 (v.a) 4,500 Bal. (v.b) 60.000 60,000 Bal. 16-Interest Payable 0 Bal. ? (v.b) $ ? Bal. (ii) (ii) 17-Dividends Payable 1,800 1,800 Bal. 3,000 -6.000 (ii) 3,000 Bal. 18-Salaries Payable 6,500 Bal. (viii.a) 6,500 ?(viii.b) ? Bal. 19-Taxes Payable 10,000 Bal. ? ? (ix.b) (ix.a) ? Bal. 20-Consulting Fee Payable 0 Bal. 4,800 (x) 4,800 Bal. 21-Advances from Customers (Unearned Rev) 600 Bal. 1,400 (vii.a) ? Bal. 22-Common Stock 40,000 Bal. 23-Retained Earnings 45,800 Bal. ? (iv.b) ? Bal. (ii) 6,000 39.800 Bal. 22-Common Stock 40,000 Bal. 23-Retained Earnings 1 45,800 Bal. ? (iv.b) ? Bal. (ii) 6.000 39.800 Bal. 24-Sales Revenue 226,600 (vii.a) ? (vii.b) Bal. $? 25-Interest Revenue ? (iii) Bal. $? 1 .1 Share _ (COGS) 26-Cost of Goods Sold 88.000 27a-Depreciation Expense - Del. Truck (v.a) 4.500 Bal. $ 88,000 Bal. 4.500 27b-Depreciation Expense - Computer (vi) Bal. 13,000 $ 13,000 29-Tax Expense 28-Salary Expense (viii.a) 74,500 (viii.b) Bal. ? (ix.a) (ix.b) Bal. $ ? 30-Insurance Expense (i) (x) 31-Consulting Expense 4,800 Bal. __? Bal. 4.800 30-Insurance Expense (i) 31-Consulting Expense 4,800 (x) Bal. Bal. 4,800 32-Interest Expense 3,000 (v.b) (v.b) Bal. Portobello Co.- Reconstructing the income statement and balance sheet. Portobello Co., a retailer, is in its 10th year of operation. On December 28, 2008, three days before the close of its fiscal year, a Category 5 hurricane devastated the company's administrative office and destroyed almost all of its accounting records. The company saved the balance sheet on December 31, 2007 (see Exhibit 1 on the next page), the checkbook, the bank statements, and some soggy remains of the specific accounts receivable and accounts payable balances. Based on a review of the surviving documents and a series of interviews with company employees, you obtain the following information i. The company's insurance agency advises that a four-year insurance policy has six months to run as of December 31, 2008. The policy cost $12,000 when the company paid the four-year premium during 2005. ii. During 2008, the company's board of directors declared $6,000 of dividends, of which the firm paid $3,000 in cash to shareholders during 2008 and will pay the remainder during 2009. Early in 2008, the company also paid dividends of $1,800 cash that the board of directors had declared during 2007 iii. On April 1, 2008, the company received from Appleton Co. $10,900 cash, which included principal of $10,000 and interest, in full settlement of Appleton's nine-month note dated July 1, 2007. According to the terms of the note, Appleton was required to and paid all interest at maturity on April 1, 2008. a. The amount owed by the company to merchandise (inventory) suppliers on December 31, 2008, was $16,000. During 2008, the company paid $115,000 to merchandise suppliers. The cost of merchandise inventory on December 31, 2008, based on a physical count, was $40,000. The cost of goods sold was correctly calculated at $88,000. This amount was debited to the Cost of Goods Sold account and credited to the Merchandize inventory account. v. a. The company purchased delivery trucks on March 1, 2008, for $60,000. The delivery trucks have an expected useful life of 10 years and an estimated salvage value of $6,000. The company uses the straight-line depreciation method. b. To finance the acquisition of the truck, it gave the seller a $60,000 four-year note that bears interest at 10% per year. The company must pay interest on the note each six months, beginning September 1, 2008. On September 1, the company made the required interest payment of $3,000 (60,000x10% x 6/12)) for the 6 month period (3/1-9/1) and recorded it accordingly. vi. The company's computer system has a six-year total expected life and zero expected salvage value. vii. a. The company makes all sales on account and recognizes revenue at the time of shipment to customers. During 2008, the company received $210,000 cash from sales to customers. A close examination revealed that $1,400 of the $210,000 cash from its customers cash received from customers during 2008 applies to merchandise that the company will not ship until 2009. The company's accountant reconstructed the Accounts Receivable subsidiary ledger, the detailed record of the amount owed to the company by each customer. It showed that customers owed the company $51,000 on December 31, 2008. b. The beginning balance in the "Advances from Customers" account reflects $600 received in advance from customers during 2007 for merchandise shipped in 2008. viii. a. The company paid $85,000 in cash to employees during 2008. Of this amount, $6,500 relates to services that employees performed during 2007 and reflected in the "Salaries Payable" account at the beginning of the period. $4,000 relates to advance payment to employees for services to be performed during 2009. Advance payments to employees were debited to "Advances to Employees" account. Employees performed the remainder of the services during 2008. b. On December 31, 2008, the company owes employees $1,300 for services performed during the last several days of 2008. The amount has not been recorded. ix. a. The company paid $27,000 in cash for property and income taxes during 2008. Of this amount, $10,000 relates to income taxes applicable to 2007, and $3,000 relates to future property taxes applicable to 2009. b. The company owes and has yet to record $4,000 in income taxes on December 31, 2008. On December 9, 2008, Portobello Co. entered into a contract with a management consulting firm for consulting services at a cost of $48,000 per year. The consulting firm had performed 10% of the estimated total consulting services under the contract by December 31, 2008. However, the accountant at Portobello Co. forgot to record an adjusting entry on December 31, 2008 for the consulting expenses incurred during the period. Portobello Co. Balance Sheet December 31, 2007 $ 18,600 33,000 10,000 600 22,000 4.500 $ 88,700 Cash Accounts Receivable Notes Receivable Interest Receivable Merchandise Inventories Prepaid Insurance Total Current Assets Computer System: At Cost Less Accumulated Depreciation Net Computer System. Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Accounts Payable for Merchandise Dividend Payable Salaries Payable Taxes Payable.. Advances from Customers. Total Liabilities Common Stock Retained Earnings. Total Shareholders' Equity. Total Liabilities and Shareholders' Equity. $ 78,000 (26,000) $ 52,000 $140,700 $ 36,000 1,800 6,500 10,000 600 $ 54,900 $ 40,000 45,800 $ 85,800 $140.700 REQUIRED: Determine the missing amounts in the T accounts provided in the following pages using information provided in the above transactions Transactions provided in bold have not been recorded in the T accounts. Prepare a Trial Balance for the period ended December 31, 2008. Use the template provided on page 6 of this exercise. Bal. (vii) Homework Assignment 2 Team Assignment 1 Solution Template 1-Cash 2-Accounts Receivable 18,600 Bal. 33,000 (ili) 10,900 1,800 (ii) (vii.) 226,600 208,600 (vii.a)* 210,000 115,000 (iv) (210.000-1.400) 3,000 (ii) Bal. 51.000 85,000 (viii.a) 27,000 (ix) 3,000 (v.b) Bal. 4,700 Bertran Arna C... Team Assignment.... * sh (V1) Homework Assignment 2 Team Assignment 1 Solution Template 1-Cash _ 2-Accounts Receivable Bal. 18,600 Bal. 33,000 1 (iii) 10,900 1,800 (ii) (vii.) 226,600 208,600 (vii.a)* (vii) 210,000 115,000 (iv) (210.000-1.400) 3,000 (ii) Bal. 51,000 85,000 (viii.a) 27,000 (ix) 3.000 (v.b) Bal. 4.700 Bal. 3-Notes Receivable 10,000 ? Bal. 5-Interest Receivable 600 ? (iii) (iii) Bal. Bal. 7-Prepaid Insurance 4,500 $? Bal. (iv.a) (iv.b) Bal. 6-Merchandise Inventory 22,000 Bal. 95,000 $88,000(iv.) COGS (i) Bal. Bal. (iv.a) (iv.b) Bal. 7-Prepaid Insurance 4,500 6-Merchandise Inventory 22,000 Bal. 95,000 $88,000(iv.) COGS ? Bal. (iv) 8-Accounts Payable (A/P) 36,000 Bal. 115,000 95,000 (iv.a) 16,000 Bal. 9-Notes Payable 0 Bal. 60,000 (v.b) 60,000 Bal. 11. Prepaid Taxes 10-Advances to Employees (Prepaid Wages) Bal. Bal. (viii.a) 4,000 (ix.a) Bal. 4.000 Bal. 12-Computer System (at Cost) Bal. 78,000 13-Accumulated Depreciation- Computer System 26,000 Bal. 13,000 (vi) 39,000 Bal. Bal. 78,000 12-Computer System (at Cost) Bal. 78,000 13-Accumulated Depreciation- Computer System 26,000 Bal. 113,000 (vi) 39,000 Bal. Bal. 78,000 14-Delivery Trucks Bal. 15-Accumulated Depreciation- Delivery Trucks 0 Bal. 4,500 (v.a) 4,500 Bal. (v.b) 60.000 60,000 Bal. 16-Interest Payable 0 Bal. ? (v.b) $ ? Bal. (ii) (ii) 17-Dividends Payable 1,800 1,800 Bal. 3,000 -6.000 (ii) 3,000 Bal. 18-Salaries Payable 6,500 Bal. (viii.a) 6,500 ?(viii.b) ? Bal. 19-Taxes Payable 10,000 Bal. ? ? (ix.b) (ix.a) ? Bal. 20-Consulting Fee Payable 0 Bal. 4,800 (x) 4,800 Bal. 21-Advances from Customers (Unearned Rev) 600 Bal. 1,400 (vii.a) ? Bal. 22-Common Stock 40,000 Bal. 23-Retained Earnings 45,800 Bal. ? (iv.b) ? Bal. (ii) 6,000 39.800 Bal. 22-Common Stock 40,000 Bal. 23-Retained Earnings 1 45,800 Bal. ? (iv.b) ? Bal. (ii) 6.000 39.800 Bal. 24-Sales Revenue 226,600 (vii.a) ? (vii.b) Bal. $? 25-Interest Revenue ? (iii) Bal. $? 1 .1 Share _ (COGS) 26-Cost of Goods Sold 88.000 27a-Depreciation Expense - Del. Truck (v.a) 4.500 Bal. $ 88,000 Bal. 4.500 27b-Depreciation Expense - Computer (vi) Bal. 13,000 $ 13,000 29-Tax Expense 28-Salary Expense (viii.a) 74,500 (viii.b) Bal. ? (ix.a) (ix.b) Bal. $ ? 30-Insurance Expense (i) (x) 31-Consulting Expense 4,800 Bal. __? Bal. 4.800 30-Insurance Expense (i) 31-Consulting Expense 4,800 (x) Bal. Bal. 4,800 32-Interest Expense 3,000 (v.b) (v.b) Bal
