Integrative-Pro forma statements Provincial Imports, Inc., has assembled last year's financial statements (income statement and balance sheet) and financial projections for use in preparing financial plans for the coming year. Information related to financial projections for next year is as follows: (1) Projected sales are $5,995,000. (2) Cost of goods sold last year includes $1,006,000 in fixed costs. (3) Operating expense last year includes $240,000 in fixed costs. (4) Interest expense will remain unchanged. (5) The firm will pay cash dividends amounting to 35% 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 $364,000 will be purchased during the year. Total depreciation expense for the year will be $114,000. (10) The tax rate will remain at 40%. a. Prepare a pro forma income statement for next year, using the fixed cost data given to improve the accuracy of the percent-of-sales method. b. Prepare a pro forma balance sheet for next year, using the information given and the judgmental approach. Include a reconciliation of the retained earnings account. C a. Prepare a pro forma income statement for next year, using the fixed cost data given to improve the accuracy of the percent-of-sales method. Complete the pro forma income statement for next year below: (Round to the nearest dollar.) Pro Forma Income Statement Provincial Imports, Inc. for Next Year (percent-of-sales method) Sales Less: Cost of goods sold Gross profits Less: Operating expenses Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Cash dividends (35%) To Retained earnings $ $ $ $ $ $ Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Provincial Imports, Inc. Income Statement for the Year Just Ended Assets Cash Marketable securities Accounts receivable Inventories (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Provincial Imports, Inc. Balance Sheet for the Year Just Ended Total current assets Net fixed assets Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Cash dividends To retained earnings Total assets $208,000 232,000 622,000 498,000 $4,990,000 2,743,000 $2,247,000 Print 843,000 $1,404,000 205,000 $1,199,000 479,600 $719,400 251,790 $467,610 Liabilities and Stockholders' Equity Accounts payable Taxes payable Notes payable Other current liabilities Total current liabilities $1,560,000 1,401,000 Long-term debt Common stock Retained earnings $2,961,000 Total liabilities and equity Done $704,000 95,000 204,000 5,300 $1,008,300 496,700 78,000 1,378,000 $2,961,000 - X
Integrative-Pro forma statements Provincial Imports, Inc., has assembled last year's financial statements (income statement and balance sheet) and financial projections for use in preparing financial plans for the coming year. Information related to financial projections for next year is as follows: (1) Projected sales are $5,995,000. (2) Cost of goods sold last year includes $1,006,000 in fixed costs. (3) Operating expense last year includes $240,000 in fixed costs. (4) Interest expense will remain unchanged. (5) The firm will pay cash dividends amounting to 35% 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 $364,000 will be purchased during the year. Total depreciation expense for the year will be $114,000. (10) The tax rate will remain at 40%. a. Prepare a pro forma income statement for next year, using the fixed cost data given to improve the accuracy of the percent-of-sales method. b. Prepare a pro forma balance sheet for next year, using the information given and the judgmental approach. Include a reconciliation of the retained earnings account. C a. Prepare a pro forma income statement for next year, using the fixed cost data given to improve the accuracy of the percent-of-sales method. Complete the pro forma income statement for next year below: (Round to the nearest dollar.) Pro Forma Income Statement Provincial Imports, Inc. for Next Year (percent-of-sales method) Sales Less: Cost of goods sold Gross profits Less: Operating expenses Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Cash dividends (35%) To Retained earnings $ $ $ $ $ $ Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Provincial Imports, Inc. Income Statement for the Year Just Ended Assets Cash Marketable securities Accounts receivable Inventories (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Provincial Imports, Inc. Balance Sheet for the Year Just Ended Total current assets Net fixed assets Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Cash dividends To retained earnings Total assets $208,000 232,000 622,000 498,000 $4,990,000 2,743,000 $2,247,000 Print 843,000 $1,404,000 205,000 $1,199,000 479,600 $719,400 251,790 $467,610 Liabilities and Stockholders' Equity Accounts payable Taxes payable Notes payable Other current liabilities Total current liabilities $1,560,000 1,401,000 Long-term debt Common stock Retained earnings $2,961,000 Total liabilities and equity Done $704,000 95,000 204,000 5,300 $1,008,300 496,700 78,000 1,378,000 $2,961,000 - X
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
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