> Using Apps > Financial App

Financial App

You can use the Financial app to perform a variety of financial calculations.

Important!

Calculation results and graphs produced in this app should be regarded as reference values only.

Whenever performing an actual financial transaction, be sure to check any calculation results obtained using this calculator against the figures calculated by your financial institution.

Whether you should use a positive or a negative value for the present value (PV) or the purchase price (PRC) depends on the type of calculation you are trying to perform.

Operation Flow

Example:  To calculate the total principal and interest after two years (730 days*) when $3,000 is invested at a simple interest rate of 5.0%, and then to display a graph and check the calculation results against the graph

  1. h > Financial

  2. This displays the Financial tab.

    CY875_V2_Financial_Operation Flow_1
  3. Highlight [Simple Interest] and then press O.

  4. This displays the Simple Interest Setup tab.

    CY875_V2.2_Financial_Operation Flow_2
  5. Select the item you want to calculate.

    1. Press d to highlight the Solvefor button.

    2. Use l or r to select the item you want to calculate.

    3. To calculate this:

      Display this item:

      Simple Interest

      SI

      Future Value (SI)

      FV (SI)

      Since we want to calculate the future value, display “FV (SI)” here.

      CY875_V2.2_Financial_Operation Flow_2-1
  6. Input the following information: n (days) = 730; I‎%‎ (annual interest rate) = 5; PV (present value) = -3000.

  7. d730E5Es-(M)3000E

    CY875_V2.2_Financial_Operation Flow_3
  8. Specify the color that you want to use for the graph in step 7 of this procedure.

    1. Select T > [Graph Color].

    2. Select the color you want and then press O.

  9. To execute the calculation, press U to highlight Solvefor, and then press O.

  10. This moves the highlighting to the FV line and displays the calculation result for future value (FV = principal + interest).

    An error occurs if parameters are not configured correctly.

    CY875_V2.2_Financial_Operation Flow_4
  11. To display the graph, press >.

  12. To check the calculation results on the graph, select T > [Trace].

  13. This enables trace and causes a crosshair pointer (+pointer) to appear on the graph.

    Each press of r while trace is enabled cycles the displayed value in the sequence: present value (PV) → simple interest (SI) → future value (FV). Pressing l cycles in the reverse direction.

    To exit trace, press b.

    CY875_V2_Financial_Operation Flow_5
  14. To return from the Graph tab to the Setup tab, press b or <.

Note

You can also use the procedure below instead of step 3 above.

  1. Select T > [Solve for].

  2. Use d or u to select [Future Value (SI)], and the press O.

The SI and FV lines are for displaying results only. You cannot input values in these lines.

Performing Financial Calculations

The calculations in the table below can be performed with the Financial app.

To perform this type of calculation:

Select this for the financial calculation mode:

Interest without compounding based on the number of days money is invested

Simple Interest*1

Interest based on compounding parameters specified by you

Compound Interest*2

Value of money paid out or received in varying amounts over time

Cash Flow

Interest and principal portions of a payment or payments

Amortization*2

Effective or nominal interest rate for interest compounded multiple times during a year

Conversion

Cost, selling price, or margin of profit on an item given the other two values

Cost/Sell/Margin

Number of days between two dates, or the date that is a specified number of days from another date

Days Calculation*1

Amount that a business expense can be offset by income (depreciated) over a given year

Depreciation

Purchase price or annual yield of a bond

Bond Calculation*1*3

Before performing a calculation, specify S > [Number of Days/Year].

Before performing a calculation, specify S > [Payment Point].

Before performing a calculation, specify S > [Interest Paid].

Selecting Financial Calculation Modes

You can select a financial calculation mode on the Financial tab or Setup tab.

To select a financial calculation mode on the Financial tab

  1. Display the Financial tab.

  2. Use d or u to highlight the financial calculation mode you want to select, and then press O (or >).

To select a financial calculation mode on the Setup tab

  1. Display the Setup tab.

  2. Use d or u to highlight the first line.

  3. Use l or r to display the financial calculation mode you want to select.

 

