The following tables contain financial statements for Dynastatics Corporation. Although the company has not been growing, it now plans to expand and will increase net fixed assets (i.e., assets net of depreciation) by $200,000 per year for the next 4 years, and it forecasts that the ratio of revenues to total assets will remain at 1.50. Annual depreciation is 20% of net fixed assets at the beginning of the year. Fixed costs are expected to remain at $90 and variable costs at 70% of revenue. The company’s policy is to pay out one-half of net income as dividends and to maintain a book debt ratio of 20% of total capital. INCOME STATEMENT, 2019 (Figures in $ thousands) Revenue       $ 1,800   Fixed costs         90   Variable costs (70% of revenue)         1,260   Depreciation         160   Interest (6% of beginning-of-year debt)         18   Taxable income         272   Taxes (at 35%)         95   Net income       $ 177   Dividends $ 89         Addition to retained earnings $ 88             BALANCE SHEET, YEAR-END (Figures in $ thousands)   2019 Assets       Net working capital $ 400   Fixed assets   800   Total assets $ 1,200   Liabilities and shareholders’ equity       Debt $ 300   Equity   900   Total liabilities and shareholders’ equity $ 1,200       Please solve for the b & c only, I have the first half completed: b. Now assume that the balancing item is debt and that no equity is to be issued. Prepare a completed pro forma balance sheet for 2020. c. Assume that the balancing item is debt and that no equity is to be issued, what is the projected debt ratio for 2020?

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

The following tables contain financial statements for Dynastatics Corporation. Although the company has not been growing, it now plans to expand and will increase net fixed assets (i.e., assets net of depreciation) by $200,000 per year for the next 4 years, and it forecasts that the ratio of revenues to total assets will remain at 1.50. Annual depreciation is 20% of net fixed assets at the beginning of the year. Fixed costs are expected to remain at $90 and variable costs at 70% of revenue. The company’s policy is to pay out one-half of net income as dividends and to maintain a book debt ratio of 20% of total capital.

INCOME STATEMENT, 2019
(Figures in $ thousands)
Revenue       $ 1,800  
Fixed costs         90  
Variable costs (70% of revenue)         1,260  
Depreciation         160  
Interest (6% of beginning-of-year debt)         18  
Taxable income         272  
Taxes (at 35%)         95  
Net income       $ 177  
Dividends $ 89        
Addition to retained earnings $ 88        
 

 

BALANCE SHEET, YEAR-END
(Figures in $ thousands)
  2019
Assets      
Net working capital $ 400  
Fixed assets   800  
Total assets $ 1,200  
Liabilities and shareholders’ equity      
Debt $ 300  
Equity   900  
Total liabilities and shareholders’ equity $ 1,200  
 

 

Please solve for the b & c only, I have the first half completed:

b. Now assume that the balancing item is debt and that no equity is to be issued. Prepare a completed pro forma balance sheet for 2020.

c. Assume that the balancing item is debt and that no equity is to be issued, what is the projected debt ratio for 2020?

 

Here is my work so far in excel:

Revenue 2250
Fixed costs 90
Variable costs @ 70% 1575
Depreciation @ 20% 160
Interest @ 6% 18
Taxable income 407
Tax @ 35% 142.45
Net income 264.55
    Dividends @ 1/2 132.275
    Retained earnings 132.275
Assests    
Net working capital 500 50 % of fixed assets
Fixed assets 1000 increased by 200
Total assets 1500  
Laibilities & Shareholders equity    
Debt ? Balancing item
Equity ?  
Total Laibilities & Shareholders equity 1500  
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Planning Model
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
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