Commercial RE Project - Unlevered v Levered IRR Calculation

[Fat Pitch]

Hey all!

 

Right now I am working on a Commercial RE project viability excel. However I am having trouble with the levered v unlevered IRR calculation. I have attached the excel to this posting and the calculation error can be found on tab #2 called "cash flow".

 

I know it has to do with how I am reporting NOI with the loan.

 

Thanks everyone, I greatly appreciate it!

 

Commercial_Real_Estate_Project_Excel.xlsx

[Fat Pitch]

I may have solved my issue...updated version attached.

Updated_Commercial_RE_Project.xlsx

[Fat Pitch]

Nope, this version is actually the tried and true correct way to calculate the levered and unlevered IRR.

Project_Financials.xlsx