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

Accounting assignmentaccounting is the study of how

Accounting Assignment Accounting is the study of how businesses track their income and assets over time. Accountants engage in a wide variety of activities in addition to preparing financial statements and recording busi ...

Problem 1emma and laine form the equal el partnership emma

PROBLEM #1 Emma and Laine form the equal EL Partnership. Emma contributes cash of $100,000. Laine contributes property with an adjusted basis of $40,000 and a fair market value of $100,000. A. How much gain. If any, must ...

Bubbles hot tubsbubbles hot tubs are a business that

Bubbles Hot Tubs Bubbles Hot Tubs are a business that manufactures and sells hot tubs to the UK market. At present the business manufactures three different types of hot tubs: The selling prices for each of the hot tubs ...

Individual internal accountants report to managementyou are

Individual Internal Accountants Report to Management You are the internal accountant at a company that is preparing for an upcoming government contract bid. The management in your company is deciding if it is necessary f ...

Assignment - you are an investment analystas the cfo of

Assignment - You Are an Investment Analyst As the CFO of your corporation, you are in charge of preparing and analyzing financial statements that will be presented to potential investors and creditors. However, before yo ...

In the wake of the accounting and finance scandals of the

In the wake of the accounting and finance scandals of the early 2000s, the regulatory environment for businesses changed dramatically to create more accountability and transparency. Agencies like the Securities and Excha ...

On january 1 2011 ajax corporation signed a 1000000 7

On January 1, 2011, Ajax Corporation signed a $1,000,000, 7%, 10-year mortgage note to buy a new warehouse. The note will be repaid in 10 equal annual installments of $142,378. The first payment was made on December 31, ...

This is a group work and i entitle do the cash flow

This is a group work and I entitle do the cash flow analysis for Home Depot. Please no more than two pages. Assume that your Group has been hired to serve as my new Investment Advisory Team. I am looking for new investme ...

Business assignmentthe comany i have choosen is upsresearch

Business Assignment The comany i have choosen is UPS. Research a company that interests you from the Fortune 500. (A list will be provided). Analyze what they do. What business are they in? What industry? How have they b ...

Consider the following scenarioandre has asked you to

Consider the following scenario: Andre has asked you to evaluate his business, Andre's Hair Styling. Andre has five barbers working for him. (Andre is not one of them.) Each barber is paid $9.90 per hour and works a 40-h ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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