Mitch Nelson
Mitch Nelson
  • Видео 8
  • Просмотров 1 214
How to use MOD Function in Excel for Financial Modeling
Thanks for watching! Please subscribe for more content.
Website: mncrec.com/
LinkedIn: www.linkedin.com/in/mitchell-p-nelson/
This video will show you how to use the MOD function in Excel for financial modeling. In this example, we take a look at a fund that needs to take monthly expenses and determine how much investors need to contribute each quarter.
Просмотров: 30

Видео

FREE Value-Add Multifamily Financial Model Template
Просмотров 876 месяцев назад
Thanks for watching! Please subscribe and like if you enjoyed the video. Interested in receiving this free template? Download it from the link below. Template: mncrec.com/value-add-multifamily-financial-model-template/ LinkedIn: www.linkedin.com/in/mitchell-p-nelson/ This video discusses how to use my value-add multifamily template. Reach out if you need any financial modeling services for your...
Monte Carlo Simulation for Financial Modeling
Просмотров 1417 месяцев назад
Thanks for watching! Please subscribe and like if you enjoyed the video. Template Link: mncrec.com/monte-carlo-simulation/ Website: mncrec.com/ LinkedIn: www.linkedin.com/in/mitchell-p-nelson/ Note: The macro will run faster if you remove the data table. This video discusses how to use data tables and macros to perform a Monte Carlo simulation using variables in your model. A Monte Carlo simula...
Real Estate Interview Financial Modeling Exam
Просмотров 5557 месяцев назад
WATCH AT 1.5X OR 2.0X FOR YOUR SANITY. Subscribe for more content! Link to PDF and answer sheet is below. PDF and Completed Model: mncrec.com/real-estate-financial-modeling-interview-exam/ Website: mncrec.com/ LinkedIn: www.linkedin.com/in/mitchell-p-nelson/ 0:00 Introduction 1:22 Assumptions tab walkthrough 3:50 Pro forma setup 7:36 Rent calculations 14:50 Occupancy and updated units formulas ...
Sensitivity Analysis for Financial Modeling
Просмотров 798 месяцев назад
Thanks for watching! Subscribe for more Excel and real estate content. Check out my website below for even more lessons. mncrec.com/ Data tables are a great tool for sensitizing financial models to evaluate performance in different scenarios. This video gives an overview of how to model both one-variable and two-variable data tables using a real estate investment as an example.
FREE Real Estate Development Budget (S-Curve + Actuals)
Просмотров 1098 месяцев назад
Thanks for watching! Get this template for free by clicking on the link below. mncrec.com/development-budget-template/ This commercial real estate development budget template is great for modeling out your construction process. Our unique equations allow you to model using the S-Curve method while also inputting actuals into the model.
FREE Rental vs. Airbnb Financial Model Template
Просмотров 1039 месяцев назад
The link to download this model is below. Feel free to reach out with any questions or suggestions! mncrec.com/free-rent-vs-short-term-rental-financial-model/ Email: mitch@mncrec.com This real estate financial model allows you to analyze a home as either a rental property or a short-term rental property. You can adjust rent, average daily rate, operating revenue and expenses, and add debt. The ...

Комментарии

  • @uhhcrave
    @uhhcrave Месяц назад

    Could you do a development proforma next? :-) would love to see that