Fat Pitch Posted November 23, 2014 Share Posted November 23, 2014 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 Link to comment Share on other sites More sharing options...
Fat Pitch Posted November 23, 2014 Author Share Posted November 23, 2014 I may have solved my issue...updated version attached.Updated_Commercial_RE_Project.xlsx Link to comment Share on other sites More sharing options...
Fat Pitch Posted November 24, 2014 Author Share Posted November 24, 2014 Nope, this version is actually the tried and true correct way to calculate the levered and unlevered IRR.Project_Financials.xlsx Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now