#11 Using table 13, create a pro forma balance sheet using the percentage of sales method. If net income next year is $50,000, answer the following: a. How much did the owners take out of the business? b. What is the profit margin for next year?

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 51E: Juroe Company provided the following income statement for last year: Juroes balance sheet as of...
icon
Related questions
Question
100%

Hi need help with a & b.

a. How much did the owners take out of the business?

b. What is the profit margin for next year?

#11 Using table 13, create a pro forma balance sheet using the percentage of sales method.
If net income next year is $50,000, answer the following:
a. How much did the owners take out of the business?
b. What is the profit margin for next year?
TABLE 13 Pro forma Balance Sheet Using Percentage of Sales
Total Sales
Forecast Sales Net Year
Current Year
Percentage of
Sales (%)
$275,000
$350,000
Assets
Current Assets:
Cash
5,694
2.07%
7,247
Accounts Receivable
19,662
7.15%
25,024
Inventory
3,381
1.23%
4,303
Total Current Assets
$28,737
10.45%
36,574
Fixed Assets
Furniture & Fixtures
5,595
2.03%
7,121
Transportation Equipment
25,456
9.26%
32,399
$31,051
$59,788
Total Fixed Assets
11.29%
39,519
Total Assets
21.74%
76,094
Liabilities & Owner's Equity
Current Liabilities
Notes Payable
$15,456
5.62%
19,671
Accrues Taxes Payable
Total Current Liabilities
Long-Term Debt
Total Liabilities
Owner's Equity
3,598
$19,054
1.31%
4,579
6.93%
24,251
18,654
6.78%
23,741
$37,708
13.71%
47,992
22,080
8.03%
28,102
Total Liabilities & Owner's E
$59,788
21.74%
76,094
Transcribed Image Text:#11 Using table 13, create a pro forma balance sheet using the percentage of sales method. If net income next year is $50,000, answer the following: a. How much did the owners take out of the business? b. What is the profit margin for next year? TABLE 13 Pro forma Balance Sheet Using Percentage of Sales Total Sales Forecast Sales Net Year Current Year Percentage of Sales (%) $275,000 $350,000 Assets Current Assets: Cash 5,694 2.07% 7,247 Accounts Receivable 19,662 7.15% 25,024 Inventory 3,381 1.23% 4,303 Total Current Assets $28,737 10.45% 36,574 Fixed Assets Furniture & Fixtures 5,595 2.03% 7,121 Transportation Equipment 25,456 9.26% 32,399 $31,051 $59,788 Total Fixed Assets 11.29% 39,519 Total Assets 21.74% 76,094 Liabilities & Owner's Equity Current Liabilities Notes Payable $15,456 5.62% 19,671 Accrues Taxes Payable Total Current Liabilities Long-Term Debt Total Liabilities Owner's Equity 3,598 $19,054 1.31% 4,579 6.93% 24,251 18,654 6.78% 23,741 $37,708 13.71% 47,992 22,080 8.03% 28,102 Total Liabilities & Owner's E $59,788 21.74% 76,094
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Income Statement 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
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning