Question

In: Accounting

Group Project – Year 1 Could you do a balance sheet and income statement for below?...

Group Project – Year 1

Could you do a balance sheet and income statement for below?

The following list summarizes the transactions that took place during a start up’s first year of operations. Using the information below, prepare a list of the appropriate journal entries, including any necessary adjusting entries, and create a Balance Sheet and Income Statement. Once you have created the financial statements, provide the appropriate closing entries. The startup uses straight line when depreciating long‐term assets and a perpetual inventory system.

Transactions and information for the year:

  1. Jan 1st, issued 500 shares of common stock ($0.50 par value) for $5000.

  2. Feb 1st, paid $2500 to purchase land.

  3. Feb 28th, issued 100 shares of preferred stock ($100 par value) for $20,000.

  4. June 30th, paid $75,000 for a building (estimated useful life of 40 years; salvage

    value = $5,000) by signing a 5 year Note Payable, promising to pay 5% interest at

    the end of each of those 5 years (i.e. on June 30th of each year).

  5. July 1st, purchased 400 units of inventory at $15 each. $1,000 was paid in cash, the

    rest was on account.

  6. July 30th, sold 120 units of inventory for $63 each on account.

  7. Aug 2nd, incurred $450 of wages expense.

  8. Aug 5th, collected $2500 of accounts receivable.

  9. Aug 31st, paid $200 of wages payable.

  10. Sept 4th, paid $1600 of accounts payable.

  11. Dec 31st, incurred and paid $2,000 of utilities expense.

  12. Dec 31st, Purchased a patent for $20,000. The patent has a 20‐year useful life and no

    residual value.

  13. Estimated tax rate is 35%.

Solutions

Expert Solution

Please hit LIKE button if this helped.  
Income Statement:
Sale $        7,560
Less: Cost of goods sold $      -1,800
Gross Margin $        5,760
Less: Operating Expense
Utilities Expense $    2,000
Wages Expense $        450
Depreciation Expense ($75,000-$5,000)/40*6/12 $        750
Total Operating Expense $      -3,200
Operating Income $        2,560
Less: Interest Expense ($75,000*5%*6/12) $      -1,875
Income before tax $           685
Less: Income Tax 35% $          -240
Net Income $           445
Balance Sheet:
Cash $           200
Accounts Receivable $        5,060
Inventory $        4,200
Total Current Assets $        9,460
Land $        2,500
Building $ 75,000
Less: Accumulated Depreciation $      -750 $     74,250
Patent $     20,000
Total Assets $   106,210
Liabilities and Equity:
Current Liabilities:
Accounts Payable $        3,400
Wages Payable $           250
Interest Payable $        1,875
Income Tax Payable $           240
Total Current Liabilities $        5,765
Note Payable $     75,000
Total Liabilities $     80,765
Stockholder's Equity:
Common Stock $        250
Preferred Stock $ 10,000
Paid in capital, in excess of par-Common $    4,750
Paid in capital, in excess of par-Preferred $ 10,000
Retained Earning $        445
Total Stockholder's Equity $     25,445
Total Liabilities and Stockholder's Equity $   106,210

Related Solutions

