| Worldwide Sporting Goods |
|
|
|
|
|
| Financial
Worksheet |
|
| Calculating
the Periodic Payments |
|
|
|
| You
need to borrow $600,000 for a building project. |
|
| The
yearly interest rate of the loan will be 8.5%, |
|
| and the
company will be making payments over 15 years. |
|
|
|
|
| The PMT function
determines the yearly payments. |
|
|
|
| Principal (pv) |
$
600,000 |
|
Payment |
|
| Interest (rate) |
8.50% |
|
Per Year |
|
| Term/years (nper) |
15 |
|
($72,252) |
|
|
|
|
|
|
|
|
|
|
|
|
| Worldwide
Sporting Goods |
|
| Financial
Worksheet |
|
| Calculating
the future value of a series of equal payments |
|
|
|
|
|
| Will
be investing $20,000 per year in |
|
| an
account with 8% interest for 15 years. |
|
|
| The
Future Value function determines the value of the account after the last
payment. |
|
|
|
| Payments (pmt) |
$ (20,000) |
|
Future Value |
|
| Interest (rate) |
8.00% |
|
$543,042
|
|
| Term/years (nper) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|