MHB How can I generate a complex loan ammortization schedule with specified figures?

  • Thread starter Thread starter dzweber
  • Start date Start date
  • Tags Tags
    Complex
AI Thread Summary
To generate a complex loan amortization schedule for a $390,000 loan with three annual payments of $10,000 each, starting on July 5, 2015, and amortized over 30 years, an interest rate must be specified. A suggested annual interest rate is approximately 6.5%, assuming total annual payments of $30,000. The irregular payment dates complicate the use of standard formulas for amortization. A computer program or spreadsheet is recommended to accurately calculate and print the amortization schedule. Providing the interest rate will enable more precise assistance with the calculations.
dzweber
Messages
2
Reaction score
0
How would I create a complex loan ammortization schedule for the following figures

$390,000 Loan

(3) payments of $10,000 each year on Jan 5th, July 5th and Oct 5th

First Payment on July 5th 2015

Ammortized over 30yrs
 
Mathematics news on Phys.org
dzweber said:
How would I create a complex loan ammortization schedule for the following figures

$390,000 Loan

(3) payments of $10,000 each year on Jan 5th, July 5th and Oct 5th

First Payment on July 5th 2015

Ammortized over 30yrs

Hi dzweber! Welcome to MHB! (Smile)

We ask that our users show their progress (work thus far or thoughts on how to begin) when posting questions. This way our helpers can see where you are stuck or may be going astray and will be able to post the best help possible without potentially making a suggestion which you have already tried, which would waste your time and that of the helper.

Can you post what you have done so far?
 
Not even sure where to start with a formula. Hoping for a spreadsheet referal
 
dzweber said:
How would I create a complex loan ammortization schedule for the following figures

390,000 Loan

(3) payments of 10,000 each year on Jan 5th, July 5th and Oct 5th

First Payment on July 5th 2015

Ammortized over 30yrs
Problem: you didn't specify an interest rate

Anyway, assuming an annual payment of 30,000,
an annual rate of ~6.5% needs to be the loan's rate.

But regardless of all that, no formula can be used
using those weird payment dates.

If you need an amortization schedule, then you need a
computer program to do the calculations and appropriate
schedule printing.

I'll gladly help...once you supply a rate!
 
Thread 'Video on imaginary numbers and some queries'
Hi, I was watching the following video. I found some points confusing. Could you please help me to understand the gaps? Thanks, in advance! Question 1: Around 4:22, the video says the following. So for those mathematicians, negative numbers didn't exist. You could subtract, that is find the difference between two positive quantities, but you couldn't have a negative answer or negative coefficients. Mathematicians were so averse to negative numbers that there was no single quadratic...
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
Thread 'Unit Circle Double Angle Derivations'
Here I made a terrible mistake of assuming this to be an equilateral triangle and set 2sinx=1 => x=pi/6. Although this did derive the double angle formulas it also led into a terrible mess trying to find all the combinations of sides. I must have been tired and just assumed 6x=180 and 2sinx=1. By that time, I was so mindset that I nearly scolded a person for even saying 90-x. I wonder if this is a case of biased observation that seeks to dis credit me like Jesus of Nazareth since in reality...
Back
Top