Explore BrainMass

Explore BrainMass

    how to prepare a cash budget

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 December 24, 2021, 4:43 pm ad1c9bdddf


    Solution Summary

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