Simple Interest Formula - Excel by ofm18586

VIEWS: 373 PAGES: 60

Simple Interest Formula document sample

More Info
									                  Chapter 08: Simple Interest
What is Interest?
  Solve for simple interest
    I = P*R*T
  Calculate maturity value
  Determine the number of days from one date to another
  Exact Simple Interest
  Ordinary Simple Interest
What is a Note?
  Due date of Note
Find Principal
  P = I/(R*T)
Find Rate
  R = I/(P*T)
Find Time
  T = I/(P*R)
Discount Notes
  Bank Discount
  Proceeds
  Face Value
  Effective Interest Rate for Simple Interest Discount Note
Interest:
  Interest is rent paid on money
  Firms, businesses and individuals borrow money in order to
  invest the money and earn a higher rate of return than the
  interest rate
  Firms, businesses and individuals invest money to earn
  interest

Principal:
 Amount borrowed, lent out, or invested

Simple Interest:
 Interest paid on only the principal

Compound Interest:
 Interest paid on principal and past interest also known as
 "interest on interest"

Simple Interest Rate:
 Annual % rate paid or received
                                     Calculate Simple Interest
I = Simple interest
P = Principal
R = Interest Rate
T = Time in YEARS               ** If you are given time in months or days, you must convert it to years


                                                  I=P*R*T
  Hank’s Auto shop takes out a loan from the bank for $10,000 in order to buy new equipment. Hank is considering whether he
            should take out the loan for 6 months at 7% or 1.5 years at 10%. Find the simple interest on both loans.

                                                      Step 1: List details:

                                                           Loan # 1
Principal =                      $                  10,000.00
Rate =                                                  7.00%
Time =                                                       6 Months

                                                           Loan # 2
Principal =                      $                  10,000.00
Rate =                                                 10.00%
Time =                                                      1.5 Years

                                                   Step 2: Set up and solve

                            Loan # 1                                                         Loan # 2

Convert Time to years = 6
Months/12 Months = 6/12 =

I = P*R*T =                                                     I = P*R*T = $10,000.00*0.1*1.5
$10,000.00*0.07*6/12 =                                          =

                                                     Step 3: State in words
erest

t convert it to years




equipment. Hank is considering whether he
he simple interest on both loans.




         Loan # 2


                                             <== Do not have to
                                            round because we are
                                            not using these
                                            numbers in any
                                            subsequent
                                            calculations. The
                                            formatted display of
                                            the number is
                                            sufficient.
                          Calculate Maturity Value
P = Principal
I = Simple interest
P + I = Maturity Value


                                               M=P+I
   Christina takes out a $6,500.00 loan for 30 months at 10% interest in order to buy a used Jetta. Find the
                               interest due on the loan and the maturity value.

Principal =                                $           6,500.00
Time =                                                        30 Months
Simple Interest Rate =                                   10.00%

Interest = 6500*0.1*30/12 =                                       =ROUND(B11*B13*B12/12,2) (because we are going to add
Principal =
P + I = Maturity Value = 6500 + 1625 =
because we are going to add it to principal later)
           Find The Number Of Days From One Date To Another
                                          Find the number of days from November 4 to February 21

1)               To do it by hand you have to look at a calendar or use the knuckle trick or learn the Rhyme method
            Sunday, November 04, 2007 Saturday, December 01, 2007 Tuesday, January 01, 2008
             Friday, November 30, 2007    Monday, December 31, 2007 Thursday, January 31, 2008
                                     26                             31                            31

     Total Days =                                                     109

      To do it in Excel you put the two date in two different cells, and then in a third cell subtract the earlier date from th
2)                  date (this method fits the requirement of not counting the start date and counting the end date)
     Earlier date                            Sunday, November 04, 2007
     Later date                              Thursday, February 21, 2008
     Total days from 11/4/07 to 2/21/08                                                        Remember the keyboard
                                                                                               shortcut for "General Number
                                                                                               Format" ==> Ctrl + Shirt + ~
     Earlier date                                Friday, February 23, 2007
     Later date                                  Saturday, March 24, 2007
     Total days from 2/23/07 to 3/24/07
Date To Another
ary 21

k or learn the Rhyme method
                 Friday, February 01, 2008
               Thursday, February 21, 2008
                                        21




ll subtract the earlier date from the later
and counting the end date)


    Remember the keyboard
    shortcut for "General Number
    Format" ==> Ctrl + Shirt + ~
                                                                        I=P*R*T
                                          Number of days assumed in one year = 365
               Exact Interest time =                   # of days in the loan period/365


                                          Number of days assumed in one year = 360
              Ordinary Interest time =                 # of days in the loan period/360


                                                Find the exact interest and the banker’s interest given the following data:
