Question

Rachel Robinson owns a small retail store in Cairo, Georgia. The following summary information regarding expectations for the month of January is provided: As of December 31, there is $1,000 in the bank and the balance in accounts receivable is $5,000. Budgeted cash and credit sales for January are $6,000 and $4,000, respectively. Ninety percent of credit sales are collected in the month of sale, and the remainder is collected in the following month. Rachel's suppliers do not extend credit. Cash payments for January are expected to be $24,000. Rachel has a line of credit that enables the store to borrow funds on demand. However, funds must be borrowed on the first day of the month and interest paid in cash on the last day of the month. Rachel's bank charges annual interest of 12% per year. Rachel desires a minimum $1,000 cash balance at the end of each month.

Answer 1

Answer:

Check the explanation

Explanation:

   January  

Beginning Cash Balance                                   $1,000  

Add: Collection:    

December Sale ($5,000*10%)                           $500  

January Cash Sale                                             $6,000  

January Credit Sale ($4,000*90%)                   $3,600  

Total Cash Available a                                      $11,100  

Cash payment to suppliers b                          $24,000  

Cash deficit before financing a-b                   $-12,900  

Add: Borrowing  (Using permutation-comb.) $14,040  

                                                                                   

Less: Interest Payment                                      $-140  

$14,040*12%*1/12    

Ending Cash Balance                                        $1,000