Real Estate Models - Interview Excel Case Tests - Learn Real Estate, Finance or Financial Modelling from a Fund Manager

Analyst Practice Interview Excel Case Studies

Our tutor is a Real Estate Investment Manager with years of experience in interviewing and assessing Analyst/Associate candidates.

A key part of the interview process is an assessment of the analyst’s ability to use Excel to put together an appraisal/investment reccommendation using given material under a level of time constraint.

We have compiled over 50 practice cases/solutions for all levels of ability/complexity from Basic cases requiring 1-2 hours, typically administered to Graduate Analysts, to more complex cases of 4 hours+ that are typically administered to more senior candidates.

Basic Interview Excel Case (1 to 2 hr)

Description: An Instituitional Grade Office/Retail/Industrial financial appraisal model that can accommodate 150 units and multiple assets.
Features: IC Summary, Annual Cash Flows, Capex, Refurbishments, Dilapidations, Indexed Leases, 3 new leases, 3 Rent Reviews, Ground Leases, Service Charge Caps

WhatsApp Image 2025-02-22 at 2.56.51 AM

WhatsApp Image 2025-02-22 at 2.56.54 AM

WhatsApp Image 2025-02-22 at 2.56.58 AM

Intermediate Interview Excel Case (2 to 4hr)

Description: An Instituitional Grade Office/Retail/Industrial financial appraisal model that can accommodate 150 units and multiple assets.
Features: IC Summary, Annual Cash Flows, Capex, Refurbishments, Dilapidations, Indexed Leases, 3 new leases, 3 Rent Reviews, Ground Leases, Service Charge Caps

WhatsApp Image 2025-02-22 at 2.56.51 AM

WhatsApp Image 2025-02-22 at 2.56.54 AM

WhatsApp Image 2025-02-22 at 2.56.58 AM

Advanced Interview Excel Case (4hr+ or deadline within 1-2 days)

Description: An Instituitional Grade Office/Retail/Industrial financial appraisal model that can accommodate 150 units and multiple assets.
Features: IC Summary, Annual Cash Flows, Capex, Refurbishments, Dilapidations, Indexed Leases, 3 new leases, 3 Rent Reviews, Ground Leases, Service Charge Caps

WhatsApp Image 2025-02-22 at 2.56.51 AM

WhatsApp Image 2025-02-22 at 2.56.54 AM

WhatsApp Image 2025-02-22 at 2.56.58 AM

Leila H. Student in MSc Real Estate Finance at Henley Business School

Dan was great at teaching real estate finance to someone with no prior background in the subject. He was patient and thorough, ensuring I fully understood each concept before moving on to the next. He took the time to explain problems multiple times in different ways, making complex ideas much easier to grasp. I recommend him to anyone looking to build a strong foundation in real estate finance. Dan was great at teaching real estate finance to someone with no prior background in the subject. He was patient and thorough, ensuring I fully understood each concept before moving on to the next. He took the time to explain problems multiple times in different ways, making complex ideas much easier to grasp. I recommend him to anyone looking to build a strong foundation in real estate finance.

Katya G. Student in MSc Real Estate Finance at Henley Business School

Dan was a great tutor for my MSc Real estate finance exams. He was clear, concise and motivating at all times. He was able to do very flexible hours and was always super helpful at all hours of the day. Would recommend to anyone, I wouldn’t have passed without him and I came out with a First!

Kat H. Senior Director at Avison Young taking Real Estate Investment lessons

I had a couple of sessions with Dan alongside a short course in real estate finance and found his approach incredibly helpful. Dan was very responsive in setting up sessions, often accommodating a difficult schedule, and was great at helping me put principles into practice. Dan was also happy to take a more flexible approach to the content of each session, allowing for multiple questions and more of a discussion, which was both enjoyable and a great way of testing my understanding.

Nigel G. Student on BA Accounting and Finance at Lancaster University (Parent)

My son needed to retake his Accounting and Finance minor for his year 1 uni course. He’s a maths student who just didn’t get accounting and needed a more ‘grass roots’ explanation. I found The Profs online and they recommended Dan. There was a lot to cover in three weeks but Dan quickly assessed what could be achieved and which quick wins were available. He put together a programme of tutoring based around three hours a day. My son has just finished his resits and reckons he’s passed. He felt Dan was highly organised with a gift for explaining complex issues in an understandable way. My son is also autistic and has trouble communicating, so Dan was a good choice because he has experience with autism and knows how to get through to people who think in a different way. I would recommend Dan to uni students looking for help with accounting and finance.

Abdullah N. Student on Msc Real Estate Finance at Bayes Business School

Dan was good at explaining the content and helped me a lot with everything. I felt comfortable asking my questions and he was really helpful in explaining everything with the pace I was good at and gave me examples to help me understand.

Erich P. Overseas student on MSc in Real Estate at Bayes Business School

Dan was a great tutor and I had a really good experinece with him and he helped me cover many of the lecture slides. Thank you very much.

Kushal B. Accountant taking Financial Modelling and Private Equity classes

I recently contacted Dan for some tutoring with the intention of improving my financial modelling skills. Having only had three sessions so far, I already see an improvement in my understanding and abilities. I am looking forward to see how much I will develop over the next few sessions.

Sacha T. Overseas Student in Msc Management at Deusto Business School

Dan has been very helpful across several subjects like Financial and Management Accounting. Nice guy, easy to get on with and adaptable.

Spencer G. Chartered Surveyor taking Financial Modelling Classes

Dan has helped with analysing data, valuation Templates and setting up processess which will help speed up my valuation assesments and format them in a concise and analytical manner.He has a great attititude and has been patient, helpful and informative,I couldn't recommend highly enough. Thanks Dan .

Company

Services

Contact Us

©2025 RealEstateTutor. All Rights Reserved