Ask Question
3 February, 13:46

Here are some important figures from the budget of Nashville Nougats, Inc., for the second quarter of 2012: April May June Credit Sales $547,200 $570,240 $630,720 Credit Purchases 211,680 252,720 288,710 Cash Disbursements Wages, other expenses 57,240 69,420 72,430 Interest 16,410 16,410 16,410 Equipment purchases 119,520 131,040 0 The company predicts that 3 percent of its credit sales will never be collected, 36 percent of its sales will be collected in the month of sale, and the remaining 61 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2012, credit sales were $302,400, and credit purchases were $224,640. The April 1 cash balance was $403,200. What is the cash balance at the end of May

+5
Answers (1)
  1. 3 February, 15:21
    0
    Answer: $449,488.4

    Explanation:

    April:

    Beginning cash balance = $403,200

    Cash receipts = 36% * sales in April

    = 0.36 * $547,200

    = $196,992

    Cash collections from credit sales = 61% of sales in March

    = 0.61 * $302,400

    = $184,464

    Total cash available = Cash receipts + Cash collections from credit sales + Beginning cash balance

    = $196,992 + $184,464 + $403,200

    = $784,656

    Total cash disbursements:

    = Purchases + Wages, taxes, and expenses + Interest + Equipment purchases

    = 211,680 + 57,240 + 16,410 + 119,520

    = $404,850

    Ending cash balance = Total cash available - Total cash disbursements

    = $784,656 - $404,850

    = $380,000

    May:

    Beginning cash balance = $380,000

    Cash receipts = 36% * sales in May

    = 0.36 * $570,240

    = $205,286.4

    Cash collections from credit sales = 61% of sales in April

    = 0.61 * $547,200

    = $333,792

    Total cash available = Cash receipts + Cash collections from credit sales + Beginning cash balance

    = $205,286.4 + $333,792 + $380,000

    = $919,078.4

    Total cash disbursements:

    = Purchases + Wages, taxes, and expenses + Interest + Equipment purchases

    = 252,720 + 69,420 + 16,410 + 131,040

    = $469,590

    Ending cash balance = Total cash available - Total cash disbursements

    = $919,078.4 - $469,590

    = $449,488.4

    Therefore, the cash balance at the end of May is $449,488.4
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Here are some important figures from the budget of Nashville Nougats, Inc., for the second quarter of 2012: April May June Credit Sales ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers