Softtrends, makes PDA Software for Palm OS, Pocket PC 2002, Symbian,Nokia 9200, Microsoft Smartphone. We also develop software for 802.11, Bluetooth wireless and provide design sevices.
Amortization

tApCalc Finance for Nokia 9200 Series

User Manual

 

Contents

 

Getting Started

About User Interface

Setting calculator preferences

 

Calculator Key Convention

About calculator keys

Binary Function Keys

Unary Function Keys

Financial Function Keys

 

Tape Functions

About paper tape simulation

Saving tape content

Loading tape content

Editing tape content

Running tape

Clearing the tape

Beaming tape in

Beam tape out

 

Financial Functions

Amortization

Depreciation

Bond calculation

Time Value of Money

Loan calculation

Mortgage calculation

Saving calculation

Discounted Cash Flow Analysis

 

Getting Started

 

User Interface

 

About User Interface

tApCalc Finance provides a very simple and easy to use user interface suitable for a device without touch stylus interface. All keys and commands that tApCalc Finance understands are made available through the user interface and are mapped to the keyboard keys.

·         Each key is mapped to a key on the keyboard and the mapping is shown below the key name e.g. Pressing Q means selecting function n.

·         The keys that are mapped to a key starting with ch e.g. ch Q require pressing the Chr key and the key together e.g. pressing Chr Q means selecting the function Beg.

·         Results are displayed on the calculator display area (right above the keys) and the tape area, which is to the left of the calculator keys.

·         Tape menu provides all tape related functions.

 

Setting calculator preferences

There are 2 preferences you can set for tApCalc Finance:

  • Number of decimal places preference will set the number of digits after decimal place that the calculator needs to display. The value can be set from 0 to 4
  • Save format can be set to “Tab delimited” or “CSV Format”. Most text files are usually tab delimited. However, if you want the tape to be used by other programs that understand CSV format, including Microsoft Excel, you should select CSV format.

 

Calculator keys

 

About Calculator keys

tApCalc Finance has different types of keys, Number keys, Unary keys, Binary keys, and flag keys. It is not a RPN calculator. Therefore, you must use the keys as you would use a normal calculator that does not follow RPN.

 

  1. Number input must always follow an operator input, which marks the end of number input for tApCalc. If you are ending a calculation and do not have any more operators to input, a “=” must be entered to mark the end of calculation.
  2. If after pressing “=” key you need to continue with the operation, you do not need to enter the result displayed on the calculator again. Just go ahead and enter the operator you desire.

 

Binary Function Keys

Binary keys are the keys that require 2 inputs to work on. Example of binary keys are +, - , /, X etc.

 

  1. When a Binary key is pressed, a second operand number must be entered followed by another operator to indicate end of operand input for the binary operator. For example, to add 10+20+50 you will need to enter “10”, “+”, 20,”+”,”50”. Here, the first + indicates end of input for number 10, and the second + for 20. Therefore, after second + is entered, tApCalc will evaluate 10+20 and display 30 on the display.
  2. Now the natural question is what to do after entering “50”? If you calculation ends here, you must enter the operator “=” to indicate end input for 50. Otherwise, you should enter the corresponding calculator key for the function you want to apply to the above result.

 

Unary Function Keys

Unary keys are the keys that require only a single input and are evaluated as soon as the operand is pressed.

 

  1. Example of unary keys is 1/x, Sqrt, M+ etc. When a unary key is pressed, it is applied on the last result displayed on calculator display, and the calculator immediately displays the new result after applying the operator.
  2. All memory keys are unary keys.

 

Financial Function Keys

Financial keys are the keys used to carry out the financial operations. Following financial keys are available in tApCalc.

 

Time Value of Money (TVM) Keys

TVM keys are Present Value (PV), Final Value (FV), Payment (PMT), Interest Rate (i), Periods (n), Amortization (AMO).

 

  • These keys are used in tandem to calculate Time Value of Money. In addition, a %12 and x12 keys are available.
  • Flag keys Beg (Begin) and End (End) are provided to set the payment date at the beginning or end of the month.
  • %12 Key will do 3 things. It will terminate the current number, divide the number input by 12 and store the result in Interest Rate (i). 
  • x12 key will do 3 operations.  It will terminate the current number, multiply the number input by 12 and store the result in Period (n).
  • The sequence of using these keys for a financial operation is described in TVM Functions.
  • These keys can also be used to calculate Amortization. It is explained in Amortization section.

 

Discounted Cash Flow (DCF) Keys

tApCalc support 2 DCF functions, Internal Rate of Return(IRR), and Net Present Value (NPV). In order to calculate these, 5 keys are available. CF0, CFj, Nj, IRR and NPV.

 

  • CF0, CFj and Nj are used to provide cash flow values and repeated cash flow values.
  • You will also need to use additional financial keys to calculated IRR or NPV
  • The sequence in which these keys need to be used for the underlying financial operation is described in DCF Functions.

 

Depreciation Keys

tApCalc provides functions to calculate depreciation of assets. It supports 3 forms of depreciation calculation, Straight Line (SL), SYD, and Declining Balance (DB) methods of depreciation. The 3 keys SL, SYD, DB are used for this.

 

  • These keys are used in combination with the TVM keys PV, FV, n, and i to calculate depreciation.
  • The sequence in which these keys need to be used for the underlying financial operation is described in Depreciation Functions.

 

Bond Calculation

tApCalc provides function to calculate semi-annual bond yield and price. The keys used for calculating bond are YTM, Price, p.Dt, m.Dt. In addition there is a flag key m.dt available to indicate to tApCalc that the data entered is a date not a number.

 

  • When entering a date for Bond calculation, you will have to enter 6 digits after decimal point but the maximum number of digits after decimal in tApCalc is 4. Besides, you will have to go back and forth between preferences and calculator to set the preference. By clicking on m.dt button, you will notify tApCalc to accept 6 digits after decimal, as input because you are entering date, not a number.
  • The sequence to calculate Bond Price and yield is described in the section Bond calculation.

 

Tape Functions

 

About Paper tape simulation

tApCalc Finance provides a simulated paper tape that comes in handy many ways. Most hardware financial desk calculators come with a paper tape or printer attached to it that records all calculation for future reference. Paper tape simulation in tApCalc does exactly that and more. In case of tApCalc tape, a tape saved to the disk can be reloaded, edited for mistakes and rerun without reentering all data again, thus saving valuable time for the user. Lets say you have to do some calculations and you do not have all data handy, you can start the calculation using tApCalc, enter the known data and save the calculation to a tape file. In a future time, when you have the remaining data you can load the tape and extend the calculation with new data.

 

tApCalc provide the following functionality with the tape:

 

  • Save tape
  • Load tape
  • Edit tape
  • Run tape
  • Clear tape

 

Save tape

Save tape will save the entire content of the currently displayed tape on to a database on the device.

 

Select “Save” menu item from “Tape” menu to access this function.

 

  • If no tape is currently open it will directly go to the “Save” dialog box screen.
  • Enter the name of the file you want to save your tape to.
  • Select mode as “User program” or “Output”. Tapes saved as User program can be loaded and recalculated. Tapes saved as Output can only be viewed.
  • If you have opened a tape and added additional calculation to it and then selected the Save tape menu item, tApCalc will display a dialog box asking if you would like the save the new calculations to the same tape that you had opened. If you want the currently opened tape overwritten, click on Yes, otherwise click on No and tApCalc will enter the “Save” dialog box for you to specify a new file name for the tape and a comment.

 

Load tape

Use load tape option to load a previously stored calculation from the database.

 

Select “Load” menu item from “Tape” menu to load tape

 

  • In the load dialog box, you can only select a previously saved tape. If you select “User program” option, then only the tapes saved as User program will be displayed. If you select Output, only Output types tapes will be displayed.
  • Press delete button will delete the tape.
  • Pressing done will open the tape.
  • If you do not wish to load any tape, tap on cancel

 

