Question: Make a complete cash budget for Archer Electronics... I was just wondering if I could get a question looked over from my Finance Homework to
Make a complete cash budget for Archer Electronics...
I was just wondering if I could get a question looked over from my Finance Homework to see what I did wrong. I completed it but it does not look right. I also need help finding Cumulative Marketable Securities and Marketable Securities sold.
Archer Electronics Company's actual sales and purchases for April and May are shown here along with forcasted sales and purchases for June through September.
| Sales | Purchases | |
| April(actual) | $370,000 | $155,000 |
| May(actual) | 350,000 | 145,000 |
| June(forcast) | 325,000 | 145,000 |
| July(forcast) | 325,000 | 205,000 |
| August(forcast) | 340,000 | 225,000 |
| September(forcast) | 380,000 | 220,000 |
The company makes 20 percent of its sales on cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale and 50 percent are collected two months later. Archer pays 20 percent of its purchases in the month after purchase and 80 percent two months after.
Labor expense is 15 percent of the current months sales. Overhead expense is $12,500 per month. Interest payments of $32,500 are paid in June and September. A cash dividend of $52,550 is scheduled to be paid in June. Tax payments of $25,500 are dune in June and September. There is a scheduled capital outlay of $350,000 in September.
Archer Electronics ending cash balance in May is $22,500. The minimum desired cash balance is $10,500. Prepare a schedule of monthly cash recipts, monthly cash payments, and a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable Securities are sold before borrowing funds in case of a cash shortfall (less than $10,500).
This is what I came up with for the answers the first parts look right to me but the cash budget part is where I need help.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
