+ Reply to Thread
Results 1 to 67 of 67

How do I caluclate an Annual Percentage Rate in Excel?

  1. #1
    Lisa M
    Guest

    How do I caluclate an Annual Percentage Rate in Excel?



  2. #2
    JE McGimpsey
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Depends on what information you start with...

    Take a look at the RATE() function in XL Help.

    In article <[email protected]>,
    Lisa M <Lisa [email protected]> wrote:

  3. #3
    Lisa M
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    I tried that but it didn't work. Thanks!!!! I need to calculate for
    mortgages. Any other sugestions?
    Lisa M

    "JE McGimpsey" wrote:

    > Depends on what information you start with...
    >
    > Take a look at the RATE() function in XL Help.
    >
    > In article <[email protected]>,
    > Lisa M <Lisa [email protected]> wrote:
    >


  4. #4
    JE McGimpsey
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How could anyone know what to suggest when you don't tell what
    information you have available?

    RATE() certainly can "calculate for mortgages". What does "it didn't
    work" mean? Did you get the wrong answer? no answer? an error? a crash?

    Nobody can see your worksheet (and please don't post it). Instead you
    need to actually describe how your data is laid out, what you've tried,
    and what hasn't worked.


    In article <[email protected]>,
    Lisa M <[email protected]> wrote:

    > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > mortgages. Any other sugestions?


  5. #5
    Lisa M
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Hope this info helps. It's kind of hard to type it and I wouldn't think it
    be a good idea to post it. I can use a HP Financial Calculator to get the
    number I need but I would rather have it on the spreadsheet that I am using.
    I need to calculate an APR with Fees included. I tried the =Rate(TERM, -PMT,
    $ AMT)*12 and it gave me the actually rate of interest charged. That is not
    what I need. The APR is greater than the interest rate charged because it
    takes the original loan amt plus certain fees charged. An example: loan
    amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80 and
    fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    5.810%. I would like to have the speadsheet do the calculation that my HP
    calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    and fees. Do you have any other suggestions?
    Thanks for all of your help. I hope that I gave you better info than before.
    Lisa M

    "JE McGimpsey" wrote:

    > How could anyone know what to suggest when you don't tell what
    > information you have available?
    >
    > RATE() certainly can "calculate for mortgages". What does "it didn't
    > work" mean? Did you get the wrong answer? no answer? an error? a crash?
    >
    > Nobody can see your worksheet (and please don't post it). Instead you
    > need to actually describe how your data is laid out, what you've tried,
    > and what hasn't worked.
    >
    >
    > In article <[email protected]>,
    > Lisa M <[email protected]> wrote:
    >
    > > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > > mortgages. Any other sugestions?

    >


  6. #6
    N Harkawat
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    gives me 5.81%



    "Lisa M" <[email protected]> wrote in message
    news:[email protected]...
    > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > it
    > be a good idea to post it. I can use a HP Financial Calculator to get the
    > number I need but I would rather have it on the spreadsheet that I am
    > using.
    > I need to calculate an APR with Fees included. I tried the
    > =Rate(TERM, -PMT,
    > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > not
    > what I need. The APR is greater than the interest rate charged because it
    > takes the original loan amt plus certain fees charged. An example: loan
    > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > and
    > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > and fees. Do you have any other suggestions?
    > Thanks for all of your help. I hope that I gave you better info than
    > before.
    > Lisa M
    >
    > "JE McGimpsey" wrote:
    >
    >> How could anyone know what to suggest when you don't tell what
    >> information you have available?
    >>
    >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    >>
    >> Nobody can see your worksheet (and please don't post it). Instead you
    >> need to actually describe how your data is laid out, what you've tried,
    >> and what hasn't worked.
    >>
    >>
    >> In article <[email protected]>,
    >> Lisa M <[email protected]> wrote:
    >>
    >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    >> > mortgages. Any other sugestions?

    >>




  7. #7
    Lisa M
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Thanks. I was missing part of the formula. Have a good day.

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  8. #8
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  9. #9
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  10. #10
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  11. #11
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  12. #12
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  13. #13
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  14. #14
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  15. #15
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  16. #16
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  17. #17
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  18. #18
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  19. #19
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  20. #20
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  21. #21
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  22. #22
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  23. #23
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  24. #24
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  25. #25
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  26. #26
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  27. #27
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  28. #28
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  29. #29
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  30. #30
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  31. #31
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  32. #32
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  33. #33
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  34. #34
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  35. #35
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  36. #36
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  37. #37
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  38. #38
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  39. #39
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  40. #40
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  41. #41
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  42. #42
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  43. #43
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  44. #44
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  45. #45
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  46. #46
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  47. #47
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  48. #48
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  49. #49
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  50. #50
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  51. #51
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  52. #52
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  53. #53
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  54. #54
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  55. #55
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  56. #56
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  57. #57
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  58. #58
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  59. #59
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




  60. #60
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  61. #61
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  62. #62
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  63. #63
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    GREAT help. Can you help with TWO interest only loans?

    First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo). Fees
    of $11,090.56 are deducted from loan amount for a net funding of 488,909.44
    and include a 2 point origination fee ($10,000); prepaid interest from
    6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    considered a fee for this calculation???

    Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    deducted from loan amount for a net funding of $1,195,520.56 and include a
    4.25% origination fee (53,125); prepaid interest from 6/27-6/30 ($1,319.44);
    and a $35 wire fee. Again, is prepaid interest considered a fee for this
    calculation?

    "N Harkawat" wrote:

    > =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > gives me 5.81%
    >
    >
    >
    > "Lisa M" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hope this info helps. It's kind of hard to type it and I wouldn't think
    > > it
    > > be a good idea to post it. I can use a HP Financial Calculator to get the
    > > number I need but I would rather have it on the spreadsheet that I am
    > > using.
    > > I need to calculate an APR with Fees included. I tried the
    > > =Rate(TERM, -PMT,
    > > $ AMT)*12 and it gave me the actually rate of interest charged. That is
    > > not
    > > what I need. The APR is greater than the interest rate charged because it
    > > takes the original loan amt plus certain fees charged. An example: loan
    > > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > > and
    > > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > > 5.810%. I would like to have the speadsheet do the calculation that my HP
    > > calculator does. I have in the spreadsheet the loan amount, int rate, pmt
    > > and fees. Do you have any other suggestions?
    > > Thanks for all of your help. I hope that I gave you better info than
    > > before.
    > > Lisa M
    > >
    > > "JE McGimpsey" wrote:
    > >
    > >> How could anyone know what to suggest when you don't tell what
    > >> information you have available?
    > >>
    > >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> work" mean? Did you get the wrong answer? no answer? an error? a crash?
    > >>
    > >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> need to actually describe how your data is laid out, what you've tried,
    > >> and what hasn't worked.
    > >>
    > >>
    > >> In article <[email protected]>,
    > >> Lisa M <[email protected]> wrote:
    > >>
    > >> > I tried that but it didn't work. Thanks!!!! I need to calculate for
    > >> > mortgages. Any other sugestions?
    > >>

    >
    >
    >


  64. #64
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    A word of advice, repost this as a reply in the original thread, there's a
    good chance it wont be seen by the person you're addressing by starting a
    new one,
    Regards,
    Alan.
    "MK Manzer" <MK [email protected]> wrote in message
    news:[email protected]...
    > GREAT help. Can you help with TWO interest only loans?
    >
    > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > Fees
    > of $11,090.56 are deducted from loan amount for a net funding of
    > 488,909.44
    > and include a 2 point origination fee ($10,000); prepaid interest from
    > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > considered a fee for this calculation???
    >
    > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > ($1,319.44);
    > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > calculation?
    >
    > "N Harkawat" wrote:
    >
    >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> gives me 5.81%
    >>
    >>
    >>
    >> "Lisa M" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> > think
    >> > it
    >> > be a good idea to post it. I can use a HP Financial Calculator to get
    >> > the
    >> > number I need but I would rather have it on the spreadsheet that I am
    >> > using.
    >> > I need to calculate an APR with Fees included. I tried the
    >> > =Rate(TERM, -PMT,
    >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    >> > is
    >> > not
    >> > what I need. The APR is greater than the interest rate charged because
    >> > it
    >> > takes the original loan amt plus certain fees charged. An example:
    >> > loan
    >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    >> > and
    >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    >> > 5.810%. I would like to have the speadsheet do the calculation that my
    >> > HP
    >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    >> > pmt
    >> > and fees. Do you have any other suggestions?
    >> > Thanks for all of your help. I hope that I gave you better info than
    >> > before.
    >> > Lisa M
    >> >
    >> > "JE McGimpsey" wrote:
    >> >
    >> >> How could anyone know what to suggest when you don't tell what
    >> >> information you have available?
    >> >>
    >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> crash?
    >> >>
    >> >> Nobody can see your worksheet (and please don't post it). Instead you
    >> >> need to actually describe how your data is laid out, what you've
    >> >> tried,
    >> >> and what hasn't worked.
    >> >>
    >> >>
    >> >> In article <[email protected]>,
    >> >> Lisa M <[email protected]> wrote:
    >> >>
    >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> > for
    >> >> > mortgages. Any other sugestions?
    >> >>

    >>
    >>
    >>




  65. #65
    MK Manzer
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    How do I do that exactly? Go to the first box where Lisa asked the question
    and reply there?

    "Alan" wrote:

    > A word of advice, repost this as a reply in the original thread, there's a
    > good chance it wont be seen by the person you're addressing by starting a
    > new one,
    > Regards,
    > Alan.
    > "MK Manzer" <MK [email protected]> wrote in message
    > news:[email protected]...
    > > GREAT help. Can you help with TWO interest only loans?
    > >
    > > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    > > Fees
    > > of $11,090.56 are deducted from loan amount for a net funding of
    > > 488,909.44
    > > and include a 2 point origination fee ($10,000); prepaid interest from
    > > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    > > considered a fee for this calculation???
    > >
    > > Second - $1,250,000 loan for 3 years (36 months). First 2 years at 9.5%
    > > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44 are
    > > deducted from loan amount for a net funding of $1,195,520.56 and include a
    > > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    > > ($1,319.44);
    > > and a $35 wire fee. Again, is prepaid interest considered a fee for this
    > > calculation?
    > >
    > > "N Harkawat" wrote:
    > >
    > >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    > >> gives me 5.81%
    > >>
    > >>
    > >>
    > >> "Lisa M" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    > >> > think
    > >> > it
    > >> > be a good idea to post it. I can use a HP Financial Calculator to get
    > >> > the
    > >> > number I need but I would rather have it on the spreadsheet that I am
    > >> > using.
    > >> > I need to calculate an APR with Fees included. I tried the
    > >> > =Rate(TERM, -PMT,
    > >> > $ AMT)*12 and it gave me the actually rate of interest charged. That
    > >> > is
    > >> > not
    > >> > what I need. The APR is greater than the interest rate charged because
    > >> > it
    > >> > takes the original loan amt plus certain fees charged. An example:
    > >> > loan
    > >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of $326.80
    > >> > and
    > >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR of
    > >> > 5.810%. I would like to have the speadsheet do the calculation that my
    > >> > HP
    > >> > calculator does. I have in the spreadsheet the loan amount, int rate,
    > >> > pmt
    > >> > and fees. Do you have any other suggestions?
    > >> > Thanks for all of your help. I hope that I gave you better info than
    > >> > before.
    > >> > Lisa M
    > >> >
    > >> > "JE McGimpsey" wrote:
    > >> >
    > >> >> How could anyone know what to suggest when you don't tell what
    > >> >> information you have available?
    > >> >>
    > >> >> RATE() certainly can "calculate for mortgages". What does "it didn't
    > >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    > >> >> crash?
    > >> >>
    > >> >> Nobody can see your worksheet (and please don't post it). Instead you
    > >> >> need to actually describe how your data is laid out, what you've
    > >> >> tried,
    > >> >> and what hasn't worked.
    > >> >>
    > >> >>
    > >> >> In article <[email protected]>,
    > >> >> Lisa M <[email protected]> wrote:
    > >> >>
    > >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    > >> >> > for
    > >> >> > mortgages. Any other sugestions?
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >


  66. #66
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    Yes, just open Lisa's mail and cick 'Reply Group'
    Regards,
    Alan.
    "MK Manzer" <[email protected]> wrote in message
    news:[email protected]...
    > How do I do that exactly? Go to the first box where Lisa asked the
    > question
    > and reply there?
    >
    > "Alan" wrote:
    >
    >> A word of advice, repost this as a reply in the original thread, there's
    >> a
    >> good chance it wont be seen by the person you're addressing by starting a
    >> new one,
    >> Regards,
    >> Alan.
    >> "MK Manzer" <MK [email protected]> wrote in message
    >> news:[email protected]...
    >> > GREAT help. Can you help with TWO interest only loans?
    >> >
    >> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >> > Fees
    >> > of $11,090.56 are deducted from loan amount for a net funding of
    >> > 488,909.44
    >> > and include a 2 point origination fee ($10,000); prepaid interest from
    >> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >> > considered a fee for this calculation???
    >> >
    >> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >> > 9.5%
    >> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >> > are
    >> > deducted from loan amount for a net funding of $1,195,520.56 and
    >> > include a
    >> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >> > ($1,319.44);
    >> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >> > this
    >> > calculation?
    >> >
    >> > "N Harkawat" wrote:
    >> >
    >> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >> >> gives me 5.81%
    >> >>
    >> >>
    >> >>
    >> >> "Lisa M" <[email protected]> wrote in message
    >> >> news:[email protected]...
    >> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >> >> > think
    >> >> > it
    >> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >> >> > get
    >> >> > the
    >> >> > number I need but I would rather have it on the spreadsheet that I
    >> >> > am
    >> >> > using.
    >> >> > I need to calculate an APR with Fees included. I tried the
    >> >> > =Rate(TERM, -PMT,
    >> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >> >> > That
    >> >> > is
    >> >> > not
    >> >> > what I need. The APR is greater than the interest rate charged
    >> >> > because
    >> >> > it
    >> >> > takes the original loan amt plus certain fees charged. An example:
    >> >> > loan
    >> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >> >> > $326.80
    >> >> > and
    >> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >> >> > of
    >> >> > 5.810%. I would like to have the speadsheet do the calculation that
    >> >> > my
    >> >> > HP
    >> >> > calculator does. I have in the spreadsheet the loan amount, int
    >> >> > rate,
    >> >> > pmt
    >> >> > and fees. Do you have any other suggestions?
    >> >> > Thanks for all of your help. I hope that I gave you better info
    >> >> > than
    >> >> > before.
    >> >> > Lisa M
    >> >> >
    >> >> > "JE McGimpsey" wrote:
    >> >> >
    >> >> >> How could anyone know what to suggest when you don't tell what
    >> >> >> information you have available?
    >> >> >>
    >> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >> >> >> didn't
    >> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >> >> >> crash?
    >> >> >>
    >> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >> >> >> you
    >> >> >> need to actually describe how your data is laid out, what you've
    >> >> >> tried,
    >> >> >> and what hasn't worked.
    >> >> >>
    >> >> >>
    >> >> >> In article <[email protected]>,
    >> >> >> Lisa M <[email protected]> wrote:
    >> >> >>
    >> >> >> > I tried that but it didn't work. Thanks!!!! I need to calculate
    >> >> >> > for
    >> >> >> > mortgages. Any other sugestions?
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




  67. #67
    Alan
    Guest

    Re: How do I caluclate an Annual Percentage Rate in Excel?

    click even! lol
    "Alan" <[email protected]> wrote in message
    news:[email protected]...
    > Yes, just open Lisa's mail and cick 'Reply Group'
    > Regards,
    > Alan.
    > "MK Manzer" <[email protected]> wrote in message
    > news:[email protected]...
    >> How do I do that exactly? Go to the first box where Lisa asked the
    >> question
    >> and reply there?
    >>
    >> "Alan" wrote:
    >>
    >>> A word of advice, repost this as a reply in the original thread, there's
    >>> a
    >>> good chance it wont be seen by the person you're addressing by starting
    >>> a
    >>> new one,
    >>> Regards,
    >>> Alan.
    >>> "MK Manzer" <MK [email protected]> wrote in message
    >>> news:[email protected]...
    >>> > GREAT help. Can you help with TWO interest only loans?
    >>> >
    >>> > First -- $500,000 loan for 2 years (24 months) at 9.5% (3,958.33/mo).
    >>> > Fees
    >>> > of $11,090.56 are deducted from loan amount for a net funding of
    >>> > 488,909.44
    >>> > and include a 2 point origination fee ($10,000); prepaid interest from
    >>> > 6/23-6/30 of $1,055.56; and a $35 wire fee. Is prepaid interest is
    >>> > considered a fee for this calculation???
    >>> >
    >>> > Second - $1,250,000 loan for 3 years (36 months). First 2 years at
    >>> > 9.5%
    >>> > (9,895.83/mo); 3rd year at 10.5% (10,937.50/mo). Fees of $54,479.44
    >>> > are
    >>> > deducted from loan amount for a net funding of $1,195,520.56 and
    >>> > include a
    >>> > 4.25% origination fee (53,125); prepaid interest from 6/27-6/30
    >>> > ($1,319.44);
    >>> > and a $35 wire fee. Again, is prepaid interest considered a fee for
    >>> > this
    >>> > calculation?
    >>> >
    >>> > "N Harkawat" wrote:
    >>> >
    >>> >> =RATE(360,PMT(5.75%/12,360,56000),56000-361.22)*12
    >>> >> gives me 5.81%
    >>> >>
    >>> >>
    >>> >>
    >>> >> "Lisa M" <[email protected]> wrote in message
    >>> >> news:[email protected]...
    >>> >> > Hope this info helps. It's kind of hard to type it and I wouldn't
    >>> >> > think
    >>> >> > it
    >>> >> > be a good idea to post it. I can use a HP Financial Calculator to
    >>> >> > get
    >>> >> > the
    >>> >> > number I need but I would rather have it on the spreadsheet that I
    >>> >> > am
    >>> >> > using.
    >>> >> > I need to calculate an APR with Fees included. I tried the
    >>> >> > =Rate(TERM, -PMT,
    >>> >> > $ AMT)*12 and it gave me the actually rate of interest charged.
    >>> >> > That
    >>> >> > is
    >>> >> > not
    >>> >> > what I need. The APR is greater than the interest rate charged
    >>> >> > because
    >>> >> > it
    >>> >> > takes the original loan amt plus certain fees charged. An example:
    >>> >> > loan
    >>> >> > amount of $56,000 at rate of 5.75% for 30 yrs with a P&I pmt of
    >>> >> > $326.80
    >>> >> > and
    >>> >> > fees of $361.22. If I plug the numbers into my HP, it calcs an APR
    >>> >> > of
    >>> >> > 5.810%. I would like to have the speadsheet do the calculation
    >>> >> > that my
    >>> >> > HP
    >>> >> > calculator does. I have in the spreadsheet the loan amount, int
    >>> >> > rate,
    >>> >> > pmt
    >>> >> > and fees. Do you have any other suggestions?
    >>> >> > Thanks for all of your help. I hope that I gave you better info
    >>> >> > than
    >>> >> > before.
    >>> >> > Lisa M
    >>> >> >
    >>> >> > "JE McGimpsey" wrote:
    >>> >> >
    >>> >> >> How could anyone know what to suggest when you don't tell what
    >>> >> >> information you have available?
    >>> >> >>
    >>> >> >> RATE() certainly can "calculate for mortgages". What does "it
    >>> >> >> didn't
    >>> >> >> work" mean? Did you get the wrong answer? no answer? an error? a
    >>> >> >> crash?
    >>> >> >>
    >>> >> >> Nobody can see your worksheet (and please don't post it). Instead
    >>> >> >> you
    >>> >> >> need to actually describe how your data is laid out, what you've
    >>> >> >> tried,
    >>> >> >> and what hasn't worked.
    >>> >> >>
    >>> >> >>
    >>> >> >> In article <[email protected]>,
    >>> >> >> Lisa M <[email protected]> wrote:
    >>> >> >>
    >>> >> >> > I tried that but it didn't work. Thanks!!!! I need to
    >>> >> >> > calculate
    >>> >> >> > for
    >>> >> >> > mortgages. Any other sugestions?
    >>> >> >>
    >>> >>
    >>> >>
    >>> >>
    >>>
    >>>
    >>>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1