Question
The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is available: Projected cash sales: $10,000 each month Projected credit
The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is available:
Projected cash sales: $10,000 each month
Projected credit sales: $ 8,000 each month
One half of the credit sales are collected in the month of sale, and the remainder collected in the following month (there are no uncollectible accounts).
Accounts receivable on April 1st were $3,000.
Operating expenses (paid in cash): $20,000 for April, and $13,000 for each of the following two months.
Cash balance-4/1: $7,000
The company must maintain a minimum cash balance at the end of each month of $5,000.
Any deficiency must be borrowed, and repaid (with no interest) the following month.
Complete the following cash budget for Fortunate (22 points).
| April | May | June |
Beg. Balance
|
|
|
|
Cash Sales
|
|
|
|
Credit Sales
|
|
|
|
Cash Expenses
|
|
|
|
Balance before borrowing |
|
|
|
Borrow/Repay
|
|
|
|
End. Balance
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started