How do I use the Excel financial formulas to calculate present value, future value and discount rates?
Solution Preview
It is really very easy to calculate using an Excel sheet.
The explanations are as follows:
(1) PRESENT VALUE:
Open a new Excel sheet and click on Insert on the Menu Bar. Then click on fx Function, a window would appear click on Financial in function category and select PV from the Function name and click OK. You will see a window that asks for- Rate, Nper, Pmt, Fv and Type.
In Rate- put the discount rate,
Nper-Number of annuity ...
Solution Summary
The solution does a very job of explaining exactly how to use several of the financial functions in Excel: PV, FV, and IRR
Free BrainMass Quizzes
-
This quiz introduces basic concepts of Pinterest social media
-
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
-
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
-
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
-
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.