Question: 5. Time Value Excel Exercise A. Using Excel to calculate the Future Value for a single payment over 5 years at 10% Rate 0.1 Nper
| 5. Time Value Excel Exercise | ||||||||||||
| A. | Using Excel to calculate the Future Value for a single payment over 5 years at 10% | |||||||||||
| Rate | 0.1 | |||||||||||
| Nper | 5 | |||||||||||
| PMT | 0 | |||||||||||
| PV | -10000 | |||||||||||
| Type | 0 | |||||||||||
| FV = | Returns the FV of an investment based on periodic, constant payments and a constant interest rate | |||||||||||
| B. | Use Excel to calculate the Present Valaue for a single payment | |||||||||||
| Rate | 0.1 | |||||||||||
| Nper | 5 | |||||||||||
| PMT | 0 | |||||||||||
| FV | -16105 | |||||||||||
| Type | 0 | |||||||||||
| PV = | Returns the PV of and investment - the tota amount that a series of future paymnets is worth now. | |||||||||||
| C. | Use Excel to calculatee the Future Value for an ordinary annuity payment | |||||||||||
| Rate | 0.1 | |||||||||||
| Nper | 3 | |||||||||||
| PMT | -1000 | |||||||||||
| FV | ||||||||||||
| Type | ||||||||||||
| FV = | $3,310.00 | |||||||||||
| D. | Using Excel to calculate the Present Value for an ordinary annuity payment | |||||||||||
| Rate | 0.1 | |||||||||||
| Nper | 3 | |||||||||||
| PMT | -1000 | |||||||||||
| PV | ||||||||||||
| Type | ||||||||||||
| PV = | $2,486.85 | |||||||||||
Please help. I will put a thumb up for you. Thanks
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help