Appendix 364
Function
Description
Example
(principal,
interest, term)
Calculates the constant
"
required to
repay a loan at a specified interest rate over a
given period of time.
Principal
is the amount of
the loan.
Interest
is the interest rate for the same
time period as the term.
Term
is the interval at
which the payments are made.
Be careful to
enter the interest rate for the same time period as
the terms.
Use the PMT function to determine the monthly
payment for a 20 year loan of $75,000, at 5%
annual interest.
=PMT(75000,.05/12,240)
returns
$494.97.
!
(future value,
present value,
term)
Required interest
to reach a future value.
Future_value
is the value of the annuity at the
end of the investment period.
Present_value
is
the value of the annuity today.
Term
is the time
periods for the investment.
If you have $5000, what annual interest rate
would you need to have $8000 in 5 years?
=RATE(8000,5000,5)
returns
9.86%.
(cost, salvage,
life)
.
Cost
is the initial
cost of the asset.
Salvage
is the value of the
asset at the end of the time period.
Life
is the
useful life of the asset, the number of time
periods the asset is being depreciated.
=SLN(12000,2000,5)
returns
2000.
(cost, salvage,
life, period)
Accelerated depreciation of an asset, using the
"
method.
Cost
is the initial
cost of the asset.
Salvage
is the value of the
asset at the end of the time period.
Life
is the
useful life of the asset, the number of time
periods the asset is being depreciated.
Period
is
the period to analyze.
What is the depreciation in the 4th year for a
computer system that initially cost $12000,
which after 5 years could be sold for $2000?
=SYD(12000,2000,5,4)
returns
$1333.33.
(payments,
interest, future
value)
Required number of
or payment periods
to reach a future value. Payments are made at
the end of each term and earn a constant
interest rate.
Payments
is the amount of the
periodic payments.
Interest
is the interest rate for
the investment per time period.
Future_value
is
the value of the annuity at the end of the
investment period.
Be careful to enter the interest
rate for the same time period as the term.
How long will it take to accrue $10,000 if you
make monthly payments of $250 at an annual
interest rate of 5.5%?
=TERM(250,.055/12,10000)
returns
36.8.
Содержание Ensemble PDP-100J
Страница 11: ......
Страница 71: ...Getting Started 60 Optional Accessories Fax Modem Data Modem Scanner Cut Sheet Feeder ...
Страница 72: ......
Страница 83: ......
Страница 84: ...Word Processing 71 3 Word Processing Important Word Processing Tips ENTER ENTER TAB SPACEBAR TAB ...
Страница 152: ......
Страница 217: ...Spreadsheet 203 The following dialog box appears ...
Страница 219: ......
Страница 262: ......
Страница 269: ......
Страница 284: ......
Страница 301: ......
Страница 306: ...Calculator 287 Cut and paste Handling Error or Overflow Conditions To clear an error ...
Страница 308: ...Calculator 289 Converting Measurements S S S S S S To convert ...
Страница 312: ......
Страница 325: ......
Страница 327: ...Book Reader 306 To close a book Using Information and Text To read a book ...
Страница 329: ...Book Reader 308 Printing from Book Reader To print selected text from a book To print the current page ...
Страница 330: ......
Страница 333: ......
Страница 337: ...Text File Editor 314 ...
Страница 338: ......
Страница 345: ......
Страница 349: ...Scanner 324 What to do if an error occurs Error Condition Message Solution ...
Страница 350: ......
Страница 379: ......
Страница 387: ...Appendix 360 Color Clip Art SNOWMAN TEA TIGER TURTLECA WANDFLOW WATERLIL ...
Страница 396: ...Appendix 369 Print Functions Function Description Example ...
Страница 405: ...Appendix 378 Fonts Occidental Font Symbols keyboard International keyboard Math Symbols ...
Страница 406: ...Appendix 379 Ping Pong Font Pointer keyboard Numbers keyboard Symbols keyboard Other Symbols ...
Страница 407: ...Appendix 380 Shattuck Avenue Font Symbols keyboard International keyboard Math Symbols ...
Страница 408: ...Appendix 381 URW Mono Font Symbols keyboard International keyboard Math Symbols ...
Страница 409: ...Appendix 382 URW Roman Font Symbols keyboard International keyboard Math Symbols ...
Страница 410: ...Appendix 383 URW Sans Font Symbols keyboard International keyboard Math Symbols ...
Страница 411: ...Appendix 384 URW SymbolsPS Font Bracket keyboard Greek keyboard Symbol Math keyboard Symbol Other keyboard ...
Страница 414: ......
Страница 418: ...Glossary 390 ...
Страница 420: ...Glossary 392 0 1 1 1 ...
Страница 421: ...Glossary 393 text style sheet ...
Страница 422: ...Glossary 394 ...
Страница 423: ......
Страница 428: ...Index 399 D cont d 1 0 1 1 1 1 0 1 0 1 1 0 2 1 0 0 0 1 0 ...
Страница 430: ...Index 401 F cont d 1 1 0 0 1 0 0 0 0 0 0 0 0 0 G 1 0 1 ...
Страница 436: ...Index 407 S cont d 1 3 3 1 1 0 1 4 0 3 0 0 1 1 3 1 3 1 0 1 1 1 0 1 3 1 0 1 2 ...
Страница 440: ......