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.

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

Excel formulas functions assignment depreciation

EXCEL FORMULAS / FUNCTIONS Assignment Depreciation Schedule Learning Objectives: 1. Creating Range Names 2. Creating variable Comments 3. Using Absolute and Relative References 4. Creating Formulas using following functi ...

Accounting discussion questionaccounts receivables please

Accounting Discussion Question Accounts Receivables" Please respond to the following: • Imagine that you are the treasurer of your organization, and the company is in need of cash; unfortunately, the company is unable to ...

Task - task covers study schedule weeks 5-12 inclusiveq21-

Task - Task covers study schedule weeks 5-12 inclusive. Q2.1- Naming cells in spreadsheets Critically evaluate a YouTube video on naming cells in spreadsheets. What are the advantages of naming cells in formulas Paste an ...

1-1 define marketing and outline the steps in the marketing

1-1. Define marketing and outline the steps in the marketing process. (AACSB: Written and Oral Communication) 1-2. What is marketing myopia, and how can it be avoided? (AACSB: Written and Oral Communication; Reflective T ...

Accounting questionsinternational accounting focuses on

Accounting Questions: International Accounting focuses on foreign currency and hedging. Why might a company prefer a foreign currency option rather than a forward contract in hedging a foreign currency firm commitment? W ...

Moonee ponds 3039max matters is a semi-retired physical

MOONEE PONDS 3039 Max Matters is a semi-retired physical education teacher and is starting a wholesale home gym sales business on the 1st September 2016, he is contributing the following assets and liabilities to commenc ...

Assume that a client has a recurring late cutoff error

Assume that a client has a recurring late cutoff error. Prior- year sales included $10 million of current-year sales, and current- year sales include $12 million of next year sales. a. What is the misstatement under the ...

Explain what is meant by accruals and prepayments andhow

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

Essay objectivethe objective of this case study is to

Essay Objective: The objective of this case study is to understand Australian Conceptual Framework in accounting standard setting and in business practices. Discussions: You should select a company listed on the Australi ...

Locate and read the article listed below and answer the

Locate and read the article listed below and answer the following questions. Brandon, D. M. November 2010. External Auditor Evaluations of Outsourced Internal Auditors. Auditing: A Journal of Practice & Theory 29 (2): 15 ...

  • 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