Explore BrainMass

Explore BrainMass

    Forecasting: Additional Funds Needed (AFN)

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

    A firm has the following balance sheet:
    Cash $ 20 Accounts payable $ 20
    Accounts receivable 20 Notes payable 40
    Inventory 20 Long-term debt 80
    Fixed assets 180 Common stock 80
    Retained earnings 20
    Total assets $240 Total liabilities & Equity $240

    Sales for the year just ended were $400, and fixed assets were used at 80 percent of capacity. Current assets and accounts payable vary directly with sales. Sales are expected to grow by 5 percent next year, the expected net profit margin is 5 percent, and the dividend payout ratio is 60 percent.

    How much additional funds (AFN) will be needed next year, if any?

    © BrainMass Inc. brainmass.com June 3, 2020, 8:40 pm ad1c9bdddf
    https://brainmass.com/business/business-management/forecasting-additional-funds-needed-afn-148299

    Attachments

    Solution Preview

    How much additional funds (AFN) will be needed next year, if any?

    Current Forecasted
    Revenue 400.00 420.00
    Net Income 20.00 21.00 (5% of Sales)
    Dividends 12.00 12.60 (60% of Dividends)
    Retained Earnings 8.00 8.40

    Current Forecasted/Proforma
    Assets
    Current Assets 60.00 63.00
    Fixed Assets 180.00 180.00
    Total ...

    Solution Summary

    This solution calculates the retained earnings, external funds required and the new level of debt with step-by-step calculations enclosed in an Excel file. Brief calculations are included for further understanding.

    $2.19

    ADVERTISEMENT