Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
15th Edition
ISBN: 9780134476315
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 4, Problem 4.21P
Learning Goal 5
P4-21 Integrative: Pro forma statements Provincial Imports Inc. has assembled past (2019) financial statements (income statement and
Provincial Imports Inc. Income Statement for the Year Ended December 31, 2019
| Sales revenue | $5,000,000 |
| Less: Cost of goods sold | 2,750,000 |
| Gross profits | $2,250,000 |
| Less: Operating expenses | 850,000 |
| Operating profits | $1,400,000 |
| Less: Interest expense | 200,000 |
| Net profits before taxes | $1,200,000 |
| Less: Taxes (rate = 40%) | 480,000 |
| Net profits after taxes | $ 720,000 |
| Less: Cash dividends | 288,000 |
| To |
$ 432,000 |
Information related to financial projections for the year 2020 is as follows:
- 1. Projected sales are $6,000,000.
- 2. Cost of goods sold in 2019 includes $1,000,000 in fixed costs.
- 3. Operating expense in 2019 includes $250,000 in fixed costs.
- 4. Interest expense will remain unchanged
- 5. The firm will pay cash dividends amounting to 40% of net profits after taxes.
- 6. Cash and inventories will double.
- 7. Marketable securities, notes payable, long-term debt, and common stock will remain unchanged.
- 8. Accounts receivable, accounts payable, and other current liabilities will change in direct response to the change in sales
- 9. A new computer system costing $356,000 will be purchased during the year. Total
depreciation expense for the year will be $110,000. - 10. The tax rate will remain at 40%.
- a. Prepare a pro forma income statement for the year ended December 31, 2020, using the fixed cost data given to improve the accuracy of the percent-of-sales method.
- b. Prepare a pro forma balance sheet as of December 31, 2020, using the information given and the judgmental approach. Include a reconciliation of the retained earnings account.
- c. Analyze these statements, and discuss the resulting external financing required.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Please assist with 3.2
Please refer to screenshots for question
Very important please be correct thank you
Chapter 4 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in 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
- OBJECTIVE: To enable learners to utilize financial ratios as a mechanism to evaluate the firm's financial performance and identify areas for making decisions for improvement REQUIREMENT: Financial Statement Analysis Question Refer to the following financial statements of Delima Corporation for 2019 and 2020: Delima Corporation Income Statements For the year ended 31 December (in millions) 2020 $13,198 7,750 2019 $12,397 7,108 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations 5,448 5,289 3,472 3,299 1,976 1,990 Interest expense 233 248 Other (income) expense, net 11 1,732 503 1,229 Income before income taxes 1,742 Income tax expense 502 Net income 1,240 Delima Corporation Balance Sheets 31 December (in millions) 2020 2019 Assets Current assets Cash $460 $444 Accounts receivables (net) 1,188 1,132 1,190 1,056 225 2,915 3,128 Inventories Other current assets 247 Total current assets 3,027 3,281 Property (net) 5,593 $11,901 Other assets…arrow_forward1. Using the data in the student spreadsheet file Ethan Allen Financials.xlsx forecast the 2019 income statement and balance sheet for Ethan Allen. Use the percent of sales method and the following assumptions: (1) sales in FY 2019 will be $797.3359; (2) the tax rate will be 35%; (3) each item that changes with sales will be the five-year average percentage of sales; (4) net fixed assets will increase to $300; and (5) the common dividend will be $0.75 per share. Use your judgment on all other items. a. What is the discretionary financing needed in 2019? Is this a surplus or deficit? b. Assume that the DFN will be absorbed by long-term debt and that the interest rate is 4% of LTD. Set up an iterative worksheet to eliminate it.arrow_forwardHIC GROUP OF Companies COMPARATIVE INCOME STATEMENT For years ended 3rd December 2019 2020 Revenue and gains Sales revenue 495,500 496,738.75 Interest revenue 278,500 279,196.25 Investment Income 71,700 71,879.25 Other revenue 101,500 101,753.75 Total revenue and gains 947,200 949,968 Expenses and losses Cost of good sold 450,000 447,750 Selling&administrative 185,000 184,075 Computer (operating) 42,500 42,288 Depreciation 50,000…arrow_forward
- HIC GROUP OF Companies COMPARATIVE INCOME STATEMENT For years ended 3rd December 2019 2020 Revenue and gains Sales revenue 495,500 496,738.75 Interest revenue 278,500 279,196.25 Investment Income 71,700 71,879.25 Other revenue 101,500 101,753.75 Total revenue and gains 947,200 949,968 Expenses and losses Cost of good sold 450,000 447,750 Selling&administrative 185,000 184,075 Computer (operating) 42,500 42,288…arrow_forwardFINA310 IP TEMPLATE FOR STUDENTS Student name: Date: ACTUAL FORECAST Current Year Next Year Total Revenue 71,879 |Cost of Revenue (51,125) Gross Profit 20,754 Operating Expenses: Selling, General, and Administrative (14,248) Research and Development Special Income/Other Charges (2,194) Total Operating Expenses (16,442) Operating Income 4,312 Net Interest Income (666) edite Pre-Tax Income 3,646 Provision for Income Tax (19.5%) (711) Net Income 2,935 Additionally, Tag-It's CEO has predicted a 12% increase in total revenue next year. Utilizing the percentage of sales method, prepare a forecast for next year in the correct section on the Excel spreadsheet. 1. The total revenue numbers over the past 4 years for Tag-lt Corporation were as follows (values in millions): o 73,785 O 69,495 o 75,356 o 71,879 2. Determine whether you think Tag-It can hit the target of a 12% increase in sales next year.arrow_forwardProblem 13-02A (Video) The comparative statements of Cullumber Company are presented here: Cullumber CompanyIncome StatementsFor the Years Ended December 31 2020 2019 Net sales $1,891,640 $1,751,600 Cost of goods sold 1,059,640 1,007,100 Gross profit 832,000 744,500 Selling and administrative expenses 501,100 480,100 Income from operations 330,900 264,400 Other expenses and losses Interest expense 23,700 21,700 Income before income taxes 307,200 242,700 Income tax expense 93,700 74,700 Net income $213,500 $168,000 Cullumber CompanyBalance SheetsDecember 31 Assets 2020 2019 Current assets Cash $60,100 $64,200 Debt investments (short-term) 74,000 50,000 Accounts receivable 118,900 103,900 Inventory 127,700 117,200 Total current assets 380,700 335,300 Plant assets (net)…arrow_forward
- Income Statement for the years ending 31 August: 2020 2019 £ £Revenue 950,000 975,000Cost of sales 455,000 460,000Gross profit 495,000 515,000Total expenses 320,000 310,000Net profit 175,000 205,000 Statement of financial position as at 31 August:- 2020 2019£ £Non-current assets 70,000 65,000Current assetsCash at bank…arrow_forwardIncome Statement for the years ending 31 August: 2020 2019 £ £Revenue 950,000 975,000Cost of sales 455,000 460,000Gross profit 495,000 515,000Total expenses 320,000 310,000Net profit 175,000 205,000 Statement of financial position as at 31 August: 2020 2019£ £Non-current assets 70,000 65,000Current assetsCash at bank…arrow_forwardCourse: 2020FA Accounting for X * CengageNOWv2 | Online teachir x /v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAs... еВook GE Calculator Sales Mix and Break-Even Sales Data related to the expected sales of kayaks and canoes for River Sports Inc. for the current year, which is typical of recent years, are as follows: Products Unit Selling Price Unit Variable Cost Sales Mix Kayaks $240 $160 20% Canoes 510 240 80% The estimated fixed costs for the current year are $273,760. Instructions: 1. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year. units 2. Based on the break-even sales (units) in part (1), determine the unit sales of both kayaks and canoes for the current year. Kayaks units Canoes units 3. Assume that the sales mix was 80% Kayaks and 20% canoes. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year. units 田arrow_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 Learning
Corporate 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 ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License