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

[dzweber]

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

 

[I like Serena]

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?

 

[dzweber]

Not even sure where to start with a formula. Hoping for a spreadsheet referal

 

[Wilmer]

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!