Ask Question, Ask an Expert


Ask Accounting Basics Expert

Q1) Jodi Horton, president of retailer Crestline Products, has just approached company's bank with request for a $30,000. 90-day loan. Purpose of loan is to help company in acquiring inventories in support of peak April sales. As company has had some difficulty in paying off its loans in past, loan officer has asked for cash budget to assist find out whether loan must be made. Following data are available for months April-June, during which the loan will be used:

a. On April 1, start of loan period, cash balance will be $26,000. Accounts receivable on April 1 will total $151,000, of which $141,000 will be gathered during April and $7,200 will be accumulated during May. Remainder will be uncollectible.

b. Past experience illustrates that 20% of month's sales are accumulated in the month of sale, 75% in month following sale, and 4% in second month following sale. Other 1% represents bad debts which are never collected. Budgeted sales and expenses for three-month period follow:

April May June
Sales (all on account) $200,000 $300,000 $250,000
Merchandise purchases $120,000 $180,000 $150,000
Payroll $9,000 $9,000 $8,000
Lease payments $15,000 $15,000 $15,000
Advertising $70,000 $80,000 $60,000
Equipment purchases $8,000 - -
Depriciation $10,000 $10,000 $10,000

c. Merchandise buys are paid in full during month following purchase. Accounts payable for merchandise purchase on March 31, that will be paid during April, total $18,000.

d. In preparing cash budget, suppose that $30,000 loan will be made in April and repaid in June. Interest on  loan will total $1,200.

Create a cash budget, by month and in total, for three-month period.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M918747

Have any Question? 

Related Questions in Accounting Basics

Barriers to critical thinkinginstructions1 refer to kirby

Barriers to Critical Thinking Instructions: 1. Refer to Kirby and Goodpaster (2007), Thinking: An interdisciplinary approach to critical and creative thought, Ch. 2. 2. There are multiple categories of internal barriers ...

Practice questionsexplain the main items you would expect

Practice questions: Explain the main items you would expect to find on the profit and loss account of a limited company which are not present on the profit and loss account of a sale trader.

Determining adjusting entries and tracingtheir effects to

Determining Adjusting Entries and Tracing Their Effects to Financial Statements Tim Angel opened a small travel agency. At the end of its second year of operation, Angel Travel, Inc., had the trial balance shown below. A ...

Fraud triangle and red flagsread the following case study

Fraud Triangle and Red Flags Read the following case study and respond according to the instructions at the end: Plutonium was an Internet start-up company founded in 1988 at the beginning of the technology boom. One of ...

Accounting standardsguidelines for literature

Accounting Standards Guidelines for Literature Critiques Students must submit a critique of the following academic articledeemed to be seminal to their main area of research. Details about the format, structure and asses ...

Accounting theory assignment-international convergence of

Accounting Theory Assignment- International convergence of accounting standards is a major priority of both the International Accounting Standards Board (IASB) and the Australian Accounting Standards Board (AASB). The IA ...

Bull the president of a plastics company was quoted in a

• The president of a plastics company was quoted in a business journal as stating, "We haven't had a dollar of interest-paying debt in over 10 years. Not many companies can say that." As a stockholder in this company, ho ...

Practice questionsindicate which of the following costs

Practice questions: Indicate which of the following costs that are incurred in a manufacturing company are production costs, selling and distribution costs or administration costs: • Motor vehicles' licences • Depreciati ...

Accounting questionsin the last module we discussed the

Accounting Questions: In the last module we discussed the reactive approach that can (and has been) taken by corporations to identify current fraudulent activities. The issue with this approach is that by the time corpor ...

1 match the following definitions to the appropriate

1. Match the following definitions to the appropriate terms. Potential Matches: 1 : Due professional care 2 : Sufficient understanding of internal control 3 : Adequacy of informative disclosures Answer : Standards of fie ...

  • 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