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

There are 5 parts to this assignment -part a financial

There are 5 parts to this assignment - Part A: Financial analysis of a publicly-held company. Use Ford's latest consolidated and segment financial statements (form 10K) as filed with the SEC.  1. Calculate the current ra ...

Assignemnt investment and pension trust funds1 describe

Assignemnt: Investment and Pension Trust Funds 1. Describe GASB requirements for accounting for Investment Trust Funds, (a) a discussion of when the use of investment trust funds is appropriate. (b) the investments to be ...

Budgetsmith manufacturing inc has asked for your assistance

Budget Smith Manufacturing, Inc. has asked for your assistance in preparing a budget for next year's operations. Take a few moments to consider where you would begin the budgeting process.What types of information do you ...

Create a 10-15-slide powerpoint presentation demonstrating

Create a 10-15-slide PowerPoint presentation demonstrating a thorough understanding of the firm you have been evaluating through the class. Be sure to include speaker notes at the bottom of each slide that provide more d ...

Borachera is a major spanish wine wholesaler currently

Borachera is a major Spanish wine wholesaler currently operating two CDCs in Salamanca and Albacete, and a number of RDCs all over the Iberian peninsula. In order to reduce its overall logistics cost, the company wishes ...

Able company is selling a bond for 867 the bond is with a

Able Company is selling a bond for $867. The bond is with a 20% coupon rate annually, and will mature in 10 years. The company's shareholders are receiving a 22.5% return. The company is subject to a 25% tax rate. The co ...

Pretty lady cosmetic product has an average production

Pretty Lady Cosmetic Product has an average production process time of forty days. Finished goods are kept on hand for an average of fifteen days before they are sold. Accounts receivable are outstanding an average of th ...

Suppose chapman corporation is planning to pay a 2 per

Suppose Chapman Corporation is planning to pay a $2 per share dividend to its common stockholders. If the common stock price after the ex-dividend date is $50, what was the stock price before the ex-dividend date? $50 $5 ...

An investor can make an investment in a real estate

An investor can make an investment in a real estate development and receive an expected cash return of $45,000 at the end of six years. Based on a careful study of other investment alternatives, she believes that a 9 per ...

Comment on the current credit risk assumed for each of the

Comment on the current credit risk assumed for each of the following positions. Treat them separately; that is, not combined with any other instruments. a. You are short an out-of-the-money interest rate call option. b. ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen