Premium Essay

Npv Calculator

In: Computers and Technology

Submitted By janenn
Words 363
Pages 2
When cash inflows are even:
|NPV = R × |1 − (1 + i)-n |− Initial Investment |
| |i | |

In the above formula,
R is the net cash inflow expected to be received each period; i is the required rate of return per period; n are the number of periods during which the project is expected to operate and generate cash inflows.
When cash inflows are uneven:
NPV = | |R1 |+ |R2 |+ |R3 |+ ... | |− Initial Investment | | | |(1 + i)1 | |(1 + i)2 | |(1 + i)3 | | | | |Where, i is the target rate of return per period;
R1 is the net cash inflow during the first period;
R2 is the net cash inflow during the second period;
R3 is the net cash inflow during the third period, and so on ... Each cash inflow/outflow is discounted back to its present value (PV). Then they are summed. Therefore NPV is the sum of all terms,

[pic] where

[pic] – the time of the cash flow [pic] – the discount rate (the rate of return that could be earned on an investment in the financial markets with similar risk.); the opportunity cost of capital [pic] – the net cash flow i.e. cash inflow – cash outflow, at time t . For educational purposes, [pic] is commonly placed to the left of the sum to emphasize its role as (minus) the investment. The result of this formula is multiplied with the Annual Net cash in-flows and reduced by Initial Cash outlay the present value but in cases where the cash flows are not equal in amount, then the previous formula will be used to determine the present value of each cash flow separately. Any cash flow within 12 months will not be discounted for NPV purpose, nevertheless the usual initial investments during the first year R0 are summed up a negative cash flow.[2]

Given the (period, cash flow) pairs ([pic], [pic]) where [pic] is the total…...

Similar Documents

Premium Essay

Calculating Npv

...-75,000 95,000 -38,000 57,000 6,33,000 359181.1997 -520000 -7,20,000 16000 15,00,000 -13,00,000 2,00,000 -30,000 -75,000 95,000 -38,000 57,000 16000 15,00,000 -13,00,000 2,00,000 -30,000 -75,000 95,000 -38,000 57,000 73,000 16000 15,00,000 -13,00,000 2,00,000 -30,000 -75,000 95,000 -38,000 57,000 73,000 51959.95809 16000 15,00,000 -13,00,000 2,00,000 -30,000 -75,000 95,000 -38,000 57,000 73,000 46392.81972 -7,20,000 -7,20,000 -1,39,092 73,000 65178.57143 58195.15306 Internal Rate of Return NPV @ 5% NPV Year 0 -7,20,000 34,826 Taking IRR at 5% and 12% IRR Traditional Formula = LR + { NPV @ LR/NPV @ LR - NPV @ HR} X (HR-LR) IRR 0.064017186 6.401718635 Year 1 Year 2 69523.80952 66213.15193 Year 3 63060.14469 Year 4 60057.28066 Year 5 495972.0634 Therefore Internal Rate of Return for this Project is 6.69600 A) Payback Period Year 0 1 2 3 4 5 Future Cash Flows -7,20,000 73,000 73,000 73,000 73,000 6,33,000 PV of FCF Accumulated NPV on FCF 65178.57143 58195.15306 51959.95809 46392.81972 359181.1997 -6,54,821 -5,96,626 -5,44,666 -4,98,273 -1,39,092 Pay back Period Cannot be caluculated as it is taking more than 5 years to beak even Profitability Index: PI = PVCF/ Intial Investment Present Value Initial Investment 580907.7 7,20,000 Profitability Index 0.806816 Fact File: Machine A Machine B SP 2,00,000 3,00,000 12 50,000 60,000 40,000 60,000 Year 0 Investing Activities Initial Investment Depreciation Tax Salavage value......

Words: 578 - Pages: 3

Premium Essay

Adjusted Npv