Principal = $10,000                                   $                     10,000.00
Simple interest = 10%                                                           10.00%
Loan taken out on                                                      January 1, 2007
Loan paid back on                                                         July 31, 2007

                                 Exact Interest time                                                                  Ordinary In
Total days from 1/1/07 to 7/31/07 =
Number of days assumed in one year =

Interest = P * R * T = $10,000 * 0.1 * 211/ =
=P*R*T
assumed in one year = 365
                 This will always be smaller because you are comparing the same thing to a
                                 bigger number (think of 1/3 compared to 1/2)


assumed in one year = 360
                 This will always be bigger because you are comparing the same thing to a
                                smaller number (think of 1/2 compared to 1/3)

d the banker’s interest given the following data:




                                           Ordinary Interest time
              Total days from 1/1/07 to 7/31/07 =
              Number of days assumed in one year =

              Interest = P * R * T = $10,000 * 0.1 * 211/ =
                                            Notes
Promissory Notes:
 A legal document in which on person or firm agrees to pay:
 A stated amount of money
 Plus interest computed at a stated rate
 At a stated time in the future
 To another person or firm
 A promissory note is the written record of a loan

Maker or Payer or Debtor of the note:
 The person borrowing the money

Payee or Creditor of the note:
 The person lending the money

Term:
 Length of time until the note is due

Face Value or Principal:
 The principal amount due – the amount written of the face of the promissory note.

Simple Interest Note:
 A promissory note for a loan in which the interest is calculated using the simple interest formula:
   I = PRT = Face Value x Simple Interest Rate x Time
erest formula:
                                      Find The Due Date Of A Note
When the term for a loan is given in DAYS, count the number of days from the day after the promissory
                                                      date.

                                                      Example:
When is a 90-day loan made on January 15, 2004 due?
                                                               Date
                                                        Term length
                                                          Due Date

When the term for a loan is given in MONTHS, the loan is due on the same day the loan is made, after t
                                                of months has passed
If the date should be at the end of the month, but that day does not exist, use the last day of the month, a
                                                   as the due date
         When the loan term is given in months, do not convert the time to days in order to find the due da

                                                      Example:
When is a 6-month loan made on January 15, 2004 due?
It is due on the 15th, 6 months later:
                                                Term of loan
                                             Note Issue Date
                                                    Due Date

                                                      Example:
When is a 3-month note made on January 31 due?
It is due on April 31, but April 31 does not exist.
The due date becomes April 30.
                                                    Term of loan
                                                 Note Issue Date
                                                        Due Date
 e Date Of A Note
number of days from the day after the promissory note issue
 date.

xample:
                                     1/15/2004
                                            90
                                                                   days

 n is due on the same day the loan is made, after the number
 hs has passed
day does not exist, use the last day of the month, as it exists,




                                                                          different
he due date
 convert the time to days in order to find the due date.

xample:

                                            6 Months
                Thursday, January 15, 2004
                                                 =EDATE(B12,B10) months


xample:


                                            3 Months
                Saturday, January 31, 2004
                                                 =EDATE(B19,B18)
  Example 1: If you take out a 90 days, $5,000.00 loan with a simple interest rate of 7.25% on January 6, 2004, what is the due
                                            and maturity value (use 365 days in a year)?

                                                          Step 1: List Details:
Term                                                                             90 days
Principal                                           $                     5,000.00
Simple Interest Rate =                                                       7.25%
Note Issue Date                                           Tuesday, January 06, 2004
Days in the Year                                                                365


                                                        Step 2: Set up and solve
Interest = P * R * T = $5,000 * 0.0725 * 90/365 =                                     =ROUND(B5*B6*B4/B8,2) (must round b
Principal =                                                                           =B5
Maturity Value                                                                        =SUM(B12:B13)
Due Date                                                                              =B7+B4

                                                        Step 3: State in Words



  Example 2: If you take out a 6 month, $3,800.00 loan with a simple interest rate of 11.00% on March 2, 2004, what is the due
                                                        and maturity value?

                                                          Step 1: List Details:
Term                                                                              6 months
Principal                                           $                     3,800.00
Simple Interest Rate =                                                      11.00%
Note Issue Date                                             Tuesday, March 02, 2004
Months in the Year                                                               12


                                                        Step 2: Set up and solve
Interest = P * R * T = $3,800 * 0.11 * 6/12 =                                         =ROUND(B25*B26*B24/B28,2)
Principal =                                                                           =B25
Maturity Value                                                                        =SUM(B32:B33)
Due Date                                                                              =EDATE(B27,B24)

                                                        Step 3: State in Words
nuary 6, 2004, what is the due date




B5*B6*B4/B8,2) (must round because we are going to use it in a later calculation)




