Mini-Case 13-3: Rent-A-Nerd Computer Consultants

Mini-Case 13-3: Rent-A-Nerd Computer Consultants
The owners of Rent-A-Nerd Computer Consultants have prepared the partial cash budget for the upcoming quarter:
CASH BUDGET - RENT-A-NERD COMPUTER CONSULTANTS
Month 1 Month 2 Month 3
Cash Receipts
Total Sales $42,650 $45,500 $47,000
Credit Sales 25,590 27,300 28,200
Collections
10 percent same month 2,559 2,730 2,820
80 percent next month 19,941 20,472 21,840
8 percent following month 1,864 1,994 2,048
Cash Sales $17,060 $18,200 $18,800
Total Cash Receipts ________ ________ ________
Cash Disbursements
Purchases $32,404 $33,267 $35,490
Wages/Salaries 4,212 4,897 5,126
Rent/Utilities 1,865 1,910 2,250
Other 2,400 3,750 6,105
Total Cash Disbursements ________ ________ ________
End of Month Balance
Beginning Cash $4,750 ________ ________
Cash Receipts ________ ________ ________
Cash Disbursement ________ ________ ________
EOM Balance ________ ________ ________
Borrow ________ ________ ________
Repay ________ ________ ________
Calculate the final end-of-month balance for months 1-3 and answer the following questions.
-Total cash receipts for months 1, 2, and 3, respectively are ________.

A) $42,650, $45,400, and $47,000
B) $25,590, $27,300, and $28,200
C) $68,240, $72,800, and $75,200
D) $41,424, $43,396, and $45,508