Explore BrainMass

Explore BrainMass

    Cambridge Prep Shops-Percent-of-sales method

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

    (See attached file for full problem description)

    ---
    24. Cambridge Prep Shops, a national clothing chain, had sales of $200 million last year. The business has a steady net profit margin of 12 percent and a dividend payout ratio of 40 percent. The balance sheet for the end of last year is shown below.
    Balance Sheet
    End of Year
    (in $ millions)
    Cambridge's marketing staff tells the president that in this coming year there will be a large increase in the demand for tweed sport coats and various shoes. A sales increase of 15 percent is forecast for the Prep Shop.
    Percent-of-sales method
    Assets Liabilities and Stockholders' Equity
    Cash . . . . . . . . . . . . . . . . . . . . . . . . . $ 10
    Accounts receivable . . . . . . . . . . . . . 15 Accounts payable . . . . . . . . . . . . . . . $ 15
    Inventory . . . . . . . . . . . . . . . . . . . . . . 50 Accrued expenses . . . . . . . . . . . . . . 5
    Plant and equipment. . . . . . . . . . . . . 75 Other payables . . . . . . . . . . . . . . . . . 40
    Total assets. . . . . . . . . . . . . . . . . . . . $150 Common stock . . . . . . . . . . . . . . . . . 30
    Retained earnings. . . . . . . . . . . . . . . 60
    Total liabilities and
    stockholders' equity. . . . . . . . . . . . $150

    All balance sheet items are expected to maintain the same percent-of-sales relationships as last year, except for common stock and retained earnings. No change is scheduled in the number of common stock shares outstanding, and retained earnings will change as dictated by the profits and dividend policy of the firm. (Remember the net profit margin is 12 percent.)
    a. Will external financing be required for the Prep Shop during the coming year?
    b. What would be the need for external financing if the net profit margin went up to 14 percent and the dividend payout ratio was increased to 70 percent ?
    ---

    © BrainMass Inc. brainmass.com June 3, 2020, 6:44 pm ad1c9bdddf
    https://brainmass.com/business/financial-ratios/cambridge-prep-shops-percent-of-sales-method-73217

    Attachments

    Solution Summary

    The solution calculates the external financing reuired.

    $2.19

    ADVERTISEMENT