- 62
- 379 259
Michael Belasco
Registrace 15. 11. 2015
Michael Belasco works in commercial real estate development and is the co-founder of www.AdventuresInCRE.com, a website dedicated to teaching and learning about commercial real estate.
RV Park Acquisition Model - Version 1.1 Updates
A quick walkthrough of the major updates to the RV Park Acquisition Model. This is the second version of the model (v1.1). To view the original video, please go here:
czcams.com/video/5p_7JR4jK54/video.html
The updates to the original model are the following:
- Added initial cap ex requirement
- Added franchise fees
- Switched the op ex expense inputs to hard coded year 1 numbers rather than being dependant as a percentage of EGR
- Added ability to add asset management fees to to Waterfall tab
- Added Cash on cash metrics to unlevered and levered Annual Cash Flow
- Added average Cash on Cash metric to return assumptions for project level returns
- Fixed error in cell I71 in Waterfall tab
The original post where you can download the model can be found by using the following link: www.adventuresincre.com/rv-park-acquisition-model/
You can also check out other financial modeling posts and much more on our website Adventures In CRE by clinking on the link below: www.AdventuresInCRE.com
czcams.com/video/5p_7JR4jK54/video.html
The updates to the original model are the following:
- Added initial cap ex requirement
- Added franchise fees
- Switched the op ex expense inputs to hard coded year 1 numbers rather than being dependant as a percentage of EGR
- Added ability to add asset management fees to to Waterfall tab
- Added Cash on cash metrics to unlevered and levered Annual Cash Flow
- Added average Cash on Cash metric to return assumptions for project level returns
- Fixed error in cell I71 in Waterfall tab
The original post where you can download the model can be found by using the following link: www.adventuresincre.com/rv-park-acquisition-model/
You can also check out other financial modeling posts and much more on our website Adventures In CRE by clinking on the link below: www.AdventuresInCRE.com
zhlédnutí: 684
Video
RV Park Acquisition Model Tutorial
zhlédnutí 1,5KPřed rokem
This video walks you through the A.CRE RV Park Acquisition Model. This model is meant for analyzing the acquisition of an RV Park. The RV Park Acquisition Model is comprehensive, yet simple and intuitive to use. It comes with four worksheet: a Summary tab, an Annual Cash Flow tab, Monthly Cash Flow tab, and a Waterfall module. All your project level assumptions will be put in the Summary tab an...
Condo Development Model 2.0 Update Video
zhlédnutí 1,4KPřed rokem
In this video, I do a very quick walkthrough of the changes in the Condominium Development Model from version 1.86 to 2.0. The major change is that the debt financing inputs and assumptions section has moved from the Inputs worksheet to the Summary worksheet. The original post where you can download the model can be found by using the following link: www.adventuresincre.com/condominium-developm...
Publicly Traded Tenant Analysis Tool
zhlédnutí 1,1KPřed 2 lety
This is the video walk through for the A.CRE Publicly Traded Tenant Analysis Tool. This module is meant for analyzing the health of a publicly traded tenant in a commercial real estate property. The tenant analysis tool allows for an ability to plug in key numbers from annual and quarterly reports (10-Ks and 10-Qs) to which the module will then spit out metrics to compare against industry data....
Single Family Rental Proforma
zhlédnutí 4,1KPřed 2 lety
This is the video walk through for the A.CRE Single Family Rental Proforma. This model is meant for analyzing single family rental investment opportunities. The single family rental proforma allows for an ability to model detailed acquisition assumptions, debt, a refinance option, detailed capital reserves, partnership splits, and more. Please watch the video for a full walk through and I hope ...
The Acquisition Process | Title Insurance featuring Josh Roling - Contract to Close
zhlédnutí 419Před 2 lety
Welcome to this episode of the Contract to Close series! This episode features Josh Roling, an expert in all things commercial real estate acquisitions. Josh is a close friend and colleague of mine whom I've done 48 deals with thus far! In this episode, I speak to Josh about title insurance. It's something people often forget about, and we do talk a little bit on why that is, but it is also som...
How to Calculate the Operating Expense Ratio
zhlédnutí 3,4KPřed 2 lety
In this video I show you quickly how to calculate the operating expense ratio. What is the operating expense ratio? www.adventuresincre.com/glossary/operating-expense-ratio/ Learn about other commercial real estate concepts: www.adventuresincre.com/glossary/ Become a real estate financial modeling pro: www.adventuresincre.com/accelerator/ Click to SUBSCRIBE for more: czcams.com/channels/HyxIDeb...
Updates to Pro Forma for Multifamily Renovation - v1.1
zhlédnutí 845Před 3 lety
This quick video will walk you through the updates to the Proforma for Multifamily Renovation model for version 1.1. If you haven't already, check out the video for the initial release: czcams.com/video/W2hi5Zp0RFc/video.html The new updates to the model are as follows: - Added the ability for interest only debt - Added draw schedule for loan disbursement - Added interest only period section in...
Pro Forma for Multifamily Renovation
zhlédnutí 4,3KPřed 3 lety
This is the video walk through for the A.CRE Pro Forma for Multifamily Renovation. This model is meant for acquisition opportunities that are value add. The pro forma allows for a lot of nuance through renovating / repositioning of an asset and provides great functionality to get into details as the video will demonstrate. One of the main features that I like about this model is that it gives y...
The Earnest Money Deposit - A.CRE Contract to Close Series
zhlédnutí 416Před 3 lety
In this video we will talk briefly about the earnest money deposit: what it is and how it is use during the purchase of a property. This video is part of a larger series we're doing at Adventures in CRE called the Contract to Close Series. If you'd like to see the loose transcript or visit the post on the website, you can check it out here: www.adventuresincre.com/the-earnest-money-deposit. And...
DateDif: The "Secret" Excel Formula
zhlédnutí 2,7KPřed 3 lety
In this video I walk you thorugh Excel's DateDif formula. This formula allows a user to quickly calculate how much time has passed between two dates. The DateDif formula can be utilized to quickly figure out the length of tme between two dates measured either in days, months, or years. One further interesting point about this formula is that Excel does not have it pre-stored as a recognized for...
IRR and XIRR [Different Results, Same Cash Flow?]
zhlédnutí 4,3KPřed 4 lety
In this video I explain why your XIRR and IRR values come out differently when you are applying them in the same financial model. Either the XIRR (extended internal rate of return) or IRR (internal rate of return) function is used to calculate the IRR, which is a fundamental return metric to understanding the value of almost any real estate investment. It's important to understand what they mea...
Index Match Match Explained
zhlédnutí 7KPřed 4 lety
In this video, I walk you through how to use the Microsoft Excel function Index Match Match. The video is quick and to the point and is accompanied with a downloadable template that you can follow along with on our website, www.AdventuresInCRE.com. Link is below. Index Match Match allows a user to pull a specific cell value from a field using both a header and column reference to hone in on the...
Mixed Use Development Model - Condo and Retail
zhlédnutí 7KPřed 4 lety
In this video, I walk you through my mixed use development model that is available for download on our site. This mixed use model allows you to underwrite a condo and retail development opportunity over a five year hold. It also gives you the ability to turn off the retail component entirely if you just want to simply look at a condo development opportunity only. The model contains a total of 9...
How The IRS Calculates 4% and 9% Low Income Housing Tax Credits [LIHTC]
zhlédnutí 9KPřed 4 lety
In this video, I walk you through how the IRS calculates the 4% and 9% rates for LIHTCs or Low Income Housing Tax Credits. To get straight to the point, tax credits are purchased in exchange for the ability to utilize them over a 10-year period. The IRS backs into what the annual tax credits should be by applying a discount rate to the 10 years of tax credits so that the present value of the ta...
How To Calculate Low Income Housing Tax Credits [LIHTC]
zhlédnutí 16KPřed 4 lety
How To Calculate Low Income Housing Tax Credits [LIHTC]
Adventures In CRE Audio Series [Season 2 Preview]
zhlédnutí 153Před 4 lety
Adventures In CRE Audio Series [Season 2 Preview]
Data Table Not Working? [Try This Quick Fix]
zhlédnutí 46KPřed 4 lety
Data Table Not Working? [Try This Quick Fix]
Amortization Schedule [Roll Up Monthly Data Into Annual Periods]
zhlédnutí 766Před 4 lety
Amortization Schedule [Roll Up Monthly Data Into Annual Periods]
Hotel Development Model [Walkthrough #3]
zhlédnutí 2,2KPřed 4 lety
Hotel Development Model [Walkthrough #3]
Data Tables Tutorial Series Part 1 [One Variable Data Tables]
zhlédnutí 10KPřed 4 lety
Data Tables Tutorial Series Part 1 [One Variable Data Tables]
Hotel Development Model - Vid 2 - Mezz Debt Added
zhlédnutí 1,3KPřed 4 lety
Hotel Development Model - Vid 2 - Mezz Debt Added
Rolling Up Monthly Cash Flows to Annual Cash Flows
zhlédnutí 3,2KPřed 4 lety
Rolling Up Monthly Cash Flows to Annual Cash Flows
New Hotel Acquisition Model - The Basic Model
zhlédnutí 9KPřed 4 lety
New Hotel Acquisition Model - The Basic Model
30/360, Actual/365, Actual/360 Amortization Tables [Watch Me Build]
zhlédnutí 22KPřed 5 lety
30/360, Actual/365, Actual/360 Amortization Tables [Watch Me Build]
Hotel Valuation Model 2.0 - Video 3 - Operating Cash Flow Tab
zhlédnutí 2,4KPřed 5 lety
Hotel Valuation Model 2.0 - Video 3 - Operating Cash Flow Tab
Hotel Valuation Model 2.0 - Video 2 - Cash Flow Summary Tab
zhlédnutí 3KPřed 5 lety
Hotel Valuation Model 2.0 - Video 2 - Cash Flow Summary Tab
Hotel Valuation Model 2.0 - Video 1 - Summary Tab
zhlédnutí 7KPřed 5 lety
Hotel Valuation Model 2.0 - Video 1 - Summary Tab
THNAK YOUUUUUUUUUUUUUUUUUUUUU!
Short and sweet, thanks!
Can you help with switching from condo sales to rentals
Hey, Michael. I've been looking for this feature for such a long time now. 🥲 How do you get Excel to interpret "Year 1" as the number 1 instead of text? It's such a cool display for cash flow analysis spreadsheets, please help me figure it out.
I can't believe this worked! Saved me before my exam tomorrow. Thank you!
Hi. I downloaded this model recently and the recalibration button doesn't seem to work.
saved me after a few hours, thanks!!
Legend THANKS!
I still can't fix it...even though it's automatic but the result is still the same🥲
Could not believe the solution was so simple... Thank you for the the quick and to the point solution and for saving me hours of headache!
Naw Bro - you gots to use the old school HP 12c! You wind it up like an old Ford Model T. Ha!
4 year old video, straight to the point, saved my bacon because I was banging my head against a wall. Thanks!
You are a LEGEND for making this video.
Thank you
Still not Working
This was so helpful at work today!!! Thank you ❤
OMG Thank you! I was going crazy not understanding why mine kept populating with zeros
Is there a way to incorporate the equity raised as well?
What to do if Microsoft won't even let you access the Data table? I have no forecast, no what-if analysis, nothing. And I've added on everything
Is there anyway to get these into Google Sheets without breaking them? I tried to use a converter tool, but it broke a lot of the formulas.
I really wish their spreadsheets worked in Google Sheets so I could use them. They mentioned doing this about 4 years ago, but it doesn't look like it happened.
@@luke9822 I agree!
I wanna give you a big kiss - thank you so much. Cannot believe my prof has not warned us of this
thank you!!
straight to the point. Thanks!
Wow!!! Thanks a lot. Life saver!!
What about interest reserves?
Michael, great video. Question - My assumption is that we have the interest reserve to pay for interest that becomes due each month. If this is the case, why do we model it to show interest accruing from one period to the next? Shouldn't the interest reserve just be based on the amount drawn, since we would not allow interest to accrue to the next period?
I noticed that in your NPV calculation, you are discounting the NOI figure which is after deducting Capital & FFE reserve. But when calculating the final year Terminal value (Sale price), you capitalised Ebitda (7,526,832) and not NOI. EBITDA did not deduct Capital Reserve. Shouldn't we capitalisng NOI to determine the Terminal value?
I notice that you calculate monthly interest on cumulative loan disbursements only. Your end of month balance did not include accrued interest and therefore you are not calculating interest on accumulated interest
Hi. Thanks for the note. The interest rate formula in a given cell actually uses the cumulative balance in the current period PLUS the interest charged in the previous periods to calculate the interest payment in the present period in this example, so it does actually capture the interest being accrued and charges interest on it. You can see the formula being highlighted around 3:14 of the video and here's the link to the post on our site and you can download the model as well to check it out: www.adventuresincre.com/construction-draw-schedule-calculate-ltc/. So, the aggregate total debt required is accurate and includes interest accrued and interest charged on accrued interest. Although, in retrospect, I do agree with you that I should have just added the interest to the cumulative balance. I do that in all of my models available for download on our site, but for some reason I didn't do that on this video. Why? I have no idea! So understand the confusion! Nonetheless, the math is correct. Hope that helps!
thanks you!
Hey! just wanted to say beautiful model. Especially the reformatting on the budget tab!
You are a beast.
Hi Michael, i just wonder is this model easy to add more tenants?
Thank u sir
Good stuff man. Really, great job!
Thank you 🙏
Thank you so much for this video!
I'm trying to Calculate the Actual Credit Adjustment of a LIHTC Project based in Oklahoma, finished in 2021, since it was started by 2018, the credit percentage remains as 3.27% Thanks for this video, it's very helpful!
life saver video :) thanks a lot
Fantastic video! Well done.
u have gone through it & u knew lot of people will get stuck here with same issue, u are a Jem coming out & making solution for the world
Ad for another video right on top of the formula. How annoying.
Very helpful, thanks you solved my problem
Thanks ❤
Just wondering if this model is still available? The link is broken.
Here you go: www.adventuresincre.com/construction-draw-schedule-calculate-ltc/
Hi @MichaelBelasco, in buying and renovating a hotel/motel, how much seasoning is required post-renovation to determine the new NOI of the property and therefore new valuation? Thanks!
Hi @MichaelBelasco, in buying and renovating a hotel/motel, how much seasoning is required post-renovation to determine the new NOI of the property and therefore new valuation? Thanks!
Cannot thank you enough. This was driving me crazy for hours.
Where is this software?? Have a Link??
Think you will make a model for manufactured housing where selling off the park-owned homes can be modeled? On rent-to-own schedules.
"promosm"