You are here
Home > Financial Modelling

Investment Banking Modeling Test / Case Study

Most investment banks have a fairly gruelling interview process that we outline in our interview section. We also are now offering mock interviews for those who do not have friends to practice with. Each interview goes through a technical question section, usually with some combination of analyst/associate/VP, as well as several

Modeling Commercial Real Estate

Before going into some real estate strategies, here are some key financial assumptions in modeling out the return on investment for your real estate investment. Real Estate Operating Assumptions Net Operating Income (NOI) Net operating income is the revenue of the property or property portfolio less any operating expenses. This is before maintenance

How to Get Cash Taxes for Financial Modeling

This is a simplified example to understand the mechanics of cash taxation at a high level and should not be relied upon for anything other than educational purposes Cash Taxes in Financial Analysis What companies report as accounting tax and what they actually pay in terms of cash to the government can

Microsoft Excel Best Practices For Investment Bankers Part II

A managing director decides to follow up with a client in terms of pitching a prospective acquisition target. From: To: Hi Bob, Hope you’ve had a nice weekend. Would you be interested in taking a look at some updated valuation materials for Paris Baugette as per our discussion in April? Kind Regards, MD From: To: