Lansing Auto Parts, Inc., has projected sales of $25,000 in October, $35,000 in November, and $30,000 in

Question:

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 by cash and 80 percent are sold on credit. The credit sales are collected one month after sale. Determine collections for November and December.

Also assume that the company's cash payments for November and December are $30,400 and $29,800, respectively. The beginning cash 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. (You will need to prepare a cash receipts schedule first.)


Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment.  Its primary purpose is to provide the...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Foundations of Financial Management

ISBN: 978-0077454432

14th edition

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen

Question Posted: