On the basis of the cash forecast write a brief report

Reference no: EM13482539

A company is negotiating with the bank for a $200,000/ 90 day/12% loan effective July 1 of the current year. If the bankgrants the loan, the proceeds will be $194,000 which the companyintends to use on July 1 as follows: pay accounts payable$150,000; purchase equipment $160,000; add to bank balance$28,000.

the current working capital position, according to financialstatements as of June 30 as follows:

cash inbank.......................................................................$20,000
receivables(net of allowance for doubtfullaccounts............ 160,000
merchandiseinvnetory....................................................... 90,000
total currentassets............................................................$270,000
accounts payable(includes accrued operatingexpense)...... 150,000
workingcapital.................................................................$120,000

These estimates have been made, which are to be used in a 3month cash budget:

sales(all accounts) for July $300,000, August $360,000 Sept$270,000 Oct $200,000

Past experience shows that 80% of the receivables, in anymonth will be collected in the month following the sale. 19%will be collected in the second month following the sale and the 1%will prove uncollectible. They expect to collect $120,00 ofthe June30 receivables in July and the remaining $40,000 inAugust.

Cost of goods sold has averaged about 65% of sales. Operating expenses are budgeted at $36,000 per month plus 8% ofsales. With the exception of $4,400 per monthdepreciation expense, all operating expenses and purchases are inaccount and paid in the month following their occurance.

On the basis of the cash forecast, write a brief report explaining whether the compnay will be able to repay the $200,000 bank loan at the end of September.

Reference no: EM13482539

Questions Cloud

Kobyashi moru reports its inventory fixed assets : kobyashi moru reports its inventory fixed assets depreciation and cost of goods sold on a current value basis fair

If the firm desires to net 450 per unit in profit over : taurus tools has developed a new kitchenutensil. the firm has conducted significant market research and estimated the

Detmer holdings ag of zurich switzerland has just : detmer holdings ag of zurich switzerland has just introduced a new fashion watch for which the company is trying to

Incur 429000 of costs for 36-month zip contract paying 70 : 1. pay 238000 to lessor co. as 1st annual payment on the signing of a 3-year noncancelable computer lease to begin 111.

On the basis of the cash forecast write a brief report : a company is negotiating with the bank for a 200000 90 day12 loan effective july 1 of the current year. if the

On august 31 kravsnik company receives its bank statement : on august 31 kravsnik company receives its bank statement. the company deposits its receipts in the bank and makes all

Rand medical manufactures lithotripters lithotripsy uses : rand medical manufactures lithotripters. lithotripsy uses shock waves instead of surgery to eliminate kidney stones.

How can sales clerks employed at rare earth clothing use : rare earth clothing is a retail store specializing in womensclothing. the store has established a liberal return policy

On the basis of the following data for nader co for 2008 : on the basis of the following data for nader co. for 2008 and the preceding year ended december 31 2008 prepare a

User Account

All Pages