Debt Scenario Model

For starters, I am not in IB but in Commercial Banking as a credit analyst in a MM group. My problem may seem simple to most of you but thank you in advance for taking the time to read.

I am looking for advice and/or examples of how to take financial statements of a company and test them against various debt scenarios. For example, how would this company look if they had a $500MM TLA or TLB, or a $200MM RLOC with various levels of usage. End goal would be to create a template that can take statement inputs and show debt scenarios based on user input (term loan, rloc, subordinated notes, usage, rates, etc).

Thus far, I've been pretty much making it up as I go but I don't feel great about it. People in my group seem impressed by it but when I interact with our IB group, it's clear that our standards of 'great work' are clearly different. I'd like to bring the standard of work product up to a higher level for both myself and my peers but being in MM, we don't have access to the same trainings and network of knowledge. I know the basics of forecasting out financial statements based on past performance and expectations. My thoughts are to take parts of an LBO model and adapt it to my needs but I'm not sure if that's the best way to go about this.

Any advice or assistance is greatly appreciated.