Question about Computers & Internet

Ad

There are three four option to check out this finance payment ,
this is the direct link
click it directly
http://www.ehow.com/how_2098559_calculate-interest-payment-using-microsoft.html

this is another link
http://www.docstoc.com/search/excel-formula-to-calculate-mortgage-payments/

this another link
http://www.google.co.in/search?hl=en&q=formula+to+calculate+finance+payments+in+microsoft+excel+&btnG=Google+Search&meta=&aq=f&oq=

thanks.
keep updated.please do rate the solution.thank you for using fixya.

Posted on May 20, 2009

Ad

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)

click here to download the app (for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

Would you like to finish the question? Do you want to know the monthly payment for a given interest rate? Do you want to know how to calculate the monthly payment on a particular make and model calculator?

Mar 21, 2013 | Office Equipment & Supplies

Bridging finance is very helpful when you need a short term finance.I recommend you to check http://www.charlesfrankfinance.co.uk/

Nov 25, 2012 | Cars & Trucks

Please refer to the link to formula involving loan calculation: http://www.docstoc.com/docs/64563308/Calculating-Loan-Payments-Using-Reducing-Balance-Formula

Mar 21, 2011 | Texas Instruments BA-II Plus Calculator

Work with the simple formula:
Interest = Initial * rate * time

To find the total amount, add the Initial plus the Interest, then subtract what has been paid. This will change the amount of money that will be accruing interest, though, so if there is a payment schedule you will need to repeat this calculation to get an exact number.

Find more information on wikipedia: http://en.wikipedia.org/wiki/Interest#Simple_interest

To find the total amount, add the Initial plus the Interest, then subtract what has been paid. This will change the amount of money that will be accruing interest, though, so if there is a payment schedule you will need to repeat this calculation to get an exact number.

Find more information on wikipedia: http://en.wikipedia.org/wiki/Interest#Simple_interest

Mar 07, 2011 | Texas Instruments BA-II Plus Calculator

The IRR function is provided by Excel so you can calculate an
internal rate of return for a series of values. The IRR is the interest
rate accrued on an investment
consisting of payments and income that occur at the same regular
periods. In the values provided to the function, you enter payments you
make as negative values and income you receive as positive values.

For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.

Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:

=IRR(D4:D8)

The function returns an IRR of 19.49%.

The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:

=IRR(D4:D8, -5%)

This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.

Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:

=IRR(D4:D8)

The function returns an IRR of 19.49%.

The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:

=IRR(D4:D8, -5%)

This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

Jun 09, 2010 | Microsoft Office Professional 2007 Full...

The formula is:

J

M = P x ------------------------

1 - ( 1 + J ) ^ -N

where:

M = monthly payment ($)

P = principal ($)

J = monthly interest (15% --> 0.15/12=0.0125 )

N = number months (years X 12) Note__minus__ sign!

"^" represents the calculator's exponentiation function:

____ ____

This key: | y | not this key: | y |

| x | | e |

----- -----

J

M = P x ------------------------

1 - ( 1 + J ) ^ -N

where:

M = monthly payment ($)

P = principal ($)

J = monthly interest (15% --> 0.15/12=0.0125 )

N = number months (years X 12) Note

"^" represents the calculator's exponentiation function:

____ ____

This key: | y | not this key: | y |

| x | | e |

----- -----

Aug 25, 2009 | Texas Instruments Office Equipment &...

See this handy Texas Instrument guide on calculating different formulae.

http://www.retrevo.com/support/TI-BA-II-PLUS-PROFESSIONAL-Calculators-manual/id/421ci277/t/2/

http://www.retrevo.com/support/TI-BA-II-PLUS-PROFESSIONAL-Calculators-manual/id/421ci277/t/2/

Apr 12, 2009 | Office Equipment & Supplies

Check to make sure you have the proper value set for payments-per-year.

Mar 27, 2009 | Texas Instruments BA-II Plus Calculator

I gave up using the Texas BA II. I used an on-line mortgage calculator for interest only. I was able to get a full printout.

I would like to learn more about the BA II and how to do this type of math on it.

Thank you

I would like to learn more about the BA II and how to do this type of math on it.

Thank you

Mar 02, 2008 | Texas Instruments BA-II Plus Calculator

The function you are looking for is =FV(rate,nper,pmt,pv,type)
It calculates future value of payments.
Let me know if you have further questions.
|D>

Sep 10, 2007 | Microsoft Office Standard for PC

38 people viewed this question

Usually answered in minutes!

×