Having worked at Hines in London, your advanced financial modelling was the best learning content I have ever come across. Talk about cutting corners. Respect
Very informative video is. I'd like to know how you estimate the operating expenses, including average expence amount or ratio of the example property.
Hey Nayef, yes - you would likely have some more detail on the construction costs line item in your capital expenses, but this will still be the general format.
Break Into CRE 2 last questions Justin and I really appreciate your help. 1st question: is there a formula like cumpmt to calculate the interest pmt based on the debt outstanding balance and ( the principal will be paid off only in last month ending after selling the developed RE project) or shall I proceed with my manual model to do it 2nd question: if I want to subscribe now in the annual subscription and start later (after 2 or 3 months) is there an option or shall I wait till that time? cuz I have the money now but I don’t have time for 2 months
@@nayefalomar297 1. Yes, the equivalent of CUMPRINC for principal payments is CUMIPMT. Alternatively, you could also calculate the interest payment every month by just taking your interest rate divided by 12, and then multiplying that by your outstanding loan balance every month. 2. I would wait until that time. Your annual payment covers 12 months that starts at the time you enroll, so I'd recommend waiting until you have the time to work through the material. Hope to see you in there in 2020!
@@BreakIntoCRE I can not wait till 2020 I just have subscribed in the annual plan and will do my best to find time going through the courses thanks Justin for this amazing website
Having worked at Hines in London, your advanced financial modelling was the best learning content I have ever come across. Talk about cutting corners. Respect
this is not a Cash Flow statement but an Operating Statement/Income Statement
Very informative video is. I'd like to know how you estimate the operating expenses, including average expence amount or ratio of the example property.
Very interesting video.
keen to learn property/owner operator companies 3 statements
Hello Justin
what if it was a development infrastructure project will it be the same way to structure the cash flow statement?
Hey Nayef, yes - you would likely have some more detail on the construction costs line item in your capital expenses, but this will still be the general format.
Break Into CRE
2 last questions Justin and I really appreciate your help.
1st question:
is there a formula like cumpmt to calculate the interest pmt based on the debt outstanding balance and ( the principal will be paid off only in last month ending after selling the developed RE project) or shall I proceed with my manual model to do it
2nd question:
if I want to subscribe now in the annual subscription and start later (after 2 or 3 months) is there an option or shall I wait till that time? cuz I have the money now but I don’t have time for 2 months
@@nayefalomar297 1. Yes, the equivalent of CUMPRINC for principal payments is CUMIPMT. Alternatively, you could also calculate the interest payment every month by just taking your interest rate divided by 12, and then multiplying that by your outstanding loan balance every month.
2. I would wait until that time. Your annual payment covers 12 months that starts at the time you enroll, so I'd recommend waiting until you have the time to work through the material.
Hope to see you in there in 2020!
@@BreakIntoCRE I can not wait till 2020 I just have subscribed in the annual plan and will do my best to find time going through the courses
thanks Justin for this amazing website
@@nayefalomar297 great to have you in the program!
Y don't u explain with finger
Talk too fast