Note: If you selected Output instead of User Program, the tape will not be loaded to the calculator as a calculation. Rather, it will open a text window and display the data stored in the tape.

 

Edit Tape

Edit tape function can only operate on tapes displayed on the calculator screen. Therefore, it will be active when the tape is on and you have entered some calculations, or you have loaded a previously stored tape.

 

Select “Edit” menu item from “Tape” menu to edit tape. It will be enabled if there is any content on the tape.

 

  • You can make changes to any operator or operand. To change an operator or operand, tap on that line. Then, if you enter an operand, the operand will be changed and if you enter an operator, the operator will be changed.
  • To enter comment on the line, tap on left side of the line. You will see a box where you can enter text.
  • Please note the line with (NE) at the end of them. This means Not Editable. These are the results of previous operations that are displayed on the tape and recalculated after you make changes to the operators and operands on the tape. These cannot be changed.
  • If you made a mistake on changing a line, use <Undo> to discard changed to the line.
  • If you made mistakes and want to discard all changes, click on <Cancel>
  • <Done> will enter “Edit” mode and keep the changes you did intact. In most cases, the tape will be reevaluated and the lines that had (NE) with them will have new numbers.

 

Run Tape

Run tape function to rerun the calculations from the beginning as if the user enters all the data from the beginning. This is equivalent to programming. Run is primarily useful when you want to load a tape to extend the calculation or edit a tape for mistakes.

 

Select “Run” menu item from “Tape” menu to run tape. It will be enabled only when there is any content in the tape.

 

  • When the tape is run, you will see the calculation being reevaluated in the calculator display. At the end of the run, the calculator will display the final result and you can continue adding new calculations to the tape normally.

 

Clear Tape

Clear tape clears the tape content.

 

Select “Clear” menu item from “Tape” menu to clear tape. It will be enabled only when there is any content in the tape.

 

 

Financial Functions

 

Amortization

Amortization calculations produce the amount applied toward the principal and interest for a particular loan payment or series of payments.

 

To amortize a loan payment, follow the following steps:

 

1.       Clear the financial registers by Selecting C

2.       Key in the loan amount and then Select PV.

3.   Key in the interest rate and Select i.

4.   Key in the payment amount and Select  ± , PMT.

5.   Key in the number of payments you wish to have amortized and Select AMO .

6.   The amount applied towards interest is now shown in the display.

 

Example:  Suppose you have purchased an automobile for $25,000 at 8.75% interest compounded monthly on a 5 year loan.  Find the amount you will have paid in interest and principal on the loan after 10 months.

 

1.   Select function C to clear financial registers.

2.   Select function END for end mode.

3.       Key in 25000 and select function PV to enter the loan amount.

4.       Key in 8.75 and select function ¸ to enter the interest compounded monthly. You can also directly enter the interest rate and select function I

5.       Key in 5 and select function ´12 to enter the number of months. You can also directly enter the number of payments and select function n.

6.   Select function PMT to calculate the monthly payment, which will show as 515.9357.

7.   Key in 10 and select function AMO to amortize the loan.

 

The program will display the following on the tape

Interest Paid                  Amor                1,711.3645        indicating the amount of interest you have paid in 10 months

Principal Paid                Principal            3447.9925         indicating the amount you have paid towards principal in 10 months after 10 months

Remaining balance         PV                    21,552.0075      indicating the remaining principal balance after 10 months.

 

Note: Please note that you actual numbers may be slightly different because of preferences setting. If your preferences are set to 2, then the i value calculated will be rounded to next higher decimal point value causing the difference.

 

Bond Calculations

 

The PRI and YTM functions calculate the price and yield to maturity of a semi-annual coupon bond.  Calculations are made on a 30/360 basis using a par value of 100.

 

Example: You are interested in purchasing a 7.25% semi-annual coupon bond at 92.25.  Determine the yield this bond will produce if you purchased it on Oct 10, 1987 and it matures on Oct 10, 1997.

 

  1. Key in 7.25 and select PMT to enter the coupon rate.
  2. Key in 92.25 and select PV  to enter the bond price.
  3. Select m.dy to use Month-Day-Year format.
  4. Key in 10.101987 and select p.dt  to enter the purchase date.
  5. Key in 10.101997 and select m.dt to enter the mature date
  6. Select YTM the yield to maturity.

 

The bond will yield 8.4%.

 

Example:  Assume you desire a yield of 8.88% on a bond that reaches maturity on October 10, 1998.  If the bond is a 7.75% treasury bond, how much should you pay for it on October 10, 1988?

 

  1. Key in 7.75 and select PMT to enter the coupon rate.
  2. Key in 8.88 and select i to enter the desired yield.
  3. Select m.dy to use Month-Day-Year format.
  4. Key in 10.101988 and select p.dt    to enter the purchase date.
  5. Key in 10.101998 and select m.dt to enter the mature date
  6. Select PRI to calculate the price.

 

You should pay $92.7096 for the bond.

 

Depreciation

Depreciation calculations can be performed using Straight Line (SL), Sum of Years Digits (SYD), or Declining Balance (DB) methods.

 

To calculate depreciation using any method:

 

1.   Key in the price of the asset and select PV

2.   Key in the salvage value and select FV

3.   Key in the length of time (in years) of the asset's usefulness and select n

4.   If you are using the declining balance method, key in the percentage declining balance factor and select i

5.   Key in the length of time (in years) to calculate the depreciation on and select either SL or DB or SYD.

 

Example: Compute the depreciation on a $8600 computer workstation after 1 year.  Assume the workstation will be depreciated over 6 years and that the Sum of Years Digits method will be used.

 

1.   Key in 8,600 and select PV

2.   Key in 0 and select FV. 

3.   Key in 6 and select n.

4.   Key in 1 and select SYD. The depreciation for the first year is $2,457.1429.

 

To compute the depreciation after the 2nd year, key in 2 and select SYD.

The depreciation after the second year is $2,047.619

 

Time Value of Money Calculation

 

Loan Calculation

 

Example:  Suppose you wish to take out a Car loan.  Calculate the monthly payment if your loan is for $9,000 at 7.95% interest compounded monthly for 7 years.

 

1.   Select C to clear the financial registers.

2.   Key in 9,000 and select PV to enter the loan amount.

3.   Select End to make sure end-mode is being used.

4.   Key in 7.95 and select ¸12 to enter the interest rate per period.

5.   Key in 7 and select ´12 to enter the number of compounding periods.

6.   Select PMT. The monthly payment is $140.0518.

 

Example:  How much could you afford to pay for a new car if you could afford $450 monthly payments?  Assume a 6year loan with 7.25% interest compounded monthly.

 

1.   Select C   to clear the financial registers and set end mode.

2.   Key in 450 and select PMT   to enter the monthly payment amount.

3.   Key in 7.25 and select ¸12   to enter the interest rate per period.

4.   Key in 6 and select ´12    to enter the number of periods.

5.  Select PV to calculate the purchase price.

 

The amount you could afford to pay for the car is $26,209.2679.

 

Mortgage Calculation

 

Example:  How much would your monthly payments be for a house costing $170,000 at 9.75% compounded monthly on a 25 year loan?

 

1.   Select C , End to clear the financial registers and use end mode.

2.   Key in 170,000 and select PV    to enter the purchase price.

6.       Key in 9.75 and select ¸12 to enter the interest rate per compounding period.

7.       Key in 25 and select ´12 to enter the number of periods.

8.       Select PMT to compute the monthly payment.  The result is $1,514.9336.

 

The result is negative because it represents an amount paid out.

 

Example: Calculate the payments for the first 2 years of a variable rate mortgage if the interest rate is 9.75% for the first year and 10.25% for the second year.  The loan amount is $180,000 and has a 15year term.

 

1.       Select C, End to clear the financial and select end mode.

2.       Key in 180,000 and select PV to enter the loan amount.

3.       Key in 15 and select ´12 to enter the number of compounding periods.

4.       Key in 9.75 and select ¸12 to enter the 1st year's interest rate

5.       Select PMT to calculate the payments for the 1st year.

 

