Calculating the Time to Repay Loans Business Articles | September 28 Duke Dawson Jersey , 2012 Trying to calculate how long a loan will take to repay? Microsoft Excel can help. Excel's NPER, or number of periods, function lets you easily calculate how long repaying a loan will take given the loan interest rate, its balance, and the payment made.
The NPER function calculates the term, or number of regular payments, on a loan or for an investment annuity given its interest rate, the payments, present value (or loan balance), future value (or balloon payment) Sony Michel Jersey , and, optionally, the type-of-annuity switch. If you set the type-of-annuity switch to 1, Excel assumes payments occur at the beginning of the period, following the annuity due convention. If you set the annuity switch to 0 or you omit the argument, Excel assumes payments occur at the end of the period following the ordinary annuity convention.
The function uses the following syntax:
NPER (rate, pmt, pv, fv, type)
For example Isaiah Wynn Jersey , to calculate the number of $1,000 monthly payments required to pay off a 9% mortgage that still has a $100,000 mortgage balance, you use the following formula:
=NPER (.0912,-1000,100000,0,0)
The function returns the value 185.53, representing roughly 185 payments and then another roughly half payment. Notice that to convert the 9% annual interest to a period interest, the formula divides the annual interest rate by 12. Notice Malcom Brown Jersey , too, that the payment amount, as a cash outflow, shows as a negative value while the loan balance, as an implicit cash inflow, shows as a positive value.
NOTE The NPER function rarely returns an integer, or whole-number result. As in the preceding example, it commonly returns a fractional value, indicating that after the last regular payment, an additional fractional payment will also need to be made.
You can also use the NPER function to calculate investment terms. In this case Joe Thuney Jersey , you calculate the number of payments that need to be made in order to reach some future value. Suppose, for example, that you want to calculate how many years a customer needs to contribute $2,000 to an Individual Retirement Account in order to amass a $1,000,000 portfolio. If you assume the customer will earn 9% annually and will make payments at the beginning of the year, you use the following formula to make this estimate:
The function returns the value 43.45, indicating the $2,000 payments will need to be made for slightly more than 43 years. Notice that the type switch is 1, which means that the function returns the amount that must be paid at the beginning of the year. If you instead want to calculate the amount that would need to be paid at the beginning of each year, you would use the following formula to make this estimate:
=NPER (.09,-2000,0,1000000,0)
This formula returns the value 44.43. This value is slightly more than the annuity due value because by making payments at year-end, the customer loses interest. If you wanted to make the same calculation but recognize the added fact that the customer already has $5 Devin McCourty Jersey ,000 in his IRA account, you would use the formula:
=NPER (.09,-2000,-5000,1000000,0)
This formula returns the value 42.07.
Article Tags: Nper Function, Following Formula, Function Returns
Every single year, more and more people are replacing their home phones with mobile phones. But, with replacing our old land line phones with mobile phones we are noticing two things. The first thing Stephen Gostkowski Jersey , is that technology is ever changing. I had my land line phone for about 3 years. It rocked. It had everything I needed. I never needed to replace it because it had everything that would do what I needed it to do. The second thing I noticed was that mobile phones DO change technology and quite often! Within a years time I ended up switching my mobile phones 4 times. FOUR TIMES! This was simply because I felt that the newer phones had better features than mine.
Even the “G”s were getting upgraded. The one phone I had started with had wireless technology, but it wasn’t any kind of a “G”. The second phone I had was a 3g connection. The third one I bought was a 3g connection plus it had a hot spot and a wireless and a bluetooth option. The fourth one I bought (recently) has the 4G option. You know how crazy this stuff is sometimes. It can drive you nuts. I just saw some kind of a commercial recently, I think it was for Best Buy.
I just walked into the room, so I didn’t know it was a spoof or anything. But, it was the one where someone is talking about 5g. I was like, wait did not 4g JUST come out. Thankfully it was a joke and they were just talking about some buy back program they had for televisions and electronics! Anyway, electronics, especially mobile phones, are insane. They change every single week, one company trying to outdo the competition.
We Dont'a Hightower Jersey , as consumers, of course benefit from this. But, because of all these updates, upgrades and changes, a lot of us are stuck with 4 phones – like in my case. Most companies won’t buy back cell phones. But, there is another option you can try – mobile phone recycling. A little note about mobile phone recycling from our friends at EPA.GOV: “Recycling cell phones helps the environment by saving energy and keeping usable materials out of landfills.
Mondwächter
Thema drucken
06.01.2020 09:21
Antworten
