Building financial models

Reference no: EM1357563

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 (that is, assets net of depreciation) by $200,000 per year for the next 5 years and forecasts that the ratio of revenues to total assets will remain at 1.50. Annual depreciation is 10 percent of net fixed assets at the end of the year. Fixed costs are expected to remain at $56,000 and variable costs at 80 percent of revenue. The company's policy is to pay out two-thirds of net income as dividends and to maintain a book debt ratio of 25 percent of total capital.

a. Produce a set of financial statements for 2007. Assume that net working capital will equal 50 percent of fixed assets.

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 2007. What is the projected debt ratio for 2007?

Income Statement, 2006
(figures in thousands of dollars)
Revenue $1,800
Fixed costs 56
Variable costs (80% of revenue) 1,440
Depreciation 80
Interest (8% of beginning-of-year debt) 24
Taxable income 200
Taxes (at 40%) 80
Net income $ 120
Dividends $80
Retained earnings $40

Balance Sheet, Year-End
(figures in thousands of dollars)2006
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

Reference no: EM1357563

Questions Cloud

Suppose a shuttle were launched from a launchpad : An object is held up by two ropes. rope 1 makes an angle of 65 degrees above horizontal and the tension in it is T1 = 26N. rope 2 makes an angle of 32 degrees above horizontal and the object is in equilibrium. what is the tension in rope 2 (T2) an..

Development of an anxiety problem : Describe how respondent behavior is involved in the development of an anxiety problem. Identify the CS and CR in this example.

Explain they both feel stress because of the economic : Explain They both feel stress because of the economic pressures as well as freedom to continue the lifestyle that they were accustomed to before Christa arrived.

Illustrate what role did the policies of various governments : Illustrate what role did the policies of various governments play in influencing the international expansion strategies of both McDonald's and Wal-Mart.

Building financial models : The given 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

Americans with disabilities act and the aging population : Explain what are some reasons why employees might resent workplace accommodations that are dictated by the Americans with Disabilities Act?

Strategic planning - performance management : Evaluate the finding that performance management is one of the key success factors in strategic planning.

Describe which market participants you believe benefited : Describe which market participants you believe benefited from the final court decision and whose interests were harmed.

Financial perspective on customers : The material in this module shows that many companies place disproportionate emphasis on the financial perspective at the costs of the other three perspectives.

User Account

All Pages