...Adjusted present value Wadia Haddaji February 20, 2008 • Topics: 1. Adjusted present value. • Readings: 1. Brealey, Myers and Allen, section 20.4. 1 The Adjusted-Present-Value Rule • Recall that we can write the value of a levered firm as the value of an otherwise identical all-equity firm and the value of its financing decisions: V = VU +NPV(financing decisions). • It is then obvious to define the APV of a project as the sum of its NPV to an all-equity firm and the PV of the associated financing decisions: APV = NPV(unlevered project) + NPV(financing decisions) • Separating the APV of a project into its NPV to an all-equity firm and the value of the associated financing decisions should be generally useful for the financial manager. 2 A Comparison of WACC and APV • Features/advantages of WACC. 1. WACC accounts for tax shield benefit of interest in discount rate. 2. WACC is widely adopted by practitioners and is easy to use. 3. WACC is applicable when D/E remains essentially constant through project life. 4. WACC is most appropriate when the project is “typical” of the firms traditional businesses (i.e., same risk), or “scale enhancing”. • Features/advantages of APV. 1. APV accounts for tax shield benefit of interest in cash flows (not discount rate). 2. APV was introduced by academics and is slowly being adopted in practice. 3. 11% of firms always or almost always use it. • APV often requires/accomodates knowledge of a particular debt repayment schedule. • APV (as opposed...

Words: 2208 - Pages: 9

Premium Essay

Ovulation Calculator

...Ovulation calculator Are you trying to get pregnant? Or are you trying to find out the days which you ovulate and planning for a baby. Use an ovulation calculator. Ovulation calculator is a tool which helps to predict the days in a month in which you are likely to ovulate. The chances of getting pregnant are more if you have intercourse on the ovulating days. For a woman who has a regular menstrual cycle of 28 -32 days, ovulation is likely to happen between 11 – 21 days. It is calculated from the day one of your last periods. For eg, if you had your last periods on 12 of the previous month, your ovulating period is likely to be between 22nd – 2nd of the next month. The calculation needs to be done taking the number of days in a month. The given one is just an example. If you are trying to get pregnant, this ovulating period is considered as the best time for intercourse and gets a positive result. Though not very accurate, it can be used as a safe period for avoiding sex and to avoid getting pregnant. But its not 100% fool proof. Many websites offer online ovulation calculators. Enter the details asked by them, it will be your first day of last menstrual period and normal menstrual cycle , whether it is 28 days or 30 days. Ovulation depends on that as well. Some websites where you can check this are http://www.webmd.com/baby/healthtool-ovulation-calculator,......

Words: 345 - Pages: 2

Premium Essay

Npv Comparison

...Comparing Net Present Value and Internal Rate of Return by Harold Bierman, Jr Executive Summary • • • Net present value (NPV) and internal rate of return (IRR) are two very practical discounted cash flow (DCF) calculations used for making capital budgeting decisions. NPV and IRR lead to the same decisions with investments that are independent. With mutually exclusive investments, the NPV method is easier to use and more reliable. Introduction To this point neither of the two discounted cash flow procedures for evaluating an investment is obviously incorrect. In many situations, the internal rate of return (IRR) procedure will lead to the same decision as the net present value (NPV) procedure, but there are also times when the IRR may lead to different decisions from those obtained by using the net present value procedure. When the two methods lead to different decisions, the net present value method tends to give better decisions. It is sometimes possible to use the IRR method in such a way that it gives the same results as the NPV method. For this to occur, it is necessary that the rate of discount at which it is appropriate to discount future cash proceeds be the same for all future years. If the appropriate rate of interest varies from year to year, then the two procedures may not give identical answers. It is easy to use the NPV method correctly. It is much more difficult to use the IRR method correctly. Accept or Reject Decisions Frequently, the investment......

Words: 2310 - Pages: 10

Free Essay

Whiz Calculator

...Whiz Calculator Company Case 4-4 Whiz Calculator Company adalah sebuah perusahaan yang memproduksi penuh lini kalkulator elektronik, yang dijual ke seluruh cabang kepada pedagang perantara dan ritel, secara langsung baik kepada pemerintah dan pengguna industri. Perusahaan ini merupakan salah satu perusahaan yang terbesar dalam industri. Whiz Calculator Company dipimpin oleh Bernard Riesman. Riesman sudah bekerja di perusahaan selama 5 tahun dan untuk 2 tahun sebelumnya menjabat sebagai wakil presiden manufaktur. Setelah menjabat sebagai presiden, Riesman mengadakan konferensi dengan pengendali untuk mendiskusikan tentang pengendalian anggaran. Ia berpikir metode lama dalam perencanaan dan pengendalian biaya penjualan tidak memuaskan. Oleh karena itu, ia meminta pengendali untuk membuat sistem baru yang memiliki pengendalian yang lebih baik atas biaya. Metode lama penganggaran biaya penjualan menerapkan basis “tetap” atau “yang ditetapkan”. Setiap bulan Oktober, departemen akuntansi mengirim catatan biaya aktual departemen atau cabang-cabang tahun sebelumnya dan tahun ini sampai bulan Oktober, ke masing-masing manajer cabang dan manajer lainnya yang berada di bawah departemen penjualan. Kemudian dengan berpandu pada catatan ini dan perkiraan penjualan tahun depan serta penilaian manajer, pemimpin cabang akan membuat dan menyerahkan perkiraan biaya untuk tahun berikutnya. Perkiraan ini diberikan pada manajer penjualan yang memimpin semua penjualan cabang. Ia......

Words: 1092 - Pages: 5

Free Essay

Scientific Calculator

... SCIENTIFIC CALCULATOR [pic] SUBMITED TO: SUBMITED BY: Ms. Sukhdilpreet Kaur Name: Anuj Sharma &Naman Roll NO.:R246A16 & R246A11 Regn.No.: 10802451 &10800991 AKNOWLEDGMENT First and the foremost I would like to thank to my almighty for giving me courage to bring up this term assignment. At the outset, I would like to propose a word of thanks to my teacher, friends and other sources that gave an unending support and helped me in numerous ways from the first stage of my term assignment conceived. I would also like to thank my family members for their whole hearted support and cooperation. I duly acknowledge the contribution of ms.Sukhdilpreet Kaur for invaluable help. Coding scientific calculator is an uphill task and would have not been possible without proper and timely assistance of ms.Sukhdilpreet Kaur. I would also thanks to all my friends for forwarding their suggestions to make necessary modifications. Special thanks to Ms.Sukhdilpreet Kaur for her able guidance in my term assignment. INTRODUCTION Scientific Calculator | | |Top of Form | |[pic] | |Bottom of Form | |[pic] | The calculator was written by Rolf Howarth in early 1996. A fully featured scientific calculator with proper operator......

Words: 3778 - Pages: 16

Premium Essay

Discussion on Npv

...Present Value: Net present value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows. NPV compares the value of a dollar today to the value of that same dollar in the future, taking inflation and returns into account. NPV is calculated using the following formula: NPV= -C0 + C11+r+ C21+r2+…+ Ct(1+r)t - C0 = initial investment C = cash flow r = discount rate t = time If the NPV of a prospective project is positive, the project should be accepted. However, if NPV is negative, the project should probably be rejected because cash flows will also be negative. Example of Net Present Value To provide an example of Net Present Value, consider a company who is determining whether they should invest in a new project. The company will expect to invest $500,000 for the development of their new product. The company estimates that the first year cash flow will be $200,000 the second year cash flow will be $300,000, and the third year cash flow to be $200,000. The expected return of 10% is used as the discount rate. The following table provides each year's cash flow and the present value of each cash flow. Year | Cash Flow | Present Value = FV(1+r)t | 0 | - 500,000.00 | -500000/(1.10)^0 = -500000.00 | 1 | 200,000.00 | 200000/(1.10)^1 = 181,818.18 | 2 | 300,000.00 | 300000/(1.10)^2 = 247,933.88 | 3 | 200,000.00 | 200000/(1.10)^3 = 150,262.96 | NPV = -500000.00 +......

Words: 919 - Pages: 4

Premium Essay

Using Financial Calculators

...Using Financial and Business Calculators Daniel J. Borgia Table of Contents Texas Instruments (TI) BA-35 SOLAR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1 Texas Instruments (TI) BA II PLUS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 Hewlett Packard (HP) 12C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27 Hewlett Packard (HP) 17BII . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .39 Hewlett Packard (HP) 19BII . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53 Using Financial and Business Calculators Most business and financial calculators offer a multitude of powerful functions. The purpose of this guide is to provide students with an easy and quick reference for some of the most commonly used financial functions. More detailed operational descriptions can be obtained from the owner’s manuals that accompany the calculators. This calculator guide discusses the basic functions of five business and financial calculators: the Texas Instruments (TI) BA-35 SOLAR, the Texas Instruments (TI) BA II PLUS, the Hewlett-Packard (HP) 12C, the Hewlett-Packard (HP) 17BII, and the HewlettPackard (HP) 19BII. The sections for each calculator present step-by-step instructions for using general and financial functions offered by each calculator. The calculations for each type......

Words: 12987 - Pages: 52

Premium Essay

Carbon Calculator

...Writing #4: Carbon Calculator Many of our daily activities trigger emissions of greenhouse gases. We produce greenhouse gas emissions by burning gasoline on our daily commutes, burning gas for home heating, or using electricity. Greenhouse gas emissions vary among individuals depending on a person's location, habits, and personal choices. It is good to know how much green house gasses an individual produces in their daily habits to be aware of their carbon footprint. From there a person can change their habits in an effort to reduce their footprint for a better life style and for the general health of the world. For this assignment I went through and checked all of my homes shared bills for accurate dollar amounts and measurements. For the questions about my car and my grandparent’s car, those were estimated through various websites including fuleeconomy.com. The lowest reliable value that I entered was my cars MPG. I found it easier to determine the average MPG from the reports on fuleeconomy.com rather than determining it myself. By the end of the carbon calculator, my estimated household carbon usage was 37,393 pounds of CO2 per year. Per individual this amount translates to roughly 12,464 pounds of CO2 per year. In comparison to the class average as seen below in figure 1.1, my house hold emissions were definitely on the lower end of the spectrum. To find the class average I took the higher number in the ranges offered, multiples each of those numbers by the responses......

Words: 1118 - Pages: 5

Premium Essay

Financial Calculator Exercises

...FINANCIAL ANALYST Texas BA II Calculator Workshop CHARTERED FINANCIAL ANALYST Setting up your BAII Calculator Workshop Setting up your calculator (BAII Plus)  Decimal places &|F!  Set to mathematical precedence &|"&!  No. of payments per year &-K  Clear time value calculations &0 Calculator Workshop Memory function  The calculator can store numbers for you Example:  You calculate the answer to 2 + 3.5 = 5.5 and then wish to store it  Press D then K (5.5 has now been stored and assigned to button K  Having cleared the screen (P), it is now possible to recall the number by pressing J then K It is always possible to recall the last answer from the calculator by pressing & and then x CHARTERED FINANCIAL ANALYST Nominal vs. Effective Interest Rates Calculator Workshop Calculating nominal and effective rates Periodic rate (r) Nominal/stated rate r x Annual no. of periods Effective Annual Rate (EAR) EAR = (1 + r)12/n – 1 Where n = number of months Example: Calculating nominal and effective rates  Calculate the nominal rate from a 4% six-monthly periodic rate  Calculate the EAR from a 4% six-monthly rate  Calculate the EAR from a nominal rate of 8% paid quarterly Calculator Workshop Example:  8% paid 6-monthly is, in effect, 8.16%  8% paid quarterly is, in effect, 8.243%  0.08  FV = $100 1 +  = $108.243 4   r  Effective rate =  1 +  − 1  n where r is the nominal rate n 4 Calculator Workshop  You......

Words: 2388 - Pages: 10

Premium Essay

Swap Calculator

...P – notional ti – number of days in the period Ti – basis period dfi – discount factor Similarly, PV of floating leg: , where fi – floating rate And resulting swap present value: Excel work Vanilla interest rate swap calculator, developed and designed in Excel with some use of VBA, is completely based on swap theory described above. All the requirements imposed for the calculator are met. Before we value the plain vanilla swap, we need to input the following parameters: • Notional • Contract period (Since the majority of interest rate swaps have a contract period between 1 year and 5 years, I decided to specify it within this interval.) • Fixed interest rate • Frequency of payments (1, 2 or 4 times a year) After all the values of the required variables are entered, the button “Calculate” should be clicked to obtain the swap present value and such intermediate values like PV of fixed CF and PV of floating CF, the difference of which is actually the swap present value. The table below represents the logic of the swap calculator. Explanation of columns: • Column (1) represents maturity in parts of the year. The scale interval is set as 0.25, since maximum possible payment frequency (for this calculator) is 4 times per annum. • Column (2): I set forward LIBOR rates as floating interest rates. Depending on payment frequency, 1-year, 6-month or 3-month LIBOR rates are set as floating rates for 1, 2, or 4 times per annum payments......

Words: 892 - Pages: 4

Free Essay

Mortgage Calculator

...Mortgage calculator One of my favorite tools and that I have used on many occasions is the mortgage amortization calculator from the internet. Using some basic information and a calculator it will help you have an elementary idea of monthly payments. Also, it can give you average information about the period of time needed for the full payment of the loan. Furthermore, an amortization schedule will show the payment, the interests, the distribution of capital, and the unpaid balance of the loan for each month until the full balance is paid off. The online mortgage calculator can be use easily without the need to understand complicated formulas. Simply enter the amount of the mortgage, interest rates and desire period of years, in order to be given immediately the amount of monthly payment plus a division of interest and the principal amount to be paid. With some calculator’s mortgage amortization, you can choose to check the consequences of the monthly over or lack of payments in efforts for the buyer to be mindful of the penalties if there are any in regards to their mortgage. Moreover, the debtor will determine how much they might save on interest payments if they were to pay the prematurely the loan. Prepared with awareness and understanding of your own financial abilities is key to make a tangible and wise decision on purchasing a home. Consequently you will be armed with the knowledge in efforts to negotiate terms and conditions that will be beneficial to your......

Words: 255 - Pages: 2

Premium Essay

Npv Analysis

...Less Initial Investment 125.000 NPV 23.298 NPV @ 12% = £23, 298 Project B: £000 Year NCF 1 43 2 43 3 43 4 43 5 43 Discount Factor 12% PV 0.893 38.399 0.797 34.271 0.712 30.616 0.636 27.348 0.567 24.381 Total PV 155.015 Less Initial Investment 125.000 NPV 30.015 NPV @ 12% = £30,015 Yes, they should be accepted because both projects have a positive NPV, therefore it indicates the increase in the market value of the shareholder’s funds. For both projects the company will recover the initial outlay and earn a return greater than 12% per year on the investment. 4 Question E According to Colin Drury, the most straightforward way of determining whether a project yields a return in excess of the alternative equal risk investment in traded securities is to calculate the net present value (NPV). This is the present value of the net cash inflows less the project’s initial investment outlay. If the rate of return from the project is greater than the return from an equivalent risk investment in securities traded in the financial market, the NPV will be positive. Alternatively, if the rate of return is lower, the NPV will be negative. A positive NPV therefore indicates that an investment should be accepted, while a negative value indicates that it should be rejected. A zero NPV calculation indicates that the firm should be indifferent to whether the project is accepted or rejected. Question F 1) If the cost of capital increases, the NPV would be reduced and......

Words: 1395 - Pages: 6

Free Essay

Calculators

...Calculators, lemmings or frame-makers? The intermediary role of securities analysts Daniel Beunza and Raghu Garud Introduction As Wall Street specialists in valuation, sell-side securities analysts constitute a particularly important class of market actor.1 Analysts produce the reports, recommendations and price targets that professional investors utilize to inform their buy and sell decisions, which means that understanding analysts’ work can provide crucial insights on the determinants of value in the capital markets. Yet our knowledge of analysts is limited by insufficient attention to Knightian uncertainty. Analysts estimate the value of stocks by calculating their net present value or by folding the future back into the present. In so doing, they are faced with the fundamental challenge identified by Frank Knight, that is, with the difficulty of making decisions that entail a future that is unknown. These decisions, as Knight wrote, are characterized by ‘neither entire ignorance nor complete . . . information, but partial knowledge’ of the world (Knight, [1921] 1971: 199). The finance literature has not examined the Knightian challenge faced by analysts. Indeed, existing treatments circumvent the problem by adopting one of two extreme positions. In the first, put forward by orthodox economists, it is assumed that Knightian uncertainty is non-existent and that calculative decision-making is straightforward. Analysts are presented as mere calculators in a probabilistic......

Words: 12718 - Pages: 51

Premium Essay

Npv Irr

...1.NPV NPV(Net Present Value), is the present value of a project's cash flow minus the present value of its cost, it means that how much the project could create to shareholders' wealth, the more the NPV, the more value the project makes and the higher the stock's price. If NPV equal to zero means the cash flow which the project makes can compensate for the cost of investment, the rate of return equal to required rate of return. If NPV exceeds zero, the part of exceeded belongs to shareholders. Accept the project which has a positive NPV will create positive economic value added and market value added. In this case, it can be seen clearly from Table 1, SSW and CCS both has a positive NPV, they all create value and wealth for the company. What should be mentioned is that, the NPV of SSW is higher than CCS, it means SSW could add more value than CCS. Table 1. the NPVs of SSW and CCS SSW CCS NPV 240,796.39 226,897.07 2.IRR IRR(Internal Rate of Return ) is the discount rate that make the inflows to equal the initial cost, in other word, it makes NPV to equal to zero. IRR is an estimate of expected project's rate of return. If this return exceed the cost of the capital used to the project, the part of difference is a dividend to shareholders and causes the stock's price to rise. If the IRR is less than cost of capital , shareholders have to make up. In this case, the cost of capital of these two restaurants both equal to 10%, the Table 2 shows that the IRR of SSW is......

Words: 1227 - Pages: 5

Mission Scooby-Doo | Cecilia Bartoli | Watch online