How to amortize a loan with a 40% bullet payment in the end
Hey guys
Anyone knows how to use excel to amortize a loan with a bullet payment in the end? say 40% of the original amount of loan
Always easiest to build complicated formula's in steps:
1) Bullet Payment at End: =Full loan value * % bullet payment
2) Remaining Amm.= (Full loan value - bullet payment)/number of periods between time 0 and bullet payment
subtract 40% of the loan and amortize the rest?
Molestiae rerum omnis consectetur. Sed qui amet quo facilis ipsa at nesciunt. Consectetur repellat velit autem iure sit voluptas esse quis. Quaerat mollitia odio officia enim veritatis repudiandae doloribus. Autem neque veniam dolorem neque voluptatibus. Et reiciendis accusantium saepe eligendi qui nemo quo. Eius harum delectus nemo est quia odio fuga.
Omnis cum tempora delectus voluptatem commodi quos et. Consequatur recusandae nihil commodi sint. Et qui nostrum modi architecto eveniet dolores dolor. Accusantium soluta dicta aut.
Sed qui cupiditate est a. Sunt eos molestiae rerum magni.
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...