In: Accounting
Rock Hard Software and Hardware reports the following amounts at the end of the year (all amounts in $000): Cash $23,430 Depreciation Expense $4,100 Taxes Payable $712 Mortgage Payable $43,500 Land $62,000 Treasury Stock $2,210 Sales Discounts and Returns $1,258 Accounts Receivable $5,292 Supplies Expenses $355 Bonds Payable $38,000 Accumulated Depreciation $17,250 Income Tax Expense $780 Equipment $29,300 Interest Expense $2,900 Notes Payable $11,000 Cost of Goods Sold $18,344 Current Portion of Bonds Payable $6,200 Current Portion of Mortgage Payable $2,350 Product Sales (Gross) $56,145 Utilities Expense $950 Inventory $12,500 Discount of Bonds Payable $970 Salaries Expense $14,100 Revenues from Software Licenses $1,050 Buildings $52,000 Goodwill $350 Advertising Expenses $5,340 Sales Expenses $7,200 Salaries Payable $412 Marketable Securities $3,450 Accounts Payable $5,340 PrePaid Expenses $750 Deferred Revenues $1,920 In addition, the company had common stock of $42,000 at the beginning of the year and issued an additional $3,500 during the year. The company also had retained earnings of $19,700 at the beginning of the year and declared dividends of $1,500 during the year. Using the account information above develop a Balance Sheet and Income Statement, then answer the next seven questions. The list of accounts is complete so your balance sheet should balance if you have performed the work correctly.
Cash | $23,430 | Depreciation Expense | $4,100 | Taxes Payable | $712 |
Mortgage Payable | $43,500 | Land | $62,000 | Treasury Stock | $2,210 |
Sales Discounts and Returns | $1,258 | Accounts Receivable | $5,292 | Supplies Expenses | $355 |
Bonds Payable | $38,000 | Accumulated Depreciation | $17,250 | Income Tax Expense | $780 |
Equipment | $29,300 | Interest Expense | $2,900 | Notes Payable | $11,000 |
Cost of Goods Sold | $18,344 | Current Portion of Bonds Payable | $6,200 | Current Portion of Mortgage Payable | $2,350 |
Product Sales (Gross) | $56,145 | Utilities Expense | $950 | Inventory | $12,500 |
Discount of Bonds Payable | $970 | Salaries Expense | $14,100 | Revenues from Software Licenses | $1,050 |
Buildings | $52,000 | Goodwill | $350 | Advertising Expenses | $5,340 |
Sales Expenses | $7,200 | Salaries Payable | $412 | Marketable Securities | $3,450 |
Accounts Payable | $5,340 | PrePaid Expenses | $750 | Deferred Revenues | $1,920 |
Question #1: Calculate the Net Income After Interest and Taxes
Question #2: Calculate the Total Amount of Current Assets
Question #3: Calculate the Total Amount of Current Liabilities.
Question #4: Calculate the Total Assets for Rock Hard.
Question #5: What is the total amount of the stockholders equity for Rock Hard Software and Hardware.
Question #6Continuing with Rock Hard, what is the amount of Long-Term Liabilities.
Question #7: What is Rock Hard Software and Hardware's Return on Equity (ROE). Chose the best answer from the choices below.
1) | |
Statement of Income | |
Sales | 56145 |
Less: | |
Sales Discount and Returns | -1258 |
Net Sales | 54887 |
Revenue from Software Licenses | 1050 |
Gross Revenue | 55937 |
Less: | |
Cost of Goods sold | -18344 |
Gross Profit | 37593 |
Less: | |
Discount of bonds | 970 |
Sales Expenses | 7200 |
Depreciation Expense | 4100 |
Utilities Expense | 950 |
Salaries Expense | 14100 |
Prepaid Expenses | 0 |
Supplies expense | 355 |
Advertising Expense | 5340 |
Total Expenses | 33015 |
Earning before Interest and Taxes | 4578 |
Less | |
Interest | 2900 |
Taxes | 780 |
Total | 3680 |
Earning after Interest and Taxes | 898 |
2) | |
Current Assets | |
Cash | 23430 |
Account receivable | 5292 |
Prepaid Expense | 750 |
Inventory | 12500 |
Marketable Securities | 3450 |
Total | 45422 |
3) | |
Current Liabilities | |
Current Portion of Mortgage | 2350 |
Account payable | 5340 |
Salaries Payable | 412 |
Taxes payable | 712 |
Notes payable | 11000 |
Deferred Revenue | 1920 |
Accumulated Depreciation | 17250 |
Current portion of bond | 6200 |
Total | 45184 |
4) | |
Assets | |
Current Assets | |
Cash | 23430 |
Account receivable | 5292 |
Prepaid Expense | 750 |
Inventory | 12500 |
Marketable Securities | 3450 |
Total (A) | 45422 |
Non Current Assets | |
Equipment | 29300 |
Building | 52000 |
Land | 62000 |
Goodwill | 350 |
Total (B) | 143650 |
Total (A+B) | 189072 |
5) | |
Shareholders funds | |
Common Stock (A) | 42000 |
Additional Equity (B) | 3500 |
Retained Earnings | |
Balance Opening | 19700 |
Net Profit | 898 |
Less: Dividend | -1500 |
Closing Retained Earnings ( C) | 19098 |
Less: Treasury Stock (D) | -2210 |
Total (A+B+C-D) | 62388 |
6) | |
Long Term Liabilities | |
Mortgage Payable | 43500 |
Bonds Payable | 38000 |
Total | 81500 |
7) | |
Return on Equity | |
Net Income | 898 |
Shareholders Funds | 62388 |
1.4393794% |