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 $6,006,000. ​(2) Cost of goods sold last year includes $998,000 in fixed costs. ​(3) Operating expense last year includes $246,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 $116,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. Analyze these​ statements, and discuss the resulting external financing required

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
 I need help urgently could you please explain the solution of this question???
 
 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
$6,006,000.
​(2) Cost of goods sold last year includes
$998,000
in fixed costs.
​(3) Operating expense last year includes
$246,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
$116,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. Analyze these​ statements, and discuss the resulting external financing required.
 
 
 
 
Complete the liabilities and equity part of the pro forma balance sheet for next​ year:  ​(Round to the nearest​ dollar.)
 
Pro Forma Balance Sheet
Provincial Imports, Inc.
for Next Year
(Judgmental Method)
Accounts payable
$
 
Taxes payable
 
 
Notes payable
 
205,000
Other current liabilities
 
 
Total current liabilities
$
 
Long-term debt
 
512,200
Common stock
 
 
Retained earnings
 
 
External funds required
 
 
Total liabilities and stockholders’ equity
$
 
Data table
Less. Operaling expenSES
O35,000
$1,410,000
Operating profits
Less: Interest expense
201,000
Net profits before taxes
Less: Taxes (rate = 40%)
$1,209,000
483,600
Net profits after taxes
$725,400
Less: Cash dividends
253,890
To retained earnings
$471,510
(Click on the icon here D
in order to copy the contents of the data table below into a spreadsheet.)
Provincial Imports, Inc. Balance Sheet
for the Year Just Ended
Assets
Liabilities and Stockholders' Equity
Accounts payable
Taxes payable
Notes payable
Cash
$190,000
$700,000
Marketable securities
230,000
95,000
Accounts receivable
635,000
205,000
Inventories
508,000
Other current liabilities
4,800
Total current assets
$1,563,000
Total current liabilities
$1,004,800
Net fixed assets
1,408,000
Long-term debt
512,200
Common stock
77,000
Retained earnings
1,377,000
Total assets
$2,971,000
Total liabilities and equity
$2,971,000
Transcribed Image Text:Data table Less. Operaling expenSES O35,000 $1,410,000 Operating profits Less: Interest expense 201,000 Net profits before taxes Less: Taxes (rate = 40%) $1,209,000 483,600 Net profits after taxes $725,400 Less: Cash dividends 253,890 To retained earnings $471,510 (Click on the icon here D in order to copy the contents of the data table below into a spreadsheet.) Provincial Imports, Inc. Balance Sheet for the Year Just Ended Assets Liabilities and Stockholders' Equity Accounts payable Taxes payable Notes payable Cash $190,000 $700,000 Marketable securities 230,000 95,000 Accounts receivable 635,000 205,000 Inventories 508,000 Other current liabilities 4,800 Total current assets $1,563,000 Total current liabilities $1,004,800 Net fixed assets 1,408,000 Long-term debt 512,200 Common stock 77,000 Retained earnings 1,377,000 Total assets $2,971,000 Total liabilities and equity $2,971,000
Click on the icon here D
in order to copy the contents of the data table below into a spreadsheet.)
Provincial Imports, Inc. Income Statement
for the Year Just Ended
Sales revenue
$5,006,000
Less: Cost of goods sold
Gross profits
Less: Operating expenses
2,741,000
$2,265,000
855,000
$1,410,000
Operating profits
Less: Interest expense
201,000
Net profits before taxes
$1,209,000
Less: Taxes (rate = 40%)
483,600
Net profits after taxes
$725,400
Less: Cash dividends
253,890
To retained earnings
$471,510
Click on the icon here a in order to copy the contents of the data table below into a spreadsheet.)
Provincial Imports, Inc. Balance Sheet
for the Year Just Ended
Assets
Liabilities and Stockholders' Equity
Accounts payable
Taxes payable
Cash
$190,000
$700,000
Marketable securities
230,000
95,000
Transcribed Image Text:Click on the icon here D in order to copy the contents of the data table below into a spreadsheet.) Provincial Imports, Inc. Income Statement for the Year Just Ended Sales revenue $5,006,000 Less: Cost of goods sold Gross profits Less: Operating expenses 2,741,000 $2,265,000 855,000 $1,410,000 Operating profits Less: Interest expense 201,000 Net profits before taxes $1,209,000 Less: Taxes (rate = 40%) 483,600 Net profits after taxes $725,400 Less: Cash dividends 253,890 To retained earnings $471,510 Click on the icon here a in order to copy the contents of the data table below into a spreadsheet.) Provincial Imports, Inc. Balance Sheet for the Year Just Ended Assets Liabilities and Stockholders' Equity Accounts payable Taxes payable Cash $190,000 $700,000 Marketable securities 230,000 95,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education