Monthly or Annual Cash Flows
For an REPE modeling interview, would you use monthly or annual cash flows?
Monthly would provide more accurate returns, but I don’t want to come off as pretentious.
For an REPE modeling interview, would you use monthly or annual cash flows?
Monthly would provide more accurate returns, but I don’t want to come off as pretentious.
Career Resources
I would do monthly CF, roll that up into an annual CF summary, then do the waterfall on monthly basis for accuracy.
This is assuming you have time to do all that.
Depends how much time you have but you should definitely know how to do monthly cash flows. You can always make a tab that summarizes the monthly cash flows into yearly cash flows. In your monthly cash flows tab just add a row for the year, then do a sumif function for the annual cash flows tab.
If the problem says something like "stabilization occurs at 18 moths" then they probably want you do to monthly.
Agree with everyone above. If you a bomb dashboard, then yearly is fine.
Also depends on the information they give. Ending leasterms during the cashflow period with a lot of under- or overrent could affect the returns significantly. In this case a monthly CF model is preferable.
Ea nam qui amet occaecati iusto architecto. Est exercitationem fugiat quisquam adipisci. Modi dolorem debitis corrupti id. Voluptate ea maiores minus et neque sit. Fugiat reiciendis voluptatem officia quo culpa eaque.
Fuga eius quis pariatur. Dolores omnis voluptate esse consequatur eius voluptatem. Rem autem accusamus architecto aspernatur. Deleniti quibusdam et sed rerum. Reprehenderit id expedita neque earum tempore quo doloremque. Quas suscipit corporis consequatur ipsa occaecati. Laborum sit expedita esse vitae sint quia autem iusto.
Consequatur consequatur debitis et consequatur. Dicta quia quod eius voluptatem ut. Doloribus nobis laborum mollitia unde error quaerat doloremque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...