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

1 compare the advantages and disadvantages of using

1. Compare the advantages and disadvantages of using interviews versus questionnaires in survey research. 2. Compare a sample and a population. Under what circumstances can a sample be used to draw conclusions about a po ...

A national survey of 40000 adults in the us in 1992 found

A national survey of 40,000 adults in the US in 1992 found that 26% of adults were current smokers. A similar survey of 37,000 adults in the US in 1966 found that 43% of adults were current smokers. Construct a 95% confi ...

Als sport store has sales of 2720 costs of goods sold of

Al's Sport Store has sales of $2,720, costs of goods sold of $2,080, inventory of $516, and accounts receivable of $426. How many days, on average, does it take the firm to sell its inventory assuming that all sales are ...

Go to wwwbloombergcomnewseconomy and locate an article

Go to www.bloomberg.com/news/economy/ and locate an article related to a recent Federal Reserve action. Write a brief summary of the article, and explain what impact it is likely to have on the economy and you as an indi ...

1 what is a mortgage pay-through bond mptb how does it

1. What is a mortgage pay-through bond (MPTB)? How does it resemble a mortgage-backed bond (MBB)? How does it differ? 2. Are the overcollateralization requirements for mortgage pay-through bonds the same as for mortgage- ...

Briefly describe each of the following developments in

Briefly describe each of the following developments in accounts payable and disbursements. a. Integrated accounts payable b. Purchasing/procurement cards c. Imaging services d. Fraud prevention in disbursements.

Nbspa shoe company checks police records on 1200 randomly

A shoe company checks police records on 1200 randomly selected auto accidents and notes that teenagers were at the wheel in 180 of them. Construct a 90% confidence interval estimate of the proportion of shoe accidents th ...

1 what general rule can be developed concerning maximum

1. What general rule can be developed concerning maximum values and compounding intervals within a year? 2. What does the time value of money (TVM) mean? 3. How does discounting, as used in determining present value, rel ...

Project finance is difficult to define what are its

Project finance is difficult to define. What are its essential features? When deciding whether or not to back a project finance proposition, what essential features do potential lenders home in on?

Ritz furniture has a contribution margin ratio of 011 if

Ritz furniture has a contribution margin ratio of 0.11. If fixed cost are $172,800 how man dollars of revenue must the company generate in order to reach the break-even point?

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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