Analyzing a lease and how it impacts the books. Looking for a resource.
I’m a commerical office broker on both the tenant and landlord side that primarily focuses on leasing. 

I’m looking for a resource or class I can take to help me better analyze and interpret the financial impact of an office lease for my clients. 

Im not looking for underwriting help, rather a way to break down and provide guidance for my clients on how a particular deal structure will impact their books and business. I use a pretty basic excel document to break down base rent, base year and TI overages, etc but I want to take it a step further. 

I know a lot of larger shops have proprietary software or analysts with a background in accounting but I don’t have those tools at my disposal. 

Does anyone have any guidance?

As a side note, I’ve already completed the CCIM courses and those aren’t exactly what I’m looking for. 

Any help is appreciated.
[{"id": "igelrxy", "text": "I work at a top 3 brokerage and I do these types of analysis every day for our senior brokers.\n\nTypically, we build out a cashflow for the lease term, say 10 years. Then we add in base rent , additional rent, moving costs, parking costs, swing space if applicable, TI costs, etc. \n\nAt the end we get a average annual costs as well as a \u201cpresent value\u201d cost if the client is more sophisticated. We also show some nice graphs with costs over the term of their lease.\n\nLet me know if you\u2019d like I can rebuild one out for you we can discuss further", "replies": [{"id": "igeqrsg", "text": "Would love to chat more and possibly see your form. Will PM you.", "replies": [{"id": "igqg9ms", "text": "Just DMed you", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "igfdf8d", "text": "Oddly enough, there is a tool in CoStar called Lease Analysis. If you have a Costar subscription, look under the Lease section.\n\nI think they've added videos to the knowledge base. If you need help, ask your research team. If they don't know (and many don't) feel free to DM.", "replies": [], "depth": 1}]