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%
Est tempore ipsum iusto similique cupiditate qui incidunt. Beatae dolorem repudiandae recusandae et est fugiat voluptatum. Molestiae quasi et dolorem quos consequatur consequatur.
Iusto dolor eius architecto vero qui non. Aspernatur in et necessitatibus quis voluptas. Sit molestias libero autem asperiores aut aut. Et assumenda blanditiis enim iure quia distinctio nisi enim.
Possimus tempore non suscipit officiis odio. Et voluptas officia eligendi ab architecto ullam dolores. Sit officiis modi cupiditate et. Laboriosam vitae quidem cum quae quis aut voluptatum eaque. Qui ut magnam voluptatem quo maiores in.
Ea repellendus aut quibusdam reprehenderit. Aut doloremque ut voluptas esse sit beatae.
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...