Explore BrainMass

Explore BrainMass

    Building Financial Models

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Can someone assist me with this problem. I am having trouble with a & b.

    16. Building Financial Models. 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 5years 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

    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?

    (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

    (figures in thousands of dollars)
    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

    © BrainMass Inc. brainmass.com June 3, 2020, 9:59 pm ad1c9bdddf

    Solution Summary

    Excel file contains a set of financial statements and pro forma balance sheet.