Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Statement Analysis
Authors: Andrew P.C.
1st Edition
1520985002, 978-1520985008