March 2, 2004, what is the due date




B25*B26*B24/B28,2)
                                           Find Principal Given Interest, Rate, & Time

                                                                Formulas:
                                                             Interest = P*R*T
                                                            Principal = I/(R*T)
                                                              Rate = I/(P*T)
                                                         Time (in years) = I/(P*R)

Gardenia borrows a principal amount that earns $50.00 interest for the lender, the simple interest rate on the loan is 10.00%, a
                                            is out for 180 days. Find the principal amount.

                                                             Step 1: List Details:
Interest                                    $        50.00
Principal
Rate                                                10.00%
Time                                                    180 days
Days in a year                                          365


                                                         Step 2: Set up and solve
                                                                                                        <== Do not have to rou
Principal = I/(R*T) = 50/(0.1*180/365) =                      =B12/(B14*B15/B16)                       because we are not usin
                                                                                                       any subsequent calcula
                                                                                                       formatted display of the
                                                                                                       sufficient.
Check with Interest = P*R*T ==>                               =B21*B14*B15/B16

                                                          Step 3: State in Words
Time




interest rate on the loan is 10.00%, and the loan
nt.




              <== Do not have to round
             because we are not using this in
             any subsequent calculations. The
             formatted display of the number is
             sufficient.
                                              Find Rate Given Interest, Principal, & Time

                                                                  Formulas:
                                                              Interest = P*R*T
                                                              Principal = I/(R*T)
                                                                Rate = I/(P*T)
                                                           Time (in years) = I/(P*R)

                   Gardenia borrows $750.00 and pays $75.00 interest. If the loan is out for 270 days, find the interest rate.

                                                              Step 1: List Details:
Interest                                         $         75.00
Principal                                        $        750.00
Rate
Time                                                          270 days
Days in a year                                                365


                                                           Step 2: Set up and solve

Rate = I/(P*T) = $75.00/($750.00*270/365) =                        =B12/(B13*B15/B16)


Check with Interest = P*R*T ==>                                    =B12/(B13*B15/B16)

                                                            Step 3: State in Words
me




0 days, find the interest rate.




                <== Do not have to round
                because we are not using this in
                any subsequent calculations.
                The formatted display of the
                number is sufficient.
                                                 Find Time Given Interest, Principal, & Rate

                                                                        Formulas:
                                                                    Interest = P*R*T
                                                                    Principal = I/(R*T)
                                                                      Rate = I/(P*T)
                                                                 Time (in years) = I/(P*R)

 Gardenia deposits $10,000.00 in a savings account at an interest rate of 10.00%. If she earns $750.00 interest, how many da
                                                                        the account?

                                                                   Step 1: List Details:
Interest                                                     $        750.00
Principal                                                    $     10,000.00
Rate                                                                  10.00%
Time                                                                            days
Days in a year                                                            360


                                                                 Step 2: Set up and solve

