Explore BrainMass

Explore BrainMass

    how to prepare a cash budget

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

    Please see attached spreadsheet for information.

    The company predicts that 4 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 56 percent will be collected in the following month. Credit purchases will be paid for in the month following the purchase. In September credit sales were $7,500,000 and credit purchases were $3,500,000. The ending cash balance for September was $12,000,000. Using this information, complete a cash budget for Acme for the three months above, with the ending cash balance for each month clearly shown.

    © BrainMass Inc. brainmass.com June 3, 2020, 4:47 pm ad1c9bdddf
    https://brainmass.com/business/cash-budgeting/prepare-cash-budget-3918

    Attachments

    Solution Summary

    This solution is comprised of a simple explanation of how to prepare a cash budget.

    $2.19

    ADVERTISEMENT