#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?
#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?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc38e2d48-f1b7-48f0-afee-ea9fbe1419d8%2Fbe392c54-84e9-4f78-9f60-84e2a9c3f32b%2Fe4auqwo_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
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 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education