Time (in years) = I/(P*R) = $750.00/($10,000.00*10.00% =                        =B12/(B13*B14)
Time in days = *360 =                                                           =B21*B16

Check with Interest = P*R*T ==>                                                 =B13*B14*B22/B16

                                                                 Step 3: State in Words




                                                 Find Time Given Interest, Principal, & Rate

                                                                        Formulas:
                                                                    Interest = P*R*T
                                                                    Principal = I/(R*T)
                                                                      Rate = I/(P*T)
                                                                       Time I/(P*R)

Gardenia deposits $10,000.00 in a savings account at an interest rate of 10.00%. If she earns $750.00 interest, how many mon
                                                                        the account?

                                                                   Step 1: List Details:
Interest                                                     $        750.00
Principal                                                    $     10,000.00
Rate                                                                  10.00%
Time                                                                            months
Months in a year                                                            12
                                                             Step 2: Set up and solve

Time I/(P*R) = $750.00/($10,000.00*10.00% =                          0.750 =B12/(B13*B14)
Time in days = 0.75*12 =                                                 9 =B21*B16



                                                              Step 3: State in Words

                                          From the data presented, we calculated the Time to be 9 months.
cipal, & Rate




)

arns $750.00 interest, how many days did she leave the money in




                         <== Do not have to round because we
                        want to use the unrounded decimal to
                        multiply times the number of days in a
e                       year. (We need the unrounded decimal
                        so that we get the actual number of
                        days).




cipal, & Rate




rns $750.00 interest, how many months did she leave the money in
e




Time to be 9 months.
           Simple Discount Notes or “Interest in Advance Notes”:

                   The idea of a Simple Discount Note is:
1                 You go to the bank and ask to borrow $1,000
    The bank says sure, but we will only give you $900 today, then you have to
2                     pay use the $1,000 back in one year
3       You say: "What??!? Why only $900, if I have to pay back $1,000?"
     The bank says: "We are going to collect the $100 interest up front. This is
4                        called a Simple Discount Note."



          Simple Discount Notes or “Interest in Advance Notes”:
                   The bank collects the interest in advance
          The borrower pays the full face value back on the due date
The borrower receives the face value minus the interest on the day that the funds
                                 are disbursed.
            The amount the borrower receives is called “Proceeds”
         The interest in advance is called “bank discount” or “discount”
Example: Principal (face value)        - Interest (Discount)       = Proceeds

            $              1,000.00 - $                  100.00 = $ 900.00



 The trick the bank is playing is that it will tell you that the rate is 10%, but
 really the Effective Simple Interest Rate = $100.00/$900.00 = 11.11% or
                                   11 1/9%
Type of Note                                        Amount Received
Simple Interest                               >> Face Value or Principal            +
Simple Discount                               >> Proceeds                           +
                                      ** The face value and the maturity value are the same for a S. discount note

Bank Discount                                  = Face Value or Maturity Value         *
B                                              = M                                    *

Proceeds                                       = Face Value or Maturity Value         -
P                                              = M                                    -

                                                     Example 1:
    If you take out a loan with a maturity value (face value) of $2000 and the bank discount is $150, what are the
                                                       proceeds?

                                                   Step 1: List Details:
Face Value or Maturity Value                   =     $                     2,000.00
Bank Discount                                  =     $                       150.00

                                              Step 2: Set up and solve

Proceeds                                       = Face Value or Maturity Value         -
P                                              = M                                    -
                                               =                                      -

                                               Step 3: State in Words




                                                     Example 2:
Cynthia Thomas signs an $8500, 9-month note. If the bank discounts the note at 9%, find the amount of the discount
                                                 and proceeds.

                                                   Step 1: List Details:
Face Value or Maturity Value                   =                           8,500.00
Time                                           =                                   9 months
Discount Rate (Interest Rate)                  =                              9.00%
Months in the year                             =                                  12

                                              Step 2: Set up and solve

Bank Discount                                  = Face Value or Maturity Value         *
B                                              = M                                    *

Bank Discount = $8,500.00*09.00%*9/12 =        =

Proceeds = 8500-573.75 =                       =


                                               Step 3: State in Words
.
             Interest                           Repayment amount
             Interest                         = Maturity Value
             Bank Discount                    = Face Value or Maturity Value
value are the same for a S. discount note

             Discount Rate (Interest Rate)    * Time
             D                                * T

             Bank Discount
             B


the bank discount is $150, what are the




             Bank Discount
             B




note at 9%, find the amount of the discount




         months




             Discount Rate (Interest Rate)    * Time
             D                                * T

             =ROUND(C33*C35*C34/C36,2)
    If you know the proceeds you want, how do you figure out the amount to
                    borrow, the maturity value or face value?

         Formula = Maturity Value = Proceeds / (1 - Discount Rate * Time) =
                                  M = P/(1-D*T) =


                                   Example 1:
 Mike Modigliani needs $4000 to buy a machine. Find the amount he needs to
 borrow (maturity value) if he plans to repay the note in 180 days and the bank
                         charges a 12% discount rate.
                                                                                   <== Do not have to
                                        Step 1: List Details:                     round because we
                                                                                  are not using this in
Proceeds                                              = $       4,000.00
                                                                                  any subsequent
Discount Rate (interest Rate)                         =           12.00%
                                                                                  calculations. The
Time                                                  =               180 Days    formatted display of
Days in Year                                          =               360         the number is
                                                                                  sufficient.
                                     Step 2: Set up and solve

M = P/(1-D*T) = $4,000.00/(1-0.12*180/360)            =                     =C9/(1-C10*C11/C12)

                                      Step 3: State in Words
       <== Do not have to
      round because we
      are not using this in
      any subsequent
      calculations. The
      formatted display of
      the number is
      sufficient.


=C9/(1-C10*C11/C12)



                              4255.3191
                                                 Simple Interest Note Simple Discount Note
Face Value                                                        7500                 7500
Interest                                                           225                  225
Amount available to borrower                                      7500                 7275
Maturity value                                                    7725                 7500
Time in days                                                        90                   90
Days in year                                                       360                  360

Effective Interest Rate Simple Interest Note =             0.1200000 =B3/(B2*B6/B7)

Effective Interest Rate Simple Discount Note =            0.12371134 =C3/(C4*C6/C7)
                                     Calculate Simple Interest
I = Simple interest
P = Principal
R = Interest Rate
T = Time in YEARS                ** If you are given time in months or days, you must convert it to years


                                                    I=P*R*T
  Hank’s Auto shop takes out a loan from the bank for $10,000 in order to buy new equipment. Hank is considering whether he
            should take out the loan for 6 months at 7% or 1.5 years at 10%. Find the simple interest on both loans.

                                                        Step 1: List details:

                                                             Loan # 1
Principal =                      $                    10,000.00
Rate =                                                    7.00%
Time =                                                         6 Months

                                                             Loan # 2
Principal =                      $                    10,000.00
Rate =                                                   10.00%
Time =                                                        1.5 Years

                                                     Step 2: Set up and solve

                            Loan # 1                                                          Loan # 2

Convert Time to years = 6
Months/12 Months = 6/12 =                                     0.5

I = P*R*T =                                                     I = P*R*T = $10,000.00*0.1*1.5
$10,000.00*0.07*6/12 =           $                       350.00 =

                                                      Step 3: State in words

     The simple interest on loan # 1 is $350.00 for 1/2 of a year. The simple interest for loan # 2 is $1,500.00 for 1.5 years.
erest

t convert it to years




equipment. Hank is considering whether he
he simple interest on both loans.




         Loan # 2


                                                 <== Do not have to
                                                round because we are
                                                not using these
               $                     1,500.00   numbers in any
                                                subsequent
                                                calculations. The
                                                formatted display of
                                                the number is
t for loan # 2 is $1,500.00 for 1.5 years.
                                                sufficient.
                           Calculate Maturity Value
P = Principal
I = Simple interest
P + I = Maturity Value


                                                M=P+I
Christina takes out a $6,500.00 loan for 30 months at 10% interest in order to by a used Jetta. Find the interest
                                    due on the loan and the maturity value.

Principal =                                 $           6,500.00
Time =                                                         30 Months
Simple Interest Rate =                                    10.00%

Interest = 6500*0.1*30/12 =                 $           1,625.00   =ROUND(B11*B13*B12/12,2) (because we are going to add
Principal =                                 $           6,500.00
P + I = Maturity Value = 6500 + 1625 =      $           8,125.00
because we are going to add it to principal later)
           Find The Number Of Days From One Date To Another
                                          Find the number of days from November 4 to February 21

1)               To do it by hand you have to look at a calendar or use the knuckle trick or learn the Rhyme method
            Sunday, November 04, 2007 Saturday, December 01, 2007 Tuesday, January 01, 2008
             Friday, November 30, 2007    Monday, December 31, 2007 Thursday, January 31, 2008
                                     26                             31                            31

     Total Days =                                                     109

      To do it in Excel you put the two date in two different cells, and then in a third cell subtract the earlier date from th
2)                  date (this method fits the requirement of not counting the start date and counting the end date)
     Earlier date                            Sunday, November 04, 2007
     Later date                              Thursday, February 21, 2008
     Total days from 11/4/07 to 2/21/08                               109                      Remember the keyboard
                                                                                               shortcut for "General Number
                                                                                               Format" ==> Ctrl + Shirt + ~
     Earlier date                                Friday, February 23, 2007
     Later date                                  Saturday, March 24, 2007
     Total days from 2/23/07 to 3/24/07                                 29
Date To Another
ary 21

k or learn the Rhyme method
                 Friday, February 01, 2008
               Thursday, February 21, 2008
                                        21




ll subtract the earlier date from the later
and counting the end date)


    Remember the keyboard
    shortcut for "General Number
    Format" ==> Ctrl + Shirt + ~
                                                                        I=P*R*T
                                         Number of days assumed in one year = 365
               Exact Interest time =                   # of days in the loan period/365


                                         Number of days assumed in one year = 360
             Ordinary Interest time =                  # of days in the loan period/360


                                               Find the exact interest and the banker’s interest given the following data:
Principal = $10,000                                  $                     10,000.00
Simple interest = 10%                                                          10.00%
Loan taken out on                                                     January 1, 2007
Loan paid back on                                                        July 31, 2007

                                 Exact Interest time                                                                 Ordinary In
