Building financial models

Assignment Help Finance Basics
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
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

Previous Q& A

  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.

  Explain the major dsm iv-tr categories of schizophrenia

Explain the major DSM IV-TR categories of schizophrenia and psychosis, and lifespan development and Examine the various classifications of schizophrenia and psychosis, and lifespan development.

  Calculate the acceleration on the radio

Calculate the acceleration on the radio. The rms voltage across a 5.02 Ω resistor is 34.7 V. Find the maximum instantaneous current by the resistor.

  Justify and analysis by using appropriate examples

Justify your discussion and analysis by using appropriate examples and references." The additional information on Trade Data and Analysis was submited last night.

  Explain relationship oriented and less transaction oriented

Are geared towards short-term spot purchasing. Are more relationship oriented and less transaction oriented than private industrial networks.

  Show value of a grievance process

Value of a Grievance Process - Do you think that the grievance process adds a value to a company and Why or why not?

  Example of a gad and a phobic disorder

Can you provide a summary of Generalized Anxiety Disorder (GAD) and provide an example of a GAD and a phobic disorder?


Write a Review


Similar Q& A

  Explain capital budgeting involves calculation value

Explain Capital budgeting involves calculation of net present value of Mills Mining is considering an expansion project

  Computation of present value of cash flows to make purchase

Computation of present value of cash flows to make purchase decision where demand is so high for Anderson Electric's products that the company cannot manufacture enough inventory to satisfy demand

  Prepare necessary entries to clear the intangible assets

Rolanda Marshall Corporation, organized in 2006, has set up a single account for all intangible assets. The given summary discloses the debit entries that have been recorded during 2007.

  Decision of profitable loan among alternatives

Decision of profitable loan among alternatives and you can either take out a standard student loan

  Describe stock valuation with constant growth rates

Describe Stock Valuation with constant growth rates in the dividends and Constant growth valuation Thomas Brothers is expected to pay a $3 per share dividend at the end of the year

  Compute the contribution margin and fixed costs

Tyson Corporation bottles and distributes LO-KAL, a fruit drink. The beverage is sold for fifty cents per 16-ounce bottle to retailers, who charge customers 70 cents each bottle.

  Semiannual coupon bond valuation

Hartnett Computing has 8 year, non-callable, 8.8% semiannual coupon bonds outstanding. The bonds have a par value of $1,000 and a nominal YTM of 9.5%. Find out the bond's current market price?

  Markets a least semi strong

You do a study and find out that on average stock prices for firms decrease 3 percent evfor every 5 percent decrease in inside ownership.

  Hierarchical and network database structure

Compare and contrast the Hierarchical Database Structure and the Network Database Structure

  Determining the retirement annuity

What annual contributions to retirement fund will let you to receive the $60,000 annually? What annual contributions are needed if the contributions are made at the beginning of each year?

  Describe how the degree of operating and financial leverage

Describe how the degree of operating and financial leverage can change the profitability of the firm when sales levels change significantly

  Pv of future cash flows and multiples based accounting

How are valuations based upon financial statement data affected by the companies' financial reporting choices and earnings management?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd