Problem 18-11 Calculating the Cash Budget Here are some important figures from t
ID: 2615799 • Letter: P
Question
Problem 18-11 Calculating the Cash Budget Here are some important figures from the budget of Cornell,Inc, for the second quarter of 2017 Credit sales Credit purchases Cash disbursesents $31e,8e0 $298,8e0 $35e,90 118,000 141,00 166,00 Wages, taxes, and expenses Interest Equipment purchases 43,000 10,50062,00 1e,e6018,e1, e,eee 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 tne 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 201, credit caies were st80.000, nd creait purchases were $120000 using tnis informanion, complete the folowing cash budget (Do not round Intermediate calculetions) April May 111,90 Segineing cash balance Cash recespts Cash colLections fron credit sale otal cash available Cash disbursements ages aesespee Louipeent purchases otal cash disbuesenents ndang cash palanceExplanation / Answer
Answer )
April May June Beg Cash Balance $111,000.00 $78,000.00 $118,000.00 cash receipt cash collection from present sale $93,000.00 $87,000.00 $105,000.00 cah collection from credit sale $117,000.00 $201,500.00 $188,500.00 Total cash available $321,000.00 $366,500.00 $411,500.00 cash disbursement purchase $120,000.00 $118,000.00 $141,000.00 wage,taxes and expanses $43,000.00 $10,500.00 $62,000.00 Interest $10,000.00 $10,000.00 $10,000.00 Equipment purchase $70,000.00 $110,000.00 $0.00 Total cash disbursement $243,000.00 $248,500.00 $213,000.00 Ending cash balance $78,000.00 $118,000.00 $198,500.00