Total days from 1/1/07 to 7/31/07 =                                                 211
Number of days assumed in one year =                                                365

Interest = P * R * T = $10,000 * 0.1 * 211/365 =       $                   578.082192
=P*R*T
assumed in one year = 365
                 This will always be smaller because you are comparing the same thing to a
                                 bigger number (think of 1/3 compared to 1/2)


assumed in one year = 360
                 This will always be bigger because you are comparing the same thing to a
                                smaller number (think of 1/2 compared to 1/3)

d the banker’s interest given the following data:




                                           Ordinary Interest time
              Total days from 1/1/07 to 7/31/07 =                                       211
              Number of days assumed in one year =                                      360

              Interest = P * R * T = $10,000 * 0.1 * 211/360 =      $           586.111111

                       Is $586.11 bigger than $578.08?
                                    TRUE
                                      Find The Due Date Of A Note
When the term for a loan is given in DAYS, count the number of days from the day after the promissory
                                                      date.

                                                      Example:
When is a 90-day loan made on January 15, 2004 due?
                                                               Date
                                                        Term length
                                                          Due Date

When the term for a loan is given in MONTHS, the loan is due on the same day the loan is made, after t
                                                of months has passed
If the date should be at the end of the month, but that day does not exist, use the last day of the month, a
                                                   as the due date
         When the loan term is given in months, do not convert the time to days in order to find the due da

                                                      Example:
When is a 6-month loan made on January 15, 2004 due?
It is due on the 15th, 6 months later:
                                                Term of loan
                                             Note Issue Date
                                                    Due Date

                                                      Example:
When is a 3-month note made on January 31 due?
It is due on April 31, but April 31 does not exist.
The due date becomes April 30.
                                                    Term of loan
                                                 Note Issue Date
                                                        Due Date
 e Date Of A Note
number of days from the day after the promissory note issue
 date.

xample:
                                     1/15/2004
                                            90
                                     4/14/2004                     days

 n is due on the same day the loan is made, after the number
 hs has passed
day does not exist, use the last day of the month, as it exists,




                                                                          different
he due date
 convert the time to days in order to find the due date.

xample:

                                            6 Months
                Thursday, January 15, 2004
                   Thursday, July 15, 2004 =EDATE(B12,B10) months

xample:


                                            3 Months
                Saturday, January 31, 2004
                      Friday, April 30, 2004 =EDATE(B19,B18)
  Example 1: If you take out a 90 days, $5,000.00 loan with a simple interest rate of 7.25% on January 6, 2004, what is the due
                                            and maturity value (use 365 days in a year)?

                                                           Step 1: List Details:
Term                                                                              90 days
Principal                                            $                     5,000.00
Simple Interest Rate =                                                        7.25%
Note Issue Date                                            Tuesday, January 06, 2004
Days in the Year                                                                 365


                                                         Step 2: Set up and solve
Interest = P * R * T = $5,000 * 0.0725 * 90/365 =    $                          89.38    =ROUND(B5*B6*B4/B8,2) (must round b
Principal =                                          $                       5,000.00    =B5
Maturity Value                                       $                       5,089.38    =SUM(B12:B13)
Due Date                                                        Monday, April 05, 2004   =B7+B4

                                                         Step 3: State in Words

                             The maturity value of the loan is $5,089.38 and the due date is April 5, 2004.

  Example 2: If you take out a 6 month, $3,800.00 loan with a simple interest rate of 11.00% on March 2, 2004, what is the due
                                                        and maturity value?

                                                           Step 1: List Details:
Term                                                                               6 months
Principal                                            $                     3,800.00
Simple Interest Rate =                                                       11.00%
Note Issue Date                                              Tuesday, March 02, 2004
Months in the Year                                                                12


                                                       Step 2: Set up and solve
Interest = P * R * T = $3,800 * 0.11 * 6/12 =        $                       209.00      =ROUND(B25*B26*B24/B28,2)
Principal =                                          $                     3,800.00      =B25
Maturity Value                                       $                     4,009.00      =SUM(B32:B33)
Due Date                                              Thursday, September 02, 2004       =EDATE(B27,B24)

                                                         Step 3: State in Words

                          The maturity value of the loan is $4,009.00 and the due date is September 2, 2004.
nuary 6, 2004, what is the due date




B5*B6*B4/B8,2) (must round because we are going to use it in a later calculation)




 5, 2004.

March 2, 2004, what is the due date




B25*B26*B24/B28,2)




ber 2, 2004.
                                           Find Principal Given Interest, Rate, & Time

                                                                Formulas:
                                                             Interest = P*R*T
                                                            Principal = I/(R*T)
                                                              Rate = I/(P*T)
                                                         Time (in years) = I/(P*R)

Gardenia borrows a principal amount that earns $50.00 interest for the lender, the simple interest rate on the loan is 10.00%, a
                                            is out for 180 days. Find the principal amount.

                                                             Step 1: List Details:
Interest                                    $        50.00
Principal
Rate                                                10.00%
Time                                                    180 days
Days in a year                                          365


                                                         Step 2: Set up and solve
                                                                                                        <== Do not have to rou
Principal = I/(R*T) = 50/(0.1*180/365) =            1013.89 =B12/(B14*B15/B16)                         because we are not usin
                                                                                                       any subsequent calcula
                                                                                                       formatted display of the
                                                                                                       sufficient.
Check with Interest = P*R*T ==>                          50 =B21*B14*B15/B16         Checks out!!

                                                          Step 3: State in Words

                                   From the data presented, we calculated the Principal to be $1,013.89.
Time




interest rate on the loan is 10.00%, and the loan
nt.




              <== Do not have to round
             because we are not using this in
             any subsequent calculations. The
             formatted display of the number is
             sufficient.




be $1,013.89.
                                              Find Rate Given Interest, Principal, & Time

                                                                  Formulas:
                                                              Interest = P*R*T
                                                              Principal = I/(R*T)
                                                                Rate = I/(P*T)
                                                           Time (in years) = I/(P*R)

                   Gardenia borrows $750.00 and pays $75.00 interest. If the loan is out for 270 days, find the interest rate.

                                                              Step 1: List Details:
Interest                                         $         75.00
Principal                                        $        750.00
Rate
Time                                                          270 days
Days in a year                                                365


                                                           Step 2: Set up and solve

Rate = I/(P*T) = $75.00/($750.00*270/365) =               13.52% =B12/(B13*B15/B16)


Check with Interest = P*R*T ==>                  $         75.00   =B12/(B13*B15/B16)      Checks out!!

                                                            Step 3: State in Words

                                       From the data presented, we calculated the Rate to be 13.52%.
me




0 days, find the interest rate.




                <== Do not have to round
                because we are not using this in
                any subsequent calculations.
                The formatted display of the
                number is sufficient.




13.52%.
                                                 Find Time Given Interest, Principal, & Rate

                                                                        Formulas:
                                                                    Interest = P*R*T
                                                                    Principal = I/(R*T)
                                                                      Rate = I/(P*T)
                                                                 Time (in years) = I/(P*R)

 Gardenia deposits $10,000.00 in a savings account at an interest rate of 10.00%. If she earns $750.00 interest, how many da
                                                                        the account?

                                                                   Step 1: List Details:
Interest                                                     $        750.00
Principal                                                    $     10,000.00
Rate                                                                  10.00%
Time                                                                            days
Days in a year                                                            360


                                                                 Step 2: Set up and solve

