Mortgage Math Q - Given fixed principal pmt, what is equivalent schedule?
I'm having a brain fart.
- $30,000,000 loan
- 6% interest rate
- $60,000 monthly principal payments, fixed amount
I'm trying to answer the question "what is the equivalent amortization schedule of this?" Aka, 20 years, 25 years, 30 years? i guess it changes over time as the loan balance decreases, but what would it be out the gates at Y0?
I know that the mortgage constant = 8.40%, but am stuck.
- Annual Interest = 6%*$30M = $1.8M
- Annual Principal = $720,000
- Annual Debt Service = $2,520,000
- Debt Constant = $2.52 / $30M = 8.4%
Voluptatem enim fugiat sunt. Tempora fugit occaecati magni non quibusdam. Voluptatem qui enim nobis et temporibus tempore tenetur veritatis. Doloremque at consequuntur cupiditate modi quis.
Quia optio praesentium hic eum velit dolores. Est est vel amet. Itaque amet dolores laborum placeat repellat minus.
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...