Main Page Sitemap

How to calculate discounted payback period in excel

how to calculate discounted payback period in excel

One of the major disadvantages of simple payback period is that it ignores the time value of money.
Discounted Payback Period A, b C, where, A, last period with a negative discounted cumulative cash flow;.
In addition to weight watchers online promotion code canada the first two flaws, the business owner also has to guess at the interest rate or cost of capital.
Solution, step 1: Prepare a table to calculate discounted cash flow of each period by multiplying the actual cash flows by present value factor.Absolute value of discounted cumulative cash flow at the end of the period A; C, discounted cash flow during the period after.Add the first years discounted cash flow to the initial investment.Calculate the cumulative discounted cash flows: Year 0: - 10,000 Year 1: - 5,454.55 Year 2: - 42,148.76 Year 3: 105.18 Discounted payback period (DPP) occurs when the negative cumulative discounted cash flows turn into positive cash flows which, in this case, is between the.The rest of the procedure is similar to the calculation of simple payback period except that we have to use the discounted cash flows as calculated above instead of actual cash flows.It is interesting to note that if a project has negative net present value it won't pay back the initial investment.In the example, divide -454.55 by 661.16, which equals -0.69, and use positive.69 for the result.Step 3, discount the second years cash flow using the same formula as the first years cash flow, but adjusting n to the second year.(See References 3, A variant: Discounted payback).(See References 2,.This flaw overstates the time to recover the initial investment.Alternatively, go to one of several financial circle line discount code 2015 online financial calculator sites.Divide the first years cash flow by (1 i)n to discount the cash flow.Step 3, determine how much of the final year is required to pay back the initial investment.
The discounted payback period calculation differs only in that it uses discounted cash flows.


Most viewed

John 'Samples' Clark Dec 9, 2017 Read More Possible free Household, Beauty Other Products From Good Housekeeping Product Testing Panel (Survey Required) Good Housekeeping is an excellent magazine for homemakers and acuvue advance plus rebate much more.Its a great show and it has a great promotion going on..
Read more
New Office Depot and OfficeMax coupons and promo codes added every Office Depot and OfficeMax Coupons, Promo Codes costco voucher code 2016 uk Cash Back Says.00 coupon.Available aafes Coupons and aafes Coupon Codes: 10 off Most Items Use aafes Coupon x2182vip Up To 30 Off on Select Furniture..
Read more
Next to Windows, there is an Additional download cravenspeed coupon code 2016 options drop-down menu.The device must be formatted in order for the device to be bootable.You can download.NET framework here and you can download the Image Mastering API here.If you change the boot order of drives in..
Read more

Most viewed

Cheap online bookstores australia

When I looked online, in bookstores, and the local public and university libraries I was shocked to find how little information there was about purchasing health insurance.Algonquin College's First Class Bookstore, algonquin College, allan Hancock College los angeles dodgers giveaway schedule 2016 Bookstore.Joseph College Store College of New

Read more

Price is right contestant

The wheel is buy laptop in store positioned on 5 prior to royal canin so rebate the bonus spin so that it cannot land on a winning prize without making a complete revolution.So it pays to watch this remix contest pack show first, and get to know the

Read more

Promotional codes for levis

And CouponzGuru is making it simple for the buyers to save immensely with the home and kitchen discounts.It is like a second nature to Amazon to be supportive for its customers and keep them engaged with bountiful offers.It does have some of its own-made products features such as

Read more