Modified Internal Rate of Return | HP 17bII guide

Keys:

Display:

Description:

"

Displays TVM menu.

"

]

"

Sets 1 payment per year

.

1

Y

# 5?@2 JH=;< 0EAH"

and Begin mode.

Z

e

35

<8%.&(("

Stores years until

T

retirement.

v8.175 -28 % *&#*/$&$,"

Calculates and stores

v

;6@28.&*,"

interest rate diminished by

U

tax rate.

0

Stores no present value.

V

5O8(&(("

3000 &

W

50:8/%K(((&(("

Stores annual payment.

Calculates future value.

X

GO8%+.K.(.&'#"

8

"

Calculates present-value

U

0

"

purchasing power of the

W

5O8/$%K%'*&##"

above FV at 8%

V

inflation.

Modified Internal Rate of Return

When there is more than one sign change (positive to negative or negative to positive) in a series of cash flows, there is a potential for more than one IRR%. For example, the cash-flow sequence in the following example has three sign changes and hence up to three potential internal rates of return. (This particular example has three positive real answers: 1.86, 14.35, and 29.02% monthly.)

The Modified Internal Rate of Return (MIRR) procedure is an alternative that can be used when your cash-flow situation has multiple sign changes. The procedure eliminates the sign change problem by utilizing reinvestment and borrowing rates that you specify. Negative cash flows are discounted at a safe rate that reflects the return on an investment in

14: Additional Examples 209

File name : 17BII-Plus-Manual-E-PRINT-030709

Print data : 2003/7/11

Image 209

HP 17bII manual Modified Internal Rate of Return, Keys Display Description

Contents

HP 17bII+ Financial Calculator Edition June Printing History Welcome to the hp17bII+ Welcome to the HP 17bII+ Contents Using Parentheses in Calculations Error MessagesPower Function Exponentiation Saving and Reusing Numbers Cash Flow Calculations Time Value of MoneyInterest Rate Conversions Depreciation Bonds10 121 Running Total and Statistics 11 141 Time, Appointments, and Date Arithmetic 12 153 The Equation Solver 14 190 Additional Examples More About Calculations Assistance, Batteries, Memory, and Service RPN The Stack Menu Maps RPN Summary RPN Selected Examples Error Messages Index List of Examples List of ExamplesGeneral Business Calculations Currency Exchange Calculations Interest Rate Conversions How to Use the Equation Solver Time, Alarms, and Date ArithmeticBonds and Notes Running Total and Statistical Calculations Important Information Important Information Adjusting the Display Contrast Power On and Off Continuous MemoryGetting Started Getting Started What You See in the Display Setting the LanguageKeys for language Key Description 18 1 Getting Started Backspacing and Clearing Shift Key @ 20 1 Getting Started Keys for ClearingKeys Display Description KeysDisplayDescription Doing Arithmetic 22 1 Getting Started Using the Menu KeysKeying in Negative Numbers Menu Labels Menu Keys Main Menu 24 1 Getting Started Main Menu Menu Label Operations Done Covered This Category Choosing Menus and Reading Menu Maps Displaying the MU%C menu Using the MU%C menu26 1 Getting Started Calculations Using Menus 28 1 Getting Started Exiting Menus eClearing Values in Menus = Cost Solving Your Own Equations Solve 30 1 Getting Started Typing Words and Characters the ALPHAbetic Menu Keys Editing ALPHAbetic Text34 5? Characters Alphabetic Editing Operation Label or Key to Press Calculating the Answer CalcKeyboard 32 1 Getting Started Menu for carpeting Decimal Places Controlling the Display FormatInternal Precision Temporarily SHOWing ALL Exchanging Periods and Commas in Numbers Rounding a Number 36 1 Getting Started Error MessagesModes Memory still free Calculator Memory @M Calculator Line ArithmeticVDoing Calculations 38 2 Arithmetic 456 75 × 18.5 VUsing Parentheses in CalculationsKeys Display 30 x 40 2 Arithmetic VThe Percent KeyMathematical Functions Key VThe Power Function ExponentiationShifted Math Functions Math Menu Labels Math MenuKeysDisplay Description 42 2 Arithmetic History Stack of Numbers Saving and Reusing Numbers 44 2 Arithmetic VReusing the Last Result @LVKeys Display VKeys Display Description Storing and Recalling Numbers475.6 560.1 + 39.15 Arithmetic in Registers Keys New Register ContentsDoing Arithmetic Inside Registers and Variables Scientific Notation 48 2 Arithmetic Range of Numbers Business Percentages BUS Menus Percentage Calculations BusinessMenu Description Percentage Calculations in Business Examples Using the BUS Menus Using the BUS MenusPercent Change %CHG 50 3 Percentage Calculations in Business Percent of Total %TOTL 52 3 Percentage Calculations in Business Markup as a Percent of Cost MU%CMarkup as a Percent of Price MU%P Cost Price M%C Cost Price M%P Sharing Variables Between Menus 54 4 Currency Exchange Calculation Currency Exchange CalculationsCurrx Menu Currency Exchange Calculation Selecting a Set of CurrenciesCurrx Menu Currencies Currency Rate United States Conversion Chart in US$Entering a Rate Select HK$ as currency 58 4 Currency Exchange CalculationSelect CAN$ as currency Example Converting between Hong Kong and U.S Dollars Converting Between Two CurrenciesStoring and Recalling Sets of Currencies 60 4 Currency Exchange Calculation Clearing the Currency Variables Time Value of Money Time Value of MoneyTVM Menu Second Level of TVM First Level of TVM Second Level TVM Menu LabelsMenu Label Description First Level 64 5 Time Value of Money Cash Flow Diagrams and Signs of Numbers PMT 66 5 Time Value of Money Using the TVM Menu Loan Calculations Figures and stores number 68 5 Time Value of Money 11.5 Figures and stores 70 5 Time Value of Money 000 Savings Calculations 72 5 Time Value of Money 15X 12X 359 360 74 5 Time Value of Money Leasing Calculations @28#+ 76 5 Time Value of Money Amortization Amrt Amrt Menu Labels Displaying an Amortization ScheduleLabel 78 5 Time Value of Money Number of payments Next successive set of payments authorized 80 5 Time Value of Money Printing an Amortization Table Table 82 5 Time Value of Money 508 /,%&-$ GO8 84 6 Interest Rate Conversions Interest Rate Conversions Interest Rate Conversions Icnv MenuConverting Interest Rates 86 6 Interest Rate Conversions Compounding Periods Different from Payment Periods 88 6 Interest Rate Conversions Per year 90 6 Interest Rate Conversions Cash Flow Calculations Cash Flow CalculationsCflo menu 92 7 Cash Flow Calculations Cflo Menu Labels Cash Flows Ungrouped 94 7 Cash Flow Calculations Creating a Cash-Flow List For grouped cash flows The display now shows Entering Cash Flows 96 7 Cash Flow Calculations Prompting for #TIMES #T?. When the calculator displays EGG Viewing and Correcting the List Naming and Renaming a Cash-Flow List Copying a Number from a List to the Calculator Line98 7 Cash Flow Calculations Deleting Cash Flows from a List. Pressing ndeletes both Viewing the Name of the Current List. Press o, then e Clearing a Cash-Flow List and Its NameStarting or GETting Another List 100 7 Cash Flow Calculations Cash-Flow Calculations IRR, NPV, NUS, NFV Calc Menu for Cflo Lists Menu Label 115,000 500 102 7 Cash Flow Calculations G9ECL#T8U 104 7 Cash Flow Calculations Group Number Amount G9ECL.T8U 50 50 50 106 7 Cash Flow Calculations Doing Other Calculations with Cflo Data 108 8 Bonds BondsBond Menu Bonds Bond Menu LabelsMenu Description Label To calculate the price or yield of a bond Doing Bond Calculations110 8 Bonds Since there is no call on 112 8 Bonds MM.DDYYYY format 114 9 Depreciation DepreciationDeprc Menu Depreciation Deprc Menu Labels DB, SOYD, and SL Methods Doing Depreciation Calculations116 9 Depreciation To calculate the depreciation for an asset Basis Salv 4,000 KeysDisplay 118 9 Depreciation Acrs MethodYear Percentage Deductible Keys Display Description Partial-Year Depreciation 120 9 Depreciation Calendar Year Depreciation Value Running Total and Statistics Running Total and Statistics 122 10 Running Total and Statistics SUM MenuSUM Menu Labels Entering Numbers and Viewing the Total Creating a SUM List 124 10 Running Total and Statistics Transaction DateAmount Date 126 10 Running Total and Statistics Naming and Renaming a SUM List Doing Statistical Calculations Calc Clearing a SUM List and Its Name 128 10 Running Total and Statistics Calculations with One VariableCalc Menu for SUM Lists Menu Key Expense Month Phone 130 10 Running Total and Statistics Calculations with Two Variables Frcst Calc Total 132 10 Running Total and Statistics Frcst Menu Labels Logarithmic Curve Fit Curve Fitting and Forecasting To do curve fitting and forecasting 134 10 Running Total and Statistics Radio Dollar Sales Advertising Values Number of Minutes Minutes 136 10 Running Total and Statistics Minutes 138 10 Running Total and Statistics Weighted Mean and Grouped Standard Deviation Summation Statistics 140 10 Running Total and Statistics Doing Other Calculations with SUM Data Time, Appointments, and Date Arithmetic Time, Appointments, Date ArithmeticViewing the Time and Date Time Menu Labels Time MenuMenu Label Description 142 11 Time, Appointments, and Date Arithmetic SET Menu Labels Setting the Time and Date SETOr DD.MMYYYY To set the date 144 11 Time, Appointments, and Date Arithmetic Adjusting the Clock Setting AdjstChanging the Time and Date Formats SET Appointments Appt Viewing or Setting an Appointment APT1-APT10Menu Labels for Setting Appointments Description Appointment message optional To set, change, or just view a To set an appointment or view its current setting146 11 Time, Appointments, and Date Arithmetic Acknowledging an Appointment Clearing Appointments Unacknowledged Appointments148 11 Time, Appointments, and Date Arithmetic To acknowledge a past-due appointment Date Arithmetic Calc Calculating the Number of Days between Dates Determining the Day of the Week for Any DateCalc Menu Labels for Date Arithmetic 150 11 Time, Appointments, and Date Arithmetic Calculating Past or Future Dates DATE2 152 11 Time, Appointments, and Date Arithmetic Equation Solver Equation SolverSolver Example Sales Forecasts Next =OLD 154 12 The Equation Solver Menu Label Display Description Keys Solve Menu156 12 The Equation Solver To make an entry into the Solver list Entering EquationsSolve Menu Labels 158 12 The Equation Solver Calculating Using Solver Menus CalcTo do a calculation using a Solver menu Rmenu label Eqty 160 12 The Equation Solver Naming an Equation Editing an Equation Edit Shared Variables Finding an Equation in the Solver ListClearing Variables 162 12 The Equation Solver Deleting a variable is quite different from clearing it Deleting Variables and Equations Deleting One Equation or Its Variables Delet Writing EquationsDeleting All Equations or All Variables in the Solver @c 164 12 The Equation Solver × E 100× C Could be entered as 166 12 The Equation Solver What Can Appear in an Equation Using the Alpha Menu 168 12 The Equation Solver Using a Typing AidSolver Functions DDAYSd1d2cal Solver Functions for Equations Description HH.MMSS format 170 12 The Equation SolverIFcond expr 1 expr ITEMSUM-listnameitem# SIZECCFLO-listname Σcfr c 1 c 2 s exprSIZESSUM-listname #TCFLO-listnameflow# 172 12 The Equation Solver Days OperatorKeys Conditional Expressions with if≥ ³= 174 12 The Equation Solver Rating Percent Salary Increase Examples of Conditional EquationsVALUE＝FIRST＋1 ÷ FIRST. If FIRST＝0, then VALUE＝FIRST HC8E9AL#GL28#I&%IGL28$I&I&#TTT Summation Function ∑176 12 The Equation Solver Accessing Cflo and SUM Lists from the Solver 178 12 The Equation Solver Creating Menus for Multiple Equations S Function How the Solver Works 180 12 The Equation Solver Halting and Restarting the Iterative Search Entering Guesses 52EG8527H Y@/O127EF Y@/GX7EF Keys 182 12 The Equation Solver @I$&/Solves for QTY iteratively 184 13 Printing Printing Double Space Printing Printer’s Power SourcePrinting the DisplayP Printing Printing Variables, Lists, and Appointments List Printing Other Information @pPrinter Menu Labels 186 13 Printing Except IRR%. Instead, press tPto print the value for IRR% 188 13 Printing Printing Descriptive Messages MSGTrace Printing Trace KeysPrint-out How to Interrupt the Printer Loans Additional ExamplesSimple Annual Interest 190 14 Additional Examples Additional Examples Yield of a Discounted or Premium Mortgage Figures and stores total 192 14 Additional Examples See appendix F for RPN keystrokes for the next two examples Annual Percentage Rate for a Loan with Fees 194 14 Additional Examples Loan with an Odd Partial First Period @c e Solver Equation for Odd-Period Calculations 196 14 Additional Examples Canadian Mortgages Solver Equation for Canadian Mortgages 198 14 Additional Examples Solver Equation for Advance Payments Advance Payments Leasing 200 14 Additional Examples SavingsValue of a Fund with Regular Withdrawals Displays periodic 202 14 Additional Examples Deposits Needed for a Child’s College Account Additional Examples 204 14 Additional Examples Flow of Withdrawals For FLOW1 206 14 Additional Examples Value of a Tax-Free Account # 5?@2 JH= 0EAH 208 14 Additional Examples Value of a Taxable Retirement Account Modified Internal Rate of Return Group No. of Months Cash Flow, $ Flow no 210 14 Additional Examples 100000 V8 /12 212 14 Additional Examples 200000V13 /12 Solver Equation for Insurance Price Price of an Insurance Policy 214 14 Additional Examples Bonds 216 14 Additional Examples Discounted Notes Moving Average Statistics Solver Equation for Moving Averages 218 14 Additional Examples If necessary Chi-Squared χ2 Statistics If the expected values vary 220 14 Additional Examples Use Keystroke Display DescriptionNumber Assistance, Batteries, Memory, and Service Assistance, Batteries Memory, and ServiceAnswers to Common Questions Obtaining Help in Operating the Calculator Assistance, Batteries, Memory, and Service Do not use rechargeable batteries Power and BatteriesLow-Power Indications Installing Batteries Assistance, Batteries, Memory, and Service Managing Calculator Memory Reset hole Resetting the Calculator For selecting English language For selecting the other languages Erasing Continuous MemoryFor English language For the other languages Environmental Limits Determining If the Calculator Requires ServiceClock Accuracy If the calculator doesn’t respond to keystrokes Confirming Calculator Operation Self-TestIf the calculator won’t turn on Warranty Assistance, Batteries, Memory, and Service Europe Country Telephone numbers America Country Telephone numbers Regulatory informationAsia Pacific Country Telephone numbers Japan Canada IRR% Calculations More About CalculationsPossible Outcomes of Calculating IRR% More About Calculations Storing a Guess for IRR% Halting and Restarting the IRR% Calculation Solver Calculations Direct SolutionsO F I T = P R I C E － C O S T S T = P R I C E － P R O F I T ＝ a R E a ÷ W E a ＝L x W Iterative Solutions Case 1a Case 1b Is exactly Is not exactly More About Calculations J1A =4HFFHFI Actuarial Functions Equations Used by Built-in Menus － n 100  Amortization Percentage Calculations in Business BUSTime Value of Money TVM Cash-Flow Calculations Interest Rate ConversionsNOM %  P NPV ＝ CF0 + ∑CFj x Uspv i% nj x Sppv i% Nj NUS ＝ Uspv i% N Total ＝ ∑nj × CFj Bond Calculations DB ＝ Basis × Fact % /100 Depreciation Calculations Model Transformation Sum and StatisticsForecasting SXY = Σ Equations Used in ChapterSX 2 × SY PV = − PMT Modified Internal Rate of Return Odd-Period CalculationsAdvance Payments Menu Maps Menu Maps Figure C-2. Currx Menu Figure C-3. FIN Menu Figure C-3 . FIN Menu Figure C-4. SUM Menu Figure C-5. Time Menu Figure C-6. Solve Menu About RPN RPN SummaryAbout RPN on the HP 17bII+ RPN Summary To select RPN mode Press @ Setting RPN Mode Function Definition Key to Use Name Where the RPN Functions Are~ same as Same as Simple Arithmetic Arithmetic Topics Affected by RPN ModeDoing Calculations in RPN To Calculate Press Display 27 % Chain Calculations－No Parentheses RPN Mode ALG ModeCalculations with STO and RCL + 5 E 6 + RPN The Stack RPN The StackWhat the Stack Is Exchanging the X- and Y-Registers in the Stack Reviewing the Stack Roll Down Arithmetic－How the Stack Does It ＋ 6 ： How Enter Works Clearing Numbers Retrieving Numbers from Last Reusing NumbersLast X Register Chain Calculations Exercises Solution 23 @w13 E9 *-7@t+ RPN Selected Examples RPN Selected Examples RPN Selected Examples #$ 5?@2 HA 0EAH 10 @ Stores total number Payments 1000000 E #TIMES1 for FLOW1 For E, press =, not I11 I G9ECLT8U # 5?@2 JH= # 5?@2 JH= Begin mode Error Messages Error Messages H22E2I EOH2G9EC Error Messages Error Messages EOH2G9EC Error Messages #Special Characters IndexIndex 143 2, 42 -,150 147 169 166 56 ›, 132 a, 78 Z 156 74-75 =, F 85-87 31-32174-76 149 115 ?, 32 ª, 150 «, 150 ¬145 162-64 144116 64 I 133 181-83 138-39 168-71 239 72-73213-15 132-34 132 k, 186 o, 42 3, 42 L132 , 109 +, 49, 53 6, 52, 128 ‘, 128 \, 143 N 143-44 Memory. See also Continuous Memory146 175 101 w, 101 x, 101 /, 157 @, 56 B, 56 J, 56 4, 42 j92-94 56 5, 42 , 18 @p, 186 P 80-81 85-86PMT. See also Payments in TVM, 63 rounded amortization 115 56 Q, 56 l, 186 ¡ Using128 146-47 176 243-46 171 132 L 148178 109 ‹, 115 M This regulation applies only to The Netherlands