> 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_Financial_Operation Flow_2
  5. Since we want to determine the sum of principal and interest, select the [Type] menu’s [Future Value (SI)] item.

    1. Highlight [Type] and then press O.

    2. On the menu that appears, select [Future Value (SI)] and then press O.

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

  7. d730E5Es-(M)3000E

    CY875_V2_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 > (or highlight Buttom_Execute and press O).

  10. This displays the calculation result for future value (FV = principal + interest) on the Result tab.

    An error occurs if parameters are not configured correctly.

    CY875_V2_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 Result tab, press b or <.

Performing Financial Calculations

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

To perform this type of calculation:

Select this on the Financial tab:

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].

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 (I‎%‎) of 5%

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

  2. This displays the Conversion Setup tab.

  3. Since we want to find the annual percentage rate, select [Annual Percent Rate] from the [Type] menu.

    1. Highlight [Type] and then press O.

    2. On the menu that appears, select [Annual Percent Rate] and then press O.

  4. Input the following information: n (number of compoundings) = 6; I‎%‎ (interest rate) = 5.

  5. d6E5E

    CY875_V2_Financial_Calculation Example_1-1
  6. To execute the calculation, press >.

  7. This displays the calculation result on the Result tab.

    CY875_V2_Financial_Calculation Example_1-2

 

Example 2 (Depreciation):

To use the sum-of-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. Since we are using the sum-of-years’-digits method, select [Sum-of-the-Years’-Digits] from the [Type] menu.

  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. d5E12000E0E1E12E

    CY875_V2_Financial_Calculation Example_2-1
  6. To execute the calculation, press >.

  7. This displays the calculation result on the Result tab.

    CY875_V2_Financial_Calculation Example_2-2
  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_Financial_Calculation Example_2-3

 

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. Since we want to determine the bond price, select [Bond’s Price] from the [Type] menu.

  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
    100E3E4E

    CY875_V2_Financial_Calculation Example_3-1
  6. To execute the calculation, press >.

  7. This displays the calculation result on the Result tab.

    CY875_V2_Financial_Calculation Example_3-2

    Note: Bond Calculation Memorandum Screen

    Selecting T > [Display Memorandum] on the Result 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_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

I%: Interest rate

 

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.