Barry’s Superstore wishes to prepare financial plans. Use the financial statements on the next page and the other information provided below to prepare the financial plans. The following financial data are also available: (1) The firm has estimated that its sales for next year will be $130,000. (2) The firm expects to pay $30,000 in cash dividends. (3) The firm wishes to maintain a minimum cash balance of $25,000. (4) Accounts receivable represent approximately 20% of annual sales. (5) The firm’s ending inventory represents 60% of Cost of Goods Sold. (6) A new machine costing $15,000 will be purchased next year. (7) Accounts payable will increase by 5%. (8) Unearned Revenue will be earned. (9) Notes Payable would decrease by $5000. (10) Short-Term Investments and common stock will remain unchanged. Requirement: a. Prepare a pro forma income statement for the year ended December 31, 2021, using the percent-of-sales method. Tax Rate is expected to be 15%. b. Prepare a pro forma balance sheet dated December 31, 2021, using the judgmental approach. c. Analyze these statements, and discuss the resulting external financing required.
Barry’s Superstore wishes to prepare financial plans. Use the financial statements on the next page and the other information provided below to prepare the financial plans. The following financial data are also available: (1) The firm has estimated that its sales for next year will be $130,000. (2) The firm expects to pay $30,000 in cash dividends. (3) The firm wishes to maintain a minimum cash balance of $25,000. (4) Accounts receivable represent approximately 20% of annual sales. (5) The firm’s ending inventory represents 60% of Cost of Goods Sold. (6) A new machine costing $15,000 will be purchased next year. (7) Accounts payable will increase by 5%. (8) Unearned Revenue will be earned. (9) Notes Payable would decrease by $5000. (10) Short-Term Investments and common stock will remain unchanged. Requirement: a. Prepare a pro forma income statement for the year ended December 31, 2021, using the percent-of-sales method. Tax Rate is expected to be 15%. b. Prepare a pro forma balance sheet dated December 31, 2021, using the judgmental approach. c. Analyze these statements, and discuss the resulting external financing required.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
Barry’s Superstore wishes to prepare financial plans. Use the financial statements on the next page and the other information provided below to prepare the financial plans.
The following financial data are also available:
(1) The firm has estimated that its sales for next year will be $130,000.
(2) The firm expects to pay $30,000 in cash dividends.
(3) The firm wishes to maintain a minimum cash balance of $25,000.
(4)
(5) The firm’s ending inventory represents 60% of Cost of Goods Sold.
(6) A new machine costing $15,000 will be purchased next year.
(7) Accounts payable will increase by 5%.
(8) Unearned Revenue will be earned.
(9) Notes Payable would decrease by $5000.
(10) Short-Term Investments and common stock will remain unchanged.
Requirement:
a. Prepare a pro forma income statement for the year ended December 31, 2021, using the percent-of-sales method. Tax Rate is expected to be 15%.
b. Prepare a pro forma
c. Analyze these statements, and discuss the resulting external financing required.
Transcribed Image Text:BARRY'S SUPERSTORE
BARRY'S SUPERSTORE
Comparative Year-End Income Statements
Comparative Year-End Balance Sheets
Prior Year
Current Year
Prior Year
Current Year
Net Sales
$100,000
$120,000
Assets:
Cost of Goods Sold
50,000
60,000
Cash
$90,000
$110,000
Gross Profit
50,000
60,000
Accounts Receivable
20,000
30,000
Inventory
35,000
40,000
Rent Expense
5,000
5,500
Short-Term Investments
15,000
20,000
Total Current Asstes
Depreciation Expense
Salaries Expense
Utility Expense
2,500
3,600
160,000
200,000
3,000
5,400
Equipment
40,000
50,000
1,500
2,500
Total Assets
$200,000
$250,000
Operating Income
38,000
43,000
Liabilities:
Accounts Payable
$ 60,000
$ 75,000
Interest Expense
Income Tax Expense
3,000
2,000
Unearned Revenue
10,000
25,000
5,000
6,000
Total Current Liabilities
70,000
100,000
Net Income
$ 30,000
$ 35,000
Notes Payable
40,000
50,000
Total Liabilities
110,000
150,000
Stockholder Equity
Common Stock
75,000
80,000
Ending Retained Earnings
Total Stockholder Equity
Total Liabilities and Stockholder Equity
15,000
20,000
90,000
100,000
$200,000
$250,000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Knowledge Booster
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education