The result is $1,906.8528.

 

6.   Key in 1 and select ´12, FV to calculate the remaining balance after the 1st year.  The result is $174,422.9092.

7.   Key in the result of FV with sign change(i.e. 174,422.9092), and select PV  to store the new loan amount.

8.   Key in 14 and select ´12 to enter the new number of compounding periods.

9.   Key in 10.25 and select ¸12 to enter the new interest rate.

10.       Key in 0 and select FV since the loan will be paid off at the end.

11.       Select PMT to calculate the 2nd year's payments.

 

The result is $1,959.2811.

 

Savings Calculation

 

Example:  Suppose you have $7,000 in a savings account.  You have just received a raise and are able to make monthly deposits of $550 into this account.  How long will it be before you have $19,000 if your account earns 6.75% interest compounded monthly?

 

 

1.   Select C , End to clear the financial registers.

2.   Key in 7,000, ± and Select PV to enter the beginning amount.

3.   Key in 550, ± and select PMT to enter the monthly deposit.

4.   Key in 6.75, select ¸12 to enter the interest rate per compounding period.

6.       Key in 19,000 and select FV to enter the future value.

7.       Select n to calculate the number of periods.

 

The result is 19 months. 

 

 

Example:  A savings account has a $100,000 balance and earns 8.25% interest compounded monthly.  How long will it take before the account is depleted  if regular monthly withdrawals of $1800 are made at the beginning of each month?

 

1.       Select  C , Beg to clear the financial registers and select begin mode.

2.       Key in 100,000 and Select PV  to enter the balance.

3.       Key in 8.25 and Select ¸12 to enter the interest rate per compounding period.

4.       Key in 1800 and Select  ±  , PMT  to enter the monthly withdrawal.

5.       Select n to calculate the number of months to deplete the account.

 

The result is 70 months (5.8333 years).

 

Discounted Cash Flow Analysis

 

The Net Present Value, and Internal Rate of Return functions allows you to compute compound interest problems at regular intervals where the payment (positive or negative) amount is irregular. In addition, if a number of the amounts are regular, you can "group" them together. You must observe the Cash Flow Sign Convention when entering the payment amounts.

 

The NPV function calculates the net present value of a series of cash flows made at regular intervals.  It is most commonly used to perform an analysis between a variety of investment opportunities.   A negative NPV represents a loss on an investment.

 

Example:  Suppose you are considering purchasing a hotel for an initial payment of $150,000.  You predict that cash flows for the first 3 years to be $50,000 each year, $65,000 for the 4th year, and $75,000 for the 5th year.  You desire a 20% return on investment.  Can this amount be realized?

 

1.   Select C  to clear the financial registers.

2.   Key in 150,000 and Select +/-, CFo to enter the initial cash outlay.

3.   Key in 50,000 and Select CFj To enter the 2nd cash flow.

4.   Key in 3 and Select Nj to "group" 3 cash flows at 45,000.

5.   Key in 65,000 and Select CFj to enter the 4th cash flow.

6.   Key in 75,000 and Select CFj to enter the 5th cash flow.

7.   Key in 20 and Select i to enter the interest rate.

 

8.   Select NPV to calculate the net present value.

 

The result is $16,811.3426

 

8.       Select IRR to calculate the Internal Rate of Return.  The investment would yield 24.6367%.

 

Note: Please note the cash Flow Sign Convention. Compound interest calculations involve money being received as well as paid out.  For example, if you take out a loan, you initially receive money (positive) and then make periodic payments (negative). Thus a loan calculation would involve a positive present value and a negative payment.

 

 

 



 

PDA Software

Wireless

Design Services

 

Sign-up here to Get
update information.
Your Name

Your E-Mail address
 
 
 
 
 

(c) 2001 - 2002 Softtrends, LLC, 1475 Barrett Place, Lawrenceville, GA 30043
(c) 2001 - 2002 Softtrends Software Pvt Ltd, 2970-1,12th Main, 4th Cross, HAL II Stage, Indiranagar, Bangalore 560008, India.
Contact