Jake marley owner of marley wholesale is negotiating with

Reference no: EM13579551

Jake Marley, owner of Marley wholesale, is negotiating with the bank for a $200,000, 90 %u2013day, 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) 60,000
Merchandise inventory 190,000
Total current assets $270,000
Accounts payable (including accrued operating expenses 150,000
Working capital $120,000

The bank loan officer ask Marley to prepare a forecast of his 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 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 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%u2019s sales.

Instructions; 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. Supporting schedules should be prepared for estimated collections on receivables, estimated merchandise purchases, and estimated payments for operating expenses and of accounts payable for merchandise purchases.
b. On the basis of this cash forecast, write a brief report to Marley explaining whether he will be able to repay the $200,000 bank loan at the end of September.

Reference no: EM13579551

Questions Cloud

Common stock 12 par value 500 shares authorized 200 shares : which answer would represent the financial statement presentation of stockholders equity after the following

A factorys worker productivity is normally distributed one : q1. the signs on an elevator states maximum capacity 1140 kilogram or 16 persons. if the mean weight is 75 kilos and

When a company purchases land with a building on it and : 1. on-call services corporation bought a building lot to construct a new corporate office building. an older home on

Test the claim that the standard deviation of the hardness : when 12 bolts are tested for hardness their indexes have a standard deviation of 41.7. test the claim that the

Jake marley owner of marley wholesale is negotiating with : jake marley owner of marley wholesale is negotiating with the bank for a 200000 90 u2013day 12 percent loan effective

Construct a two sided confidence interval on the mean : here is the data.131.15 135.69 130.91 124.54 129.64 128.77130.72 128.33 128.24 129.65 130.14 129.29128.71 129.00 129.39

Chudrick inc makes unfinished bookcases that it sells for : chudrick inc. makes unfinished bookcases that it sells for 58.58. production costs are 37.81 variable and 9.56 fixed.

A company ran a regression analysis using direct labor : a company ran a regression analysis using direct labor hours as the independent variable and manufacturing overhead

The purchasing agent of an organization acquired some raw : the purchasing agent of an organization acquired some raw materials at a bargain price even though she knew that their

User Account

All Pages