Skip to main content
19-Tanzanite
September 24, 2024
Solved

Total interest paid for a load L(money) over M months at an annual interest rate ia(%)

  • September 24, 2024
  • 2 replies
  • 1596 views

Hi,

Calculate the total interest paid:

Cornel_0-1727167311273.png

 

Best answer by DJF

There are of course built-in finance functions within mathcad and excel.

 

DJF_0-1727185277431.png

 

2 replies

25-Diamond I
September 24, 2024

M=240 months is wrong! M is not a time, it has to be just a number (possibly numbering the months).

In the formula for "p.mon" the definition of "m" in the exponent is missing.

Cornel19-TanzaniteAuthor
19-Tanzanite
September 24, 2024

@Werner_E wrote:

M=240 months is wrong! M is not a time, it has to be just a number (possibly numbering the months).


Yes, its the numbering/number of the months for which the load was made.

Cornel_2-1727184703071.png

 

 


@Werner_E wrote:

In the formula for "p.mon" the definition of "m" in the exponent is missing.


From where I took the problem its not written either there. But from my interpretation is like that:

Cornel_1-1727184650621.png

25-Diamond I
September 24, 2024

My point was merely that the information is garbage, as is unfortunately very often the case in so-called economic “science”.
If a quantity is dimensionless, then you can't assign a unit to it in the text either.
And if you use a variable “m” in your explanations, then you also have to say what you mean by it.
Simply replacing “m” with a “k” would be too short-sighted, you would just have to express that p.mon is dependent on “m” - in mathematics this is called a function 😉
In the formula for b.k you can then use the running variable k as a function argument.

 

But actually its just a typo and "m" should be "M" !

See my answer below.

DJF16-PearlAnswer
16-Pearl
September 24, 2024

There are of course built-in finance functions within mathcad and excel.

 

DJF_0-1727185277431.png

 

25-Diamond I
September 24, 2024

@DJF wrote:

There are of course built-in finance functions within mathcad and excel.

 

DJF_0-1727185277431.png

 


Yes, that corresponds with the formula given if we replace "m" by "M" 🙂

Werner_E_1-1727189540266.png