During 2022, Mastermind Corporation had: Revenue of $766,000 Cost of Goods Sold of $225,000 Operating expenses of $58,000 Interest expense of $3,500 Depreciation Expense of $13,000 During the year Mastermind Corporation paid: 40% of net income in dividends 21% in corporate taxes A. Prepare a multi-step income statement on Sheet 1 of your spreadsheet. Rename Sheet 1 “Income Statement”. Every calculation needs a working Excel formula*. Include the dividend and additions to Retained Earnings below the income statement. B. Calculate Mastermind’s Operating Cash Flow beneath the Income Statement.* Be sure to label it.

During 2022, Mastermind Corporation had: Revenue of $766,000 Cost of Goods Sold of $225,000 Operating expenses of $58,000 Interest expense of $3,500 Depreciation Expense of $13,000 During the year Mastermind Corporation paid: 40% of net income in dividends 21% in corporate taxes A. Prepare a multi-step income statement on Sheet 1 of your spreadsheet. Rename Sheet 1 “Income Statement”. Every calculation needs a working Excel formula. Include the dividend and additions to Retained Earnings below the income statement. B. Calculate Mastermind’s Operating Cash Flow beneath the Income Statement. Be sure to label it.

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter5: The Income Statement And The Statement Of Cash Flows

Section: Chapter Questions

Problem 1RE: Brandt Corporation had sales revenue of 500,000 for the current year. For the year, its cost of...

See similar textbooks

Similar questions

