Basic course on financial modeling on Excel for Real Estate Investing.
Learn how to analyze real estate investments in Excel and how to make investment recommendations based on your analysis.
In this course, you will have the opportunity to practice and become a true Excel modeling whiz with the four cases included in the course materials. The models you build will be completely automated and dynamic, and will allow you to test your assumptions and run sensitivity analyses on your main investment assumptions.
If you are preparing for an interview in real estate investment and asset management roles, this course will help you pass the Excel test, which is the first stage of the interview process. This is because it is based on modeling exercises that I have done as part of recruiting processes.
To get the most out of this course, you need previous knowledge of Excel and finance, including, among others, the use of formulas such as EDATE, SUMIF, INDEX, and MATCH, and finance concepts related to revenue, costs, profitability, and returns, such as the IRR, equity multiple, cash-on-cash returns, and gross and net initial yields.
It's also good to have some knowledge of debt financing, such as loan-to-value ratios, and financial solvency metrics such as debt yield, debt service coverage ratio, and interest coverage ratio.
Professional with over 15 years of experience in development, investment and management of real estate projects across Europe, having worked in projects with a total value over 2bn €. I am an MBA graduate from the Tuck School of Business at Darmouth College, and I hold an LLM from Harvard Law School and Centro de Estudios Garrigues. I studied my bachelor and JD degrees in the University of Granada.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
