CASE STUDY: K-Bar Operating, LP Assignment: Underwrite a request for a revolving line of credit to K-Bar Operating, LP. 1. Using Excel, create a model in a spreadsheet for the A/R Aging Summary for the company. 2. On the same sheet, and showing your work, create a table showing a borrowing base calculated as follows: a. RLOC shall be limited to the lesser of (i) $4,000,000, or (ii) 80% of Eligible Receivables. b. Eligible Receivables shall exclude the following: All accounts receivable over 60 days past due; The entire receivable of one account debtor becomes ineligible if more than 10% of the total due is over 60 days past due. 3. What is the amount Borrower is eligible to borrower according to the borrowing base you calculated above? 4. Please note, special attention will be paid towards formatting and appropriate use of formulas