Question

In: Accounting

NEED ANSWER ASAP Read the given financial data of Bob's Bacon House Inc. Determine which accounts...

NEED ANSWER ASAP

  • Read the given financial data of Bob's Bacon House Inc.
  • Determine which accounts belong to the balance sheet and which accounts belong to the income statement.
  • Determine to which subgroup of balance sheet or income statement each account belongs.
  • Compute the correct account balances that should be reported in balance sheet and correct amounts of revenues and expenses that should be reported in income statement.
  • Arrange the accounts in proper order and functionality.
  • Prepare a comprehensive balance sheet in good form.
  • Prepare a multistep income statement in good form.

Financial Data of Bob's Bacon House Inc. as of January 1, 20XX

Accounts Payable 200,500
Account Receivable 165,700
Accumulated Depreciation's 350,000
Additional Paid-In Capital 40,000
Allowance for Doubtful Accounts 2,650
Building and Equipment 1,120,000
Cash 45,300
Common Stock 544,850
Copyrights 112,000
Customer Deposits (expected to be paid in 20XX) 375
Goodwill 225,000
Income Taxes Payable 42,340
Inventories @ $25/unit 315,250
Long-term Investments in Warren Co. 95,630
Deposits With Vendors 47,200
Land 125,000
Mortgage Payable ($2,780 per month) 667,200
2% Notes Payable to Banks (due 20XX) 26,000
Notes Receivable (due 20XX) 16,000
Patents 219,335
Retained Earnings 127,500
Trademarks 115,000
Twenty-year, 3% Bonds, Due 1/1/20XX 600,000

Financial Data of Bob's Bacon House Inc. for the Year 20XX

1 Finished Goods inventory purchased from suppliers on account.

2/10/20XX 10,000 units @ $26 each

6/12/20XX 15,000 units @ $28 each

10/23/20XX 12,000 units @ $29 each

11/25/20XX 8,000 units @ $30 each

Bob's Bacon House Inc. uses periodic inventory system and LIFO costing method. All purchases and sales are made on account.
2 Payments made to suppliers on account during 20XX are $1,124,450.
3 Sales made to customers on account are 49,356 units @ $36 each.
4 Cash collected from customers during 20XX is $1,750,700.
5 Total interest paid on notes payable and bonds payable amounted to $17,415.
6 Rental income on property leased out is $25,650.
7 Bob's Bacon House Inc. was operating a retail store in Chicago. Original cost of building and equipment was $120,000 with a book value of $95,000. During 20XX, New York Traders disposed of this store at a loss of $35,800.
8 Bob's Bacon House Inc. wants to make an allowance for doubtful debts at 2% on accounts receivable for the year 20XX.
9 Selling and administrative expenses are $128,475. These expenses include $56,000 depreciation expense on building and equipment but exclude bad debts expenses.
10 Income tax expense paid is $90,500. Bob's Bacon House income tax rate for 20XX is 30%.

grading format

Category Points % Description
Account Selection 15 10 Make proper selection of accounts relative to the balance sheet or the income statement. From the provided listing of accounts, determine which accounts are balance sheet accounts and which accounts are income statement accounts.
Subgroup Functionality 15 10 Put the accounts into the proper subgroup according to functionality. Each account belongs to a particular subgroup. The student is to determine to which subgroup the account belongs. This should be done according to functionality.
Balance Sheet 60 40 Prepare the balance sheet in good form with correct amount of financial items. Proper form is important in the preparation of the balance sheet. Examples can be found in the text.
Income Statement 45 30 Prepare the income statement in good form with correct amount of financial items. Proper form is important in the preparation of the income statement. Examples can be found in the text.
Computation Results 15 10 Show full work of computation to arrive at the correct amount of financial items.
Total 150 100 A quality paper will meet or exceed all of the above requirements.

Solutions

Expert Solution

