Here is how you can calculate the rate of interest using Excel XP
Insert > Function > Rate
Enter the following
Number of periods
Regular payment
PV (i.e amount of loan)
FV (i.e. accumulated amount)
Type (0 - payment at end of period, 1 - payment at beginning of period
Enter negative amount for PV and FV and positive amount for regular payment
This will give you the interest rate per period. You can convert to an annual rate by multiplying the number of periods in a year.
The function in Excel 2007 is different, but the concept is the same.
0 komentar:
Post a Comment
Contoh Makalah Jurnal Skripsi Tesis
PDF Download PDF Search Engine
Art Gallery Artist - Contemporary Abstract Paintings and Graphics
History of Art, Artists & Art Movements
Top 30 Hot Music Downloads
Top Digital Songs
Christian Residential Drug Treatment
Donate Your Car San Francisco
Firm Law Mesothelioma Texas
Ms Exchange Server Hosting
Villa di Piazzano Cortona Italy Hotel
Windows Download Software
Windows Download Center
plastic surgery before and after korean
Fashion N style
Aliving Room Furniture
The Hotels Las Vegas
Acamping Sites
About Hilton Hotels
Women Hair Styles Short
Hair Styles Short Medium
2010 Haircuts Style
Hair Styles Short Hair
Insurance Quotes Online
Note: Only a member of this blog may post a comment.