1st Step : To Know Future Value of Investment

Without knowing future value of investment, you can not understand the FV Function in excel. Actually, excel's FV Formula automates the calculation of future value of investment. If you want to learn it, you can learn at here.

2nd Step : Write Few Important Information

FV Function is used on the basis of data. In this data, you should write Rate, Nper, Pmt, PV and type.

Rate = Rate of Interest

Nper = The number of years of your investment. If you invest your money for 10 years, 10 years will be Nper

Pmt = Period deposit for investment. Suppose, you deposit Rs. 1000 in your bank account every year for 10 years.

PV = Your initial investment in the project.

Type = If you pay at the beginning of the period, write 1 and if you pay at the end of the period write 0. Default will be 1.

3rd Step : Apply the Function

You can apply the function by using financial function FV. Just go to insert in ms excel, then go to function and then choose financial. After this click FV. You will see a pop up window. Write all above information. If you invest only initial amount, then you write Pmt as 0. After click ok, you will find the result in your excel cell.

.
Share above Content to Your Friends

Name

accounting Accounting Concepts Accounting Course Accounting Education accounting equation Accounting Solutions Algebra Answer the Questions and Become Master Balance Sheet bank Bodybuilding Education Business Business Education Business Environment Business Solutions CA Calculus cameras car Car Driving Course Career Solutions carpentry Class 10 Maths Class 9 Maths Computer Computer Basics Computer Hardware Computer Networking Computer Software Computer Solutions cooking education Corporate Accounting Corporate Law cost cost accounting CSE Dailymotion depreciation determinant drawing Driving Education e-accounting earn money Economics Education Education Education Solutions Electronics Email Events Examination Finance Education Finance Solutions financial Financial Accounting FIR Football Gambling Gambling Addiction Goldsmith Google Adsense GST Guest Writers Health Education Help History Home Building Home Maintenance amp; Repair Index Number India Indian Language Inspiration insurance internal audit Internet Internet Forum Jobs amp; Careers Journal journal entries journal entry Kenya Laptop Basics Law Education Law Solutions Learning Lecture Legal Education Linear algebra Linear Programming Malaysia Management Accounting Management Education Management Solutions Marketing Education Mathematics Education matrices Medical and Surgery Education Mobile motivation MS Excel Nepal Nigeria organisation Other Pakistan Personal Finance Philippines Photography Photoshop Software Picture Plumbing Education Probability Profiles provision real estate rectification Relationships amp; Family Religious Studies Result Sahas Saudi Arabia Science Education Self-Learning Skating Slideshow Solution Spiritual Education Sports Statistics Statistics Education stock Story svtuition Tablet Education Tally Tally Solutions Tally.ERP 9 tax Tax Solutions teaching Teaching Education Tech Simplify Test Testimonials Travel Trigonometry tuition TV Shows UK USA variance analysis VAT vector Video Video on Demand videos Vocational Education Web design website Welding Skills Wife Window Movie Maker Wordpress working capital Youth youtube
false
ltr
item
Svtuition: How to Use FV Function in Excel
How to Use FV Function in Excel
https://i.ytimg.com/vi/4nykbg-o1mA/hqdefault.jpg
https://i.ytimg.com/vi/4nykbg-o1mA/default.jpg
Svtuition
http://www.svtuition.com/2012/06/how-to-use-fv-function-in-excel.html
http://www.svtuition.com/
http://www.svtuition.com/
http://www.svtuition.com/2012/06/how-to-use-fv-function-in-excel.html
true
3065238051582539150
UTF-8