Classification Sub Group Classification
Accounts Payable $    200,500.00 liabilities Current Liability
Account Receivable $    165,700.00 asset Current Asset
Accumulated Depreciation's $    350,000.00 liabilities To be deducted from Fixed Asset
Additional Paid-In Capital $     40,000.00 liabilities Owners Equity
Allowance for Doubtful Accounts $       2,650.00 liabilities To be deducted from Accounts Receivable
Building and Equipment $ 1,120,000.00 asset Fixed Asset
Cash $     45,300.00 asset Current Asset
Common Stock $    544,850.00 liabilities Owners Equity
Copyrights $    112,000.00 asset Intangible Asset
Customer Deposits (expected to be paid in 20XX) $          375.00 liabilities Current Liability
Goodwill $    225,000.00 asset Intangible Asset
Income Taxes Payable $     42,340.00 liabilities Current Liability
Inventories @ $25/unit $    315,250.00 asset Current Asset
Long-term Investments in Warren Co. $     95,630.00 asset Non current Asset
Deposits With Vendors $     47,200.00 asset Current Asset
Land $    125,000.00 asset Fixed Asset
Mortgage Payable ($2,780 per month) $    667,200.00 liabilities Current Liability
2% Notes Payable to Banks (due 20XX) $     26,000.00 liabilities Current Liability
Notes Receivable (due 20XX) $     16,000.00 asset Current Asset
Patents $    219,335.00 asset Intangible Asset
Retained Earnings $    127,500.00 liabilities Owners Equity
Trademarks $    115,000.00 asset Intangible Asset
Twenty-year, 3% Bonds, Due 1/1/20XX $    600,000.00 liabilities non current liability
Sales [49356units*$36] $ 1,776,816.00 revenue Income from Operation
Rental Income $     25,650.00 revenue Other Income
Purchases $ 1,268,000.00 expense Operating Expense
Selling & Administration $    128,475.00 expense Selling & Administration Expense
Loss on Sale of Asset $     35,800.00 expense Selling & Administration Expense
Interest Payable $        17,415.00 expense Selling & Administration Expense
Bad debt $          1,186.00 expense Selling & Administration Expense
WN 1: Calculation of purchases
2/10/20XX 10,000 units @ $26 each $      260,000.00
6/12/20XX 15,000 units @ $28 each $      420,000.00
10/23/20XX 12,000 units @ $29 each $      348,000.00
11/25/20XX 8,000 units @ $30 each $      240,000.00
$ 1,268,000.00
Income Statement
Income:
Income from Operation:
Sales $ 1,776,816.00
Other Income:
Rental Income $        25,650.00
Total Income $ 1,802,466.00
Expenses
Operating Expense
Opening Stock $      315,250.00
Add: Purchases $ 1,268,000.00
Less: Closing Stock $   (206,350.00)
COGS $ 1,376,900.00
Selling & Administration:
Selling & Administration $      128,475.00
Loss on sale of Asset $        35,800.00
Interest Payable $        17,415.00
Bad Debt $          1,186.00
Total Expense $      182,876.00
Net Profit $      242,690.00
Comprehensive Balance Sheet
Liabilities Amount Asset Amount
Accounts Payable $      416,525.00 Accounts Receivable $                        191,816.00
Customer Deposit $              375.00 Less: Doubtful Debts $                          (3,836.00)
Income Tax Payable $        42,340.00 Cash $                        756,400.00
Mortgage Payable $      667,200.00 Inventory $                        206,350.00
2% Notes Payable $        43,415.00 Deposit with Vendor $                          47,200.00
Total Current Liability $ 1,169,855.00 Notres Receivable $                          16,000.00
$                    1,213,930.00
Non Current Liability
Twenty-year, 3% Bonds, Due 1/1/20XX $      600,000.00 Non Current Asset
Long Term Investment $                          95,630.00
Total Liability $ 1,769,855.00 Fixed Asset
Building & Equipment $                    1,120,000.00
Owners Equity Less: Accumulated Dep $                     (406,000.00)
Common Stock $      544,850.00 Less: Asset Sold $                        (95,000.00)
Additional Paid in Capital $        40,000.00 $                        619,000.00
Retained Earnings $      127,500.00 Land $                        125,000.00
Add: Income of Current Year $      242,690.00 Intangible Asset
Total Equity $      955,040.00 Copy Right $                        112,000.00
Goodwill $                        225,000.00
Patent $                        219,335.00
Trademark $                        115,000.00
$                        671,335.00
Total Liability & Equity $ 2,724,895.00 Total Asset $                    2,724,895.00
No of units
Opening Stock 12610 [315250/25]
Purchases 45000
Less: Sales -49356
Closing Stock 8254
Cost of Closing Stock using LIFO
Out of opening Stock: 8254 units @$25 $                                      206,350.00

Related Solutions

