cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

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

Cornel
19-Tanzanite

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

Hi,

Calculate the total interest paid:

Cornel_0-1727167311273.png

 

ACCEPTED SOLUTION

Accepted Solutions
DJF
16-Pearl
16-Pearl
(To:Cornel)

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

 

DJF_0-1727185277431.png

 

View solution in original post

7 REPLIES 7
Werner_E
25-Diamond I
(To:Cornel)

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.

Cornel
19-Tanzanite
(To:Werner_E)


@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

Werner_E
25-Diamond I
(To:Cornel)

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.

Cornel
19-Tanzanite
(To:Werner_E)

Yes, it think its better to forget this problem. This problem I found somewhere, and it seems to me interesting at first sight as it is related to real life. Think about when someone make a mortgage/load when someone buy a house. But anyway, lets forget about this problem.

Werner_E
25-Diamond I
(To:Cornel)

As DJF pointed out, mot programs have a built-in function for those kind of calculations.

The scan you showed is sloppily formulated and also contains a typing error (m > M)

But essentially its the correct formula (one can argue about the sign, if the result should be positive or negative).

See my answer here Solved: Re: Total interest paid for a load L(money) over M... - PTC Community

DJF
16-Pearl
16-Pearl
(To:Cornel)

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

 

DJF_0-1727185277431.png

 

Werner_E
25-Diamond I
(To:DJF)


@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

 

 

Announcements

Top Tags