# Prepating a Cash Budget - Lansing Auto Part Example

Lansing Auto Parts, Inc. has projected sales of \$25,000 in October, \$35, 000 in November, and \$30,000 in December. Of the company's sales, 20 percent are paid for in cash, and 80 percent are sold on credit. The credit sales are collected one month after the sale. Determine collections for November and December. Also assume that the company's cash payment for November and December are \$30,400 and \$29,800 respectively. The beginning balance in November is \$6,000, which is the desired minimum balance. Prepare a cash budget with borrowing needed or repayments for November and December.

Find attached, a formatted MS Excel spreadsheet containing an illustrative example on the creation of a cash budget schedule.

Solution Summary

Lansing Auto Parts, Inc. has projected sales of \$25,000 in October, \$35, 000 in November, and \$30,000 in December. Of the company's sales, 20 percent are paid for in cash, and 80 percent are sold on credit. The credit sales are collected one month after the sale. Determine collections for November and December. Also assume that the company's cash payment for November and December are \$30,400 and \$29,800 respectively. The beginning balance in November is \$6,000, which is the desired minimum balance. Prepare a cash budget with borrowing needed or repayments for November and December.

\$2.19
###### This answer includes:
• Plain text
• Cited sources when necessary
• Attached file(s)
• Lansing Auto Parts.xlsx
Add to Cart   \$2.19

Dwayne Felder, MA

Rating 4.9/5

Active since 2007

AA, City University of New York
BA, University of Phoenix
MA, University of Phoenix

Responses 527

Comments on Dwayne's work:

"Thank you!!!"

"Thank you so much"

"Thanks for the assist! It really helped."

"thank you for your continued assistance with the problems. It is usually one part of the problem that gets me stuck and after seeing what you come up with, I can usually finish out the rest. thank you"

"thank u"