Bill Inc.'s last year financial statements are shown below: Bill Inc. Balance Sheet as of December 31 Cash $ 90,000 Accounts payable $ 180,000 Receivables 180,000 Notes payable 78,000 Inventory 360,000 Accruals 90,000 Total current assets $630,000 Total current liabilities $ 348,000 Common stock 900,000 Net fixed assets 720,000 Retained earnings 102,000 Total assets $1,350,000 Total liabilities and equity $1,350,000 Bill Inc. Income Statement for December 31 Sales $1,800,000 Operating costs 1,639,860 EBIT $ 160,140 Interest 10,140 EBT $ 150,000 Taxes (40%) 60,000 Net income $90,000 Dividends (60%) $ 54,000 Addition to retained earnings $ 36,000 Suppose that next year's sales will increase by 20 percent over last year's sales. Construct the pro forma financial statements using the percent of sales method. Assume the firm operated at full capacity last year. How much additional capital will be required?
Bill Inc.'s last year financial statements are shown below: Bill Inc. Balance Sheet as of December 31 Cash $ 90,000 Accounts payable $ 180,000 Receivables 180,000 Notes payable 78,000 Inventory 360,000 Accruals 90,000 Total current assets $630,000 Total current liabilities $ 348,000 Common stock 900,000 Net fixed assets 720,000 Retained earnings 102,000 Total assets $1,350,000 Total liabilities and equity $1,350,000 Bill Inc. Income Statement for December 31 Sales $1,800,000 Operating costs 1,639,860 EBIT $ 160,140 Interest 10,140 EBT $ 150,000 Taxes (40%) 60,000 Net income $90,000 Dividends (60%) $ 54,000 Addition to retained earnings $ 36,000 Suppose that next year's sales will increase by 20 percent over last year's sales. Construct the pro forma financial statements using the percent of sales method. Assume the firm operated at full capacity last year. How much additional capital will be required?
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter16: Financial Statement Analysis
Section: Chapter Questions
Problem 17E
Related questions
Question
Bill Inc.'s last year financial statements are shown below:
Bill Inc. Balance Sheet as of December 31
Cash |
$ 90,000
|
Accounts payable |
$ 180,000
|
|||
Receivables |
180,000
|
Notes payable |
78,000
|
|||
Inventory |
360,000
|
Accruals |
90,000
|
|||
Total current assets |
$630,000
|
Total current liabilities |
$ 348,000
|
|||
|
Common stock |
900,000
|
||||
Net fixed assets |
720,000
|
102,000
|
||||
Total assets |
$1,350,000
|
Total liabilities and equity |
$1,350,000
|
Bill Inc. Income Statement for December 31
Sales |
$1,800,000
|
|
Operating costs |
1,639,860
|
|
EBIT |
$ 160,140
|
|
Interest |
10,140
|
|
EBT |
$ 150,000
|
|
Taxes (40%) |
60,000
|
|
Net income |
$90,000
|
|
|
||
Dividends (60%) |
$ 54,000
|
|
Addition to retained earnings |
$ 36,000
|
Suppose that next year's sales will increase by 20 percent over last year's sales. Construct the pro forma financial statements using the percent of sales method. Assume the firm operated at full capacity last year. How much additional capital will be required?
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 3 steps with 4 images
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
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning