Calculating present and future values
Not what you're looking for?
1.
FOR EACH OF THE CASES SHOWN IN THE TABLE BELOW, CALCULATE THE FUTURE VALUE OF THE SINGLE CASH FLOW DEPOSITED TODAY THAT WILL BE AVAILABLE AT THE END OF THE DEPOSIT PERIOD IF THE INTEREST IS COMPOUNDED ANNUALLY, SEMI ANNUALLY AND QUARTERLY AT THE RATE SPECIFIED OVER THE GIVEN PERIOD.
CASE SINGLE CASH FLOW INTEREST RATE DEPOSIT PERIOD (YEARS) SEMI ANNUAL ANNUAL QUARTERLY
A $750 8% 10
B $3,250 12% 5
C $9,500 16% 2
D $10,000 20% 4
2. WHAT SINGLE INVESTMENT MADE TODAY, EARNING 14% ANNUAL INTEREST WILL BE WORTH $9,000 AT THE END OF 7 YEARS?
3.WHAT IS THE PRESENT VALUE OF $7,000 TO BE RECEIVED AT THE END OF 5 YEARS IF THE DISCOUNT RATE IS 11%?
4.WHAT IS THE MOST YOU WOULD PAY TODAY FOR A PROMISE TO REPAY YOU $3,000 AT THE END OF 5 YEARS IF YOUR OPPORTUNITY COST IS 9%?
Purchase this Solution
Solution Summary
Solutions to given problems explains the methodology to find present/future values in the given cases.
Solution Preview
Please refer attached file for better clarity of formulas in MS Excel.
Case A
Annual Compounding
PV= $750
Rate=i=8%
Number of periods=n=10
FV=?
FV=PV*(1+i)^n=$1,619
or Use FV function in MS Excel as under
FV= ($1,619)
Semi annual Compounding
PV= $750
Rate=i=8%/2=4% per semi annual
Number of periods=n=10*2 20 Semi annuals
FV= ?
FV=PV*(1+i)^n=$1,643
or Use FV function in MS Excel as under
FV=($1,643)
Quarterly Compounding
PV= $750
Rate=i=8%/4=2% per semi annual
Number of periods=n=10*4 40 Quarters
FV= ?
FV=PV*(1+i)^n=$1,656
or Use FV function in MS Excel as under
FV=($1,656)
Case B
Annual Compounding
PV= $3,250
Rate=i=12%
Number of periods=n=5
FV=?
FV=PV*(1+i)^n=$5,728
or Use FV function in MS Excel as under
FV= ($5,728)
Semi annual ...
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
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Employee Orientation
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.