Jodi horton president of the retailer crestline products

Assignment Help Accounting Basics
Reference no: EM13390784

Jodi Horton, president of the retailer Crestline Products, has just approached the company's bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories in support of peak April sales. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April-June, during which the loan will be used:

a. On April 1, the start of the loan period, the cash balance will be $26,000. Accounts receivable on April 1 will total $151,500, of which $141,000 will be collected during April and $7,200 will be collected during May. The remainder will be uncollectible.

b. Past experience shows that 20% of a month's sales are collected in the month of sale, 75% in the month following sale, and 4% in the second month following sale. The other 1% represents bad debts that are never collected. Budgeted sales and expenses for the 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

0 Lease payments $ 15,000 $ 15,000 $ 15,000

Advertising $ 70,000 $ 80,000 $ 60,000

Equipment purchases $ 8,000 ? ?

Depreciation $ 10,000 $ 10,000 $ 10,000
c.

Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases on March 31, which will be paid during April, total $108,000.
d.

In preparing the cash budget, assume that the $30,000 loan will be made in April and repaid in June. Interest on the loan will total $1,200.
Required:

1. Prepare a schedule of expected cash collections for April, May, and June and for the three months in total. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "tiny_mce_markerquot; sign in your response)

2.Prepare a cash budget, by month and in total, for the three-month period. (Input all amounts as positive values except cash deficiency, repayments and interest which should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "tiny_mce_markerquot; sign in your response.)

3. If the company needs a minimum cash balance of $20,000 to start each month , can the loan be repaid as planned? Explain

Reference no: EM13390784

Questions Cloud

What occurs if during one hour syldavia aluminum company : the rules of the syldavian electricity market stipulate that all participants must trade energy exclusively through the
Write down some approaches taken by leadership in planning : write down some approaches taken by leadership in planning developing and implementing the quality process? what type
Write down some implications or consequences of not : in a global market source venders - or stakeholders - may or may not have quality control enforcement that meets the
Under what market structure would you categorize airline : jet blue corporation continuously offers fare discounts to attract customers awareness about the company increase
Jodi horton president of the retailer crestline products : jodi horton president of the retailer crestline products has just approached the companys bank with a request for a
If you invest 100 a year for 20 years at 7 annual interest : 1. why do we say money has time value?2. why is it important for business managers to be familiar with time value of
In the manufacturing industry who are the different : in the manufacturing industry who are the various stakeholders in implementing a quality process? how is each
Why do points on the utility possibility curve represent : why do points on a utility possibility curve represent efficient allocations of resources? why must the utility
Expalin in brief the histories of both of amazoncom and : write a six to eight 6-8 page paper in which youdescribe in brief the histories of both of amazon.com and yahoo.com and

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  What is the amount of citradoria corporation allowable

What is the amount of Citradoria Corporation's allowable deduction for charitable contributions for the current year?

  Audit of the client and the amount of stock

John Brown is a PA, but not a partner, with three years of professional experience with lyle and lyle, public accountants, a one-office public accountanting firm. he owns 25 shares of stock in an audit client of the firm,but he does not take part ..

  Sommer production budget

Each unit requires 4 poundsof material that costs $6 each. Sommer's production budget should be:

  Audit-cobit methodology

How does an audit performed using CobiT methodology differ from an audit that doesn't?

  Ending inventory using the gross profit method

If it began the quarter with $18,000 of inventory at cost and purchased $72,000 of inventory during the quarter, its estimated ending inventory using the gross profit method is:

  Estimating future warranty expenses

The new management of YC Inc. has increased the amount of their year-end liability-expense accruals by over 35% compared to recent years, primarily in recording estimated future warranty expenses. The most likely reason for this action is to:

  Current year tax return

Kendra is a self-employed taxpayer working exclusively from her home office. Before the home office deduction, Kendra has $5,000 of net income. Her allocable home expenses are $10,000 in total. How are the home office expenses treated on her curre..

  Sale of obsolete inventory at cost

The increase in ROI was attributed to a reduction in operating assets brought about by the sale of obsolete inventory at cost (the proceeds from the sale were used to reduce bank loans). By how much was inventory reduced?

  Find out the equivalent units of production for materials

barker inc. uses the weighted-average method in its process costing system. the following data concern the operations

  Company new required rate of return

The risk-free rate and the firm's beta remain unchanged. What is the company's new required rate of return? (Hint: First calculate the beta, then find the required return.)

  Accrual accounting for taxation

Solutions Corporation, a computer vendor and consulting company, uses the accrual method of accounting. Its tax year is the calendar year. The following are three of the corporation's transactions during the current year:

  Acquisition of the dandy dime

When one media company buys another, goodwill is often the most costly asset acquired. World media paid $700,000 to acquire-Journalize World Media's acquisition of The Dandy Dime.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd