
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Topic Video
Question
Heads Up Company was started several years ago by two hockey instructors. The company’s comparative balance sheets and income statement follow, along with additional information.
Current Year | Previous Year | |
---|---|---|
Cash | $ 6,180 | $ 4,160 |
890 | 1,730 | |
Equipment | 5,390 | 4,900 |
(1,480) | (1,240) | |
Total Assets | $ 10,980 | $ 9,550 |
Accounts Payable | $ 710 | $ 1,200 |
Salaries and Wages Payable | 510 | 750 |
Notes Payable (long-term) | 1,600 | 500 |
Common Stock | 4,900 | 4,900 |
3,260 | 2,200 | |
Total Liabilities and |
$ 10,980 | $ 9,550 |
Income Statement | ||
Service Revenue | $ 39,700 | |
Salaries and Wages Expense | 37,200 | |
Depreciation Expense | 240 | |
Income Tax Expense | 1,200 | |
Net Income | $ 1,060 |
Additional Data:
- Bought new hockey equipment for cash, $490.
- Borrowed $1,100 cash from the bank during the year.
- Accounts Payable includes only purchases of services made on credit for operating purposes. Because there are no liability accounts relating to income tax, assume this expense was fully paid in cash.
Required:
1. Prepare the statement of
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Required information Skip to question [The following information applies to the questions displayed below.] Comparative financial statements for Weaver Company follow: Weaver CompanyComparative Balance Sheetat December 31 This Year Last Year Assets Cash $ 25 $ 12 Accounts receivable 293 230 Inventory 152 194 Prepaid expenses 9 5 Total current assets 479 441 Property, plant, and equipment 510 432 Less accumulated depreciation (83 ) (71 ) Net property, plant, and equipment 427 361 Long-term investments 24 31 Total assets $ 930 $ 833 Liabilities and Stockholders' Equity Accounts payable $ 302 $ 225 Accrued liabilities 71 80 Income taxes payable 75 63 Total current liabilities 448 368 Bonds payable 200 171 Total liabilities 648 539 Common stock 162 200…arrow_forwardGiven the following account balances at year end, compute the total intangible assets on the balance sheet of Janssen Enterprises. Cash $1,500,000 Accounts Receivable 1,000,000 Trademarks 1,200,000 Goodwill 2,500,000 Research & Development Costs 2,000,000 a. $9,700,000. b. $5,700,000. c. $3,700,000. d. $7,700,000.arrow_forwardBeta corporation reports the following solve this accounting questionsarrow_forward
- I want to this question answer general Accountingarrow_forwardRequired information Skip to question [The following information applies to the questions displayed below.] Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2024 ($ in thousands) Revenues and gains: Sales $ 720 Gain on sale of building 11 $ 731 Expenses and loss: Cost of goods sold $ 260 Salaries 112 Insurance 32 Depreciation 115 Interest expense 42 Loss on sale of equipment 10 571 Income before tax 160 Income tax expense 80 Net income $ 80 PARNELL COMPANY Selected Accounts from Comparative Balance Sheets December 31, 2024 and 2023 ($ in thousands) Year Change 2024 2023 Cash $ 126 $ 108 $ 18 Accounts receivable 316 224 92 Inventory 329 417 (88) Prepaid insurance 69 80 (11) Accounts payable 202 125 77 Salaries payable 118 101 17 Deferred tax liability 76 60 16 Bond discount 180 208 (28)…arrow_forwardGiven the following account balances at year-end, compute the total intangible assets on the balance sheet of Oriole Company. Cash $1330000 Accounts Receivable 1140000 Trademarks 1350000 Goodwill 2690000 Research & Development Costs 2190000arrow_forward
- Need help with this general accounting questionarrow_forwardThe following income statement was drawn from the annual report of Newtown Company: Cash revenue $ 69,800 Depreciation expense (24,900) Accrued interest expense (10,400) Cash operating expenses (29,700) Operating income 4800 Gain on sale of equipment 2600 Net income $ 7400 What is the net cash flow from operating activities? Group of answer choices $40,100 $42,700 $35,300 $32,700 Trainingarrow_forwardThe following data are adapted from the financial statements of Betty's Shops, Inc. E (Click the icon to view the data.) Prepare Betty's condensed balance sheet as of December 31, 2018. (Round your answers to the nearest whole dollar.) Betty's Shops, Inc. Balance Sheet December 31, 2018 Assets Data Table Total Current Assets Plant Assets Less: Accumulated Depreciation Total Current Assets $4 978,750 Total Assets Accumulated Depreciation 2,100,000 Liabilities Total Liabilities 1.460,000 Total Current Liabilities Preferred Stock Long-term Liabilities Debt Ratio 73% Total Liabilities Current Ratio 1.45 Stockholders' Equity Stockholders' Equity Print Done Total Liabilities and Stockholders' Equityarrow_forward
- Wildhorse Co. Income Statement For the Year Ended December 31, 2022 Service revenue Operating expenses, excluding depreciation $624,100 Depreciation expense 55,400 Loss on disposal of plant assets 25.200 Income before income taxes Income tax expense Net income 2021 $59,800 28,900 6,400 $970,400 Wildhorse's balance sheets contained the following comparative data at December 31. 2022 Accounts receivable $75,200 Accounts payable 40,400 Income taxes payable 13,000 704,700 265,700 39,100 $226,600 Adjustments to reconcile net income to Accounts payable pertain to operating expenses. Prepare the operating activities section of the statement of cash flows using the Indirect method. (Show amounts that decrease cash flow with either a sign e.g.-15.000 or in parenthesis e.g. (15,000).) Wildhorse Co. Partial Statement of Cash Flowsarrow_forwardThe Home Depot reported the following data (in millions) in its recent financial statements: Year 2 Year 1 Sales $83,176 $78,812 Total assets at the end of the year Total assets at the beginning of the year 39,946 40,518 40,518 41,084 a. Determine the asset turnover for The Home Depot for Year 2 and Year 1. Round to two decimal places. b. What conclusions can be drawn concerning the trend in the ability of The Home Depot to effectively use its assets to generate sales?arrow_forwardPlease helparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,