102 7 Cash Flow Calculations, 115,000 500 | HP 17bII specification

Example: Calculating IRR and NPV of an Investment. An investor makes an initial investment of $80,000, and expects returns over the next five years as illustrated below.

115,000

5,000		5,500
	4,500
		4,000

1

2

3

4

5

$ _ 80,000 (Initial flow)

Calculate the total of the cash flows and the internal rate of return of the investment. In addition, calculate the net present value and net future value, assuming an annual interest rate of 10.5%.

Start the problem with an empty cash-flow list. Since the cash flows are ungrouped, each one occurs just once. Turn off the #TIMES prompt to make cash-flow entry faster.

Keys:			Display:	Description:
			"	Displays current cash-flow
"
				list and CFLO menu keys.
r
@c			"	Clears current list or gets a
				new one. The empty list
W			"
or			"	prompts for its initial cash
				flow.
p		s	G9ECL(T8U"

qP:;0HF 52E05:;<=I" Briefly shows the status of

EGG"	q	then returns to the
	list. With prompting off,
	all cash flows are

102 7: Cash Flow Calculations

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

Print data : 2003/7/11

Image 102

HP 17bII manual 102 7 Cash Flow Calculations, 115,000 500

Contents

HP 17bII+ Financial Calculator Printing History Edition June Welcome to the HP 17bII+ Welcome to the hp17bII+ Contents Power Function Exponentiation Error MessagesUsing Parentheses in Calculations Saving and Reusing Numbers Time Value of Money Interest Rate ConversionsCash Flow Calculations 10 121 Running Total and Statistics BondsDepreciation 11 141 Time, Appointments, and Date Arithmetic 12 153 The Equation Solver 14 190 Additional Examples Assistance, Batteries, Memory, and Service More About Calculations Menu Maps RPN Summary RPN The Stack RPN Selected Examples Error Messages Index General Business Calculations List of ExamplesList of Examples Currency Exchange Calculations Interest Rate Conversions Bonds and Notes Time, Alarms, and Date ArithmeticHow to Use the Equation Solver Running Total and Statistical Calculations Important Information Important Information Getting Started Power On and Off Continuous MemoryAdjusting the Display Contrast Getting Started Keys for language Key Description Setting the LanguageWhat You See in the Display 18 1 Getting Started Shift Key @ Backspacing and Clearing Keys for Clearing Keys Display Description20 1 Getting Started Doing Arithmetic KeysDisplayDescription Using the Menu Keys Keying in Negative Numbers22 1 Getting Started Main Menu Menu Labels Menu Keys Main Menu Menu Label Operations Done Covered This Category 24 1 Getting Started Choosing Menus and Reading Menu Maps Using the MU%C menu 26 1 Getting StartedDisplaying the MU%C menu Calculations Using Menus Exiting Menus e Clearing Values in Menus28 1 Getting Started Solving Your Own Equations Solve = Cost Typing Words and Characters the ALPHAbetic Menu 30 1 Getting Started 34 5? Editing ALPHAbetic TextKeys Characters Keyboard Calculating the Answer CalcAlphabetic Editing Operation Label or Key to Press 32 1 Getting Started Menu for carpeting Internal Precision Controlling the Display FormatDecimal Places Temporarily SHOWing ALL Rounding a Number Exchanging Periods and Commas in Numbers Error Messages Modes36 1 Getting Started Calculator Memory @M Memory still free VDoing Calculations ArithmeticCalculator Line 38 2 Arithmetic Keys Display VUsing Parentheses in Calculations456 75 × 18.5 30 x VThe Percent Key Mathematical Functions40 2 Arithmetic VThe Power Function Exponentiation Shifted Math FunctionsKey KeysDisplay Description Math MenuMath Menu Labels 42 2 Arithmetic Saving and Reusing Numbers History Stack of Numbers VReusing the Last Result @L VKeys Display44 2 Arithmetic Storing and Recalling Numbers 475.6 560.1 + 39.15VKeys Display Description Keys New Register Contents Doing Arithmetic Inside Registers and VariablesArithmetic in Registers Scientific Notation Range of Numbers 48 2 Arithmetic Menu Description Percentage Calculations BusinessBusiness Percentages BUS Menus Percentage Calculations in Business Percent Change %CHG Using the BUS MenusExamples Using the BUS Menus 50 3 Percentage Calculations in Business Percent of Total %TOTL Markup as a Percent of Cost MU%C Markup as a Percent of Price MU%P52 3 Percentage Calculations in Business Sharing Variables Between Menus Cost Price M%C Cost Price M%P Currency Exchange Calculations Currx Menu54 4 Currency Exchange Calculation Selecting a Set of Currencies Currx MenuCurrency Exchange Calculation Currencies United States Conversion Chart in US$ Entering a RateCurrency Rate 58 4 Currency Exchange Calculation Select CAN$ as currencySelect HK$ as currency Converting Between Two Currencies Storing and Recalling Sets of CurrenciesExample Converting between Hong Kong and U.S Dollars Clearing the Currency Variables 60 4 Currency Exchange Calculation Time Value of Money TVM MenuTime Value of Money First Level of TVM Second Level of TVM TVM Menu Labels Menu Label Description First LevelSecond Level Cash Flow Diagrams and Signs of Numbers 64 5 Time Value of Money PMT Using the TVM Menu 66 5 Time Value of Money Loan Calculations 68 5 Time Value of Money Figures and stores number 11.5 70 5 Time Value of Money Figures and stores Savings Calculations 000 72 5 Time Value of Money 15X 12X 359 360 Leasing Calculations 74 5 Time Value of Money @28#+ 76 5 Time Value of Money Amortization Amrt Label Displaying an Amortization ScheduleAmrt Menu Labels 78 5 Time Value of Money Number of payments 80 5 Time Value of Money Next successive set of payments authorized Printing an Amortization Table Table 82 5 Time Value of Money 508 /,%&-$ GO8 Interest Rate Conversions 84 6 Interest Rate Conversions Icnv Menu Converting Interest RatesInterest Rate Conversions 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 Cflo menuCash Flow Calculations Cflo Menu Labels 92 7 Cash Flow Calculations Cash Flows Ungrouped Creating a Cash-Flow List 94 7 Cash Flow Calculations Entering Cash Flows For grouped cash flows The display now shows Prompting for #TIMES #T?. When the calculator displays 96 7 Cash Flow Calculations Viewing and Correcting the List EGG 98 7 Cash Flow Calculations Copying a Number from a List to the Calculator LineNaming and Renaming a Cash-Flow List Deleting Cash Flows from a List. Pressing ndeletes both Clearing a Cash-Flow List and Its Name Starting or GETting Another ListViewing the Name of the Current List. Press o, then e Cash-Flow Calculations IRR, NPV, NUS, NFV 100 7 Cash Flow Calculations Calc Menu for Cflo Lists Menu Label 102 7 Cash Flow Calculations 115,000 500 G9ECL#T8U Group Number Amount 104 7 Cash Flow Calculations G9ECL.T8U 106 7 Cash Flow Calculations 50 50 50 Doing Other Calculations with Cflo Data Bonds Bond Menu108 8 Bonds Bond Menu Labels Menu Description LabelBonds Doing Bond Calculations 110 8 BondsTo calculate the price or yield of a bond Since there is no call on 112 8 Bonds MM.DDYYYY format Depreciation Deprc Menu114 9 Depreciation Deprc Menu Labels Depreciation 116 9 Depreciation Doing Depreciation CalculationsDB, SOYD, and SL Methods To calculate the depreciation for an asset KeysDisplay Basis Salv 4,000 Acrs Method Year Percentage Deductible Keys Display Description118 9 Depreciation Partial-Year Depreciation Calendar Year Depreciation Value 120 9 Depreciation Running Total and Statistics Running Total and Statistics SUM Menu SUM Menu Labels122 10 Running Total and Statistics Creating a SUM List Entering Numbers and Viewing the Total 124 10 Running Total and Statistics Date Amount DateTransaction Naming and Renaming a SUM List 126 10 Running Total and Statistics Clearing a SUM List and Its Name Doing Statistical Calculations Calc Calculations with One Variable Calc Menu for SUM Lists Menu Key128 10 Running Total and Statistics Month Phone Expense Calculations with Two Variables Frcst 130 10 Running Total and Statistics Calc Total Frcst Menu Labels 132 10 Running Total and Statistics Curve Fitting and Forecasting Logarithmic Curve Fit 134 10 Running Total and Statistics To do curve fitting and forecasting Number of Minutes Radio Dollar Sales Advertising Values 136 10 Running Total and Statistics Minutes Minutes Weighted Mean and Grouped Standard Deviation 138 10 Running Total and Statistics Summation Statistics Doing Other Calculations with SUM Data 140 10 Running Total and Statistics Time, Appointments, Date Arithmetic Viewing the Time and DateTime, Appointments, and Date Arithmetic Menu Label Description Time MenuTime Menu Labels 142 11 Time, Appointments, and Date Arithmetic Or DD.MMYYYY Setting the Time and Date SETSET Menu Labels To set the date Adjusting the Clock Setting Adjst Changing the Time and Date Formats SET144 11 Time, Appointments, and Date Arithmetic Viewing or Setting an Appointment APT1-APT10 Menu Labels for Setting Appointments DescriptionAppointments Appt To set an appointment or view its current setting 146 11 Time, Appointments, and Date ArithmeticAppointment message optional To set, change, or just view a Acknowledging an Appointment 148 11 Time, Appointments, and Date Arithmetic Unacknowledged AppointmentsClearing Appointments To acknowledge a past-due appointment Date Arithmetic Calc Calc Menu Labels for Date Arithmetic Determining the Day of the Week for Any DateCalculating the Number of Days between Dates 150 11 Time, Appointments, and Date Arithmetic Calculating Past or Future Dates 152 11 Time, Appointments, and Date Arithmetic DATE2 Equation Solver Solver Example Sales ForecastsEquation Solver 154 12 The Equation Solver Next =OLD Display Description Menu Label Solve Menu 156 12 The Equation SolverKeys Entering Equations Solve Menu LabelsTo make an entry into the Solver list Calculating Using Solver Menus Calc To do a calculation using a Solver menu158 12 The Equation Solver Rmenu label 160 12 The Equation Solver Eqty Editing an Equation Edit Naming an Equation Clearing Variables Finding an Equation in the Solver ListShared Variables 162 12 The Equation Solver Deleting Variables and Equations Deleting a variable is quite different from clearing it Deleting All Equations or All Variables in the Solver @c Writing EquationsDeleting One Equation or Its Variables Delet 164 12 The Equation Solver 100 × C Could be entered as× E What Can Appear in an Equation 166 12 The Equation Solver Using the Alpha Menu Using a Typing Aid Solver Functions168 12 The Equation Solver Solver Functions for Equations Description DDAYSd1d2cal IFcond expr 1 expr 170 12 The Equation SolverHH.MMSS format ITEMSUM-listnameitem# SIZESSUM-listname Σcfr c 1 c 2 s exprSIZECCFLO-listname #TCFLO-listnameflow# 172 12 The Equation Solver Days ≥ ³= Conditional Expressions with ifOperatorKeys 174 12 The Equation Solver Examples of Conditional Equations VALUE＝FIRST＋1 ÷ FIRST. If FIRST＝0, then VALUE＝FIRSTRating Percent Salary Increase Summation Function ∑ 176 12 The Equation SolverHC8E9AL#GL28#I&%IGL28$I&I&#TTT Accessing Cflo and SUM Lists from the Solver Creating Menus for Multiple Equations S Function 178 12 The Equation Solver How the Solver Works Halting and Restarting the Iterative Search 180 12 The Equation Solver Entering Guesses 182 12 The Equation Solver 52EG8527H Y@/O127EF Y@/GX7EF Keys @I$&/Solves for QTY iteratively Printing 184 13 Printing Printing the DisplayP Printer’s Power SourceDouble Space Printing Printing Printer Menu Labels Printing Other Information @pPrinting Variables, Lists, and Appointments List 186 13 Printing Except IRR%. Instead, press tPto print the value for IRR% Printing Descriptive Messages MSG Trace Printing Trace188 13 Printing How to Interrupt the Printer KeysPrint-out Simple Annual Interest Additional ExamplesLoans 190 14 Additional Examples Yield of a Discounted or Premium Mortgage Additional Examples 192 14 Additional Examples Figures and stores total Annual Percentage Rate for a Loan with Fees See appendix F for RPN keystrokes for the next two examples 194 14 Additional Examples @c e Loan with an Odd Partial First Period 196 14 Additional Examples Solver Equation for Odd-Period Calculations Canadian Mortgages 198 14 Additional Examples Solver Equation for Canadian Mortgages Advance Payments Leasing Solver Equation for Advance Payments Savings Value of a Fund with Regular Withdrawals200 14 Additional Examples Displays periodic Deposits Needed for a Child’s College Account 202 14 Additional Examples Additional Examples Flow of Withdrawals 204 14 Additional Examples For FLOW1 Value of a Tax-Free Account 206 14 Additional Examples # 5?@2 JH= 0EAH Value of a Taxable Retirement Account 208 14 Additional Examples Modified Internal Rate of Return 210 14 Additional Examples Group No. of Months Cash Flow, $ Flow no V8 /12 100000 200000 V13 /12212 14 Additional Examples Price of an Insurance Policy Solver Equation for Insurance Price 214 14 Additional Examples Bonds Discounted Notes 216 14 Additional Examples Statistics Moving Average 218 14 Additional Examples Solver Equation for Moving Averages Chi-Squared χ2 Statistics If necessary 220 14 Additional Examples If the expected values vary Keystroke Display Description NumberUse Answers to Common Questions Assistance, Batteries Memory, and ServiceAssistance, Batteries, Memory, and Service Obtaining Help in Operating the Calculator Assistance, Batteries, Memory, and Service Power and Batteries Low-Power IndicationsDo not use rechargeable batteries Installing Batteries Assistance, Batteries, Memory, and Service Managing Calculator Memory Resetting the Calculator Reset hole For selecting English language For English language Erasing Continuous MemoryFor selecting the other languages For the other languages Determining If the Calculator Requires Service Clock AccuracyEnvironmental Limits Confirming Calculator Operation Self-Test If the calculator won’t turn onIf the calculator doesn’t respond to keystrokes Warranty Assistance, Batteries, Memory, and Service Europe Country Telephone numbers Regulatory information Asia Pacific Country Telephone numbersAmerica Country Telephone numbers Canada Japan Possible Outcomes of Calculating IRR% More About CalculationsIRR% Calculations More About Calculations Halting and Restarting the IRR% Calculation Storing a Guess for IRR% O F I T = P R I C E － C O S T Direct SolutionsSolver Calculations S T = P R I C E － P R O F I T E a ＝L x W ＝ a R E a ÷ W Iterative Solutions Case 1a Case 1b Is exactly Is not exactly More About Calculations J1A =4HFFHFI  － n Equations Used by Built-in MenusActuarial Functions 100  Percentage Calculations in Business BUS Time Value of Money TVMAmortization NOM %  P Interest Rate ConversionsCash-Flow Calculations NPV ＝ CF0 + ∑CFj x Uspv i% nj x Sppv i% Nj Bond Calculations NUS ＝ Uspv i% N Total ＝ ∑nj × CFj Depreciation Calculations DB ＝ Basis × Fact % /100 Sum and Statistics ForecastingModel Transformation SX 2 × SY Equations Used in ChapterSXY = Σ PV = − PMT Odd-Period Calculations Advance PaymentsModified Internal Rate of Return 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 on the HP 17bII+ RPN SummaryAbout RPN RPN Summary Setting RPN Mode To select RPN mode Press @ ~ same as Where the RPN Functions AreFunction Definition Key to Use Name Same as Arithmetic Topics Affected by RPN Mode Doing Calculations in RPNSimple Arithmetic 27 % To Calculate Press Display RPN Mode ALG Mode Calculations with STO and RCLChain Calculations－No Parentheses + 5 E 6 + RPN The Stack What the Stack IsRPN The Stack Reviewing the Stack Roll Down Exchanging the X- and Y-Registers in the Stack Arithmetic－How the Stack Does It How Enter Works ＋ 6 ： Clearing Numbers Reusing Numbers Last X RegisterRetrieving Numbers from Last Chain Calculations Solution 23 @w13 E9 *-7@t+ Exercises RPN Selected Examples RPN Selected Examples RPN Selected Examples #$ 5?@2 HA 0EAH 10 @ Stores total number Payments 1000000 E For E, press =, not #TIMES1 for FLOW1 I11 I G9ECLT8U # 5?@2 JH= # 5?@2 JH= Begin mode Error Messages Error Messages H22E2I EOH2G9EC Error Messages Error Messages EOH2G9EC Error Messages Index Index#Special Characters 143 2, 42 -,150 169 147 156 166 56 ›, 132 a, 78 Z =, F 74-75 31-32 174-7685-87 115 ?, 32 ª, 150 «, 150 ¬ 145149 116 144162-64 64 I 181-83 133 168-71 138-39 72-73 213-15239 132 , 109 +, 49, 53 6, 52, 128 ‘, 128 132 k, 186 o, 42 3, 42 L132-34 \, 143 N Memory. See also Continuous Memory 146143-44 101 w, 101 x, 101 /, 157 @, 56 B, 56 J, 56 4, 42 j 92-94175 56 5, 42 , 18 @p, 186 P 85-86 PMT. See also Payments in TVM, 63 rounded amortization80-81 115 128 Using56 Q, 56 l, 186 ¡ 146-47 243-46 176 171 148 178132 L 109 ‹, 115 M This regulation applies only to The Netherlands