Pro forma income statement The marketing department of Metroline Manufacturing estimates that its sales next year will be $1.58 million. Interest expense is expected to remain unchanged at $32,000, and the firm plans to pay $69,000 incash dividends. Metroline Manufacturing's income statement for the previous year is givenalong with a breakdown of the firm's cost of goods sold and operating expenses into their fixed and variable components.a. Use the percent-of-sales method to prepare a pro forma income statement for next year.b. Use fixed and variable cost data to develop a pro forma income statement for next year.c. Compare and contrast the statements developed in parts a. and b. Which statement probably provides the better estimate of income? Explain why.a. Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2020.Complete the pro forma income statement for the year ended December 31, 2020 below: (Round the percentage of sales to four decimal places and the pro forma income statement amounts to the nearest dollar.)- XPro Forma Income StatementData tableMetroline Manufacturing, Inc.for the Year Ended December 31, 2020(For Breakdown of Costs and Expenses, click on the icon here O in order to copy the contents of the data table below into aspreadsheet.)(percent-of-sales method)Sales1,580,000Metroline ManufacturingMetroline ManufacturingBreakdown of Costs and Expensesinto Fixed and Variable ComponentsLess: Cost of goods sold1,038,21865.7100 %Income StatementGross profits2$541,782for the Year Just EndedSales revenue$1,394,000for the Year Just EndedLess: Operating expensesLess: Cost of goods sold916,000Cost of goods soldFixed cost$216,000Gross profitsLess: Operating expensesOperating profits$478,000Less: Interest expense32,000124,000Variable cost700,000$354,000Total cost$916,000Operating profitsLess: Interest expenseNet profits before taxes2$32,000Operating expensesFixed expensesLess: TaxesNet profits before taxes$322,000$40,000Less: Taxes (rate = 40%)128,800Variable expenses84,000Net profits after taxes$193,200Total expenses$124,000Help me solve thisView an exampleGet more help -Less: Cash dividends64,000To retained earnings$129,200 Metroline Manufacturing, Inc.for the Year Ended December 31, 2020(percent-of-sales method)Sales$1,580,000Less: Cost of goods sold1,038,21865.7100 %Gross profits541,782Less: Operating expenses%Operating profitsLess: Interest expense32,000Net profits before taxesLess: TaxesNet profits after taxesLess: Cash dividends69,000To retained earnings%24

Income statement Dec 31 2019 sales 1,394,000 less cost of goods sold…

Pro forma income statement The marketing department of Metroline Manufacturing estimates that its sales next year will be $1.58 million. Interest expense is expected to remain unchanged at $32,000, and the firm plans to pay $69,000 in cash dividends. Metroline Manufacturing's income statement for the previous year is given , along with a breakdown of the firm's cost of goods sold and operating expenses into their fixed and variable components. a. Use the percent-of-sales method to prepare a pro forma income statement for next year. b. Use fixed and variable cost data to develop a pro forma income statement for next year. c. Compare and contrast the statements developed in parts and b. Which statement probably provides the better estimate of income? Explain why.

