John Tjia, Executive Director, Valuation & Business Modeling at Ernst and Young gave his second Baruch Financial Modeling guest lecture today. Twenty five Baruch students enrolled in Adrienne Wheeler’s spreadsheet courses were present to learn why “accounting is beautiful.” I can’t really emphasize enough that if you want to become a financial modeler you have just had an opportunity of a lifetime. One of the pioneers in this field has shared his 75 minute take on how he pleases his customers. He has even given you a book you can read during the upcoming spring break.
John began by asking students what they wanted to learn in today’s session. He wrote each question on the board and responded to these questions at the end of his presentation.
John’s focus was on three statement modeling: the income statement, the balance sheet and the cash flow statement. This is what we earn, this is what we own, and this is what we owe. John showed us a spreadsheet that presented the basic core ideas of accounting. He kept saying that accounting is beautiful because it explains everything. After creating the Profit and Loss, the income statement, build the balance sheet that includes assumptions underpinning forecasts. The last step is the cash flow, if everything works then it balances. If your model is not balanced then check everything that has a Profit and Loss as well as balance sheet presence such as depreciation. John’s teaching spreadsheet was admired by all of us, he says it is proprietary.
At some point he asked us for definitions of depreciation. Although all of answers were intelligent it was surprising to hear how different they were. The matching principle is the basis of depreciation, match the expense to the time it is being used. It defines a certain economic life but only during the time that you use it.
One of his clients had several initiatives so John created a model with toggles. In the first run the client might only want the first three initiatives. In the second run the client might want to see the outcome of having initiatives 1, 5 and 7. Many of John’s clients tell him not to include VBA in their models. However it is really necessary when he needs to reset some numbers and then turn on the iteration of the interest calculation for example.
There is only one “Master Modeler” and there may be a helper who does things on the side. When two people work on the same model it becomes inconsistent. 
When building a model John used to think that when he had a rough idea he should start keying numbers into his spreadsheet. In his current position he has to be more disciplined. After figuring out what the model is supposed to do, he has to understand what the client wants, then determine if it is doable, for example a model that needs Python or C++ is not feasible. Here are the phases of a project: define the scope, design the project, do the actual keyboarding, test it so that there are no unfortunate mishaps when presenting to the client. Please note that if the client finds an error, the financial modelers may have to work for free to fix it. After you fix all of the version one mistakes and you are working on version two you may have a serendipitous realization that, “Oh we can do it this way instead.” We were cautioned however not to do something so creative that the client asks, “What is happening!!”
John said that although some of the people who report to him use SharePoint most of the work that he and the 70 people who report to him do is in Excel, VBA and a little bit of Access. His Financial Modeling department staff is dispersed among these offices, Times Square, New York City, Chicago, San Jose, Atlanta, Houston, Charlotte, Boston and McClean. Some of his clients are General Electric, a couple of banks in Chicago, Xerox and many Fortune Five Hundred firms in Houston.
John showed us a program he created that auto loads comparable companies’ Capital IQ data into a spreadsheet. We were pleased to see Honeywell, Lockheed Martin, General Dynamics and Boeing, the companies we used for our XBRL lesson in the example he selected. Apparently John has been examining the printouts you are required to bring to our spreadsheet classes.
Please make a comment on this blog.
Thank you for speaking with us John!
It was a great presentation. I learnt a lot. It is honored to be there. We could see how much effort John puts on his work. I really appreciate for having this wonderful experience.
Mr. Tjia did a fantastic job simplifying a complex topic and powerful skill. I was quite blown away as to the power of Excel without the use of any advanced programming skills and limited use of VBA. I also pretty enlightening to learn that the accounting discipline is inherent in financial analysis. Overall, it was a captivating and informative presentation that has sparked a major interest in financial modeling in me.
Thank you for the amazing presentation Mr. Tija! Your technique of simplifying and explaining subjects to your audience of students was so helpful. I learned a lot about accounting and financial modeling. Thank you very much for coming.
Mr. Tija’s presentation opened my eyes. Your unique perspective on accounting and amazing integration of Excel modeling to accounting and financial analysis were enlightening. Thank you!
It was a great presentation Mr.Tija! I strongly feel that you should become a professor of accounting because I learned a lot from you! Your program that auto loads companies to compare them was amazing! Thank you very much for this wonderful experience!
Thank you professor Wheeler for organizing this amazing event. It is an incredible opportunity to be part of a class where we gain exposure to both the theoretical and practical aspects of the curriculum.
I had a front row seat to a very informative presentation delivered by Mr. John Tija to Baruch Students on Financial Modeling. As a business graduate student aspiring to be a professional financial modeler/ financial analyst in the near future, I got a glimpse into the tremendous level of detail and precision required in this line of work. I was highly impressed by the final product he delivers to his corporate clients. As a pioneer in the field of financial modeling, I was fortunate to experience this once in a lifetime opportunity to hear from the “Master of Modeling”. Thank you Mr. Tija.
Ernest W Infante
Baruch College MBA Candidate
May 2016
Thank you so much for Prof. Wheeler to organize this awesome event on campus. As an Accounting student, I am so fortunate to have this opportunity to experience the integration of basic accounting principles and business modeling.Most importantly, the examples John presented with were very practical and helpful.
I am in a similar situation where I have a client (internal sales team) requesting ad hoc reporting on specific key metrics. My assumption always used to be similar with John’s in that once I had an idea, I would start keying numbers into a spreadsheet. I find the phases of a project (Define the scope, design the project, do the actual keyboarding, & test) to be extremely relevant and useful. This is the same type of process I find now in my new projects, along with the “serendipitous realizations” that the project could take a turn into something beyond the scope of the original request.
Thank you Mr. Tija for your presentation and Prof Wheeler for organizing it. Mr. Tija’s presentation captured the very essence of main accounting concepts and helped me make sense of it all. I really appreciate his coming to the campus in person and sharing his valuable insights.
Thank you Mr Tija give us that presentation. And also thanks for Professor. I used to student of accounting, so I think the model is helpful for the accounting major. He show us the real life instead of the knowledge on the book.
Thank you Mr.Tijia! This presentation not only teach us many very practical skills and applications but more insight thinking of financial analysis.
It is a amazing presentation. Mr. Tjia showcased the power of EXCEL !
Looks interesting