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?
Et et nihil sed non. Alias aperiam sit pariatur est. Magnam minus dolores et sit.
Totam maiores sed ad. Atque voluptas rerum est perferendis eveniet harum.
Occaecati repellendus ut sed esse debitis. Vel rerum ex dicta possimus enim dolores. Voluptas dolorum quia sit saepe facilis numquam iure. Mollitia nihil non odio asperiores.
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...