Or:

  1. Display the Setup tab.

  2. Select T > [Mode].

  3. Use d or u to highlight the financial calculation mode you want to select, and then press O.

Calculation Examples

Example 1 (Conversion):

To determine the annual percentage rate (APR) on a bi-monthly compounded (n = 6) bond with an effective interest rate (EFF) of 5%

  1. On the Financial tab, highlight [Conversion] and then press O.

  2. This displays the Conversion Setup tab.

  3. Select the item you want to calculate.

    1. Press d to highlight the Solvefor button.

    2. Use l or r to select the item you want to calculate.

    3. To calculate this:

      Display this item:

      Effective Interest Rate

      EFF

      Annual Percent Rate

      APR

      Since we want to calculate the annual percentage rate, display “APR” here.

      CY875_V2.2_Financial_Calculation Example_1-0
  4. Input the following information: n (number of compoundings) = 6; EFF (effective interest rate) = 5.

  5. d6E5E

    CY875_V2.2_Financial_Calculation Example_1-1
  6. To execute the calculation, press U to highlight Solvefor, and then press O.

  7. This moves the highlighting to the APR line and displays the calculation result for the annual percentage rate.

    CY875_V2.2_Financial_Calculation Example_1-2

Note

You can also use the procedure below instead of step 2 above.

  1. Select T > [Solve for].

  2. Use d or u to select [Annual Percent Rate], and the press O.

The EFF and APR lines are used for both inputting values and displaying results.
When you select the APR item to calculate the annual percentage rate as the above example, the calculation result is displayed in the APR line based on the values entered in the n and EFF lines.
If you select the EFF item to calculate the effective interest rate, the calculation result is displayed in the EFF line based on the values entered in the n and APR lines.

 

Example 2 (Depreciation):

To use the sum-of-the-years’-digits method to calculate the first-year depreciation for a personal computer with a useful life (n) of 5 years and original cost (PV) of $12,000. Assume 12 months as the number of months of depreciation in the first year (Y−1). Also, display a list of the depreciation for each year.

  1. On the Financial tab, highlight [Depreciation] and then press O.

  2. This displays the Depreciation Setup tab.

  3. Select the item you want to calculate.

    1. Press d to highlight the Solvefor button.

    2. Use l or r to select the item you want to calculate.

    3. To do this:

      Display this item:

      Depreciation calculation using the straight-line method (Straight-Line)

      SL

      Depreciation calculation using the fixed percentage method (Fixed Percent)

      FP

      Depreciation calculation using the sum-of-the-years’-digits method (Sum-of-the-Years’-Digits)

      SYD

      Depreciation calculation using the declining balance method (Declining Balance)

      DB

      Calculation of the depreciation rate for the fixed percentage method (Depreciation Rate (%))

      I%

      Since we want to calculate using the sum-of-the-years’-digits method, display “SYD” here.

      CY876_V2.2_Financial_Calculation Example_2-0 SYD
  4. Input the following information: n (useful life) = 5; PV (original cost) = 12000; FV (residual book value) = 0; j (year for calculation of depreciation cost) = 1; Y−1 (number of months in the first year of depreciation) = 12.

  5. d5Ed12000E0E1E12E

    CY875_V2.2_Financial_Calculation Example_2-1 SYD
  6. To execute the calculation, press U to highlight Solvefor, and then press O.

  7. This moves the highlighting to the SYD line and displays the calculation result for the first-year depreciation.

    CY876_V2.2_Financial_Calculation Example_2-2-1 SYD
  8. To display a list of the depreciation for each year, press >.

  9. The Table tab shows the depreciation (SYD) for each year (j) and the remaining depreciated value (RDV) at the end of each year.

    While viewing the Table tab, you can display the graph by pressing >.

    CY875_V2.2_Financial_Calculation Example_2-3 SYD

Note

Instead of step 2 above, you can also select T > [Solve for] > [Sum-of-the-Years’-Digits].

All lines below the FP line are for displaying results only. You cannot input values in these lines.

 

Example 3 (Bond Calculation):

