Using the mirr function allows you to save a step and to change the reinvestment rate without having. Tibaii plus cash flow worksheet 3 cash flow worksheet. Ti ba ii plus calculator cash flow worksheet demo youtube. Appendix d using the hp10b and ti ba ii plus financial calculators 553 the bond has a yield to maturity of 9. Jan 10, 2019 in the beginning, clear all data from your calculator and set it to default settings. To enter the interest conversion worksheet, press 2nd, iconv in the interest conversion worksheet, there are 3 entries. To recall, the value in the one of the tmv keys, press rcl and then the corresponding key. How the dcf works overview based off any available financial data both historical and projected, the dcf, first, projects the companys expected cash flow each year for a finite number of years second, sums all the projected cash flows from the first step and lastly, discounts the result from the second step by some rate to yield the value in terms of present.
Texas instruments ba ii plus tutorial for the cfa exam by ift. Present value and future value of uneven cash flows using. Also returns you to the first variable in the worksheet. Setting py and cy py stands for payments per year, and cy for compounding periods per year.
Agi 37 adjust the following only if needed to adjust to cashflow. Uneven cash flows on a ti ba ii plus press cf to access the cash flow worksheet use the v keys to navigate through the worksheet all entries are labeled with a subscript cf0, cf1, f1. I set my ba ii plus to an artificially large number of decimals usually 7 which will rarely all be displayed. As your payment is going to be yearly and you are going deposit for twenty years. The ones we use most frequently, and discuss in the tutorial, are the tvm and cash flow memories. Using the hp10b and ti ba ii plus financial calculators. Cf is cashflow, f frequency 2 nd del deletes the entry 2 nd ins inserts a new entry. Whenever i calculate the npv of a stream of uneven cash flows it stays stuck in the memory until i overwrite it for the next calculation. Jul 15, 2012 ti ba ii plus calculator cash flow worksheet demo ronald moy. Texas instruments ba ii plus financial calculator for business professionals and students features are that it performs common math as well as various financial functions. It includes brief examples of commonly used ba ii plus calculator settings and financial management concepts. This article breaks down the dcf formula into simple terms with examples and a video of the calculation. On the ti, you press cf and you are instantly in the cash flow worksheet and you can scroll through the entries with the arrow.
In the interest conversion worksheet, there are 3 entries. When you are in one entry you can either enter a new value in that entry or to calculate the value in that entry. Ba ii plus calculator 1997, 2002 texas instruments incorporated. Now the baii p lus analyz es th e cash flow s based on beginning of period payments. You can also use a freestanding business or financial calculator such as ti ba ii plus or hp 12c. The exam is closedbook, but you can bring one sheet of your own notes 2sided ok. Cash flow worksheet jan feb mar april may june july aug sept oct nov dec total number of weeks you collect tuition cash on hand income cash in flows.
Discounted cash flow dcf formula guide how to calculate npv. The following calculations are demonstrated using ba ii plus calculator. Similar to an annuitys present value pv in the tvm worksheet, a typical cashflow. View and download texas instruments ba ii plus user manual online. Ba ii plus calculator guidebook english 01 june 1997, rev a 30 may 2002o. I reset the calculator entirely, so everything should be factory default settings, and i click cf.
Its worth investing some time to learn how to use your calculator better. Present value and future value of uneven cash flows. Press 2nd py to enter payments per year andor compounding periods per year. To use the m register, simply input or calculate a number, then hit the m register key as show below. Aug 23, 2018 there are a couple of different ways to store and recall numbers on the hp 10bii. Texas instruments ba ii plus user manual pdf download.
Cash flow worksheet three keys are used for performing cash flow calculations. Cash flow worksheet three keys are used for performing cashflow calculations. This tutorial also shows how to calculate net present value npv, internal rate of return irr, and modified irr mirr. Texas instruments baii plus calculator tutorial to accompany cyr, et. To compute the rcy using the mirr function in the ti ba ii plus professional, the calculation requires the use of the cash flow worksheet. Texas instruments ti ba ii plus financial calculator, cfa. Ti ba ii plus calculator cash flow worksheet demo ronald moy. Having actually gone through both ba ii plus and ba ii plus professional manuals, heres the ultimate list of a few lesser known, super handy timesaving ba ii plus functions that you need to know for your cfa preparations, regardless of level. You must now key in 1 and then enter since you want 1 payment per year. Like the base model, the ba ii plus professional operates the same way. To use the irr and npv functions in your tiba ii plus, you must first familiarize yourself with the up and down arrows vv at the top of the keyboard. The ti baii plus is a fairly easy to use financial calculator that will serve you well in all finance courses. Introduction to corporate finance concepts 3day section. The cash flow worksheet can do unequal cash flowing on an equal time span.
First, well go over the memory register key, which just stores one value at a time. It allows you to enter uneven values, each of which can be either an inflow cash received or an outflow cash paid out. Texas instruments baii plus this is a first draft, and may contain errors. In this video i will show you how you can easily calculate npv using a texas instruments ba ii plus financial calculator. We will adopt the procedure that we used to calculate the future value of a single cash flow. You can change the amount of the flow or the frequency, but if you need to delete or insert a flow, you have to clear all entries and start over. The actual cash flow values can then be used to evaluate historical cash performance of the business, as well as serve as a guide for future cash flow needs throughout the current business year. To calculate the future value of this series of cash flows, we will need to treat each cash flow as independent and calculate its future value. Calculator problem with calculating cash flows problems. Each flow has to be accessed individually with this series of keystrokes.
Cash flow analysis worksheets university of arizona. Cash flow analysis what are the irr and npv of the following set of cash flows. The sections for each calculator present stepbystep instructions for using general and financial functions offered by each calculator. Texas instruments baii plus tutorial page 2 memories the calculator has several different sets of memories, or registers. These keys will help you navigate your way through the data entry process. Todays blog entry is about the ba ii plus professional which is the deluxe version of the long time running ba ii plus. You can use microsoft excel on your laptop starting it as a blank worksheet only. The formula is used to determine the value of a business. Ba ii plus pro ba ii plus professional financial calculator, ba20 profit manager, baiiplus ba ii plus financial calculator. I change it to whatever number i want, press enter, then scroll. To clear the tvom worksheet, press the second key and then press the future value key to access its secondary function, clear tvom worksheet. Refer to your ba ii plus guidebook for detailed baii plus instructions. When bgn is not displayed, tvm calculations use endofperiod.
Using the hp 10b and ti ba ii plus financial calculators. So if you are questing for how to use financial calculator ba ii plus, you are also at the right place. Bgn tvm calculations us e beginningofperiod payments. There are a couple of different ways to store and recall numbers on the hp 10bii. Texas instruments baii plus calculator tutorial to accompany. I set my ba ii plus to an artificially large number. After entering the initial cash flow, you will need to key v once. I am going use a texas instruments ba ii plus professional financial calculator for all examples. A tutorial about using the ti baii plus financial calculator to solve time value of money problems involving uneven cash flows.
Not sure if this is the right place to post this, but im having a problem when attempting to input uneven cash flows into my ba ii plus professional. Indicator meaning compute you can press % to compute a value. If you are going to use it another way then i will suggest. Mar 24, 2014 todays blog entry is about the ba ii plus professional which is the deluxe version of the long time running ba ii plus. Ba ii plus prompted worksheet display indicators when one or more of the following indicators is displayed, you are in a prompted worksheet. To recall a value stored on the m register, simply press the rm or recall. After each subsequent cash flow, until the final cash flow you will need to key v twice, once to enter the cash flow and once to scroll through the display that shows the frequency of the cash flow. The bond worksheet on a baii plus calculator can compute the bond price, the yield to maturity or call, and accrued interest. To reset the bond worksheet to default values, press 2nd clr work. American journal of business education june 2011 volume 4. Cash flow analysis what are the irr and npvof the following set of cash flows.
Ba ii plus professional calculator ba ii plus professional. Texas instruments baii plus this is a first draft, and may. To move around in the cash flow register, simply use the arrow keys on the top row of your calculator. Sep 04, 2015 in this video i will show you how you can easily calculate npv using a texas instruments ba ii plus financial calculator. This tutorial will demonstrate how to use the financial functions to handle time value of money problems and make financial math easy. You can read about the others in the calculator manual. Using the mirr function allows you to save a step and to change the reinvestment rate without having to recompute the future value of the invested coupons. On the ti, you press cf and you are instantly in the cash flow worksheet and you can scroll through the entries with the arrow keys. Uneven cash flows on a ti ba ii plus press cf to access. Using the hp 10b and ti ba ii plus financial calculators this appendix is intended to help you use your hewlett packard hp 10b or texas instruments ti ba ii plus financial calculator to solve problems encountered in an introductory finance course. The values can be updated as you go and flows can be inserted or deleted as needed. Uneven cash flows on a ti ba ii plus press cf to access the. Cfo stands for initial cash flow outlay, c01 stands for cash flow year one, c02 stands for cash flow year two, etc. The tvm worksheet and return the values in the worksheet to a known starting point.
31 1626 51 1636 462 20 232 1627 411 394 517 758 1135 1038 598 610 1489 1265 861 1637 454 745 916 1581 1306 1463 1624 914 594 16 623 1215 100 190 3 10 843 145 283 215 1426