. NEED ANSWER ASAP Read the given financial data of Bob's Bacon House Inc. Determine which...
. NEED ANSWER ASAP Read the given financial data of Bob's Bacon House Inc. Determine which accounts belong to the balance sheet and which accounts belong to the income statement. Determine to which subgroup of balance sheet or income statement each account belongs. Compute the correct account balances that should be reported in balance sheet and correct amounts of revenues and expenses that should be reported in income statement. Arrange the accounts in proper order and functionality. Prepare a comprehensive...
The company will need to do replacement analysis to determine which option is the best financial...
The company will need to do replacement analysis to determine which option is the best financial decision for the company. Price Co. is considering replacing an existing piece of equipment. The project involves the following: • The new equipment will have a cost of $1,200,000, and it will be depreciated on a straight-line basis over a period of six years (years 1–6). • The old machine is also being depreciated on a straight-line basis. It has a book value of...
Read the article and give answer of 3 question which are given below Religion Versus the...
Read the article and give answer of 3 question which are given below Religion Versus the Charter: Canada’s commitment to multiculturalism is being tested in new and unexpected ways By Janice Gross Stein University of Toronto Magazine Winter 2007 Canadians are proudly multicultural. Along with publicly funded health care, multiculturalism has become part of the sticky stuff of Canadian identity. Section 27 of the constitution, the Canadian Charter of Rights and Freedoms, provides that the charter “shall be interpreted in...
You are given the following financial data for Pelican Paper Inc. and Timberland Forest Inc. Pelican...
You are given the following financial data for Pelican Paper Inc. and Timberland Forest Inc. Pelican Paper Timberland Total assets $10,000,000 $10,000,000 Common stockholder equity $ 9,000,000 $ 5,000,000 Total debt $ 1,000,000 $ 5,000,000 Interest expense $     100,000 $     500,000 Total Sales $25,000,000 $25,000,000 EBIT $   6,250,000 $ 6,250,000 Earnings available for common stockholders $   3,690,000 $ 3,450,000 1) Calculate each firms: a) total asset turnover b) equity ratio c) financial leverage multiplier 2) Use Dupont system formula to...
Given the following Financial Information Answer the following question: 2017 2018 Cash 2,000 189,100 Accounts Receivable...
Given the following Financial Information Answer the following question: 2017 2018 Cash 2,000 189,100 Accounts Receivable 2,000 2,020 Inventory 8,000 8,080 Prepaid Assets 3,000 3,030 Other Assets 4,000 4,040 Total Current Assets 19,000 206,270 Net PPE 20,000 4,000 Intangibles 10,000 10,000 Total Assets 49,000 220,270 Accounts Payable 8,000 8,080 Salary Payable 6,000 6,060 Notes Payable 3,000 3,000 Total Current Liabilities 17,000 17,140 Long-Term Debt 40,000 40,000 Total Liabilities 57,000 57,140 Common Stock 80,000 80,000 Retained Earnings -88,000 83,130 total equity...
What two characteristics of the data do you need to determine which binomial distribution to use?...
What two characteristics of the data do you need to determine which binomial distribution to use? What two characteristics of the data do you need to determine which Poisson distribution to use? What two characteristics of the data do you need to determine which normal distribution to use? (2) For the following scenarios determine if you should use Binomial, Poisson or Normal Distributions (a) The experiment/problem involves 2 independent outcomes, a fixed number of trials with a known (fixed) probability...
Lowell Inc. has no debt and its financial position is given by the following data: Assets...
Lowell Inc. has no debt and its financial position is given by the following data: Assets (book = market) $3,000,000 EBIT $500,000 Cost of equity (Ks) 10% Stock price (P0) $15 Shares outstanding n0 200,000 Tax rate T 40% The firm is considering selling bonds and simultaneously repurchasing some of its stock. It if moves to capital structure with 30 percent debt based on market values, its cost of equity, Ks, will increase to 11 percent to reflect the increased...
Use the financial data below from XYZ, Inc. to answer the questions below. Note that the...
Use the financial data below from XYZ, Inc. to answer the questions below. Note that the reported figures are in thousands of dollars: 2015 2014 Inventory $219,686.00 $241,154.00 Cost of Sales $54,661.00 $675,138.00 Net Income $31,185.00 $64,150.00 Tax Rate 37% 37% Note 1: If the first-in, first-out (FIFO) method of accounting for inventory had been used, inventory would have been approximately $26.9 million and $25.1 million higher than reported at 2015 and 2014, respectively. Required: What would the ending inventory...
Given the following data, determine which machine is better. Use the B/C method, a study period...
Given the following data, determine which machine is better. Use the B/C method, a study period of 10 years, and a MARR of 10%. Machine A Machine B First cost: Salvage value: Annual receipts: Annual disbursements: $20,000 2,000 150,000 138,000 $30,000 0 180,000 170,000 Determine the B/C values for each machine by using both the conventional and the modified formulations.
Financial statement data for Jenkins, Inc. include the following items: Cash $22,000 Short-term investments 33,000 Accounts...
Financial statement data for Jenkins, Inc. include the following items: Cash $22,000 Short-term investments 33,000 Accounts receivable, net 87,000 Inventories 145,000 Prepaid expenses 9,000 Total assets $675,000 Short-term note payable $44,000 Accounts payable 102,000 Accrued liabilities 37,000 Long-term notes payable 162,000 Other long-term liabilities 32,000 Net Income $95,000 Number of common shares outstanding 50,000 Requirements: 1. Calculate Jenkins, Inc. Current ratio, debt ratio and earnings per share. Round all ratios to decimal places. 2. Calculate the three ratios after evaluating...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT