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 suppose that apples profits are expected to grow twice as

1. Suppose that Apple's profits are expected to grow twice as fast as Microsoft's. Which firm's stock should be the better investment? Briefly explain. 2. Henry Blodget worked for Merrill Lynch during the dot-com boom. T ...

1 contact your state national guard office find out what

1. Contact your state National Guard office. Find out what kinds of resources they can offer to assist local communities in the event of a disaster and what kind of training and exercises they conduct to prepare their me ...

All of us have a tendency to categorize people into

All of us have a tendency to categorize people into stereotypic groups. If you look around at the students on campus, you will see science geeks, artsy freaks, jocks, wallflowers, cheerleaders, and party animals, just to ...

A company has two divisions of equal size a computer

A company has two divisions of equal size: a computer manufacturing division and a data processing division. Its CFO believes that stand-alone data processor companies typically have a WACC of 8%, while stand-alone compu ...

1 what is the risk insured by private mortgage insurance2

1. What is the risk insured by private mortgage insurance? 2. What are the principal features of an affordable housing loan qualification, and how are they different from those of recent temporary "Making Homes Affordabl ...

The portfolio manager at rbc direct investment is

The portfolio manager at RBC Direct Investment is requesting your assistance to analyze and recommend a stock for their high value clients. These high value clients would only consider "Green Finance" companies. Green fi ...

A company tests all new brands of golf balls to ensure that

A company tests all new brands of golf balls to ensure that they meet certain specifications. One test conducted is intended to measure the average distance traveled when the ball is hit by a machine. Suppose the company ...

Obtain financial statements for microsoft for the last five

Obtain financial statements for Microsoft for the last five years either from its Web site (http://www.microsoft.com) or from the SEC's online EDGAR site (http://www.sec.gov/edgar/searchedgar/webusers.htm). First, look a ...

Make up an example of deduction or deductive reasoningin

Make up an example of deduction or deductive reasoning. In deductive reasoning, if the premises or initial observations are true, does this guarantee that the conclusion is true? Explain why or why not.

Suppose that the dow jones industrial average is above the

Suppose that the Dow Jones Industrial Average is above the 10,000 level. If the Dow were to fall to 6,000, who would gain the most: investors who had bought call options, investors who had sold call options, investors wh ...

  • 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