Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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.

If company requires a minimum cash balance of $20,000 to start each month, can loan be repaid as planned? describe.

Accounting Basics, Accounting

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

Have any Question? 


Related Questions in Accounting Basics

Explain what is meant by accruals and prepayments andhow

Explain what is meant by accruals and prepayments, and How they affect the trial balance.

Nbsptask 1 - planning for profit and cost controlobjective

TASK 1 - Planning for profit and cost control Objective - To enable the learner to prepare the budgeted profit statement and undertake cost-volume-profit analysis for decision making Anhad Sdn. Bhd. manufactures car alar ...

Salem company started its operations on january 1 2016 the

Salem Company started its operations on January 1, 2016. The following transactions took place during the first month of operations: Jan 1: Saleminvests $480,000 cash to start the business. Jan 5: Purchased furniture for ...

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 ...

Enter the given transactions in the bank account in ajays

Enter the given transactions in the bank account in Ajay's ledger 1 The owner started her business with a capital contribution of N$25 000 which she deposited in the business' bank account 3. Purchased stationary, N$140 ...

Assume the a corporation has the following balances before

Assume the a corporation has the following balances before the stock issuance indicated below. Stockholders Equity Before Transaction Common stock, 30,000 shares authorized, 2,200 shares issued, 1,980shares outstanding, ...

Case study -you are auditing the financial report of best

Case Study - You are auditing the financial report of Best Living Supplies Ltd (Best Living Supplies) for the year ended 30 June 2016. Best Living Supplies sells a wide variety of household products to retail outlets. Al ...

Problem - journalizing transactions the chart of account

Problem - Journalizing Transactions The chart of account for Jerome Gelacio Pest Control is as follows: Assets Income 110 Cash 410 Landscaping Revenues Expenses 120 Accounts Receivable 510 Salaries Expense 130 Prepaid In ...

Problem 1a two four-year-old companies are identical in all

Problem 1: a. Two four-year-old companies are identical in all respects except that Company A has used straight-line depreciation exclusively since inception while Company B has used double-declining balance depreciation ...

Assignment - small business analysis and

Assignment - Small Business Analysis and Interpretation Small Business Analysis 1: The following financial statements were prepared for the management of TEDA Ltd. The statements contain some information that will be dis ...

  • 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