FREE Online Social Networking Of Indian – Make Friends, Share Photos, Videos, Audios & More!!!
 Forgot Password? | Sign Up | Remember me
 FREE live video chat – Meet Exciting People and Enjoy Life!!!
    Blog :View
Calculating Interest Rates with
Microsoft Excel
Posted : 
2 years ago
Mickey Baldwin
The actual Rate function calculates the interest rate implicit in some loan or investment phrases

given the number regarding periods (months, quarters, ages or whatever), the money per period, the show value, the future price, and, optionally, the type-of-annuity swap, and also optionally, a powerful interest-rate guess.

If you set the type-of-annuity switch to 1, Excel assumes payments occur at the beginning

of the period, adopting the annuity due convention. Should you set the annuity move to 0 or

you omit the argument, Excel assumes payments occur in the final analysis of the period pursuing

the ordinary annuity tradition.

The function uses the subsequent syntax:

RATE (nper, pmt, p v, fv, type, guess)

Jointly example, suppose you want to calculate the implicit rate of interest on a car lease for any $20, 000 car that calls for five years of $250-a-month payments (occurring for annuity due) together with a

$15, 000 balloon settlement. To do this, assuming you should start with a figure of 10%, you

can operate the following formula:

=RATE(5*12, -250, 20000, -15000, 1)

The function returns the additional value. 95%, which is a monthly interest rate of just less than 1%.

If you annualize this kind of monthly rate by spreading it by 12, you can get an equivalent annual

interest price of 11. 41%.

While another example, suppose you need to calculate the implicit rate of on a $300, 000 real estate investment mortgage that requires twenty five years of $2000-a-month payments (occurring for being an ordinary annuity) but (thankfully) absolutely no balloon payment. To accomplish this, assuming you want initially a guess of 10%, you can utilize the following formula:

=RATE(30*12, -2000, 300000)

The function returns the quality. 59%, which is a monthly monthly interest of slightly over fifty percent a percent.

If a person annualize this monthly fee by multiplying it by 12, you get some sort of equivalent annual

interest cost of 7. 0203%.

Any point: Excel solves the RATE function iteratively beginning with the guess argument you will provide.

(If you don't supply this optional argument, Surpass uses 10%. ) Should Excel can't solve typically the RATE argument within 20 effort, it returns the #NUM! problem. You can try a different guess argument, which can aid because you're telling Excel to begin its search from a further (hopefully closer) starting factor.
Tags:   Bellevue-Redmond CPA , accounting, tax
Average: 0Average: 0Average: 0Average: 0Average: 0
Comments 0 Views 66 Flag as offend? Share this Blog
    Comments ( 0 )
Want to place your comment on this Post?

Register now, its FREE, and share your views.
Already a member? Login now.

Click here to free signup!
   Popular Blog Tags:
advice wedding flowers education seo services diet SEM Taiwan fitness moving thomas sabo beauty fitness as seen on tv hair removal συντ&I... e product Cheap Ugg Boots bridesmaid dresses NEWS TAIWAN Family custom made wedding dresses ugg weight loss Vince Delmonte craigslist auto posting softw how to lose weight fast Houston Criminal Lawyer Payday Loans law click here technology SEO Taiwan w panic away watches _____ travel cars ____ __ widget Houston Lawyer marketing B Forex india tours game changer dna seo wiki wedding Rock Bottom Blueprint ___ web design supplements internet boots family website design web hosting SEM CA movers Raleigh Plumbing dizi izle internet marketing Payday Loans best apprendre l anglais angry birds f G Home game changer dna online blog Health shopping directory aziende italiane karen millen dresses fashion insurance Free Classifieds link building backlinks tips R home electronic cigarette H T BAGS __ __ replica watches Payday Loan dating ip address service six flags over texas insurance konsolidacja chwilówek a Games Internet marketing tools ip delivery service Taiwan NEWS How none Home Security free SEO συντ&... free review panic away die casting ejaculation precoce M I N internet travel forex trading music Rock Bottom Blueprint Review games D C Ch pest control craigslist auto posting tool Replica Watch health credit card real estate Replica watch shopping l Fashion S _______ _____ ugg boots panic attack sports P SEO Taipei aluminum casting Weight Ho web design Marketing jobs Wedding easy hair removal directory gra hair removal home improvement link building services lace wedding dresses affiliate marketing food Real Estate entertainment Forex robot directory aziende lose weight wedding dresses diet computers finance lose Weight online review rodent control car dresses Taiwan SEO link building link building service depression watch Vince Delmonte Scam how to lose weight fast weight loss Service cheap premature ejaculation __ craigslist Computer Moncler jackets review search engine optimization seo car game changer dna review Angry Birds Online Buy business internet marketing Coupons Business web hosting seo__
 •  Arts & Literature
 •  Astrology
 •  Baby Blogs
 •  Bloggers Park
 •  Blogging for Money
 •  Bollywood
 •  Cars and Bikes
 •  Computers & Internet
 •  Cultures & Community
 •  Education
 •  Electronics & Gadgets
 •  Emotions
 •  Entertainment
 •  Family Blogs
 •  Fantasy SF Blog
 •  Fashion & Style
 •  Friends
 •  Games
 •  Health
 •  Hobbies & Interests
 •  India
 •  International
 •  Jokers Joke
 •  Life
 •  Lifestyle
 •  Lovers Love
 •  Mobile Geeks
 •  Non-Profit & Charity
 •  Others
 •  Pets & Animals
 •  Photography
 •  Podcasting
 •  Relationships
 •  Religion and Spirituality
 •  Schools & College
 •  Science Blogs
 •  Shopping Blog
 •  Social Networks
 •  Videos
 •  Women and Blogging
  Post title Tags
  About Us  |  Help/FAQs   |  Feedback  |  Write to us  |  Terms of Use  |  Privacy policy  |  Advertise  |  Partners  |  Press  |  Site Map 
Copyright © 2014 - India's Largest and Fastest Growing Social Networking Site. All rights reserved.