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

Discussion questions- intermediate accounting 22please

Discussion Questions- Intermediate Accounting 22 Please answer each of the 4 question compounds in at least 200 words., for an 800 word total paper. Please asnwer them individually. Thank you 1. What is a change in accou ...

What is represented by the labeled lines connecting

What is represented by the labeled lines connecting entities in an REA diagram? Why are journals and ledgers not modeled in an REA diagram?

Assignment - journals ledger and trial balancethe following

Assignment - Journals, Ledger and Trial Balance The following transactions relates to Merlin Bruce, a sole trader, during his first month of business: Date Transaction details 01-Jan Started business by investing $25,000 ...

1 proceeds from an issue of debt securities having stock

1) Proceeds from an issue of debt securities having stock warrants should NOT be allocated between debt and equity features when A. the allocation would result in a discount on the debt security B. the warrants issued wi ...

Actg5210p assignment-sofias furniture sf makes residential

ACTG5210P Assignment- Sofia's Furniture ("SF") makes residential wet bar equipment from real wood and sells them through three sales outlets. The product line consists of two styles of bar stools, three styles of bar cou ...

1 many programming languages allow you to use to force an

1. Many programming languages allow you to use ____ to force an expression to evaluate first. A) a pound sign B) an asterisk C) parentheses D) quotation marks 2. At the beginning of any method, it is the programmer s res ...

A lorge corporation has collected the following information

A Lorge Corporation has collected the following information after its first year of sales. Sales... Description A Lorge Corporation has collected the following information after its first year of sales. Sales were $1,500 ...

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

Accounting theory and current issuesbio-sustainable feeds

Accounting Theory and current issues Bio-sustainable Feeds (BSF) Ltd., an Australian bio-research firm listed on the Australian Stock Exchange (ASX), has engaged research on sustainable aqua-culture feeds for two decades ...

Practice questionscompare and contrast marginal costing and

Practice questions: Compare and contrast marginal costing and throughput accounting.

  • 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