i need help with this problem and having work shown

17-6. As a loan officer for Allium National Bank, you have been responsible for the bank's relationship with USF Corporation, a major producer of remote-control devices for activating television sets, DVDs, and other audio-video equipment. USF has just filed a request for renewal of its $10 million line of credit, which will cover approximately six months. USF also regularly uses several other services sold by the bank. Applying customer profitability analysis (CPA) and using the most recent year as a guide, you estimate that the expected revenues from this commercial loan customer and the expected costs of serving this customer will consist of the following: Expected Revenues Expected Costs Interest income from the requested loan (assuming annualized loan rate of -? 4%) Interest paid on customer deposits (2.50%) -? Loan commitment fee (1%) 100,000 Cost of other funds raised 180,000 Deposit management fees 4,500 Account activity costs 5,000 Wire transfer fees 3,500 Wire transfer costs 1,300 Fees for agency services 4,500 Loan processing costs 12,400 Recordkeeping costs 4,500 The bank's credit analysts have estimated the customer probably will keep an average deposit balance of $2,125,000 for the period the line is active. What is the expected net rate of return from this proposed loan renewal if the customer actually draws down the full amount of the requested line for six months? What decision should the bank make under the foregoing assumptions? If you decide to turn down this request, under what assumptions regarding revenues, expenses, and customer deposit balances would you be willing to make this loan? 17-6. As a loan officer for Allium National Bank, you have been responsible for the bank's relationship with USF Corporation, a major producer of remote-control devices for activating television sets, DVDs, and other audio-video equipment. USF has just filed a request for renewal of its $10 million line of credit, which will cover approximately six months. USF also regularly uses several other services sold by the bank. Applying customer profitability analysis (CPA) and using the most recent year as a guide, you estimate that the expected revenues from this commercial loan customer and the expected costs of serving this customer will consist of the following: Expected Revenues Expected Costs Interest income from the requested loan (assuming annualized loan rate of -? 4%) Interest paid on customer deposits (2.50%) -? Loan commitment fee (1%) 100,000 Cost of other funds raised 180,000 Deposit management fees 4,500 Account activity costs 5,000 Wire transfer fees 3,500 Wire transfer costs 1,300 Fees for agency services 4,500 Loan processing costs 12,400 Recordkeeping costs 4,500 The bank's credit analysts have estimated the customer probably will keep an average deposit balance of $2,125,000 for the period the line is active. What is the expected net rate of return from this proposed loan renewal if the customer actually draws down the full amount of the requested line for six months? What decision should the bank make under the foregoing assumptions? If you decide to turn down this request, under what assumptions regarding revenues, expenses, and customer deposit balances would you be willing to make this loan