Time (in years) = I/(P*R) = $750.00/($10,000.00*10.00% =                 0.750 =B12/(B13*B14)
Time in days = 0.75*360 =                                                  270 =B21*B16

Check with Interest = P*R*T ==>                              $        750.00    =B13*B14*B22/B16

                                                                 Step 3: State in Words

                                             From the data presented, we calculated the Time to be 270 days.




                                                 Find Time Given Interest, Principal, & Rate

                                                                        Formulas:
                                                                    Interest = P*R*T
                                                                    Principal = I/(R*T)
                                                                      Rate = I/(P*T)
                                                                       Time I/(P*R)

Gardenia deposits $10,000.00 in a savings account at an interest rate of 10.00%. If she earns $750.00 interest, how many mon
                                                                        the account?

                                                                   Step 1: List Details:
Interest                                                     $        750.00
Principal                                                    $     10,000.00
Rate                                                                  10.00%
Time                                                                            months
Months in a year                                                            12
                                                             Step 2: Set up and solve

Time I/(P*R) = $750.00/($10,000.00*10.00% =                          0.750 =B12/(B13*B14)
Time in days = 0.75*12 =                                                 9 =B21*B16



                                                              Step 3: State in Words

                                          From the data presented, we calculated the Time to be 9 months.
cipal, & Rate




)

arns $750.00 interest, how many days did she leave the money in




                         <== Do not have to round because we
                        want to use the unrounded decimal to
                        multiply times the number of days in a
e                       year. (We need the unrounded decimal
                        so that we get the actual number of
                        days).


            Checks out!!



Time to be 270 days.




cipal, & Rate




rns $750.00 interest, how many months did she leave the money in
e




Time to be 9 months.
Type of Note                                        Amount Received
Simple Interest                               >> Face Value or Principal            +
Simple Discount                               >> Proceeds                           +
                                      ** The face value and the maturity value are the same for a S. discount note

Bank Discount                                  = Face Value or Maturity Value         *
B                                              = M                                    *

Proceeds                                       = Face Value or Maturity Value         -
P                                              = M                                    -

                                                     Example 1:
    If you take out a loan with a maturity value (face value) of $2000 and the bank discount is $150, what are the
                                                       proceeds?

                                                   Step 1: List Details:
Face Value or Maturity Value                   =     $                     2,000.00
Bank Discount                                  =     $                       150.00

                                               Step 2: Set up and solve

Proceeds                                       = Face Value or Maturity Value         -
P                                              = M                                    -
                                    1,850.00   = $                    2,000.00        -

                                               Step 3: State in Words

                   We have to pay back $2,000.00 and you are going to give us only $1,850.00?!?

                                                     Example 2:
Cynthia Thomas signs an $8500, 9-month note. If the bank discounts the note at 9%, find the amount of the discount
                                                 and proceeds.

                                                   Step 1: List Details:
Face Value or Maturity Value                   =                           8,500.00
Time                                           =                                   9 months
Discount Rate (Interest Rate)                  =                              9.00%
Months in the year                             =                                  12

                                               Step 2: Set up and solve

Bank Discount                                  = Face Value or Maturity Value         *
B                                              = M                                    *

Bank Discount = $8,500.00*09.00%*9/12 =        =                             573.75

Proceeds = 8500-573.75 =                       =                           7,926.25


                                               Step 3: State in Words
After we subtracted the bank discount of $573.75 from the face value ($8,500.00) our proceeds were $7,926.25.
             Interest                            Repayment amount
             Interest                          = Maturity Value
             Bank Discount                     = Face Value or Maturity Value
value are the same for a S. discount note

             Discount Rate (Interest Rate)     * Time
             D                                 * T

             Bank Discount
             B


the bank discount is $150, what are the




             Bank Discount
             B
              $                      150.00



give us only $1,850.00?!?



 note at 9%, find the amount of the discount




          months




             Discount Rate (Interest Rate)     * Time
             D                                 * T

              =ROUND(C33*C35*C34/C36,2)
$8,500.00) our proceeds were $7,926.25.
    If you know the proceeds you want, how do you figure out the amount to
                    borrow, the maturity value or face value?

         Formula = Maturity Value = Proceeds / (1 - Discount Rate * Time) =
                                  M = P/(1-D*T) =


                                   Example 1:
 Mike Modigliani needs $4000 to buy a machine. Find the amount he needs to
 borrow (maturity value) if he plans to repay the note in 180 days and the bank
                         charges a 12% discount rate.
                                                                                                    <== Do not have to
                                         Step 1: List Details:                                     round because we
                                                                                                   are not using this in
Proceeds                                               = $                    4,000.00
                                                                                                   any subsequent
Discount Rate (interest Rate)                          =                        12.00%
                                                                                                   calculations. The
Time                                                   =                            180 Days       formatted display of
Days in Year                                           =                            360            the number is
                                                                                                   sufficient.
                                      Step 2: Set up and solve

M = P/(1-D*T) = $4,000.00/(1-0.12*180/360)             = $                    4,255.32      =C9/(1-C10*C11/C12)

                                       Step 3: State in Words

If Mike Modigliani needs $4,000.00 to buy a machine (proceeds) and the bank is offering him a note due
     in 180 days and a bank discount rate of 12%, the face value or maturity value would have to be
                                               $4,255.32.
       <== Do not have to
      round because we
      are not using this in
      any subsequent
      calculations. The
      formatted display of
      the number is
      sufficient.


=C9/(1-C10*C11/C12)
                                                 Simple Interest Note Simple Discount Note
Face Value                                                        7500                 7500
Interest                                                           225                  225
Amount available to borrower                                      7500                 7275
Maturity value                                                    7725                 7500
Time in days                                                        90                   90
Days in year                                                       360                  360

Effective Interest Rate Simple Interest Note =             0.1200000 =B3/(B2*B6/B7)

Effective Interest Rate Simple Discount Note =            0.12371134 =C3/(C4*C6/C7)

								
To top