In a cash sweep model (on excel), how would you reflect a ceiling on debt available along with issuing stock if the cash necessary surpasses the debt cieling? How would we model a cieling on cash retained (i.e., the opposite of a floor with a minimum amount of cash on hand needed as a percetange of revenue, so as to prevent cash from exceeding a certain level) along with the repurchase of stock if the cash account exceeds the cash cieling?

The cash sweep model includes 3-statement projections. What error-trapping excel formulas should be used in this case and where?

This is a conceptual question, not a textbook one. Just need to know how to reflect the above in a Cash Sweep model