Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

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 accured operating expenses): $150,000
Working capital: $120,000

(the above breakdown is of the financial statement of june 30 and shows the current working capital)

Jake Marley is negotiating with the bank for a $200,000, 90-day 12% 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 and add to bank balance $28,000

The bank loan officer asks Marley to prepare a forecase of his cash receipts and cash payments for the next 3 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 3 month cash budget: Sales (all on account) for July $300,000, Aug $360,000, Sept $270,000 and Oct $200,000. Past experience indicates that 80% of the receivables generated in any month will be collected in the month following the sale, 19% will be collected in the second month following the sale and 1% 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% of sales. Operating expenses are budgeted at $36,000 per month plus 8% 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 months sales.

INSTRUCTIONS:
A. Prepare a monthly cash budge showing estimated cash receipts and cash payment 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 accounts payable for merchandise purchases.

B. On the basis of this cash forecast, prepare a brief report to Marley describeing whether he will be able to repay the $200,000 bank loan at the end of September.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M925992

Have any Question? 


Related Questions in Basic Finance

After examining given figure explain the potential link

After examining given Figure, explain the potential link between innovations in financial markets and output volatility since the 1980s. You should consider both the "Great Moderation" and the recession of 2007-2009 in y ...

Three months ago you purchased a put option on nole stock

Three months ago, you purchased a put option on Nole stock with a strike price of $60 and an option price of $1.02. The option expires today when the value of Nole stock is $62.79 Ignoring trading costs and taxes, what i ...

How money market rates may respond to prevailing conditions

How Money Market Rates May Respond to Prevailing Conditions : How have money market rates changed since the beginning of the semester? Consider the current economic conditions. Do you think money market rates will increa ...

A small eastern european economy asks your opinion about

A small Eastern European economy asks your opinion about whether they should pursue the path to joining the European Economic and Monetary Union (EMU) or simply "euroize" (i.e., dollarize by using the euro for all domest ...

Explain and discuss the lsquoopportunity cost concept as a

Explain and discuss the ‘opportunity cost' concept as a strategic construct. How does opportunity cost relate to the notion of incremental cash flow for a project? Present an example.

The components of the djia have changed 51 times since its

The components of the DJIA have changed 51 times since its beginning in May 26, 1896. Numerous companies were added and deleted over this time. So other than failure, bankruptcy, or simply being renamed, pick a company t ...

Regarding anovaexplain the difference between the

Regarding ANOVA: Explain the difference between the "Between-Treatments Estimate of Variance and the Within-Treatments Estimate of Variance. Why do we need two estimates? Wouldn't one estimate suffice?

Why did the mexican government establish a controlled

Why did the Mexican government establish a controlled foreign-exchange market, and why did that market differ from the free market?

1 decide whether to accept or reject a special orderviking

1. Decide whether to accept or reject a special order. Viking Corporation is operating at 80% if capacity; which means it produces 8,000. Variable cost is $100 per unit. Wholesaler Y offers to buy 2,000 additional units ...

What is a supply shockwhat is the appropriate policy

What is a supply shock? What is the appropriate policy response to a negative supply shock? What determines whether policy makers should act or do nothing in the face of adverse shocks to either aggregate demand or aggre ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate