Question

The president of the retailer Prime Products has just approached the companys bank with a request for a $55.000, 90- day loaPrepare a cash budget, by month and in total, for the three-month period. (Cash deficiency, repayments and interest should be

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.

Schedule of Cash Collections
April May June Quarter
Collected in same month @30% $   1,12,500 $ 1,23,600 $ 1,00,800 $ 3,36,900
Collected in following month @60% $   1,34,400 $ 2,25,000 $ 2,47,200 $ 6,06,600
Collected in following next month @8% $      17,920 $    30,000 $      47,920
Total Cash Collections $   2,46,900 $ 3,66,520 $ 3,78,000 $ 9,91,420

2.

Cash Budget
April May June Quarter
Beginning Cash Balance $       26,000 $      43,400 $    53,920 $           26,000
Add receipts:
    Collections from Customers $   2,46,900 $ 3,66,520 $ 3,78,000 $       9,91,420
Total cash available $   2,72,900 $ 4,09,920 $ 4,31,920 $     10,17,420
Less Cash Disbursements
Merchandise Purchase $   1,66,500 $ 2,38,000 $ 1,55,000 $       5,59,500
Payroll $       18,800 $      18,800 $    22,500 $           60,100
Lease Payments $       24,400 $      24,400 $    24,400 $           73,200
Advertising $       74,800 $      74,800 $    50,420 $       2,00,020
Equipment Purchases $ 1,06,500 $       1,06,500
Total Cash Disbursements $   2,84,500 $ 3,56,000 $ 3,58,820 $       9,99,320
Excess (Deficiency) of cash $     -11,600 $      53,920 $    73,100 $           18,100
Financing
Borrowing $       55,000 $           55,000
Repayment $   -55,000 $         -55,000
Interest $         -900 $               -900
Total financing $       55,000 $               -   $   -55,900 $               -900
Ending Cash balance $       43,400 $      53,920 $    17,200 $           17,200
Add a comment
Know the answer?
Add Answer to:
The president of the retailer Prime Products has just approached the company's bank with a request...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The president of the retailer Prime Products has just approached the company's bank with a request...

    The president of the retailer Prime Products has just approached the company's bank with a request for a $55,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through June, during which...

  • The president of the retailer Prime Products has just approached the company's bank with a request...

    The president of the retailer Prime Products has just approached the company's bank with a request for a $59,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through June, during which...

  • The president of the retailer Prime Products has just approached the company's bank with a request...

    The president of the retailer Prime Products has just approached the company's bank with a request for a $47,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through June, during which...

  • The president of the retailer Prime Products has just approached the company's bank with a request...

    The president of the retailer Prime Products has just approached the company's bank with a request for a $87,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through June, during which...

  • The president of the retailer Prime Products has just approached the company’s bank with a request...

    The president of the retailer Prime 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. 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 through June, during which...

  • The president of the retailer Prime Products has just approached the company's bank with a request...

    The president of the retailer Prime Products has just approached the company's bank with a request for a $73,000.90 day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through June, during which...

  • please answer fast The president of the retailer Prime Products has just approached the company's bank with a request...

    please answer fast The president of the retailer Prime Products has just approached the company's bank with a request for a $85,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through...

  • The president of the retailer Prime Products has just approached the company’s bank with a request for a $71,000, 90-day...

    The president of the retailer Prime Products has just approached the company’s bank with a request for a $71,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through June, during which...

  • The president of the retailer Prime Products has just approached the company’s bank with a request...

    The president of the retailer Prime Products has just approached the company’s bank with a request for a $83,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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 through June, during which...

  • Check my wor 6 The president of the retailer Prime Products has just approached the company's bank with a request for a $75,000, 90-day loan. The purpose of the loan is to assist the company in a...

    Check my wor 6 The president of the retailer Prime Products has just approached the company's bank with a request for a $75,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT