The Real Estate Financial Modeling Interview Exam Guide

/.../7. Exam #5 - The ARGUS Export Modeling Exam/

8. CUMIPMT & CUMPRINC.mp4

8. CUMIPMT & CUMPRINC.srt

15. Average Cash-on-Cash Return Modeling with Variable Hold Periods.srt

6. Dynamic Purchase & Sale Metric Modeling & Cash Outflow Formatting.srt

5. How To Build Out Ten Years of Cash Flows in 5 Minutes.srt

21. Solving For Target IRR - Property Valuation Method.srt

11. How To Format a Model in Less Than 5 Minutes.srt

3. Building Out Dynamic Annual Cash Flow Roll-Up Dates.srt

17. Using Cash Flows To Determine Asset Stabilization.srt

14. Unlevered & Levered IRR & Equity Multiple Modeling.srt

9. Dynamic Loan Payoff Modeling.srt

19. Calculating Value CAGR.srt

12. Going-In Cap Rate, Debt Yield, & DSCR.srt

2. ARGUS Export Exam Overview.srt

4. Building Out Dynamic Line Items.srt

20. Modeling LTV at Exit.srt

7. Cash Flow Before Debt Service & CF Timing Collars.srt

10. Cash Flow After Debt Service & Cash Flow Collars - Part 2.srt

18. Using Cash Flows To Determine Reimbursement Structures.srt

1. ARGUS Export Exam Introduction.srt

16. Cash-on-Cash Formula Update.html

13. Unlevered & Levered Equity Multiple - Update.html

22. Check-In - DONE..html

15. Average Cash-on-Cash Return Modeling with Variable Hold Periods.mp4

6. Dynamic Purchase & Sale Metric Modeling & Cash Outflow Formatting.mp4

5. How To Build Out Ten Years of Cash Flows in 5 Minutes.mp4

21. Solving For Target IRR - Property Valuation Method.mp4

17. Using Cash Flows To Determine Asset Stabilization.mp4

11. How To Format a Model in Less Than 5 Minutes.mp4

14. Unlevered & Levered IRR & Equity Multiple Modeling.mp4

19. Calculating Value CAGR.mp4

12. Going-In Cap Rate, Debt Yield, & DSCR.mp4

3. Building Out Dynamic Annual Cash Flow Roll-Up Dates.mp4

20. Modeling LTV at Exit.mp4

9. Dynamic Loan Payoff Modeling.mp4

7. Cash Flow Before Debt Service & CF Timing Collars.mp4

2. ARGUS Export Exam Overview.mp4

10. Cash Flow After Debt Service & Cash Flow Collars - Part 2.mp4

4. Building Out Dynamic Line Items.mp4

18. Using Cash Flows To Determine Reimbursement Structures.mp4

1. ARGUS Export Exam Introduction.mp4

/

TutsNode.com.txt

[TGx]Downloaded from torrentgalaxy.to .txt

/1. Introduction/

4.1 Real Estate Financial Modeling Exam Guide.xlsx

1. Introduction.srt

4. DOWNLOAD ME FIRST!.html

5. Disclaimer.html

2. What We Will Cover.srt

3. About The Instructor & This Course.srt

2. What We Will Cover.mp4

3. About The Instructor & This Course.mp4

1. Introduction.mp4

/.../3. Exam #1 - The Excel-Focused Assessment/

13. How To Return Values If Two or More Values Are True.srt

1. How To Find Values Using HLOOKUP.srt

6. INDEX & MATCH For Dynamic Cell Selection.srt

4. How To Count Select Cells With COUNTIFS.srt

25. Creating Data Tables To Sensitize Returns Based On Multiple Criteria.srt

7. How To Sum Cash Flows For Only Certain Years.srt

24. Using INDIRECT For Dynamic Sum Ranges (ADVANCED).srt

9. How To Sum All Negative (or Positive) Cash Flows.srt

23. Using Goal Seek To Solve For a Target IRR.srt

11. How To Find The Maximum Value in Any Data Array.srt

5. Creating A Test Using IF Statements.srt

2. How To Use VLOOKUP With Dynamic Month Toggles.srt

15. Modeling Weighted Average Rents.srt

19. Using Goal Seek To Determine Necessary Investment Growth Rates.srt

18. Calculating The Future Value of a Real Estate Investment.srt

3. How To Call Out Cells Automatically Using Conditional Formatting.srt

14. How To Return Values If AT LEAST One Criteria Is True.srt

20. Simple IRR Calculations.srt

10. How To Sum All Cash Flows In A Specific Year.srt

21. Calculating The XIRR With Uneven Dates.srt

26. Check-In - How Are You Feeling So Far.html

12. Dynamic Cash Flow Selection.srt

22. NPV vs. XNPV.srt

8. How To Count The Number of Negative Cash Flows.srt

17. How To Calculate Rent Differentials (MAX & MIN).srt

16. How To Round Values.srt

13. How To Return Values If Two or More Values Are True.mp4

6. INDEX & MATCH For Dynamic Cell Selection.mp4

1. How To Find Values Using HLOOKUP.mp4

4. How To Count Select Cells With COUNTIFS.mp4

7. How To Sum Cash Flows For Only Certain Years.mp4

24. Using INDIRECT For Dynamic Sum Ranges (ADVANCED).mp4

25. Creating Data Tables To Sensitize Returns Based On Multiple Criteria.mp4

15. Modeling Weighted Average Rents.mp4

23. Using Goal Seek To Solve For a Target IRR.mp4

5. Creating A Test Using IF Statements.mp4

10. How To Sum All Cash Flows In A Specific Year.mp4

14. How To Return Values If AT LEAST One Criteria Is True.mp4

19. Using Goal Seek To Determine Necessary Investment Growth Rates.mp4

2. How To Use VLOOKUP With Dynamic Month Toggles.mp4

3. How To Call Out Cells Automatically Using Conditional Formatting.mp4

18. Calculating The Future Value of a Real Estate Investment.mp4

12. Dynamic Cash Flow Selection.mp4

8. How To Count The Number of Negative Cash Flows.mp4

17. How To Calculate Rent Differentials (MAX & MIN).mp4

22. NPV vs. XNPV.mp4

9. How To Sum All Negative (or Positive) Cash Flows.mp4

16. How To Round Values.mp4

11. How To Find The Maximum Value in Any Data Array.mp4

21. Calculating The XIRR With Uneven Dates.mp4

20. Simple IRR Calculations.mp4

/.../6. Exam #4 - The Commercial Real Estate Cash Flow Modeling Exam/

2. Modeling Dynamic Cash Flow Dates.srt

6. Modeling Purchase & Sale Metrics.srt

5. Modeling Dynamic Renovation Timing.srt

9. Dynamic Loan Payoff & Levered Net Cash Flow Modeling.srt

8. Dynamic Principal & Interest Payments.srt

4. Modeling Vacancy, Expenses, & NOI.srt

10. Model Clean-Up & Cash Flow Date Collars Using IF Statements.srt

3. Dynamic Monthly GPR Growth.srt

11. Model Formatting.srt

1. CRE Cash Flow Modeling Exam Overview.srt

12. Modeling Unlevered & Levered IRR.srt

17. Modeling Break Even Percentage & The Operating Expense Ratio.srt

7. Modeling Loan Proceeds & Origination Fees.srt

13. Calculating Going-In Cap Rates Using Annualized Monthly NOI.srt

15. Calculating Cash-on-Cash Returns for Specific Years (Dynamically).srt

16. Calculating Going-In DSCR & Debt Yield.srt

14. Modeling The Unlevered & Levered Equity Multiple.srt

18. How To Use Goal Seek To Value a Property Based on IRR Targets.srt

19. Check-In - The Home Stretch.html

6. Modeling Purchase & Sale Metrics.mp4

9. Dynamic Loan Payoff & Levered Net Cash Flow Modeling.mp4

5. Modeling Dynamic Renovation Timing.mp4

10. Model Clean-Up & Cash Flow Date Collars Using IF Statements.mp4

8. Dynamic Principal & Interest Payments.mp4

2. Modeling Dynamic Cash Flow Dates.mp4

11. Model Formatting.mp4

4. Modeling Vacancy, Expenses, & NOI.mp4

3. Dynamic Monthly GPR Growth.mp4

12. Modeling Unlevered & Levered IRR.mp4

1. CRE Cash Flow Modeling Exam Overview.mp4

17. Modeling Break Even Percentage & The Operating Expense Ratio.mp4

13. Calculating Going-In Cap Rates Using Annualized Monthly NOI.mp4

7. Modeling Loan Proceeds & Origination Fees.mp4

15. Calculating Cash-on-Cash Returns for Specific Years (Dynamically).mp4

14. Modeling The Unlevered & Levered Equity Multiple.mp4

16. Calculating Going-In DSCR & Debt Yield.mp4

18. How To Use Goal Seek To Value a Property Based on IRR Targets.mp4

/.../5. Exam #3 - The Commercial Real Estate Lease Modeling Exam/

3. Calculating Future Lease-Up TI Amounts.srt

5. Calculating Future Lease Dates With Dynamic Downtime.srt

15. Calculating Future Percentage Rent Payments (with Inflation).srt

2. Calculating Lease Rent Growth.srt

10. Calculating Leasing Commissions For New Leases.srt

13. Calculating Future Base Rent.srt

12. Calculating Leasing Commissions Based on Renewal Probability.srt

11. Modeling Renewal Leasing Commissions.srt

9. Modeling Hybrid Reimbursement Structures.srt

4. Modeling Future Lease-Up Rent.srt

8. Base Year Stop Modeling.srt

7. NNN & FSG Lease Modeling.srt

6. Modeling The Pro Rata Share.srt

14. Calculating Percentage Rent Breakpoints.srt

1. CRE Lease Modeling Exam Introduction.srt

16. Check-In - Over The Hump.html

3. Calculating Future Lease-Up TI Amounts.mp4

5. Calculating Future Lease Dates With Dynamic Downtime.mp4

2. Calculating Lease Rent Growth.mp4

15. Calculating Future Percentage Rent Payments (with Inflation).mp4

9. Modeling Hybrid Reimbursement Structures.mp4

10. Calculating Leasing Commissions For New Leases.mp4

8. Base Year Stop Modeling.mp4

11. Modeling Renewal Leasing Commissions.mp4

12. Calculating Leasing Commissions Based on Renewal Probability.mp4

7. NNN & FSG Lease Modeling.mp4

4. Modeling Future Lease-Up Rent.mp4

13. Calculating Future Base Rent.mp4

6. Modeling The Pro Rata Share.mp4

14. Calculating Percentage Rent Breakpoints.mp4

1. CRE Lease Modeling Exam Introduction.mp4

/.../2. How To Ace Your Real Estate Financial Modeling Interview Exam - The Five Keys/

4. What Employers Are Looking For - Part 4.srt

1. What Employers Are Looking For - Part 1.srt

6. Modeling Best Practices For Interview Day.srt

2. What Employers Are Looking For - Part 2.srt

5. What Employers Are Looking For - Part 5.srt

3. What Employers Are Looking For - Part 3.srt

1. What Employers Are Looking For - Part 1.mp4

6. Modeling Best Practices For Interview Day.mp4

2. What Employers Are Looking For - Part 2.mp4

5. What Employers Are Looking For - Part 5.mp4

3. What Employers Are Looking For - Part 3.mp4

4. What Employers Are Looking For - Part 4.mp4

/.../4. Exam #2 - The Real Estate Finance Exam/

1. Calculating Monthly Debt Service.srt

8. Calculating Dynamic Cash-on-Cash Returns in Singular Years.srt

19. Using Goal Seek To Calculate Minimum Acceptable Base Rent.srt

2. Calculating Balloon Payments at the End of the Loan Term.srt

6. Calculating The Levered Equity Multiple.srt

15. Calculating The Break Even Ratio.srt

17. Calculating Variable Leasing Commissions.srt

18. Calculating TI Allowance & Return on Cost.srt

3. Modeling Debt Yield & DSCR.srt

13. How To Calculate a Loan Constant.srt

9. Sensitizing IRR Based on Cap Rate & LTV.srt

4. Calculating LTV Based on Cap Rate Valuation.srt

12. How To Calculate Future NOI WITHOUT Built-In Cash Flows.srt

14. How To Calculate Cash-on-Cash Returns With IO Loans.srt

7. Calculating The Levered IRR Using XIRR.srt

10. Calculating The Going-In Cap Rate.srt

5. Modeling Loan Sizing Based on DSCR.srt

11. Calculating The Total Monthly Loan Payment.srt

16. Calculating The Operating Expense Ratio.srt

20. Check-In - Exam #2 Complete!.html

8. Calculating Dynamic Cash-on-Cash Returns in Singular Years.mp4

1. Calculating Monthly Debt Service.mp4

6. Calculating The Levered Equity Multiple.mp4

2. Calculating Balloon Payments at the End of the Loan Term.mp4

19. Using Goal Seek To Calculate Minimum Acceptable Base Rent.mp4

15. Calculating The Break Even Ratio.mp4

7. Calculating The Levered IRR Using XIRR.mp4

17. Calculating Variable Leasing Commissions.mp4

3. Modeling Debt Yield & DSCR.mp4

18. Calculating TI Allowance & Return on Cost.mp4

9. Sensitizing IRR Based on Cap Rate & LTV.mp4

13. How To Calculate a Loan Constant.mp4

14. How To Calculate Cash-on-Cash Returns With IO Loans.mp4

12. How To Calculate Future NOI WITHOUT Built-In Cash Flows.mp4

5. Modeling Loan Sizing Based on DSCR.mp4

4. Calculating LTV Based on Cap Rate Valuation.mp4

11. Calculating The Total Monthly Loan Payment.mp4

10. Calculating The Going-In Cap Rate.mp4

16. Calculating The Operating Expense Ratio.mp4

/8. Wrapping Up/

2. What To Do Next.srt

1. How To Use This Information.srt

2. What To Do Next.mp4

1. How To Use This Information.mp4

/.pad/

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

Total files 332