Все публикации

0:00:42

Sensitivity analysis with 2 or more outputs in real estate

0:00:49

Sensitivity analysis with 2 input variables in real estate

0:01:00

Calculate maximum purchase price with an amortizing loan

0:01:00

Calculate maximum purchase price with an interest only loan

0:00:40

Amortizing tenant improvement allowance in commercial real estate

0:00:46

Calculate trailing or forward-looking NOI

0:00:51

What's the main difference between IRR and Equity Multiple?

0:00:47

What is the max loan you can afford using DSCR?

0:00:43

Calculate NOI for an Office Building - Back of the Envelope

0:00:51

Calculate NOI for an apartment building - Back of the Envelope

0:00:12

How is Debt Yield calculated in commercial real estate?

0:00:42

What's the difference between GSF, RSF, and USF?

0:00:57

Transitioning from an Interest Only to Amortizing Loan in commercial real estate

0:00:59

What does positive leverage in real estate really mean?

0:00:44

What's the difference between cold and warm shell?

0:00:44

Cap Ex vs Op Ex: What is the difference in commercial real estate?

0:00:48

Estimate cumulative interest and principal paid (CUMIPMT and CUMPRINC functions)

0:00:59

Set up a real estate milestone table (Bounded Dates) in Excel

0:00:51

Estimate a loan's interest reserve - Part 1

0:00:58

Sensitivity analysis in real estate - Data Tables Part 1

0:00:58

Make a loan amortization table

0:01:00

Rent Growth in a Pro Forma - Fixed Cell References

0:00:55

How do you summarize a rent roll?

0:00:38

What are capital reserves and how do you calculate them?