spread sheets use as examples the first two and fill out last one
tedy.r
week_04_example_problems2.xlsPresent Value
| Present Value | ||||
| Example | ||||
| Rate | 6% | |||
| Nper | 5 | |||
| PMT | 0 | |||
| FV | $100 | |||
| Type | 0 | |||
| PV | ($74.73) | |||
| Example 1A | ||||
| Rate | 5% | |||
| Nper | 5 | |||
| PMT | 0 | |||
| FV | $150 | |||
| Type | 0 | |||
| PV | Incorrect | ($117.53) | ||
| Example 1B | ||||
| Rate | 0.07 | |||
| Nper | 10 | |||
| PMT | 0 | |||
| FV | 250 | |||
| Type | 0 | |||
| PV | Incorrect | ($127.09) |
Future Value
| Future Value | ||||
| Example | ||||
| Rate | 5.00% | |||
| Nper | 20 | |||
| PMT | 0 | |||
| PV | -$100.00 | |||
| Type | 0 | |||
| FV | $265.33 | |||
| Example 2A | ||||
| Rate | 5% | |||
| Nper | 10 | |||
| PMT | 0 | |||
| PV | -$100.00 | |||
| Type | 0 | |||
| FV | Incorrect | 162.8894626777 | ||
| Example 2B | ||||
| Rate | 7% | |||
| Nper | 15 | |||
| PMT | 0 | |||
| PV | -$250.00 | |||
| Type | 0 | |||
| FV | Incorrect | 689.7578851788 |
Interest
| Simple interest using product formula. | |||||
| Example 1 | |||||
| Principal | $100.00 | ||||
| Rate | 5% | ||||
| Interest | $5.00 | ||||
| New balance | $105.00 | ||||
| Sample 3A | |||||
| Principal | $1,000.00 | ||||
| Rate | 6.00% | ||||
| Interest | |||||
| New balance | Incorrect | ||||
| Sample 3B | |||||
| Principal | $2,500.00 | ||||
| Rate | 7.50% | ||||
| Interest | |||||
| New balance | Incorrect | ||||
| Compound interest using power formula and FV Function | |||||
| Example 2 | |||||
| Interest | 5.00% | ||||
| plus 1 | 1 | ||||
| 1 plus interest | 1.05 | ||||
| Power | 20 | ||||
| POWER function | 2.6532977051 | ||||
| PV | $100.00 | ||||
| (1 + i)n | Power Function | 2.6532977051 | |||
| FV | Result | $265.33 | |||
| Example 3 | |||||
| Present Value | $100.00 | ||||
| Rate | 5.00% | ||||
| Term | 20 | ||||
| Future Value | $265.33 | ||||
| Example 4A | |||||
| interest | 4.00% | ||||
| plus 1 | 1 | ||||
| 1 plus interest | |||||
| Power | 20 | ||||
| POWER function | |||||
| PV | $500.00 | ||||
| (1 + i)n | Power Function | ||||
| FV | result | Incorrect | |||
| Present Value | $500.00 | ||||
| Rate | 4.00% | ||||
| Term | 20 | ||||
| Future Value | Incorrect | 1095.5615715167 | |||
| Example 4B | |||||
| interest | 5.00% | ||||
| plus 1 | 1 | ||||
| 1 plus interest | |||||
| Power | 20 | ||||
| POWER function | |||||
| PV | $200.00 | ||||
| (1 + i)n | Power Function | ||||
| FV | result | Incorrect | |||
| Present Value | $200.00 | ||||
| Rate | 5.00% | ||||
| Term | 20 | ||||
| Future Value | Incorrect | 530.6595410289 |
PV of Annuity
| Present Value of an Annuity | |||
| Example | |||
| Rate | 6% | ||
| Nper | 3 | ||
| PMT | ($100) | ||
| FV | 0 | ||
| type | 0 | ||
| PV | $267.30 | ||
| Example 5A | |||
| Rate | 7% | ||
| Nper | 5 | ||
| PMT | ($100) | ||
| FV | 0 | ||
| type | 0 | ||
| PV | Incorrect | 410.0197435948 | |
| Example 5B | |||
| Rate | 4.00% | ||
| Nper | 10 | ||
| PMT | ($50.00) | ||
| FV | 0 | ||
| type | 0 | ||
| PV | Incorrect | 405.5447889678 |
FV of Annuity
| Future Value of an Annuity | |||
| Example | |||
| Rate | 5% | ||
| Nper | 3 | ||
| PMT | ($100) | ||
| PV | 0 | ||
| type | 0 | ||
| FV of annuity | $315.25 | ||
| Example 6A | |||
| Rate | 6% | ||
| Nper | 5 | ||
| PMT | ($100) | ||
| PV | 0 | ||
| type | 0 | ||
| FV of an ordinary annuity | Incorrect | $563.71 | |
| Example 6B | |||
| Rate | 4% | ||
| Nper | 10 | ||
| PMT | ($50) | ||
| PV | 0 | ||
| type | 0 | ||
| FV of an ordinary annuity | Incorrect | $600.31 |
