Reference no: EM133000644
Question - Jake Marley, owner of Marley Wholesale, is negotiating with the bank for a $200,000, 90-day, 12 percent loan effective July 1 of the current year. If the bank grants the loan, the proceeds will be $194,000, which Marley intends to use on July 1 as follows: pay accounts payable, $150,000; purchase equipment, $16,000; add to bank balance, $28,000.
The current working capital position of Marley Wholesale, according to financial statements as of June 30, is as follows.
Cash in bank $20,000 Receivables (net of allowance for doubtful accounts) 160,000 Merchandise inventory 90,000 Total current assets $270,000 Accounts payable (including accrued operating expenses) 150,000 Working capital $120,000
The bank loan officer asks Marley to develop a forecast of his cash receipts and cash payments for the next three months to demonstrate that the loan can be repaid at the end of September.
Marley has made the following estimates, which are to be used in preparing a three-month cash budget: Sales (all on account) for July, $300,000; August, $360,000; September, $270,000; and October, $200,000. Past experience indicates that 80 percent of the receivables generated in any month will be collected in the month following the sale, 19 percent will be collected in the second month following the sale, and 1 percent will prove uncollectible. Marley expects to collect $120,000 of the June 30 receivables in July and the remaining $40,000 in August.
Cost of goods sold consistently has averaged about 65 percent of sales. Operating expenses are budgeted at $36,000 per month plus 8 percent of sales. With the exception of $4,400 per month depreciation expense, all operating expenses and purchases are on account and are paid in the month following their incurrence.
Merchandise inventory at the end of each month should be sufficient to cover the following month's sales.
Required - Prepare a monthly cash budget showing estimated cash receipts and cash payments for July, August, and September, and the cash balance at the end of each month.
|
What is the after-tax cost of the interest expense
: Javier and Anita file a joint return, have great eyesight, and are under 60 years of age, what is the after-tax cost of their 2021 interest expense?
|
|
SEHS4626 Air Conditioning for Indoor Thermal and Environment
: SEHS4626 Air Conditioning for Indoor Thermal and Environmental Quality Assignment Help and Solution, The Hong Kong Polytechnic University - Assessment Writing
|
|
What is the net value for the three-year project
: What is the net value for the following three-year project? The initial cost is $350,000 to retrofit the facilities, and the benefit of builds value at $15,000
|
|
Why did tesla stock price increase on monday april
: Why did Tesla's stock price increase on Monday April 5, 2021? Tesla's stock price was up about 5% in Monday's trading after announcing the previous week.
|
|
Prepare a monthly cash budget
: Prepare a monthly cash budget showing estimated cash receipts and cash payments for July, August, and September, and the cash balance at the end of each month
|
|
What are total budgeted receipts for may from credit sales
: Customers paying in the month after the sale are allowed a 10% discount. What are the total budgeted receipts for May from credit sales?
|
|
What are the budgeted sales receipts from customers
: What are the budgeted sales receipts from customers for next month? The accounts receivables at the beginning of the month is P100,000.
|
|
Discuss the auditor responsibilities for subsequent events
: Discuss the auditor's responsibilities for subsequent events of the contract for the year ended 31 December 2019
|
|
Determining the selling price for products
: Which type of pricing (cost-plus or target costing) that you feel would be more accurate in determining the selling price for products as it relates
|