Question

In: Accounting

Model constructing an income statement and balance sheet for a furniture company based on the following...

Model constructing an income statement and balance sheet for a furniture company based on the following transaction details. Please clearly show which transactions fall under the following parts of the statement:

Sales

Cost of Sales

SG&A Expenses

Interest Income

Income Expense

Loss on Sale of Non-Current Asset

Transactions

  1. Buy wood to build bookshelves- $500
  2. A recently hired team member builds the bookshelves and should be paid - $25
  3. Paid electricity bill for shop where bookshelves are made - $100
  4. Paid team member who built the bookshelves - $25
  5. Sold moving truck - $2500 (cash) (depreciation charge to date is $500; truck had an accumulated depreciation of $1000 at the time of sale)
  6. Sold 2 bookshelves for $200 each (the total cost to make the bookshelves was $75 each)
  7. Completed a subscription service from prior year - $4000
  8. A count of manufacturing inventory shows $200 of raw materials on hand, $100 of work in process and completed making $300 worth of bookshelves
  9. File cabinets depreciated - $75
  10. Paid interest on a bank loan - $1000
  11. Recorded the portion of the prepaid workshop insurance from the previous year - $50
  12. Collected interest income - $20

Opening Balances

  1. Cash - $2000
  2. Inventory stock - $1000
  3. Materials - $0
  4. Work in Process - $0
  5. Finished Goods - $0
  6. Total Inventory -
  7. Accounts Receivable - $5000
  8. PP&E - $4000
  9. Prepayments - $1000
  10. Accrued Income - $10
  11. Accounts Payable - $2000
  12. Tax Payable - $0
  13. Dividend Payable - $0
  14. Accrued Liabilities $300
  15. Bank Loan - $25000
  16. Share Capital - $10000
  17. Retained Earnings - $12,000

Solutions

Expert Solution

Answer prepared considering Income Expense as 2 separate words as no such word in accounting.

  1. Buy wood to build bookshelves- $500-- Since question is regarding furniture company, buying wood will be cost of sales
  2. A recently hired team member builds the bookshelves and should be paid - $25- It would fall under SG& A Expenses
  3. Paid electricity bill for shop where bookshelves are made - $100-It would fall under SG& A Expenses
  4. Paid team member who built the bookshelves - $25- Since expense for this transaction is already booked and this is merely a payment transaction hence will not be booked under specified heads.
  5. Sold moving truck - $2500 (cash) (depreciation charge to date is $500; truck had an accumulated depreciation of $1000 at the time of sale)- Considering accumulated depreciation includes depreciation charge to date $ 500, then it would fall under loss on sale of non current assets with $1500.
  6. Sold 2 bookshelves for $200 each (the total cost to make the bookshelves was $75 each)- It would fall under Sales with $200 and cost is already mentioned in above transactions
  7. Completed a subscription service from prior year - $4000-considering already paid, would not fall under any head, its just utilization of expenses.
  8. A count of manufacturing inventory shows $200 of raw materials on hand, $100 of work in process and completed making $300 worth of bookshelves- Its inventory in hand would not fall under any specified head.
  9. File cabinets depreciated - $75-- would fall under expenses
  10. Paid interest on a bank loan - $1000- Expense
  11. Recorded the portion of the prepaid workshop insurance from the previous year - $50- Expense
  12. Collected interest income - $20- would fall under interest income
  13. Cash - $2000-not under any specified head

  14. Inventory stock - $1000-not under any specified head

  15. Materials - $0-not under any specified head
  16. Work in Process - $0-not under any specified head
  17. Finished Goods - $0- not under any specified head
  18. Total Inventory --not under any specified head
  19. Accounts Receivable - $5000-not under any specified head
  20. PP&E - $4000-not under any specified head
  21. Prepayments - $1000-not under any specified head
  22. Accrued Income - $10- not under any specified head
  23. Accounts Payable - $2000-not under any specified head
  24. Tax Payable - $0-not under any specified head
  25. Dividend Payable - $0-not under any specified head
  26. Accrued Liabilities $300- not under any specified head
  27. Bank Loan - $25000- not under any specified head
  28. Share Capital - $10000-not under any specified head
  29. Retained Earnings - $12,000- not under any specified head

Related Solutions

Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the year 2012. Please show your workings for the related questions below (yes, all together!). If your final answers (below) are incorrect, I'll review your workings to grant partial credit. Trial Balance as at 31st December 2012 Trial Balance Dr Cr Sales 240,000 Purchases 150,000 Returns inwards 5,000 Returns outwards 6,000 Carriage Inwards 3,000 Inventory 1.1.2012 80,000 Salaries 25,000 Electricity and telephone 4,000 Rent 5,000...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for...
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018 2019 Period...
Estimating Share Value Using the ROPI Model Following are the income statement and balance sheet for...
Estimating Share Value Using the ROPI Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018 2019 Period Sales...
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for...
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018 2019 Period...
The following are the income statement and balance sheet of company X as at year 2015....
The following are the income statement and balance sheet of company X as at year 2015. Income Statement Sales 20,077,000 Cost of goods sold 14,985,000 Other Expenses 2,399,000 Depreciation 655,000 EBIT 2,038,000 Interest 362,000 Taxable income 1,676,000 Tax (40%) 670,400 Net income 1,006,600 Balance Sheet Assets Liability and Equity Current Assets Current liabilities Cash 365,040 Account payable 715,680 Account Receivable 1,534,680 Notes payable 1,446,400 Inventory 1,238,500 Total current liabilities 2,162,080 Total current assets 3,138,220 Fixed Assets Long-term debt 3,825,000 Net...
Based on the following financial information, construct the balance sheet and income statement below for Tonka...
Based on the following financial information, construct the balance sheet and income statement below for Tonka Trucking LLC for the year ending December 31, 2019. Be sure to format them as accurately as possible. Accounts Receivable $40,000 Depreciation Expense $50,000 Accumulated Depreciation $200,000 Cost of Goods Sold $50,000 Income Tax Expense $50,000 Cash $50,000 Sales Revenue $400,000 Equipment (Net of Accumulation) $200,000 Selling, General, and Administrative Expenses $100,000 Common Stock (1,000 shares) $100,000 Accounts Payable $50,000 Retained Earnings $200,000 Interest...
Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):         a)...
Based on the Income Statement and Balance Sheet for the XYZ Corporation (see below):         a) create the Pro Forma statement for 2015 given the following assumptions: - sales increase by 20% - all items vary directly with sales (except for Notes Payable, LTD, Owners Equity) - the company is currently operating at 100% capacity - the dividend payout ratio stays at 50%             Income Statement 2015 Pro Forma 2016 Sales $3,000,000 Cost of Goods Sold 2,000,000 Depreciation 300,000 EBIT...
Based on the information below create an income statement, balance sheet, and cash flow statement. On...
Based on the information below create an income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in legal fees,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT