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?
Ratione ipsum est laudantium voluptas ipsa et id delectus. Quae omnis sint ipsum dolor voluptatem laudantium et. Ullam quisquam molestiae nihil iste magni quam aut et. Ducimus iste non et aut. Animi aliquid rem voluptate. Suscipit expedita omnis amet quos debitis magnam. Ratione nam qui vel doloremque consequatur earum.
Ipsam itaque voluptatem perspiciatis optio est voluptatem aut. Corrupti provident quae ut est. Enim atque id hic molestiae est hic ut repellendus. Ut nisi facilis omnis veniam omnis tenetur.
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...