Wilton Felder Ltd is finalising its financial statements for the year ended 31 October 2024. You are presented with the following information: Income statement for the year ended 31 October 2024 £ 175,900 Sales revenue Cost of Sales (99,370) Gross profit 76,530 Operating expenses Interest income (51,280) 40 1,400 Finance costs Profit before tax 23,890 Corporation tax expenses (6,450) Profit for the year 17,440 Balance sheets as at 31 October Non-current assets Property plant & equipment at cost Less Accumulated Depreciation Current Assets Inventory Trade receivable Cash at bank and in hand Total assets Current liabilities Trade and other payables Corporation tax payable Non-current liabilities Bank Loans Net assets Equity Share capital Share premium Retained earnings Total equity 31/10/24 £ 132,040 (32,210) 99,830 24,130 17,520 4,220 45,870 145,700 20,060 5,270 25,330 28,320 92,050 24,410 13,800 53,840 92,050 31/10/23 £ 111,580 (28,870) 82,710 27,220 11,740 2,140 41,100 123,810 17,860…
During 2022, Mastermind Corporation had: Revenue of $766,000 Cost of Goods Sold of $225,000 Operating expenses of $58,000 Interest expense of $3,500 Depreciation Expense of $13,000 During the year Mastermind Corporation paid: 40% of net income in dividends 21% in corporate taxes A. Prepare a multi-step income statement include the dividend and additions to Retained Earnings below the income statement. B. Calculate Mastermind’s Operating Cash Flow beneath the Income Statement.
For this question, calculate all values to 2 decimal places of £M (e.g. £123.45M) unless otherwise specified, and all ratios to 2 decimal places of percentage (e.g. 9.87%). You are given the following income statements and balance sheets for Freddie M Corporation for fiscal years 2045 and 2046 (all figures are in £ million), Income Statement Balance Sheet Sales Cost of goods sold Gross margin Wage & salaries expense Depreciation expense Earnings before interest and tax Interest expenses Taxes Net income Dividends Change in shareholder's equity Assets: Cash & equivalents Receivables Inventories Current Assets Property, plant & equipment Accumulated depreciation Net property, plant & equip Total Assets 2045 400.00 -200.00 200.00 -50.00 -25.00 125.00 -25.00 -60.00 40.00 -16.00 24.00 2045 2046 480.00 -240.00 240.00 -60.00 -25.00 155.00 -20.00 -70.00 65.00 -26.00 39.00 2046 Liabilities: 30.00 36.00 Payables 60.00 Short-term debt 50.00 50.00 60.00 Long-term debt 130.00 156.00 Total…
During 2021, Blossom Inc. has the following account balances in Income Statement: Sales 1,630,245 Cost of Sales 646,788 Selling Expense 235,500 Administrative Expense 114,766 Other Expense 57,146 Income Tax Expense 200,400 Other Revenue 65,800 What will be the Net income?
Suppose Torche Corporation has the following revenue and expenses for 2022: Revenues of $9,100,000 Cost of Goods Sold of $2,730,000 Depreciation Expenses of $500,000 Income Taxes of $1,672,000 Interest Expenses of $180,000 Other Expenses of $600,000 Sales, General, & Administrative Expenses of $910,000 Create an income statement with amounts in thousands What is the value of Earnings Before Interest & Taxes?
K McDaniel and Associates, Inc. reported the following amounts on its 2024 income statement: Year Ended December 31, 2024 Net income Income tax expense Interest expense $ 22,950 6,600 3,000 What was McDaniel's times-interest-earned ratio for 2024? OA. 7.65 OB. 10.85 OC. 9.85 OD. 8.65 point(s) possible ...
You are provided with the following information taken from Splish Brothers Inc.’s March 31, 2022, balance sheet. Cash $ 12,330 Accounts receivable 20,370 Inventory 36,900 Property, plant, and equipment, net of depreciation 120,500 Accounts payable 22,640 Common stock 153,800 Retained earnings 12,460 Additional information concerning Splish Brothers Inc. is as follows. 1. Gross profit is 26% of sales. 2. Actual and budgeted sales data: March (actual) $47,000 April (budgeted) 73,100 3. Sales are both cash and credit. Cash collections expected in April are: March $18,800 (40% of $47,000) April 43,860 (60% of $73,100) $62,660 4. Half of a month’s purchases are paid for in the month of purchase and half in the following month. Cash disbursements expected in April are: Purchases March $22,640…
Operating data for Joshua Corporation are presented as follows: Net Sales Cost of Goods Sold Selling Expenses Administrative Expenses Income Tax Expense Net Income 2022 800,000 520,000 120,000 60,000 30,000 70,000 Instructions Prepare a schedule showing a vertical analysis for 2022 and 2021. Net Sales Cost of Goods Sold Gross Profit Selling Expenses Your Answers: FYI: Format the percent cols to one decimal place. Ex 99.9% 2022 Administrative Expenses Total Operating Expenses Income Before Income Taxes Income Tax Expense Net Income 2021 600,000 408,000 72,000 48,000 24,000 48,000 Amount 800,000 520,000 280,000 120,000 60,000 180,000 100,000 30,000 70,000 Percent 100.0% 2021 Amount Percent 600,000 100.0% 408,000 192,000 72,000 48,000 120,000 72,000 24,000 48,000
You are provided with the following information taken from Larkspur, Inc.’s March 31, 2022, balance sheet. Cash $ 12,060 Accounts receivable 23,980 Inventory 37,450 Property, plant, and equipment, net of depreciation 121,200 Accounts payable 22,760 Common stock 152,100 Retained earnings 11,630 Additional information concerning Larkspur, Inc. is as follows. 1. Gross profit is 24% of sales. 2. Actual and budgeted sales data: March (actual) $47,400 April (budgeted) 73,000 3. Sales are both cash and credit. Cash collections expected in April are: March $18,960 (40% of $47,400) April 43,800 (60% of $73,000) $62,760 4. Half of a month’s purchases are paid for in the month of purchase and half in the following month. Cash disbursements expected in April are: Purchase March $22,760 Purchase April…
For the year ended December 31, 2022, Settles Incorporated earned an ROI of 8.8 %. Sales for the year were $9 million, and average asset turnover was 2.2. Average stockholders' equity was $2.9 million. Required: a. Calculate Settles Incorporated's margin and net income. Note: Round "Margin" answer to 1 decimal place. Enter the net income answer in dollars, i.e., $5 million should be entered as 5,000,000. b. Calculate Settles Incorporated's return on equity. Note: Round your answer to 1 decimal place. a. Margin a. Net income % b. Return on equity %
The income statement of Tavis Corporation and selected additional data are presented below: Tavis Corporation Income Statement for the Year Ended December 31, 2020 Net sales $220,000 Cost of goods sold __109,000 Gross profit 111,000 Selling and general expenses _98,000 Income from operations 13,000 Interest expense __2,500 Income before income tax 10,500 Income tax expense __3,000 Net income $ 7,500 Additional data: Total assets $214,000 Common stockholders’ equity $116,000 Preferred dividends…
Rousseau Corporation has the following Statement of Income for the year ended May 31, 2020: Sales... $1,675,200 Cost of goods sold.. 887,600 Gross margin... 787,600 Selling & administrative expense.. 241,200 Interest expense. 65,000 Income before income taxes. 481,400 192,500 $288,900 Income taxes.. Net income.... Calculate the interest-coverage ratio for Rousseau Corporation for May31, 2020 (place answer at up to 2 decimal places in the space below). 신