For this next part of the project you will build the Income Statement and Balance Sheet...
For this next part of the project you will build the Income Statement and Balance Sheet for the Bike Repair & Maintenance Shop (BRMS) for 2018. Use the information below and add another sheet to your Excel Workbook. BRMS Information for 2018 In 2017, the repair shop was opened in October and ended the year with a ($10,500) operating loss. Supply Inventory of parts & supplies maintained $3,000 Replacement parts are ordered as they are used. Shop hours of operation:...
1. Shown below is Jensen Company’s projected income statement for year 2017, and the balance sheet...
1. Shown below is Jensen Company’s projected income statement for year 2017, and the balance sheet as of the end of 2016. Pro Forma Income Statement 2017 Balance Sheet Dec. 31, 2016 Dec. 31 2017 Revenues 7,000,000 Cash 30,000 Depreciation 500,000 Inventory 270,000 Other Expenses 5,800,000 Fixed Assets (Net) 4,700,000 Income 700,000 Total Assets 5,000,000 Dividends 500,000 Payables 180,000 LT. Debt 1,820,000 Equity 3,000,000 Liabilities + Equity 5,000,000 Sales are expected to increase from $5 million in 2016 to $7...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,090 $ 24,610 Accounts receivable 88,000 76,680 Inventory 39,800 47,940 Prepaid expenses 9,810 15,750 Long-term investments 254,400 210,000 Property, plant, and equipment 540,750 504,000 Less accumulated depreciation 329,600 312,700 Total assets $ 606,250 $ 566,280 Accounts payable $ 9,540 $ 25,500 Accrued liabilities 24,480 17,850 Income taxes payable 53,400 48,300 Bonds payable 176,000 216,000 Common...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,270 $ 25,300 Accounts receivable 88,800 78,100 Inventory 39,800 49,820 Prepaid expenses 9,630 15,450 Long-term investments 247,200 216,000 Property, plant, and equipment 566,500 523,200 Less accumulated depreciation 345,600 324,500 Total assets $ 609,600 $ 583,370 Accounts payable $ 9,720 $ 25,750 Accrued liabilities 25,440 18,190 Income taxes payable 51,900 50,600 Bonds payable 171,200 206,000 Common...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,300 $ 24,840 Accounts receivable 90,500 72,420 Inventory 42,900 51,230 Prepaid expenses 9,810 16,350 Long-term investments 254,400 206,000 Property, plant, and equipment 551,050 513,600 Less accumulated depreciation 348,800 315,650 Total assets $ 603,160 $ 568,790 Accounts payable $ 9,810 $ 27,500 Accrued liabilities 24,720 17,850 Income taxes payable 51,900 48,760 Bonds payable 164,800 210,000 Common...
1. The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s...
1. The table given below summarizes the 2019 income statement and end-year balance sheet of Drake’s Bowling Alleys. Drake’s financial manager forecasts a 10% increase in sales and costs in 2020. The ratio of sales to average assets is expected to remain at 0.40. Interest is forecasted at 5% of debt at the start of the year. At the end of 2018 debt was $2,400,000 and assets were $6,960,000. (10 points) Income Statement $ in thousands Sales $ 2,900 (40%...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $ 140.0 Accounts payable $800.0 Accts. Receivable 880.0 Notes payable ` 600.0 Inventories 1,320.0 Accruals 400.0 Total current assets 2,340.0 Total current liabilities 1,800.0 Long-term bonds 1,000.0 Total debt 2,800.0 Common stock 200.0 (50,000 shares) Retained earnings 1,000.0 Net plant & equip 1,660.0 Total common equity 1,200.0 Total assets $4,000.0 Total liabilities & equity $4,000.0 INCOME STATEMENT Net sales $6,000.0 Operating costs 5,599.8 Depreciation 100.2...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 220 $ 330 Accounts receivable, net 360 380 Inventory 330 300 Prepaid expenses 20 20 Total current assets 930 1,030 Plant and equipment, net 1,180 1,300 Total assets $ 2,110 $ 2,330 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 300 $ 330 Accrued liabilities 50...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 170 $ 230 Accounts receivable, net 260 280 Inventory 230 200 Prepaid expenses 20 20 Total current assets 680 730 Plant and equipment, net 880 900 Total assets $ 1,560 $ 1,630 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 200 $ 230 Accrued liabilities 50...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 190 $ 270 Accounts receivable, net 300 320 Inventory 270 240 Prepaid expenses 20 20 Total current assets 780 850 Plant and equipment, net 1,000 1,060 Total assets $ 1,780 $ 1,910 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 240 $ 270 Accrued liabilities 50...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT