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 schedule of exposed cash collections for April, May, and June for three months in total.

Accounting Basics, Accounting

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

Have any Question? 

Related Questions in Accounting Basics

Accounting information individual assignment- myob

Accounting Information Individual Assignment- MYOB Assignment 1. MYOB Assignment  uses the Case and the  Data of the  Wendy Pabst & Brian Perrin (2011), Accounting With MYOB 19, 1st Edition, Cengage Learning, Australia. ...

Assignment detailsas at the 1stmay katy perry establishes a

Assignment Details: As at the 1stMay, Katy Perry establishes a new business Katie's Bridal Services as a sole trader. The business will hire out bridal gowns and other accessories as well as provide professional services ...

As an auditor for the cpa firm of hinkson and calvert you

As an auditor for the CPA firm of Hinkson and Calvert, you encounter the following situations in auditing different clients. 1. LR Corporation is a closely held corporation whose stock is not publicly traded. On December ...

Classifying costs as materials labor or factory overhead

Classifying costs as materials, labor, or factory overhead Indicate whether each of the following costs of an automobile manufacturer would be classified as direct materials cost, direct labor cost, or factory overhead c ...

How would the auditors opinion differ if the financial

How would the auditor's opinion differ if the financial statements of a company that was a foreign private issuer were prepared in conformity with IFRS and filed with the SEC rather than prepared in conformity with U.S. ...

Question part one what are the differences between a direct

QUESTION PART ONE: What are the differences between a direct cost and an indirect cost? Which is the more difficult cost to track? Why? How do indirect costs affect the cost of a product? Should indirect costs be include ...

When measuring an impairment loss for a long-term operating

When measuring an impairment loss for a long-term operating asset, must firms determine the fair market value using a discounted cash flow model? Explain.

Explain the purpose of the cost of sales adjustment in the

Explain the purpose of the cost of sales adjustment in the profit and loss account. Include a worked example in your explanation.

Assignment case studyreqiredassume you are employed as a

Assignment Case Study Reqired Assume you are employed as a graduate tax accountant and have been asked to detail to your manager, the Australian income tax implications of the following facts relating to Mrs Gilling, who ...

Question list the penalties imposed on the employer for the

Question: List the penalties imposed on the employer for the following: a. Filing Form 941 late. b. Seven days late making a deposit. c. Issuing a bad check to the IRS.

  • 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