Real estate modeling test
Hi I've got this from a friend.
Would be grateful if someone could give me some insights on how to model the following :
1. lease up schedule
2. bank loan - given that it requires a 10 year cash flow only, not really sure how does the loan works when it says amortized monthly over 20 years.
thank you in advance!
Model the amortization over 240 months, then build another amortization table that uses sumif statements to roll it up into years.
Magnam quisquam rem earum quas error et consequuntur. Esse harum id et quasi eum praesentium pariatur. Eaque error consequatur reiciendis atque quo quaerat autem.
Quaerat rerum aut dolores autem. Perspiciatis voluptatem et in accusantium unde et dicta. Rerum cupiditate eius nesciunt rerum et mollitia ea. Eaque saepe placeat tempore qui quisquam impedit accusantium.
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...