Results 1 to 2 of 2

Math Help - How to calculate the present value?

  1. #1
    Newbie
    Joined
    Sep 2008
    Posts
    1

    How to calculate the present value?

    My homework question goes like this:

    You are purchasing a new car. The price is $18,239. You will pay $2,000 now and the rest, monthly, in a 4-year loan. The automobile dealership is offering a sales promotion where either:

    1) You will receive a $1,000 rebate check now and the annual interest rate on the loan is 11.9% or

    2) The annual interest rate on the loan will be 1.9% but there is no rebate.

    Compare the two options by calculating the present value of each option, assuming the discount rate is 8%. Which is a better deal?

    I'm allowed to use Excel but I don't even know where to begin!


    Thank you!
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Bar0n janvdl's Avatar
    Joined
    Apr 2007
    From
    South Africa
    Posts
    1,630
    Thanks
    6
    Quote Originally Posted by pocketrocket View Post
    My homework question goes like this:

    You are purchasing a new car. The price is $18,239. You will pay $2,000 now and the rest, monthly, in a 4-year loan. The automobile dealership is offering a sales promotion where either:

    1) You will receive a $1,000 rebate check now and the annual interest rate on the loan is 11.9% or

    2) The annual interest rate on the loan will be 1.9% but there is no rebate.

    Compare the two options by calculating the present value of each option, assuming the discount rate is 8%. Which is a better deal?

    I'm allowed to use Excel but I don't even know where to begin!


    Thank you!
    In Excel you have to search for the NPV function.

    Otherwise, to calculate it by hand, just manipulate the compound interest formula.

    So the present value for a certain year will be given by:

    P = \frac{A}{\left( 1 + \frac{i}{100} \right) ^n}

    Where i is the interest and n the period time.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 2
    Last Post: March 30th 2010, 05:22 PM
  2. Present Value
    Posted in the Pre-Calculus Forum
    Replies: 2
    Last Post: March 11th 2010, 07:54 AM
  3. Present value
    Posted in the Business Math Forum
    Replies: 0
    Last Post: February 2nd 2010, 12:49 PM
  4. present value
    Posted in the Math Topics Forum
    Replies: 3
    Last Post: September 27th 2008, 07:01 PM
  5. Present value
    Posted in the Math Topics Forum
    Replies: 4
    Last Post: July 8th 2008, 10:33 AM

Search Tags


/mathhelpforum @mathhelpforum