Results 1 to 14 of 14

Math Help - Problems Calcuating Interest (Time value of money)

  1. #1
    Member
    Joined
    Jan 2010
    Posts
    144

    Question Problems Calcuating Interest (Time value of money)

    I have concerns regarding questions attached.

    2.13 - Can someone verify my results, am I doing this question correctly? (See 2nd attachment)

    2.17 - I'm not sure how to do this one, I think I understand what I need to do in my head I'm just having trouble working out the math.

    Firstly, what do they mean by effective interest rate? Is it still compounded monthly?

    Here is my attempt at the single payment option:

    F = 3000*(1+0.12) = 3360

    Is this correct?

    I'm not sure how to deal with the 12 payments as opposed to one single payment at the end. If we assumed one single payment at the end it would be as follows,

    F = 3000(1+0.12)^{12}

    How do I deal with 12 equal payments effectively decreasing the balance on which compounding interest is collected each month?

    Thanks again!
    Attached Thumbnails Attached Thumbnails Problems Calcuating Interest (Time value of money)-2.13-17q.jpg   Problems Calcuating Interest (Time value of money)-2.13at.jpg  
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Senior Member MaxJasper's Avatar
    Joined
    Aug 2012
    From
    Canada
    Posts
    482
    Thanks
    54

    Lightbulb Re: Problems Calcuating Interest (Time value of money)

    #2.13 (a) :: 19.56%
    #2.13 (b) :: $1307.34-$1000=$307.34

    #2.17 :: $266.55*12-$265.6*12=$17.16

    NB.: Might contain my own discounts!
    Last edited by MaxJasper; September 12th 2012 at 03:01 PM.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Member
    Joined
    Jan 2010
    Posts
    144

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by MaxJasper View Post
    #2.13 (a) :: 19.56%
    #2.13 (b) :: $1307.34-$1000=$307.34

    #2.17 :: $266.55*12-$265.6*12=$17.16

    NB.: Might contain my own discounts!
    Could you explain how you obtained those numbers for 2.17, I am still quite confused.

    It's not obvious to me how you came up with $266.55*12-$265.6*12. What formula is that? How did you obtain the values 266.55 & 265.6?

    Thank you!
    Last edited by jegues; September 12th 2012 at 04:47 PM.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,094
    Thanks
    67

    Re: Problems Calcuating Interest (Time value of money)

    2.13:
    307.34 is correct
    For effective rate, you only need to do this: 1.015^12 - 1 = 1.195618... - 1 = .195618 ; so ~19.56%

    2.17 :
    required monthly payment = 266.55 ; 266.55 * 12 = 3198.60
    single payment 1 year later at 12% effective: 3360.00 (which you have correctly)
    3360.00 - 3198.60 = 161.40 = interest saved

    Calculation of the monthly payment:
    3000 * .01 / (1 - 1/1.01^12) = 266.54636....
    Last edited by Wilmer; September 12th 2012 at 07:35 PM.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Member
    Joined
    Jan 2010
    Posts
    144

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by Wilmer View Post
    2.13:
    307.34 is correct
    For effective rate, you only need to do this: 1.015^12 - 1 = 1.195618... - 1 = .195618 ; so ~19.56%

    2.17 :
    required monthly payment = 266.55 ; 266.55 * 12 = 3198.60
    single payment 1 year later at 12% effective: 3360.00 (which you have correctly)
    3360.00 - 3198.60 = 161.40 = interest saved

    Calculation of the monthly payment:
    3000 * .01 / (1 - 1/1.01^12) = 266.54636....
    Thank you that is much more clear.

    Could you express the formula for monthly payment in terms of variables for me so I know what every number within that expression is?

    Thanks again!
    Follow Math Help Forum on Facebook and Google+

  6. #6
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,094
    Thanks
    67

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by jegues View Post
    Could you express the formula for monthly payment in terms of variables for me so I know what every number within that expression is?
    P = payment (?)
    A = amount of loan (3000)
    n = number of payments (12)
    i = interest per month (.01)

    P = Ai / ( 1 - 1/(1 + i)^n)
    Follow Math Help Forum on Facebook and Google+

  7. #7
    Member
    Joined
    Jan 2010
    Posts
    144

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by Wilmer View Post
    2.17 :
    required monthly payment = 266.55 ; 266.55 * 12 = 3198.60
    single payment 1 year later at 12% effective: 3360.00 (which you have correctly)
    3360.00 - 3198.60 = 161.40 = interest saved
    I have a question here.

    Why is it that here we can simply do the payment amount times the number of payments? (i.e. 266.55*12)

    Aren't we ignoring the time value of money when we do this?

    Shouldn't we be finding the future value given a payment amount? Or is the time value of money implied when we first calculated the payment amount? (i.e. $266.55)

    In this example,

    Interest Questions (Inventor Rights, Loans)

    For Q2), we first calculated the payment amount given a present value (that would be our $266.55 in this question), and then to find out how much we paid given N peroids we calculated the future value given the payment amount for N peroids.

    Which is the way is the correct way to do this?

    Can you clarify Wilmer? Thanks again!
    Last edited by jegues; September 23rd 2012 at 09:12 AM.
    Follow Math Help Forum on Facebook and Google+

  8. #8
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,094
    Thanks
    67

    Re: Problems Calcuating Interest (Time value of money)

    If you borrow $1000 over 12 months and the payment is $100 per month,
    then the interest you paid HAS TO BE $200, right?
    Get it?

    The dollar interest cost is evidently the total of the payments less the amount borrowed; ok?
    Follow Math Help Forum on Facebook and Google+

  9. #9
    Member
    Joined
    Jan 2010
    Posts
    144

    Question Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by Wilmer View Post
    If you borrow $1000 over 12 months and the payment is $100 per month,
    then the interest you paid HAS TO BE $200, right?
    Get it?

    The dollar interest cost is evidently the total of the payments less the amount borrowed; ok?
    Okay, then why is it in this example,

    Interest Questions (Inventor Rights, Loans)

    For Q2), when we want to calculate how much we've paid in 20 peroids we did the future value of the payments for 20 peroids, not simply 20 * (payment amount)?

    I want to be able to distinguish the two cases.
    Follow Math Help Forum on Facebook and Google+

  10. #10
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,094
    Thanks
    67

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by jegues View Post
    Okay, then why is it in this example,

    Interest Questions (Inventor Rights, Loans)

    For Q2), when we want to calculate how much we've paid in 20 peroids we did the future value of the payments for 20 peroids, not simply 20 * (payment amount)?

    I want to be able to distinguish the two cases.
    That's because we were not given the future value of the flows, which is 199,688.38;
    the actual interest then is 199688.38 - 12000*5 - 6000*7
    Follow Math Help Forum on Facebook and Google+

  11. #11
    Member
    Joined
    Jan 2010
    Posts
    144

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by Wilmer View Post
    That's because we were not given the future value of the flows, which is 199,688.38;
    the actual interest then is 199688.38 - 12000*5 - 6000*7
    In my previous link I was refering to Q2) NOT Q1).

    Can you try answering my previous question with reference to Q2) in the link?

    Thanks again!
    Last edited by jegues; September 23rd 2012 at 11:03 AM.
    Follow Math Help Forum on Facebook and Google+

  12. #12
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,094
    Thanks
    67

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by jegues View Post
    In my previous link I was refering to Q2) NOT Q1).
    Can you try answering my previous question with reference to Q2) in the link?
    Q2) A company borrowed $100,000 to finance a new product. The loan was for 20 years at a nominal interest rate of 8 percent compounded semiannually. It was to be repaid in 40 equal payments. After one half of the payments were made, the company decided to pay the remaining balance in one final payment at the end of the 10th year. How much was owed?

    The payment was calculated to be 5052.35
    5052.35 * 40 = 202094.00 - 100000.00 = 102094.00 = interest if paid over the 20 years

    Balance end of 10th year was calculated to be 68663.07
    5052.35 * 20 = 101047.00 + 68663.07 = 169710.07 - 100000.00 = 69710.07 = interest if paid after 10 years.
    Follow Math Help Forum on Facebook and Google+

  13. #13
    Member
    Joined
    Jan 2010
    Posts
    144

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by Wilmer View Post
    Q2) A company borrowed $100,000 to finance a new product. The loan was for 20 years at a nominal interest rate of 8 percent compounded semiannually. It was to be repaid in 40 equal payments. After one half of the payments were made, the company decided to pay the remaining balance in one final payment at the end of the 10th year. How much was owed?

    The payment was calculated to be 5052.35
    5052.35 * 40 = 202094.00 - 100000.00 = 102094.00 = interest if paid over the 20 years

    Balance end of 10th year was calculated to be 68663.07
    5052.35 * 20 = 101047.00 + 68663.07 = 169710.07 - 100000.00 = 69710.07 = interest if paid after 10 years.
    Okay but to solve that question we didn't do simply the payment amount times the number of peroids at the end of the 10th year, we did the future value of 100000.00 over 20 periods less future value of 20 payments of 5052.35.

    Why is it that we need to calculate the future value and not simply do the payment amount times the number of peroids?
    Follow Math Help Forum on Facebook and Google+

  14. #14
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,094
    Thanks
    67

    Re: Problems Calcuating Interest (Time value of money)

    Quote Originally Posted by jegues View Post
    Okay but to solve that question we didn't do simply the payment amount times the number of peroids at the end of the 10th year, we did the future value of 100000.00 over 20 periods less future value of 20 payments of 5052.35.

    Why is it that we need to calculate the future value and not simply do the payment amount times the number of peroids?
    Think about it.....the future value after 10 years IS ALSO A PAYMENT, since the loan is paid off at that time.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Time value money question #2
    Posted in the Business Math Forum
    Replies: 1
    Last Post: October 1st 2011, 10:13 PM
  2. Time value money question #1
    Posted in the Business Math Forum
    Replies: 1
    Last Post: October 1st 2011, 10:13 PM
  3. Solving Time value of money
    Posted in the Algebra Forum
    Replies: 5
    Last Post: July 1st 2011, 09:50 PM
  4. A question about Time VS. Money
    Posted in the Business Math Forum
    Replies: 0
    Last Post: April 26th 2011, 09:01 PM
  5. money and interest
    Posted in the Algebra Forum
    Replies: 5
    Last Post: April 15th 2007, 03:34 AM

Search Tags


/mathhelpforum @mathhelpforum