Answers in Excel so I can understand how all figures were calculated. 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 $94 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. 1. Produce an income statement for 2020. Assume that net working capital will equal 50% of fixed assets. 2. Produce a balance sheet for 2020. Assume that net working capital will equal 50% of fixed assets. 3. 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. INCOME STATEMENT, 2019 (Figures in $ thousands) Revenue $ 1,800 Fixed costs 94 Variable costs (70% of revenue) 1,260 Depreciation 160 Interest (6% of beginning-of-year debt) 18 Taxable income 268 Taxes (at 35%) 94 Net income $ 174 Dividends $ 87 Addition to retained earnings $ 87 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

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 7P

See similar textbooks

Related questions

Question

Answers in Excel so I can understand how all figures were calculated.

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 $94 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.

1. Produce an income statement for 2020. Assume that net working capital will equal 50% of fixed assets.

2. Produce a balance sheet for 2020. Assume that net working capital will equal 50% of fixed assets.

3. 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.

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

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions