Sharp EL-738 Financial Calculation Formulas, TVM solver, Amortization calculations

Page 73

Appendix

Financial Calculation Formulas

TVM solver

PMT, PV, FV, N

Error

I/Y

If PMT = 0 then

If N = 1 then

If PMT nd i using the fol- lowing equations:

+

Error i

Amortization calculations

Calculations

(for PV, PMT, and i, see the TVM solver)

END INT(1) = ROUND(–PV i)

BGN INT(1) = 0

PRN(1) = –INT(1) + ROUND(PMT)

BAL(1) = PRN(1) + PV

INT(m) = ROUND(–BAL(m – 1) i)

PRN(m) = –INT(m) + ROUND(PMT)

BAL(m) = PRN(m) + BAL(m – 1)

ROUND(NUM): If a display notation tab setting has been chosen, NUM is rounded and truncated to the specied number of places after the decimal point.

Results

Error

AMRT P1 > AMRT P2

Discounted cash flow analysis

m

m

CF

where i = RATE(I/Y) , CFimax = the maxi- 100

mum data set number

IRR is obtained as i, which satises NPV = 0 in the above equations.

72

Image 73
Contents EL-738 Page Contents Operational Notes IntroductionKey Notations in This Manual Using the .andKeys Resetting the calculator Resetting the Calculator In Case of DifficultyPreparing to Use the Calculator Calculator layout Calculator and Display LayoutKey operation keys 2ndF Display layoutSelecting the display notation and number of decimal places SET UP Menu0003 3333333000 Selecting the angular unit seeOperations available in each mode Selecting a modeOperating Modes Selecting the date format see343 140009000 Basic CalculationsDelete key ⋅ ⋅Memory clear key Editing and Correcting an EntryCursor keys Playback functionMemory use in each mode for memory calculations Errors500 192Independent memory M Temporary memories A-H, X-ZLast answer memory ANS TVM variablesMemory calculations Statistical variablesExample Key operation Financial calculations General InformationVariables shared among calculations Variables used in financial calculationsTVM variables N, I/Y, PV, PMT, FV Basic variable operationsListed financial variables Category Display symbols Descriptions ENT and Comp symbolsCompound interest Cash flow diagramsVariable Corresponding Description Default Variable key Setting the payment period payment dueTVM Time Value of Money Solver Variables used in the TVM solverCalculating basic loan interest Basic examples for the TVM solver24000 12005600000 440008000 400125586 Calculating basic loan payments20000 3600FV= Calculating future value2000 1001000000 376889Ordinary annuity END Specifying payments dueAnnuity due BGN Ordinary annuity30000000 1800360 162457029950 240014500 299500150000 3400627995 Calculating down payment and amount to borrow90000 30000550 14655892Amortization Calculations Variable Description Default valueVariables used in amortization 8895148 61656203428 104852600 17004800 38445748275524 1724476Entering cash flow data Discounted Cash Flow AnalysisSingle cash flows Repeated cash flows200 000*2300 Confirming and editing dataEditing data 2500000Deleting data Inserting data600000 3000000Variables used in discounted cash flow analysis NPV and IRRPlay in Normal mode Procedure Key operation Display Bring up the initial disTo obtain NPV To obtain IRRCalculating the present value of variable cash flows 2314662752 Bond Calculations Setting the day-count methodVariables used in bond calculations To obtain yield to maturity Yield I/Y To obtain bond price Price PV10000 65015-2023 720728 9250Entering dates Depreciation Calculations Setting the depreciation methodVariables used in depreciation calculations Key operation DescriptionPage 5000000 3000Calculating straight-line depreciation Conversion between APR and EFF 1956To change APR to EFF To change EFF to APRVariables used in day and date calculations Day and Date Calculations22800 10-2009Calculating number of days Answer 228 daysPercent Change/Compound Interest Cal- culations Procedure Key operation Display Move to the last dateCalculate 11600000 75000005467 800000113 980000Cost/Sell/Margin/Markup Calculations Variables used in cost/sell/margin/markup calcula- tions9500 4556088842 Determining selling priceVariables used in breakeven calculations Breakeven CalculationsCalculating the breakeven point 7580 150000012000 33937Chain Calculations Constant Calculations071 0875000 4500Random numbers Random FunctionsRandom dice Random coinModify Function 532Random integer For a single-variable data set Entering statistical dataFor a two-variable data set x value y value J Key operation Sub-mode DisplayEntering statistical data 1000 2000 Single-variable statistical calculations Statistical Calculations and VariablesLinear regression calculations Quadratic regression calculationVariables Content 17857 53000Single-variable statistical calculation Linear regression calculation Quadratic regression calculation TVM solver Financial Calculation FormulasAmortization calculations Discounted cash flow analysisBond calculations Conversion between APR and EFF Depreciation calculationsDay and date calculations Cost/Sell/Margin/Markup calculations Statistical Calcula- tion FormulasBreakeven calculations Error codes and error types Errors and Calculation RangesSyntax error Error Calculation error ErrorNo solution Error Equation too long ErrorDisplay error Error Input value error ErrorFunction Calculation range Calculation ranges of functionsInteger When to replace the battery Battery ReplacementAutomatic power-off function Replacement procedurePriority Levels in Calculations For more information about business/ financial calculators SpecificationsKey operation and calculation priority Index Formulas, 72-75 FV, 18, 22, 72 GRAD, 8, 9, 61 Memo