You want to purchase a semiannual bond*1 that matures on December 15, 2028 (d2) and has a settlement date of June 1, 2024 (d1). The bond is calculated based on 365 days per year.*2 The bond is redeemed at 100% of its face value (RDV) and the coupon rate (CPN) is 3%. If the yield to maturity (YLD) is 4%, determine the price of the bond (PRC), the accrued interest (INT), and the purchase price including accrued interest (CST).

  1. On the Financial tab, highlight [Bond Calculation] and then press O.

  2. This displays the Bond Calculation Setup tab.

  3. Select the item you want to calculate.

    1. Press d to highlight the Solvefor button.

    2. Use l or r to select the item you want to calculate.

    3. To calculate this:

      Display this item:

      Bond’s Price

      PRC

      Yield to Maturity

      YLD

      Accrued Interest

      INT

      Dirty Price

      CST

      Since we want to determine the bond price, display “PRC” here.

      CY875_V2.2_Financial_Calculation Example_3-0
  4. Input the following information: d1 = 6/1/2024 (month/day/year); d2 = 12/15/2028 (month/day/year); RDV = 100; CPN = 3; YLD = 4.

  5. dE6E1E2024EE
    E12E15E2028EE
    100E3Ed4E

    CY875_V2.2_Financial_Calculation Example_3-1
  6. To execute the calculation, press U to highlight Solvefor, and then press O.

  7. This moves the highlighting to the PRC line and displays the calculation result for the bond price.

    CY875_V2.2_Financial_Calculation Example_3-2-1

    Use d to scroll the screen and display calculation results below.
    PRC: bond price
    INT: accrued interest
    CST: price including interest

    CY875_V2.2_Financial_Calculation Example_3-2-2

Note

Instead of step 2 above, you can also select T > [Solve for] > [Bond’s Price].

The INT and CST lines are for displaying results only. You cannot input values in these lines.

Note: Bond Calculation Memorandum Screen

Selecting T > [Display Memorandum] on the Setup tab of Bond Calculation displays the number-of-day values used in the calculation as shown below.

PRD:

number of days from d1 to d2

N:

number of coupon payments between settlement date and maturity date

A:

accrued days

B:

number of days from settlement date until next coupon payment date (D − A)

D:

number of days in coupon period where settlement occurs

CY875_V2.2_Financial_Calculation Example_Note_1

Selecting T > [Show Coupon Payment Day] while the Memorandum screen is displayed changes to a screen showing the interest payment date (only when S > [Number of Days/Year] is “365”). If there are multiple interest payment dates from the redemption year to the year of purchase, each press of O while this screen is displayed each interest payment date scrolls back sequentially until the first payment is reached.

Input/Output Terms and Calculation Formulas

Simple Interest

SI: interest

n: number of interest periods

PV: principal

I%: annual interest rate

FV: principal plus interest

365-day Mode: SI'= n365×PV×i    (i= I%100)

360-day Mode: SI'= n360×PV×i    (i= I%100)

SI= -SI'

FV= -(PV+SI')

Compound Interest

n: number of compound periods

I%: annual interest rate

PV: present value

PMT: payment

FV: future value

P/Y: installment periods per year

C/Y: compounding periods per year

When calculating PV, PMT, FV, n

I%0

PV=-(α×PMT+β×FV)

PMT=-PV+β×FVα

FV=-PV+α×PMTβ

n=log{(1+iS)×PMT-FV×i(1+iS)×PMT+PV×i}log(1+i)

I%=0

PV=-(PMT×n+FV)   (n>0)

PMT=-PV+FVn   (n>0)

FV=-(PMT×n+PV)   (n>0)

n=-PV+FVPMT

 

α=(1+i×S)×1-βi  β=(1+i)-n

 

 

When S > [Payment Point] is “End”

When S > [Payment Point] is “Beginning”

S=

0

1

 

 

When P/Y=C/Y=1

When P/Y1 and/or C/Y1

i=

 I%100

(1+I%100×[C/Y])C/YP/Y-1

 

When calculating I‎%‎

i (effective interest rate) is calculated using Newton’s Method.

PV+α×PMT+β×FV=0

I%= is calculated from i using the formulas below:

 

When P/Y=C/Y=1

When P/Y1 and/or C/Y1

I%=

i×100

((1+i)P/YC/Y-1)×C/Y×100

Important!

When inputting both the present value (PV) and future value (FV) for a calculation, either PV or FV must be positive, while the other (PV or FV) is negative.

Annual interest rate (I‎%‎) calculations are performed using Newton’s Method, which produces approximate values whose precision can be affected by various calculation conditions. Interest calculation results produced by this application should be used keeping the above in mind, or results should be confirmed separately.

Cash Flow

This calculator uses the discounted cash flow (DCF) method to perform investment appraisal by totalling cash flow for a fixed period. This calculator can perform the following four types of investment appraisal.

NPV: Net present value

IRR: Internal rate of return

NFV: Net future value

PBP: Payback period

A cash flow diagram like the one shown below helps to visualize the movement of funds.

CY875_V2_Financial_Cash Flow_1

With this graph, the initial investment amount is represented by CF0. The cash flow one year later is shown by CF1, two years later by CF2, and so on.

NPV=CF0+CF1(1+i)+CF2(1+i)2+CF3(1+i)3+・・・+CFn(1+i)n
(i=I%100, I%: Interest rate, n: natural number up to 254)
NFV=NPV×(1+i)n

 

IRR is calculated using the formula below:

0=CF0+CF1(1+i)+CF2(1+i)2+CF3(1+i)3+・・・+CFn(1+i)n

In this formula, NPV = 0, and the value of IRR is equivalent to i × 100. It should be noted, however, that minute fractional values tend to accumulate during the subsequent calculations performed automatically by the calculator, so NPV never actually reaches exactly zero. IRR becomes more accurate the closer that NPV approaches to zero.

PBP={    

0………………………(CF00)
n-NPVnNPVn+1-NPVn・・・(Other than those above)

NPVn=k=0nCFk(1+i)k

n:

smallest positive integer that satisfies the conditions
NPVn0, 0NPVn+1, or 0

Amortization

PM1: first installment of installments 1 through n

PM2: second installment of installments 1 through n

n: installments

I%: interest rate

PV: principal

PMT: payment for each installment

FV: balance following final installment

P/Y: installments per year

C/Y: compoundings per year

CY875_V2_Financial_Amortization_1-1 + CY875_V2_Financial_Amortization_1-1

1 payment

Last

Number of payments

CY875_V2_Financial_Amortization_1-2 + CY875_V2_Financial_Amortization_1-2

1 payment

Last

Number of payments

 

a:

interest portion of installment PM1 (INT)

INTPM1=|BALPM1-1×i|×(PMT sign)

b:

principal portion of installment PM1 (PRN)

PRNPM1=PMT+BALPM1-1×i

a + b = one repayment (PMT)

 

c:

balance of principal after installment PM2 (BAL)

BALPM2=BALPM2-1+PRNPM2

d:

total principal from installment PM1 to payment of installment PM2 (ΣPRN)

PM1PM2PRN=PRNPM1+PRNPM1+1+・・・+PRNPM2

e:

total interest from installment PM1 to payment of installment PM2 (ΣINT)

PM1PM2INT=INTPM1+INTPM1+1+・・・+INTPM2

When S > [Payment Point] is “End”, BAL0=PV.

When S > [Payment Point] is “Beginning”, INT1=0 and PRN1=PMT.

 

Converting between the nominal interest rate and effective interest rate

The nominal interest rate (I‎%‎ value input by user) is converted to an effective interest rate (I‎%‎’) for installment loans where the number of installments per year is different from the number of compound interest calculation periods.

I%'={(1+I%100×[C/Y])[C/Y][P/Y]-1}×100

The following calculation is performed after conversion from the nominal interest rate to the effective interest rate, and the result is used for all subsequent calculations.

i=I%'÷100

Conversion

EFF: Effective interest rate (%)

APR: Annual percent rate (%)

n: number of compoundings

 

EFF=[(1+APR/100n)n-1]×100
APR=[(1+EFF100)1n-1]×n×100

Cost/Sell/Margin

Cst: Cost price

Sel: Selling price

Mrg: Margin (%)

 

Cst=Sel (1-Mrg100)
Sel=Cst1-Mrg100
Mrg(%)=(1-CstSel)×100

Days Calculation

Number of Days

=

d2−d1

(d1: date 1, d2: date 2)

Days After

=

d1+D

(d1: date, D: number of days)

Days Before

=

d1−D

(d1: date, D: number of days)

Depreciation

Straight-Line Method (SL)

SLj: depreciation charge for the jth year

n: useful life

PV: original cost (basis)

FV: residual book value

j: year for calculation of depreciation cost

Y-1: number of months in the first year of depreciation

 

SL1=(PV-FV)n×{Y-1}12

SLj=(PV-FV)n

SLk=(PV-FV)n×12-{Y-1}12

(k=n+1, {Y-1}12)

Fixed-Percent Method (FP)

FPj: depreciation charge for the jth year

RDVj: remaining depreciable value at the end of jth year

I%: depreciation ratio

FP1=PV×I%100×{Y-1}12

FPj=(RDVj-1+FV)×I%100

FPn+1=RDVn ({Y-1}12)

RDV1=PV-FV-FP1

RDVj=RDVj-1-FPj

RDVn+1=0 ({Y-1}12)

Sum-of-the-Years’-Digits Method (SYD)

SYDj: depreciation charge for the jth year

RDVj: remaining depreciable value at the end of jth year

Z=n(n+1)2

n'=n-{Y-1}12

Z'=(Intg(n')+1) (Intg(n')+2×Frac(n'))2

SYD1=nZ×{Y-1}12 (PV-FV)

SYDj=(n'-j+2Z') (PV-FV-SYD1)

(j1)

SYDn+1=(n'-(n+1)+2Z') (PV-FV-SYD1)×12-{Y-1}12 ({Y-1}12)

RDV1=PV-FV-SYD1

RDVj=RDVj-1-SYD1

 

Declining-Balance Method (DB)

DBj: depreciation charge for the jth year

RDVj: remaining depreciable value at the end of jth year

I%: depreciation factor

DB1=PV×I%100n×{Y-1}12

RDV1=PV-FV-DB1

DBj=(RDVj-1+FV)×I%100n

RDVj=RDVj-1-DBj

DBn+1=RDVn ({Y-1}12)

RDVn+1=0 ({Y-1}12)

Bond Calculation

CY875_V2_Financial_Bond Calculation_1
  1. Issue date

  2. Coupon payment dates

  3. Purchase date (d1)

  4. Redemption date (d2)

PRC: price per $100 of face value

CPN: coupon rate (%)

YLD: annual yield (%)

M: number of coupon payments per year (1=annual, 2=semi annual)

N: number of coupon payments between settlement date and maturity date

RDV: redemption price or call price per $100 of face value

INT: accrued interest

CST: price including interest

D: number of days in coupon period where settlement occurs

A: accrued days

B: number of days from settlement date until next coupon payment date =D-A

For one or fewer coupon period to redemption

PRC=- RDV+CPNM1+(BD×YLD/100M)+AD×CPNM

For more than one coupon period to redemption

PRC=- RDV(1+YLD/100M)(N-1+BD)-k=1NCPNM(1+YLD/100M)(k-1+BD)+AD×CPNM

INT=- AD×CPNM

CST=PRC+INT

 

Important!

The Financial app performs annual yield (YLD) calculations using Newton’s Method, which produces approximate values whose precision can be affected by various calculation conditions. Because of this, annual yield calculation results produced by this app should be used keeping the above in mind, or results should be confirmed separately.

Financial App Settings Menu Items

The Settings menu items described below are specific to the Financial app.

S > [Payment Point] ...

Specifies the beginning of the period (Beginning) or the end of the period (End) as the payment date. This setting affects Compound Interest and Amortization calculations.

S > [Number of Days/Year] ...

Specifies the number of days in a year as 365 or 360. This setting affects Simple Interest, Days Calculation and Bond Calculation.

S > [Interest Paid] ...

Specifies the interval between interest payments in a Bond Calculation as either once a year or once every six months.