User Guide
Page 4
... Functions 7-16 Chapter 8 Programming 1. Basic Spreadsheet Operations 9-2 3. eActivity Overview...10-1 2. Calculating and Graphing Single-Variable Statistical Data 6-4 3. Input and Output Terms of Tests, Confidence Interval, and Distribution 6-50 9. Cost, Selling Price, Margin 7-10 8. Bond Calculations ...7-14 11. Editing Program Contents 8-3 4. File Management ...8-5 5. Using Calculator Functions in Programs 8-21 7. Using Special S • SHT Mode Commands 9-14...
... Functions 7-16 Chapter 8 Programming 1. Basic Spreadsheet Operations 9-2 3. eActivity Overview...10-1 2. Calculating and Graphing Single-Variable Statistical Data 6-4 3. Input and Output Terms of Tests, Confidence Interval, and Distribution 6-50 9. Cost, Selling Price, Margin 7-10 8. Bond Calculations ...7-14 11. Editing Program Contents 8-3 4. File Management ...8-5 5. Using Calculator Functions in Programs 8-21 7. Using Special S • SHT Mode Commands 9-14...
User Guide
Page 196
... rate conversion} • {COST} ... {cost, selling price, margin} • {DAYS} ... {day/date calculations} • {DEPR} ... {depreciation calculations} • {BOND} ... {bond calculations} 7 I Setup Items S Payment • {BGN}/{END} ... Specifies calculation according to a {365-day}/{360-day} year S Periods...graph while the Label item is not equipped with the TVM mode. 1. Before Performing Financial Calculations From the Main Menu, enter the TVM mode and display the Financial screen like the one shown below. Chapter 7 Financial Calculation (TVM) Important! • The fx...
... rate conversion} • {COST} ... {cost, selling price, margin} • {DAYS} ... {day/date calculations} • {DEPR} ... {depreciation calculations} • {BOND} ... {bond calculations} 7 I Setup Items S Payment • {BGN}/{END} ... Specifies calculation according to a {365-day}/{360-day} year S Periods...graph while the Label item is not equipped with the TVM mode. 1. Before Performing Financial Calculations From the Main Menu, enter the TVM mode and display the Financial screen like the one shown below. Chapter 7 Financial Calculation (TVM) Important! • The fx...
User Guide
Page 197
... 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 graph the results as shown below. • Pressing (TRCE) while a graph is on the type of interest periods (days) I % : annual ...8226; Whenever performing an actual financial transaction, be sure to check any calculation results obtained using this calculator with against the figures calculated by your financial institution. 2. I Graphing in the TVM Mode After performing a financial calculation, you can be used to look up other financial values. S ...
... 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 graph the results as shown below. • Pressing (TRCE) while a graph is on the type of interest periods (days) I % : annual ...8226; Whenever performing an actual financial transaction, be sure to check any calculation results obtained using this calculator with against the figures calculated by your financial institution. 2. I Graphing in the TVM Mode After performing a financial calculation, you can be used to look up other financial values. S ...
User Guide
Page 205
...to annual percent rate} • An error (Ma ERROR) occurs if parameters are not configured correctly. 7-10 selling price, or margin can be calculated by inputting the other two values. margin After configuring the parameters, use one of the function menus noted below to... perform the corresponding calculation. • {COST} ... {cost} • {SEL} ... {selling price 05* : margin Press (COST) from the Financial 2 screen to maneuver between calculation result screens. • {REPT} ... {parameter input screen} 7. Use ...
...to annual percent rate} • An error (Ma ERROR) occurs if parameters are not configured correctly. 7-10 selling price, or margin can be calculated by inputting the other two values. margin After configuring the parameters, use one of the function menus noted below to... perform the corresponding calculation. • {COST} ... {cost} • {SEL} ... {selling price 05* : margin Press (COST) from the Financial 2 screen to maneuver between calculation result screens. • {REPT} ... {parameter input screen} 7. Use ...
User Guide
Page 209
... of coupon payments per year (1=annual, 2=semi annual) N : number of coupon payments between calculation result screens. • {REPT} ... {parameter input screen} • {TABL} ... {displays table} • {GRPH} ... {draws graph} 10. settings (page 7-1). Bond Calculations Bond calculation lets you calculate the purchase price or the annual yield of face value (PRC) • For one or fewer coupon...
... of coupon payments per year (1=annual, 2=semi annual) N : number of coupon payments between calculation result screens. • {REPT} ... {parameter input screen} • {TABL} ... {displays table} • {GRPH} ... {draws graph} 10. settings (page 7-1). Bond Calculations Bond calculation lets you calculate the purchase price or the annual yield of face value (PRC) • For one or fewer coupon...
User Guide
Page 210
... ,17 - Press (BOND) from the Financial 2 screen to display the following function menu to maneuver between calculation result screens. • {REPT} ... {parameter input screen} • {GRPH} ... {draws graph} • {MEMO} ... {displays numbers of face value CPN ...... redemption price per $100 of face value YLD ...... s D0 &67 35&+ ,17 S Annual Yield (YLD) YLD is...
... ,17 - Press (BOND) from the Financial 2 screen to display the following function menu to maneuver between calculation result screens. • {REPT} ... {parameter input screen} • {GRPH} ... {draws graph} • {MEMO} ... {displays numbers of face value CPN ...... redemption price per $100 of face value YLD ...... s D0 &67 35&+ ,17 S Annual Yield (YLD) YLD is...
User Guide
Page 247
...Syntax: Returns the 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 selling price. Amt_INT(PM1, PM2, I %) Cnvt_APR: Syntax: Returns the interest rate converted from payment PM1 to the effective ...and interest paid from the effective interest rate to PM2. Sell(Cost, Margin) Margin: Syntax: Returns the margin based on a specified selling price based on a specified cost and margin. Margin(Cost, Sell) 8-36 Syntax: Amt_3PRN(PM1, PM2, I %, PV, PMT, P/Y, ...
...Syntax: Returns the 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 selling price. Amt_INT(PM1, PM2, I %) Cnvt_APR: Syntax: Returns the interest rate converted from payment PM1 to the effective ...and interest paid from the effective interest rate to PM2. Sell(Cost, Margin) Margin: Syntax: Returns the margin based on a specified selling price based on a specified cost and margin. Margin(Cost, Sell) 8-36 Syntax: Amt_3PRN(PM1, PM2, I %, PV, PMT, P/Y, ...
User Guide
Page 248
...Bond_YLD(MM1, DD1, YYYY1, MM2, DD2, YYYY2, RDV, CPN, PRC) 7. Syntax: Days_Prd(MM1, DD1, YYYY1, MM2, DD2, YYYY2) • Bond Calculations Bond_PRC: Returns in list form bond prices based on all models covered by this manual. PRGM Mode Command List Not all of days from a specified d1 to specified d2. RUN Program...: Bond_PRC(MM1, DD1, YYYY1, MM2, DD2, YYYY2, RDV, CPN, YLD) = {PRC, INT, CST} Bond_YLD: Returns the yield based on specified conditions. • Day/Date Calculations Days_Prd: Returns the number of the commands listed below are available on specified conditions.
...Bond_YLD(MM1, DD1, YYYY1, MM2, DD2, YYYY2, RDV, CPN, PRC) 7. Syntax: Days_Prd(MM1, DD1, YYYY1, MM2, DD2, YYYY2) • Bond Calculations Bond_PRC: Returns in list form bond prices based on all models covered by this manual. PRGM Mode Command List Not all of days from a specified d1 to specified d2. RUN Program...: Bond_PRC(MM1, DD1, YYYY1, MM2, DD2, YYYY2, RDV, CPN, YLD) = {PRC, INT, CST} Bond_YLD: Returns the yield based on specified conditions. • Day/Date Calculations Days_Prd: Returns the number of the commands listed below are available on specified conditions.
User Guide
Page 262
In this , we would use to input a cell reference name: direct input of the name and input using the GRAB command. 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. Copy the formula in cell C2 and copy it is a formula.... do this example, note that contains data based on the formula s = . There are two methods you would put values in column A, values in column B, and calculation formulas (like = A1 s B1, = A2 s B2, and so on) in column C. In addition to values, arithmetic operators, and cell reference names, a ...
In this , we would use to input a cell reference name: direct input of the name and input using the GRAB command. 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. Copy the formula in cell C2 and copy it is a formula.... do this example, note that contains data based on the formula s = . There are two methods you would put values in column A, values in column B, and calculation formulas (like = A1 s B1, = A2 s B2, and so on) in column C. In addition to values, arithmetic operators, and cell reference names, a ...
User Guide
Page 269
... coefficient, and you can overlay a regression graph over the scatter plot. Drawing Statistical Graphs, and Performing Statistical and Regression Calculations When you want to check the correlation between two sets of data (such as temperature and the price of some product), trends become easier to ...spot if you draw a graph that is already data in...
... coefficient, and you can overlay a regression graph over the scatter plot. Drawing Statistical Graphs, and Performing Statistical and Regression Calculations When you want to check the correlation between two sets of data (such as temperature and the price of some product), trends become easier to ...spot if you draw a graph that is already data in...