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!
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Back
Top