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

  • Context: MHB 
  • Thread starter Thread starter dzweber
  • Start date Start date
  • Tags Tags
    Complex
Click For Summary

Discussion Overview

The discussion revolves around generating a complex loan amortization schedule for a specified loan amount, payment structure, and amortization period. Participants are exploring the necessary components and formulas required to create this schedule, including the impact of payment dates and interest rates.

Discussion Character

  • Technical explanation
  • Homework-related
  • Debate/contested

Main Points Raised

  • One participant inquires about creating an amortization schedule for a $390,000 loan with specific payment dates and amounts.
  • Another participant emphasizes the importance of showing prior work or thoughts to facilitate better assistance.
  • A participant expresses uncertainty about starting with a formula and requests a spreadsheet reference.
  • One participant points out the lack of an interest rate in the original question and suggests that an annual payment of $30,000 with a rate of approximately 6.5% could be assumed.
  • This participant also notes that the unusual payment dates complicate the use of a standard formula for amortization.
  • They offer to assist further once an interest rate is provided.

Areas of Agreement / Disagreement

There is no consensus on how to proceed with the amortization schedule due to the lack of specified interest rates and the complexity introduced by the payment dates. Multiple viewpoints on how to approach the problem are present.

Contextual Notes

The discussion highlights the need for clarity on the interest rate and the implications of the specified payment schedule on the amortization calculations. There are unresolved aspects regarding the formula and methodology to be used.

Who May Find This Useful

Individuals interested in financial modeling, loan calculations, or those seeking assistance with amortization schedules may find this discussion relevant.

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
 
Physics 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!
 

Similar threads

Undergrad Can calculus be used to determine how much total interest I would pay?
  • · Replies 20 ·
Replies
20
Views
3K
How Do Loan Repayments Impact Differential Equations?
  • · Replies 15 ·
Replies
15
Views
3K
Comp Sci Complexity for generating strings of length k from CNF grammar
  • · Replies 3 ·
Replies
3
Views
2K
Undergrad How Many Unique Games of Commander Can Be Played?
  • · Replies 4 ·
Replies
4
Views
3K
How can I be really fast at maths?
  • · Replies 8 ·
Replies
8
Views
2K
Studying Help How do I raise my GPA? I have a full schedule with hard classes
  • · Replies 9 ·
Replies
9
Views
3K
Graduate Three generations of Fermions from octonions Clifford alegbras
  • · Replies 61 ·
3
Replies
61
Views
9K
How to Create an Amortization Table for a Mortgage Loan with Blended Payments
  • · Replies 8 ·
Replies
8
Views
5K
Can Public Loan Investments Drive Altruistic Public Goods?
  • · Replies 4 ·
Replies
4
Views
5K
How Can I Improve My DIY Van de Graaff Generator to Prevent Charge Leakage?
  • · Replies 5 ·
Replies
5
Views
2K