User Guide
Page 4
Before Performing Financial Calculations 7-1 2. Simple Interest ...7-2 3. Cost, Selling Price, Margin 7-10 8. Basic Spreadsheet Operations 9-2 3. Using Special S • SHT Mode Commands 9-14 4. Drawing Statistical Graphs, and Performing Statistical and Regression Calculations...9-15 5. eActivity File Operations 10-3 4. Chapter 6 Statistical Graphs and Calculations 1. Calculating and Graphing Paired-Variable Statistical Data 6-9 4. Performing Statistical Calculations 6-15 5. Amortization ...7-7 6. Basic Programming Steps...
Before Performing Financial Calculations 7-1 2. Simple Interest ...7-2 3. Cost, Selling Price, Margin 7-10 8. Basic Spreadsheet Operations 9-2 3. Using Special S • SHT Mode Commands 9-14 4. Drawing Statistical Graphs, and Performing Statistical and Regression Calculations...9-15 5. eActivity File Operations 10-3 4. Chapter 6 Statistical Graphs and Calculations 1. Calculating and Graphing Paired-Variable Statistical Data 6-9 4. Performing Statistical Calculations 6-15 5. Amortization ...7-7 6. Basic Programming Steps...
User Guide
Page 196
...semiannual} Note the following points regarding Setup screen settings whenever using the TVM mode. • The following graph Setup screen settings are all turned off for the horizontal axis (frequency). 7-1 Specifies {beginning of the...interest} • {CASH} ... {cash flow (investment appraisal)} • {AMT} ... {amortization} • {CNVT} ... {interest rate conversion} • {COST} ... {cost, selling price, margin} • {DAYS} ... {day/date calculations} • {DEPR} ... {depreciation calculations} • {BOND} ... {bond calculations} 7 I Setup Items S Payment • ...
...semiannual} Note the following points regarding Setup screen settings whenever using the TVM mode. • The following graph Setup screen settings are all turned off for the horizontal axis (frequency). 7-1 Specifies {beginning of the...interest} • {CASH} ... {cash flow (investment appraisal)} • {AMT} ... {amortization} • {CNVT} ... {interest rate conversion} • {COST} ... {cost, selling price, margin} • {DAYS} ... {day/date calculations} • {DEPR} ... {depreciation calculations} • {BOND} ... {bond calculations} 7 I Setup Items S Payment • ...
User Guide
Page 197
... • Whenever performing an actual financial transaction, be used only for simple interest. (SMPL) n number of interest periods (days) I Graphing in the TVM Mode After performing a financial calculation, you are trying to perform. • Note that calculation results produced in this calculator ...to check any calculation results obtained using this mode should use a positive or a negative value for the present value (PV) or the purchase price (PRC) depends on the display activates Trace, which can use (GRPH) to calculate simple interest. annual interest rate PV ........ I % ...
... • Whenever performing an actual financial transaction, be used only for simple interest. (SMPL) n number of interest periods (days) I Graphing in the TVM Mode After performing a financial calculation, you are trying to perform. • Note that calculation results produced in this calculator ...to check any calculation results obtained using this mode should use a positive or a negative value for the present value (PV) or the purchase price (PRC) depends on the display activates Trace, which can use (GRPH) to calculate simple interest. annual interest rate PV ........ I % ...
User Guide
Page 205
..., use one of the function menus noted below to perform the corresponding calculation. • {COST} ... {cost} • {SEL} ... {selling price} • {MRG} ... {margin} • An error (Ma ERROR) occurs if parameters are not configured correctly. cost Sel......... After configuring the ...67 = SEL 1- 05* 100 SEL = &67 1- 05* 100 05*(%) = 1- &67 SEL s 100 &67 : cost SEL : selling price Mrg........ Use the following input screen. (E)(COST) Cst......... Cost, Selling Price, Margin Cost, selling price, or margin can be calculated by inputting the other two values.
..., use one of the function menus noted below to perform the corresponding calculation. • {COST} ... {cost} • {SEL} ... {selling price} • {MRG} ... {margin} • An error (Ma ERROR) occurs if parameters are not configured correctly. cost Sel......... After configuring the ...67 = SEL 1- 05* 100 SEL = &67 1- 05* 100 05*(%) = 1- &67 SEL s 100 &67 : cost SEL : selling price Mrg........ Use the following input screen. (E)(COST) Cst......... Cost, Selling Price, Margin Cost, selling price, or margin can be calculated by inputting the other two values.
User Guide
Page 209
... where settlement occurs B : number of days from settlement date until next coupon payment date = D − A ,17 : accrued interest &67 : price including interest S Price per $100 of face value (PRC) • For one or fewer coupon period to redemption CPN RDV + M A CPN PRC = - +( ×... "Date Mode" and "Periods/YR." Bond Calculations Bond calculation lets you calculate the purchase price or the annual yield of coupon payments between calculation result screens. • {REPT} ... {parameter input screen} • {TABL} ... {displays table} • {GRPH} ... {draws graph} 10.
... where settlement occurs B : number of days from settlement date until next coupon payment date = D − A ,17 : accrued interest &67 : price including interest S Price per $100 of face value (PRC) • For one or fewer coupon period to redemption CPN RDV + M A CPN PRC = - +( ×... "Date Mode" and "Periods/YR." Bond Calculations Bond calculation lets you calculate the purchase price or the annual yield of coupon payments between calculation result screens. • {REPT} ... {parameter input screen} • {TABL} ... {displays table} • {GRPH} ... {draws graph} 10.
User Guide
Page 210
... screens. • {REPT} ... {parameter input screen} • {GRPH} ... {draws graph} • {MEMO} ... {displays numbers of days used in calculations} 7-15 • For more than one of the function menus noted below to perform the corresponding calculation. • {PRC} ... {Calculate the bond's price (PRC), accrued interest (INT), and cost of bond (CST)} •...
... screens. • {REPT} ... {parameter input screen} • {GRPH} ... {draws graph} • {MEMO} ... {displays numbers of days used in calculations} 7-15 • For more than one of the function menus noted below to perform the corresponding calculation. • {PRC} ... {Calculate the bond's price (PRC), accrued interest (INT), and cost of bond (CST)} •...
User Guide
Page 247
...(Cost, Sell) 8-36 Syntax: Cash_PBP(I %, PV, PMT, P/Y, C/Y) Amt_PRN: Returns the principal and interest paid for payment PM1. Syntax: Amt_BAL(PM1, PM2, I %) • Cost, Selling Price, Margin Calculations Cost: Returns the cost based on a specified cost and margin. Cnvt_APR(n, I %, PV, PMT, P/Y, C/Y) Amt_INT: Syntax: Returns the interest paid for payment PM1. Syntax: ... converted from the effective interest rate to the nominal interest rate. Sell(Cost, Margin) Margin: Syntax: Returns the margin based on a specified cost and selling price based on a specified selling...
...(Cost, Sell) 8-36 Syntax: Cash_PBP(I %, PV, PMT, P/Y, C/Y) Amt_PRN: Returns the principal and interest paid for payment PM1. Syntax: Amt_BAL(PM1, PM2, I %) • Cost, Selling Price, Margin Calculations Cost: Returns the cost based on a specified cost and margin. Cnvt_APR(n, I %, PV, PMT, P/Y, C/Y) Amt_INT: Syntax: Returns the interest paid for payment PM1. Syntax: ... converted from the effective interest rate to the nominal interest rate. Sell(Cost, Margin) Margin: Syntax: Returns the margin based on a specified cost and selling price based on a specified selling...
User Guide
Page 248
...} Bond_YLD: Returns the yield based on specified conditions. Syntax: Days_Prd(MM1, DD1, YYYY1, MM2, DD2, YYYY2) • Bond Calculations Bond_PRC: Returns in list form bond prices based on specified conditions. • Day/Date Calculations Days_Prd: Returns the number of the commands listed below are available on all models covered by this...
...} Bond_YLD: Returns the yield based on specified conditions. Syntax: Days_Prd(MM1, DD1, YYYY1, MM2, DD2, YYYY2) • Bond Calculations Bond_PRC: Returns in list form bond prices based on specified conditions. • Day/Date Calculations Days_Prd: Returns the number of the commands listed below are available on all models covered by this...
User Guide
Page 262
... the name and input using the GRAB command. I Inputting a Formula into cell B1. 9-8 I Inputting a Cell Reference Name Each cell on ) in column C. S Formula Input Example A 1 PRICE 2 3 4 B C QUANTITY TOTAL 35 15 525 52 15 780 78 20 1560 Procedure 1.
... the name and input using the GRAB command. I Inputting a Formula into cell B1. 9-8 I Inputting a Cell Reference Name Each cell on ) in column C. S Formula Input Example A 1 PRICE 2 3 4 B C QUANTITY TOTAL 35 15 525 52 15 780 78 20 1560 Procedure 1.
User Guide
Page 269
...in cell range A1:B5. Performing regression calculations on the data will produce a regression formula and correlation coefficient, and you can overlay a regression graph over the scatter plot. Move the cell cursor to cell C1 and then perform the following operation. (CEL)(Sum) )?T(A)@(:)?J(b)D • You...CLIP)CAAAA (Specifies the selection range for each set of data and draw a scatter plot or other set of data as temperature and the price of some product), trends become easier to finalize input of the formula. 4. CellProd( (Product of Cells) Returns the product of the ...
...in cell range A1:B5. Performing regression calculations on the data will produce a regression formula and correlation coefficient, and you can overlay a regression graph over the scatter plot. Move the cell cursor to cell C1 and then perform the following operation. (CEL)(Sum) )?T(A)@(:)?J(b)D • You...CLIP)CAAAA (Specifies the selection range for each set of data and draw a scatter plot or other set of data as temperature and the price of some product), trends become easier to finalize input of the formula. 4. CellProd( (Product of Cells) Returns the product of the ...