Question

In: Accounting

Sparks Corporation has a cash balance of $12,900 on April 1. The company must maintain a...

Sparks Corporation has a cash balance of $12,900 on April 1. The company must maintain a minimum cash balance of $10,500. During April, expected cash receipts are $57,000. Cash disbursements during the month are expected to total $65,500. Ignoring interest payments, during April the company will need to borrow:

$4,400

$6,100

$8,500

$10,500

Sparks Corporation has a cash balance of $12,900 on April 1. The company must maintain a minimum cash balance of $10,500. During April, expected cash receipts are $57,000. Cash disbursements during the month are expected to total $65,500. Ignoring interest payments, during April the company will need to borrow: $4,400 $6,100 $8,500 $10,500

Solutions

Expert Solution

  • All working forms part of the answer
  • NOTE: Same question got posted twice.
  • Working

A

Beginning Cash Balance - Apr 1

$           12,900.00

B

Cash receipts

$           57,000.00

C = A + B

Total Cash Available

$           69,900.00

D

Cash Disbursements

$           65,500.00

E = C - D

Excess of Cash available over disbursements

$             4,400.00

F

Ending balance desired

$           10,500.00

G = F - E

Amount to be borrowed

$             6,100.00 = Answer

  • Correct Answer = Option #2: $ 6,100

Related Solutions

2. Webster Corporation is preparing its cash budget for April. The March 31 cash balance is...
2. Webster Corporation is preparing its cash budget for April. The March 31 cash balance is $36,500. Cash receipts are expected to be $642,000 and cash payments for purchases are expected to be $609,500. Other cash expenses expected are $27,100 selling and $33,600 general and administrative. The company desires a minimum cash balance at the end of each month of $31,000. If necessary, the company borrows enough cash to meet the minimum using a short-term note. Webster's preliminary cash balance...
To maintain a stable weight, there must be energy balance. Energy intake is equal to energy...
To maintain a stable weight, there must be energy balance. Energy intake is equal to energy expenditure. However, when this energy balance is disrupted it can lead to individuals who are underweight or overweight. Maintaining proper energy balance involves complex interactions among several organ systems in the body. In the hypothalamus there is a satiety center and a hunger center. Leptin is an anorexigenic (i.e., satiety) signal, whereas ghrelin is an orexigenic signal (i.e., promotes appetite). Leptin is a peptide...
1) A company would use a sweep account to: A. Maintain a zero balance and move...
1) A company would use a sweep account to: A. Maintain a zero balance and move cash to an interest-earning account B. Move cash between countries with different currencies C. Return cash to shareholders D. Manage the amount of cash available on-hand 3) A company with predictable sales levels would A. Carry lower levels of safety stock B. Need higher average inventory levels. C. Predictability of sales doesn't impact the inventory decision D. Non of the above 5) In managing...
Stockholders’ Equity: Transactions and Balance Sheet Presentation Torey Corporation was organized on April 1, with an...
Stockholders’ Equity: Transactions and Balance Sheet Presentation Torey Corporation was organized on April 1, with an authorization of 25,000 shares of six percent, $50 par value preferred stock and 200,000 shares of $5 par value common stock. During April, the following transactions affecting stockholders’ equity occurred: Apr. 1 Issued 80,000 shares of common stock at $40 cash per share. 3 Issued 2,000 shares of common stock to attorneys and promoters in exchange for their services in organizing the corporation. The...
On 30 April 2020 Chen & Chan Ltd had a cash balance as per company records...
On 30 April 2020 Chen & Chan Ltd had a cash balance as per company records of $5,644.50 debit. The bank statement from Brisbane Bank on that date showed a credit balance of $7,825.35. A comparison of the statement with the cash account revealed the following facts: The bank statement included a debit entry of $60 for bank fees. Unpresented cheques at 30 April totalled $1,276.25, and outstanding deposits were $795.40. Included with the cheques paid was a cheque issued...
Bernie’s Corporation has a capital budget of $2.25 million. The company wants to maintain a target...
Bernie’s Corporation has a capital budget of $2.25 million. The company wants to maintain a target capital structure which is 70% debt and 30% equity. The company forecasts that its net income this year will be $800,000. a.         If the firm uses a payout ratio of 30%, what dividend will Reed pay? b.         How much will be added to retained earnings? c.         If the company wishes to maintain its debt-equity ratio to finance the capital budget, how much debt must...
Lumber River Corporation is studying its cash needs for April, May and June and has gathered...
Lumber River Corporation is studying its cash needs for April, May and June and has gathered the following information:                                                             April               May                June Sales                                                   $55,000           $58,000           $50,000 Purchases                                           $26,000           $21,000           $19,000 Cash Operating Costs                      $33,000           $32,000           $25,000 Beginning Balances for April in the Cash Account are $6,500; in Accounts Receivable $21,000; and in Accounts Payable $18,000. Seventy percent of all customer accounts are collected in the month of sale; the remainder are collected the next month. Forty percent of the...
(a) Ace Company has the following transactions in the month of April. 1 April Peter invests...
(a) Ace Company has the following transactions in the month of April. 1 April Peter invests $100,000 cash and an office equipment valued at $20,000 in the company. 2 April The company purchased $800 of office supplies on credit. 15 April The company completed $5,000 of services for a client, who must pay within 30 days. 28 April The company received a utility bill amounting $500. 30 April The company sold off an equipment costing $3,000 with a net book...
The April 30 bank statement for KMaxx Company and the April ledger account for cash are...
The April 30 bank statement for KMaxx Company and the April ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other Balance Balance, April 1 $6,000 April 5 #101 $ 700 5,300 April 9 $2,500 7,800 April 12 #102 200 7,600 April 19 #103 500 7,100 April 22 #104 1,000 6,100 April 27 EFT payment $200 5,900 April 29 NSF check 100 5,800 April 30 Service charge 25 5,775 Cash (A) April 1 Balance 6,000 April 8 2,500...
On July 1, 2017, Sparks Company purchased for $4,300,000 an equipment having an estimated useful life...
On July 1, 2017, Sparks Company purchased for $4,300,000 an equipment having an estimated useful life of 5 years with an estimated residual value of $200,000. Depreciation is taken for the portion of the year the asset is used. Instructions (a) Complete the form below by determining the depreciation expense and year-end book values for 2017and 2018 using the       1.   sum-of-the-years'-digits method.       2.   double-declining balance method.       Sum-of-the-Years'-Digits Method                                    2017                           2018           Equipment                                                                  $4,300,000                  $4,300,000       Less: Accumulated Depreciation                                  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT