MyLab Finance with Pearson eText -- Access Card -- for Principles of Managerial Finance
15th Edition
ISBN: 9780134479903
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 4, Problem 4.16P
Learning Goal 5
P4-16 Pro forma income statement The marketing department of Metroline Manufacturing estimates that its sales in 2020 will be 51.5 million. Interest expense is expected to remain unchanged at $35,000, and the firm plans to pay $70,000 in cash dividends during 2020. Metroline Manufacturing’s income statement for the year ended December 31, 2019, and a breakdown of the firm’s cost of goods sold and operating expenses into their fixed and variable components are given below.
- a. Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2020.
- b. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2020.
- c. Compare and contrast the statements developed in parts a and b. Which statement probably provides the better estimate of 2020 income? Explain why. Metroline Manufacturing Income Statement for the Year Ended December 31, 2019
Sales revenue | $1,400,000 |
Less: Cost of goods sold | 910,000 |
Gross profits | $ 490,000 |
Less: Operating expenses | 120,000 |
Operating profits | $ 370,000 |
Less: Interest expense | 35,000 |
Net profits before taxes | $ 335,000 |
Less: Taxes (rate = 40%) | 134,000 |
Net profits after taxes | $ 201,000 |
Less: Cash dividends | 66,000 |
To |
$135,000 |
Metroline Manufacturing Breakdown of Costs and Expenses into Fixed and Variable Components for the Year Ended
December 31, 2019
Cost of goods sold | |
Fixed cost | $210,000 |
Variable cost | 700,000 |
Total costs | $910,000 |
Operating expenses | |
Fixed expenses | $36,000 |
Variable expenses | 84,000 |
Total expenses | $120,000 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Prepare calculations for each financial indicator (budget and actual) that is indicated as being missing from Exhibit 2, together with other relevant financial performance measures.
Pro forma income statement The marketing department of Metroline Manufacturing estimates that its sales in 2020 will be $1.53 million. Interest expense is expected to remain unchanged at $39,000, and the firm plans to pay
$74,000 in cash dividends during 2020. Metroline Manufacturing's income statement for the year ended December 31, 2019, 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 the year ended December 31, 2020.
b. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2020.
c. Compare and contrast the statements developed in parts a. and b. Which statement probably provides the better estimate of 2020 income? Explain why.
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…
P4-16
Pro forma income statement The marketing department of Metroline Manufac
tūring estimates that its sales in 2020 will be $1.5 million. Interest expense is
expected to remain unchanged at $35,000, and the firm plans to pay $70,000 in
cash dividends during 2020. Metroline Manufacturing's income statement for
the year ended December 31, 2019, and a breakdown of the firm's cost of goods
sold and operating expenses into their fixed and variable components are gives
below.
a. Use the percent-of-sales method to prepare a pro forma income statement for the
year ended December 31, 2020.
b.
Use fixed and variable cost data to develop a pro forma income statement for the
year ended December 31, 2020.
c.
Compare and contrast the statements developed in parts a and b. Which state-
ment probably provides the better estimate of 2020 income? Explain why.
Metroline Manufacturing
Income Statement
for the Year Ended December 31, 2019
Sales revenue
Less: Cost of goods sold
Gross profits
Less…
Chapter 4 Solutions
MyLab Finance with Pearson eText -- Access Card -- for Principles of Managerial Finance
Ch. 4.1 - Prob. 4.1RQCh. 4.1 - Prob. 4.2RQCh. 4.2 - Briefly describe the first four modified...Ch. 4.2 - Describe the overall cash flow through the firm in...Ch. 4.2 - Prob. 4.5RQCh. 4.2 - 4-B Why is depreciation (as well as amortization...Ch. 4.2 - Prob. 4.7RQCh. 4.2 - Prob. 4.8RQCh. 4.2 - Prob. 4.9RQCh. 4.3 - Prob. 4.10RQ
Ch. 4.3 - Prob. 4.11RQCh. 4.3 - Prob. 4.12RQCh. 4.3 - What is the cause of uncertainty in the cash...Ch. 4.4 - Prob. 4.14RQCh. 4.5 - Prob. 4.15RQCh. 4.5 - Prob. 4.16RQCh. 4.6 - Prob. 4.17RQCh. 4.6 - What is the significance of the plug figure,...Ch. 4.7 - Prob. 4.19RQCh. 4.7 - Prob. 4.20RQCh. 4 - Opener-in-Review The chapter opener described a...Ch. 4 - Learning Goals 2, 3 ST4-1 Depreciation and cash...Ch. 4 - Prob. 4.2STPCh. 4 - Prob. 4.3STPCh. 4 - Prob. 4.1WUECh. 4 - Prob. 4.2WUECh. 4 - Learning Goal 3 E4-3 Determine the operating cash...Ch. 4 - Prob. 4.4WUECh. 4 - Learning Goal 5 E4-5 Rimier Corp. forecasts sales...Ch. 4 - Prob. 4.1PCh. 4 - Learning Goal 2 P4-2 Depreciation In early 2019,...Ch. 4 - Prob. 4.3PCh. 4 - Learning Goals 2, 3 P4-4 Depreciation and...Ch. 4 - Learning Goal 3 P4-5 Classifying inflows and...Ch. 4 - Prob. 4.6PCh. 4 - Learning Goal 4 P4-8 Cash receipts A firm has...Ch. 4 - Learning Goal 4 P4-9 Cash disbursements schedule...Ch. 4 - Learning Goal 4 P4-10 Cash budget: Basic Grenoble...Ch. 4 - Prob. 4.11PCh. 4 - Learning Goal 4 P4-12 Cash budget: Advanced The...Ch. 4 - Prob. 4.13PCh. 4 - Prob. 4.14PCh. 4 - Learning Goal 4 P4-15 Multiple cash budgets:...Ch. 4 - Learning Goal 5 P4-16 Pro forma income statement...Ch. 4 - Learning Goal 5 P4-17 Pro forma income statement:...Ch. 4 - Learning Goal 5 P4-18 Pro forma balance sheet:...Ch. 4 - Learning Goal 5 P4-19 Pro forma balance sheet...Ch. 4 - Learning Goal 5 P4-20 Integrative: Pro forma...Ch. 4 - Learning Goal 5 P4-21 Integrative: Pro forma...Ch. 4 - Prob. 4.22PCh. 4 - Prob. 1SE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Pro forma income statement The marketing department of Metroline Manufacturing estimates that its sales in 2020 will be $1.53 million. Interest expense is expected to remain unchanged at $35,000, and the firm plans to pay $65,000 in cash dividends during 2020. Metroline Manufacturing's income statement for the year ended December 31, 2019, 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 the year ended December 31, 2020. b. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2020. c. Compare and contrast the statements developed in parts a. and b. Which statement probably provides the better estimate of 2020 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…arrow_forwardPro forma income statement The marketing department of Metroline Manufacturing estimates that its sales in 2020 will be $1.59 million. Interest expense is expected to remain unchanged at $36,000, and the firm plans to pay $66,000 in cash dividends during 2020. Metroline Manufacturing's income statement for the year ended December 31, 2019, is given LOADING... , 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 the year ended December 31, 2020. b. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2020. c. Compare and contrast the statements developed in parts a. and b. Which statement probably provides the better estimate of 2020 income? Explain why.arrow_forwardConsider whether actual performance has improved since 2019 (actual 2021 vs. 2019) Consider whether the performance achieved is as good as Sonik intended (actual 2021 vs. budget 2021) and how it compares to the market leaderarrow_forward
- (Profitability Ratio)What is the Return on Investment Ratio in 2019?arrow_forwardcomparative income statements of Arab Manufacturing Company are shown below. 2019 $38,610 $32,175 $25,740 2020 2018 Net sales 25,100 19,950 S13,510 S12,225 $10,340 7,700 4,270 Cost of sales 15,400 Gross profit Selling expenses 6,565 5,148 Administrative 4.175 3,861 expenses Total operating S11,970 $10,740 $9.009 expenses Operating S 1,540 S1,485 $1,331 income Interest expense 115 95 100 Net income S 1,425 S 1,390 $1,231 before tax 655 645 S 770 S 745 541 $ 690 Income taxes Net income Required: a. Perform a vertical, common size analysis of the income statement data for Arab Manufacturing Company in columnar form, using sales as the base. b. Comment briefly on significant trends and relationships revealed by the computations. :52 PMarrow_forwardPercentage of Sales Models Here are the abbreviated financial statements for Planner's Peanuts Income Statement , 2019 Sales $2,000 Cost 1,500 Net Income $ 500 Balance Sheet, Year End 2018 2019 2018 2019 Assets $2,500 $3,000 Debt $ 833 $1,000 Equity 1,667 2,000 Total $2,500 $3,000 Total $2,500 $3,000 a. if sales increase by 20% in 2020 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 20%), what must be the balancing item? b. what will be the value of this balancing item?arrow_forward
- Answer the whole pagearrow_forwardBELOW IS THE INCOME STATEMENT FOR NEW COMPANY FOR JANUARY 2020 SALES PER UNIT $75 SALES VOLUME 185000 $13,875,000 COSTS COST OF GOODS SOLD 8,960,250 MARKETING AND ADMIN (FIXED) 1,500,000 TOTAL COSTS 10,460,250 OPERATING PROFIT 3,414,750 TAXES 1,126,868 2,287,882 0.33 PROFIT AFTER TAXES PREPARE A BUDGET FOR FEBRUARY TAKING INTO ACCOUNT THE FOLLOWING SALES VOLUME WILL INCREASE 30 PERCENT UNIT SALE VALUE WILL DECREASE 5 PERCENT COST OF GOODS SOLD WILL INCREASE LIKE SALES MARKETING AND ADMIN WILL DECREASE 6 PERCENT TAX RATE WILL INCREASE 3 PERCENTAGE POINTSarrow_forwardStatement of comprehensive income for the year ended 31 December 2021Sales 10 000 000Cost of sales (5 750 000)Gross profit 4 250 000Variable selling and administrative expenses (1 500 000)Fixed selling and administrative expenses (500 000)Net profit 2 250 000 Additional information:1. The sales budget for 2022 is as follows:First quarter R2 625 000Second quarter R2 750 000Third quarter R2 875 000Fourth quarter R2 750 0002. 90% of the sales is collected in the quarter of the sale and 10% in the quarter following the sale.3. The gross margin ratio for 2022 is expected to be the same as for 2021.4. Inventory is purchased in the quarter of the expected sale. Eighty (80%) of inventory purchases is paid for in thequarter of purchase and twenty percent (20%) is paid for in the quarter following the purchase.5. The inventories balance at the end of each quarter is expected to be the same as the end of the last quarter of2021 viz. R1 600 000.6. Variable selling and administrative expenses will…arrow_forward
- Here are the abbreviated financial statements for Planner’s Peanuts: INCOME STATEMENT, 2019 Sales $ 5,000 Cost 3,900 Net income $ 1,100 BALANCE SHEET, YEAR-END 2018 2019 2018 2019 Assets $ 7,500 $ 12,100 Debt $ 833 $ 1,000 Equity 6,667 11,100 Total $ 7,500 $ 12,100 Total $ 7,500 $ 12,100 a. If sales increase by 10% in 2020 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 10%), what must be the balancing item? b. What will be the value of this balancing item?arrow_forwardOperating data for Joshua Corporation are presented below. 2020 2019 Sales revenue $745,000 $595,000 Cost of goods sold 459,665 384,965 Selling expenses 114,730 67,235 Administrative expenses 55,130 48,790arrow_forwardPrepare a projected statement of comprehensive income for the year ended 31 December 2021 to determine the sales needed to produce a profit after tax that is 25% more than that for the year ending 31 December 2020.(Where applicable round of amounts to the nearest rand) INFORMATION:Calder EnterprisesStatement of Comprehensive Income for the year ended 31 December 2020 Additional information:1. Cost of sales is expected to be 60% of sales.2. Operating expenses will increase by 4%.3. Interest expense will increase to R120 000.4. The tax rate will remain at 28%3.2 Use the information from question 3.1 (not your solution) and calculate the following for the year ending 31 December 2020:3.2.1 Gross margin 3.2.2 Net profit margin 3.2.3 Operating margin 3.2.4 Interest coveragearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license