Pro forma income statement The marketing department of Metroline Manufacturing estimates that its sales next year will be $1.58 million. Interest expense is expected to remain unchanged at $32,000, and the firm plans to pay $69,000 in cash dividends. Metroline Manufacturing's income statement for the previous year is given , along with a breakdown of the firm's cost of goods sold and operating expenses into their fixed and variable components. a. Use the percent-of-sales method to prepare a pro forma income statement for next year. b. Use fixed and variable cost data to develop a pro forma income statement for next year. c. Compare and contrast the statements developed in parts and b. Which statement probably provides the better estimate of income? Explain why.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Required information [The following information applies to the questions displayed below] Westerville Company reported the following results from last year's operations: Sales Variable expenses Contribution margin Fixed expenses Net operating income Average operating assets ROI At the beginning of this year, the company has a $300,000 investment opportunity with the following cost and revenue characteristics: Sales $ 1,800,000 435,000 1,365,000 1,005,000 $360,000 $ 1,200,000 $360,000 $ 216,000 The company's minimum required rate of return is 10% Contribution margin ratio Fixed expenses 70 of sales. 6. What is the ROI related to this year's investment opportunity?
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $865,050,000 Less: Variable expenses 550,973,000 Contribution margin $314,077,000 Less: Fixed expenses 192,762,000 Operating income $121,315,000 At the beginning of last year, Elway had $38,661,000 in operating assets. At the end of the year, Elway had $41,350,000 in operating assets. Required: 1. Compute average operating assets.$fill in the blank 1 2. Compute the margin (as a percent) and turnover ratios for last year. If required, round your answers to two decimal places. Margin fill in the blank 2 % Turnover fill in the blank 3 3. Compute ROI as a percent. Use the part 2 final answers in these calculations and round the final answer to two decimal places.fill in the blank 4 % 4. ROI measures a company’s ability to generate relative to its investment in assets. The greater the ROI, the efficiently the company…
Gibson Corporation’s balance sheet indicates that the company has $580,000 invested in operating assets. During the year, Gibson earned operating income of $67,280 on $1,160,000 of sales. Required Compute Gibson’s profit margin for the year. Compute Gibson’s turnover for the year. Compute Gibson’s return on investment for the year. Recompute Gibson’s ROI under each of the following independent assumptions:(1) Sales increase from $1,160,000 to $1,392,000, thereby resulting in an increase in operating income from $67,280 to $76,560.(2) Sales remain constant, but Gibson reduces expenses, resulting in an increase in operating income from $67,280 to $69,600.(3) Gibson is able to reduce its invested capital from $580,000 to $464,000 without affecting operating income.
Bottlebrush Company has operating income of $49,749, invested assets of $309,000, and sales of $710,700. Use the DuPont formula to compute the return on investment, and show (a) the profit margin, (b) the investment turnover, and (c) the return on investment. Round answers to one decimal place. a. Profit margin % b. Investment turnover c. Return on investment %
Projected Operating Assets Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year Sales $1,000 Balance Sheet: Assets Cash $ 200 Short-term investments $ 135 Accounts receivable $ 200 Inventories $ 150 Total current assets $ 685 Net fixed assets $ 600 Total assets $1,285 Sales are expected to grow by 8% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round intermediate calculations. Round your answer to the nearest dollar. $
Calculating Average Operating Assets, Margin, Turnover, and Return on Investment East Mullett Manufacturing earned operating income last year as shown in the following income statement: Sales $3,750,000 Cost of goods sold 2,250,000 Gross margin $1,500,000 Selling and administrative expense 1,200,000 Operating income $ 300,000 Less: Income taxes (@ 40%) 120,000 Net income $ 180,000 At the beginning of the year, the value of operating assets was $1,600,000. At the end of the year, the value of operating assets was $1,400,000. Round your answers to two decimal places, when rounding is required. What is the average operating assets
Projected Operating Assets Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. Sales Balance Sheet: Assets Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets This year $1,000 $ 200 $ 90 $ 300 $300 $ 890 $ 450 $1,340 Sales are expected to grow by 12% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round intermediate calculations. Round your answer to the nearest dollar.
Estimation of Working Capital Requirements using Ratios Compute Working Capital Requirements of a Company from the following information: 60 days Sales Average Collection Period Average Payment Period 75 days Gross Profit Inventory Holding Period (on the 90 days Credit Purchases basis of Cost of Goods Sold) Cash & Bank Balances 2.5% of Sales 1 Year The Company expects 50% Sales increment during the next year. €20,00,000 25% 1/3 of Cost of Goods Sold 360 days
Margin, Turnover, Return on Investment Pelak Company had sales of $4,945,000, expenses of $4,566,000, and average operating assets of $3,690,000. Required: 1. Compute the operating income. $ 2. Compute the margin (as a percent) and turnover ratio. If required, round your answers to one decimal place. Margin Turnover % 3. Compute the ROI as a percent. Use the part 2 final answers in these calculations and round the final answer to two decimal places. %
Projected Operating Assets Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year Sales $ 1,000 Balance Sheet: Assets Cash $ 150 Short-term investments $ 130 Accounts receivable $ 300 Inventories $ 250 Total current assets $ 830 Net fixed assets $ 600 Total assets $ 1,430 Sales are expected to grow by 10% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round intermediate calculations. Round your answer to the nearest dollar. $
Franklin Corporation's balance sheet indicates that the company has $570,000 invested in operating assets. During Year 2, Franklin earned operating income of $64,980 on $1,140,000 of sales. Required a. Compute Franklin's profit margin for Year 2. b. Compute Franklin's turnover for Year 2. c. Compute Franklin's return on investment for Year 2. d. Recompute Franklin's ROI under each of the following independent assumptions: (1) Sales increase from $1,140,000 to $1,368,000, thereby resulting in an increase in operating income from $64,980 to $82,080. (2) Sales remain constant, but Franklin reduces expenses, resulting in an increase in operating income from $64.980 to $67,260. (3) Franklin is able to reduce its invested capital from $570,000 to $456,000 without affecting operating income. Complete this question by entering your answers in the tabs below. Req A to C Req D Compute Franklin's profit margin, turnover and return on investment for Year 2. Note: Round "Profit margin" and "Return…
Required information [The following information applies to the questions displayed below.] Westerville Company reported the following results from last year's operations: Sales Variable expenses Contribution margin Fixed expenses $ 1,600,000 700,000 900,000 660,000 Net operating income $4 240,000 Average operating assets $ 1,000,000 At the beginning of this year, the company has a $325,000 investment opportunity with the characteristics: Sales Contribution margin ratio Fixed expenses $ 520,000 70 % of sales $ 312,000 The company's minimum required rate of return is 15%. 9. If the company pursues the investment opportunity and otherwise performs the same as last year, wha (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be considered as 12.3%.)) ROI % ( Prev 1O Pr Ps to search RELS