Calculate the present value of $100,000 in the given cases
Not what you're looking for?
Using the present value function in MS Excel, verify that the present value of $100,000 to be received in five years at an interest rate of 16%, compounded annually, is $47,610. Calculate the present value of $100,000 for each of the following items (parts a-f) using these facts:
a. Interest is compounded semiannually
b. Interest is compounded quarterly
c. A discount rate of 12% is used
d. A discount rate of 20% is used
e. The cash will be received in three years
f. The cash will be received in seven years
Purchase this Solution
Solution Summary
This solution describes the steps to calculate the present values in the given cases, using Excel calculations.
Solution Preview
Please refer attached file for better clarity of functions in MS Excel.
Future Value=FV=100,000
Number of periods=NPER= 5
Interest Rate=RATE=16%
Periodic Payment=PMT=0
Type of payment=0
PV can be found by using PV function in MS Excel.
PV= $47,611 =-PV(D8,D7,D9,D6,D10)
Ignoring rounding off errors , we received the same value as given.
a. Interest is compounded semiannually
Future Value=FV=100,000
Number of periods=NPER=5*2=10
Interest ...
Education
- BEng (Hons) , Birla Institute of Technology and Science, India
- MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
- "Thank you"
- "Really great step by step solution"
- "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
- "Thanks Again! This is totally a great service!"
- "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Learning Lean
This quiz will help you understand the basic concepts of Lean.