Prepating a Cash Budget - Lansing Auto Part Example
Not what you're looking for?
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.
Purchase this Solution
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.
Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.