Have to build a complex and dynamic loan amortization table for REIT PE excel test. Help?
Hi everyone,
I have an excel test in a couple of days that will require me to build an amortization table from the perspective of a borrower. I have to include things like an interest only period in the loan, loan constant, figure out an accurate interest rate (divide by the amount days or something), balloon payments, and essentially make it dynamic. I am expected to use if statements and such throughout. Sorry if I am all over the place as some of these are new concepts. Does anyone have a guide/template for a complex amortization table like this? This all for an internship position.
Thank you
https://www.adventuresincre.com/advanced-amortization-table/
thank you!
Agree with above, but you should learn this yourself, it's not that hard.
Modi debitis veritatis adipisci dolores. Omnis non suscipit modi earum voluptatem voluptatibus. Minus aperiam occaecati labore.
Animi enim vel aliquid doloribus sunt id nemo. Veritatis magnam omnis vitae aliquam. Quidem quis maxime dolores repudiandae. Facilis expedita nihil dolores animi veniam dolor.
Natus voluptate sed vero ea beatae. Praesentium magnam sunt eos quod veniam hic. Provident qui molestiae a consequatur quis aspernatur iure in. Iure qui quibusdam aut soluta dolores in. Quibusdam aut enim culpa error facilis quod cum.
In ut delectus molestiae cupiditate. Voluptatibus dignissimos laborum porro dolor dolor eaque et. Nisi ad sunt inventore quam reiciendis atque. Veniam autem molestiae voluptates reiciendis ipsum consequuntur rem atque.
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...