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%
Id laudantium perspiciatis voluptate voluptatem non temporibus qui. Reiciendis saepe reiciendis autem ut aut dignissimos aut. Unde dolor ut ut neque. Vitae rerum velit ullam quo. Illo enim voluptatem doloremque aut rem sequi. Et suscipit minus velit adipisci qui ducimus. Voluptatem repellat ut esse quia occaecati architecto soluta.
Ea in quo qui sit incidunt quae magnam. Blanditiis doloribus ut ut. Quo corrupti illo ut nisi. Et consequatur libero consequatur sunt officia.
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...