50.1K

Verified Solution

Link Copied!

please help. i dont know what formulas i need to use.

(2.12) Calculate the line of credit needed. a. The line of credit needed is the credit limit the comprny needs to negotiate with the bank. b. It is calculated as the maximum loan balance that the company expects to carry over the course of the six month period. (2.8) Calculate the loan balance for each of the six months. a. The loan balance is equal to Additional Cash Needed minus any Cash Used to Retire Debt for that month plus the loan balance carried from the prior month. b. Reuse your formula to complete the loan balance for each month. (2.9) Calculate the ending cash balance for each month. a. The ending cash balance is equal to the Cash Available to Retire Debt minus any Cash Used to Retire Debt. b. Reuse your formula to complete the ending cash balance for each month. I The earliest a laan will b (2.6) Calculate the cash available to retire debt for each of the six months. a. There is cash available to retire debt if there is a cash surplus at the end of a month (shortfall/surplus cash >0 ). b. Cash Available to Retire Debt is equal to any cash surplus at the end of a month. c. If there is not a cash surplus, Cash Available to Retire Debt is zero (0). d. Reuse your function to complete the Cash Available to Retire Debt for each month. 2.11) Calculate the loan interest for each month. a. The loan interest is equal to the loan balance for that month times the monthly interest rate in cell (3). b. This calculation will create a circular reference. Configure Excel to appropriately handle the circular reference. c. Reuse your formula to complete the loan interest for each month 2.10 Calculate the beginning cash balance for February through June. a. The beginning cash balance is equal to the ending cash balance from the prior month. b. Reuse your formula to complete the beginning cash balance for each month. (2.7) Calculate the cash used to retire debt for each of the six months. Since the company can't use more cash than is available to retire the debt, Cash Used to Retire Debt cannot exceed the Cash Available to Retire Debt. Likewise, the company can't use more money to retire debt than it has debt from the prior month to retire. a. Cash Used to Retire Debt will be equal to the Cash Available to Retire Debt if the cash available is less than the loan balance from the prior month. b. Otherwise, the Cash Used to Retire Debt will be the loan total from the prior month. c. Reuse your function to complete the Cash Used to Retire Debt for each month

Answer & Explanation Solved by verified expert

See Answer