Showing results:
Displaying 1 - 37 of 37
REPE modelling test
Hi folks, I have a modelling test for a REPE in London in the next few days (3 hours test). I have created multiple excel sheets from scratch but i would like to know what is expected from a potential summer intern (e.g. Waterfall modelling, etc.). Do you guys have any tips and/or past interview...
ARGUS Expense Recovery Help
Hey folks, I'm just getting started setting up ARGUS models with more detailed expense recovery structures, and I'm having some issues. I'm supposing this has less to do with the limitations of ARGUS and more to do with the limitations of my pea sized brain. Any guidance is greatly appreciated. So...
Real Estate Debt modeling
When modeling debt used, what do you do with the remaining debt balance at Exit? Is it added up to the debt service? so you would have it part of your last repayment? Thanks
Is A.CRE good for learning RE modelling from scratch?
I have some of their models and materials, but I was wondering if it would be worth it to sign up for the course to go through step by step how they build the models. Their videos are really just tutorials on how to use the model, and what are the features. Do they teach you how to build their...
Real Estate Underwriting Case Study
Recently I was given a acquisition case study as part of a project for an internship with the following information provided: - 100 Unit class C multifamily being converted into class B - Market rents ~1600-1800 (Columbia Heights DC) - Renovation costs: 25K per unit - 5 year hold period - 6.5% going...
Real Estate Excel case studies
So I'm currently quarantining with COVID right now, and I'm extremely bored. Thought it might be a good time to sharpen my Excel skills back up before my internship this summer, so I'm on the hunt for some gritty Excel case studies. Anyone know any good places to find them? Just trying to pretend...
ARGUS Question: General Vacancy on a Portfolio
Here's an Argus question for y'all - I'm hoping this is a dumb question with an easy fix. I'm running a 2% General Vacancy assumption on each of 7 properties in an Argus portfolio. I'm not grossing up revenue by absorption & turnover, and I'm reducing the General Vacancy Result by absorption &...
How to break into commercial real estate without the fluff
Breaking into a top brokerage as an investment sales analyst in NYC (think CBRE, JLL, Cushman, ES) was one of the hardest things I've ever done. I went to a non-target, didn't study finance or real estate, had no previous experience, was a career switcher and several years out of school, and lived...
First Lien Position Distressed Real Estate Notes Financial Modeling Training
.............................................................................................................................................
Corporate Finance Transactions/Deals Modelling
Hi All, I've just started working at a CorpFin for Real Estate team. I've got a deal coming up and am not sure how to model a corp. transaction. I understand it to be model out asset level cash flows and roll-up . Anyone shed an y detailed breakdown or examples/point me in the right direction of a...
Project Destined Fall 2021 Undergraduate Paid Virtual Commercial Real Estate Internship
We are excited to announce a new Paid, Commercial Real Estate Virtual Internship Opportunity with Project Destined in Fall 2021. Project Destined, founded by a former Carlyle Group executive , has partnered with 100+ leading real estate firms and 70+ universities around the country to provide...
Career Move from Economic Consulting to Real Estate
Hello everyone. I am a seasoned analyst at a leading economic consulting firm (think BRG, FTI, NERA, CRA) where I have worked on antitrust, damages, and financial market engagements since graduating from undergrad a few years ago. I am considering next steps for my career and would appreciate some...
WeWork Case Study
Hi Guys, Does anyone know what case study / presentation WeWork tests applicants on? I get their business model is different from traditional RE companies so would their interview tests be too? I'm thinking it might be different from modelling out a 5-year cash flow but not too sure. I tried to find...
Real Estate Financial Modeling Case Study HELP - Getting to Purchase Price??
Hi, so I've recently applied to a RE investment firm and they gave me this case study. I've been trying to read through some case studies online, but I can't find anything that is similar to the one they gave me. Basically, there is a target Office Building to be acquired with 1 year of renovations...
Modelling Loan Refinancing - Development
Hi all, First time poster but long term lurker here. Appreciate all the help this site (and you guys) have given me over the years. I have a scenario where I'm modelling a ground up development for a resi-led scheme. It's all good up until the point of the debt modelling. Theres essentially two...
RE Financial Modeling course
Hi everyone, Hope everyone's having a good time. I was wondering if you guys knew about any good financial modeling courses that will teach me how to make a model from scratch. I'd actually like to learn stuff but at the same time have some decent resume value. The cheaper the better but the...
BIWS RE modeling course compared to real life?
Curious to hear others thoughts here. For those of you who have taken the BIWS RE modeling course, would you say they’re comparable to real life models? Other than some of the preset market assumptions and leasing activity BIWS gives you in each case study, how do you think they compare?
Deutsche Finance International -2nd Round: Case Study in Excel
Hi guys, I'm an economics graduate that is having a 2nd round interview with DFI [for London] (RE PE), and they told me that in this case, the 2nd round will be a 2-hour case study in excel. I asked for some more information, but have not received any answer me and I have no idea what to prepare....
RE Modeling -- WSO new courses
Has anyone tried the new modeling courses introduced by WSO? I'm between the BIWS, WSO, and REFM courses. There's plenty of reviews on this site for the differences between BIWS and REFM, so I was hoping someone could shed some light on the new WSO package and if it's any good.
PERE Modeling Interview Questions - WSO Modeling Course
WSO is going to create a RE modeling test/interview prep course for commonly asked interview questions that I am assisting with. What are some of the questions/concepts you would like to see answered so we can help you know enough to be dangerous in an interview?
Real Estate Developer - Net Working Capital ?
Am doing an integrated 3 statement financial model for a property developers. Question(s): (1) for a developer, do "Development & Trading Properties" that are classified as current assets get included in a calculation of working capital / change in working capital? Also, (and this is not real estate...
Modeling Apartment Downtime
I am a first year analyst that most focuses on office/retail but have been asked to model a value-add apartment deal. The business plan involves renovating units upon lease expiration by replacing kitchen/bathroom appliances, sanding/staining floors and upgrading electrical fixtures. My question is...
Breaking Into Wall Street RE Modeling Course
Has anyone here taken this and do they recommend it? I am in CRE consulting/valuation for a large Accounting/Consulting Firm. currently with an MBA concentration in RE. I have a huge desire and career goal to transition to the Investment/Principal side. The thing most lacking in my skills is...
WSP REIT or BIWS REIT or REFM Modeling, which course is better ?
WSP REIT or BIWS REIT or REFM Modeling, which course is better ? to learn how to build and value a real estate listed company ?
Recent grad looking to break into CRE...best Real Estate Modeling courses?
Background: studied finance at a non-target school in a metropolitan city in Canada. Parents had a few properties which I managed (I guess you could say I was the property manager at the time). I interned at the government for a summer doing billings (a/p & a/r - mostly managed databases and used...
Real Estate Modeling Courses
I'm thinking about getting a real estate modeling course for Christmas this year and have a few questions. For some reference I am a senior now and have signed to work in CRE Lending at a large bank next year. Aside from the practical used, I am also just kind of a nerd and enjoy learning new things...
Ski Lodge Model
Does anybody have a Resort Model that they would be willing to share? I'm looking for a Model for the actual operations of the mountain itself, not the surrounding real estate (i.e., revenue build for tickets, apparel sales, F&B ops, etc.). DM me if you do. I have a ton of LBO and operating model...
RE Modeling Swap
Would anybody like to swap RE modeling materials? I have a fair amount of resources and would happy to trade and help a fellow monkey out in the process. If you're interested, feel free to PM me.
Gross vs. Net Cap Rate
All- I have received an interview test from a small RE acquisition firm. The company primarily deals with SFR (single family rentals) and small apartment buildings. For the test, they asked me to evaluate 3 SFRs which includes determining the rental value, price we should pay, and a gross and net...
Debt Coverage Ratio
Hi Monkeys, I was given an assignment for a commercial real estate finance interview on the West Coast. The assignment was to determine if the capitalization request seemed like a good investment opportunity. I've been able calculate the the Cap Rate and Loan to Value, but I am having difficultly...
Question about general vacancy
So I'm looking for answers from other aquisition guys rather than the debt guys (sorry). This may be a bit too specific, so much so that many or all of you may not have an answer for me. When underwritting an industrial warehouse aquisition do you take a general vacancy if its only two tenants? I...
Transition from Real Estsate Appraisal to Real Estate modeling
I have 6 years’ experience appraising real estate as a certified real estate appraiser. I am exploring job opportunity in financial or RE investment company. How much would a RE Modeling certificate help? Any inputs or thoughts would be greatly appreciated.
Financing Developer/Lot Sales
Hi all - I just received a deal to finance a residential developer and wanted to know if anyone has a model they would be willing to share or trade.
I have 30 days to become RE Acquisitions Modeling Proficient, and only can spend $100. What is best way to accomplish this?
I did my undergrad in business administration, but did not touch on real estate. I have 30 days to get excel modeling proficient for an acquisitions role focusing on the main re sectors [office, retail and multifamily rental with possibility for hotel]. What books should I read, and what classes and...
Where to learn modeling skills for real estate?
Hey, I am wanting to join a real estate firm on the development or acquisition side. Most of these positions require the applicant to understand how to put together excel models on deals. My University never taught anything of the sort, so I have tried picking it up through Breaking Into Wallstreet,...
Financial Modeling: Minimum sale price to be able to pay down Debt by year 3
So I wanted to see if there is an efficient way to model this: I have a schedule of cashflows that is connected to a schedule of sales for various parcels of real estate. the parcels of real estate are broken out in 3 buckets with bucket one being all sold by year 2, bucket two by year three. We...
Waterfall / Promote modeling
I have been trying to model this and am having trouble. Any help in terms of how to tackle this (a template or thought process) will be appreciated Investor 90% $18,000 Sponsor 10% $2,000 Initial Equity $20,000 IRR Investor Sponsor Hurdle 3 12% 100% 0% Hurdle 4 18% 85% 15% Hurdle 5 22% 80% 20% Final...
or Want to Sign up with your social account?