Here are some important figures from the budget of Nashville Nougats, Inc., for

Question

Here are some important figures from the budget of Nashville Nougats, Inc., for the second quarter of 2015: April May June Credit sales $ 316,000 $ 296,000 $ 356,000 Credit purchases 124,000 147,000 172,000 Cash disbursements Wages, taxes, and expenses 43,600 11,100 62,600 Interest 10,600 10,600 10,600 Equipment purchases 76,000 142,000 0 The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2015, credit sales were $186,000 and credit purchases were $126,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) April May June Beginning cash balance $ 119,000 $ $ Cash receipts Cash collections from credit sales Total cash available $ $ $ Cash disbursements Purchases $ $ $ Wages, taxes, and expenses Interest Equipment purchases Total cash disbursements $ $ $ Ending cash balance $ $ $

Explanation / Answer

April May June Beginning cash balance $     119,000 $    78,500 $    85,000 Cash receipts: Cash collections from credit sales $     215,700 $ 294,200 $ 299,200 Total cash available $     334,700 $ 372,700 $ 384,200 Cash disbursements: Purchases $     126,000 $ 124,000 $ 147,000 Wages, taxes, and expenses $   43,600 $    11,100 $    62,600 Interest $   10,600 $    10,600 $    10,600 Equipment purchases $   76,000 $ 142,000 $             -   Total cash disbursements $     256,200 $ 287,700 $ 220,200 Ending cash balance $       78,500 $    85,000 $ 164,000 April May June Credit Sales Mar-65% Apr-65% May-65% Apr-30% May-30% June-30% Credit Purchases Mar Apr May $             120,900 $ 205,400 $ 192,400 $                94,800 $    88,800 $ 106,800 Total Sales receipts $             215,700 $ 294,200 $ 299,200 Total Credit purchase payment $             126,000 $ 124,000 $ 147,000 April May June Credit sales $ 316,000 $ 296,000 $ 356,000 Credit purchases $ 124,000 $ 147,000 $ 172,000 Cash disbursements: Wages, taxes, and expenses $   43,600 $    11,100 $    62,600 Interest $   10,600 $    10,600 $    10,600 Equipment purchases $   76,000 $ 142,000 $             -   March Credit Sales $ 186,000 Credit Purchase $ 126,000

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.