How can I insert a 10% discount on a spreadsheet - Excel Help …
Dec 12, 2005 · Ensure that Excel is creating the name Discount and that it references B1. Now we need to apply the discount to your prices. I'll assume your existing prices are in column B …
NPV/XNPV for monthly cash flows - Excel Help Forum
Jan 23, 2018 · Re: NPV/XNPV for monthly cash flows From the official documentation of the XNPV function, it requires a rate (which looks to be an annual discount rate), a range of cash …
15% discount formula - Excel Help Forum
Oct 3, 2007 · Hi everyone, I hope someone can help me with this formula its doing my head in. I would like to add a formula to my invoice that will give minus 15% off the Sub total.
How to calculate NPV of an infinite series? - Excel Help Forum
Sep 15, 2005 · Say D is your discount rate, CF the annual constant cash flow. (note that D must be above 2% to estimate an "infinite" NPV) NPV = Sum CF* ( (1+2%)/ (1+D))^N When N is …
Mid Period Discounting with the NPV Function - Excel Help Forum
May 15, 2006 · The easiest way is to use the NPV formula above with the half year adjustment, make the discount rate (.1 in example) a variable and use Solver or Goal seek to find the rate …
Discount Rates Formula & NPV [SOLVED] - Excel Help Forum
Dec 15, 2022 · Discount Rates Formula & NPV Hey All - I have built a DCF model that uses 2 different discount rates for 2 different cash flow streams within my investment (one is rental …
Excel function that can take an array value for rates for NPV with ...
Dec 19, 2024 · Excel 2007 XNPV () takes array values for "values" and "dates" but apparently not for rates. It seems to only take a single rate. Is there an NPV function that can take array …
[SOLVED] Formula to calculate the compound discount rate - Excel …
Mar 19, 2025 · Formula to calculate the compound discount rate Evening all, This may well be a simple solution that I kick myself over, but how can I calculate the compound discount rate …
Volume Purchase Discount Based on Quantity & Tiers - Excel Help …
Mar 30, 2021 · This entails a Volume Purchase Discount whereby based on the volume of quantity purchased, the Unit Price will either be higher or lower. Where all products from …
Formula to Compute Early Settlement Discount/Rebate [SOLVED]
Sep 20, 2023 · The manual formula to compute the settlement discount/rebate is the payment amount x number of days paid early x 9.75% divided by 365 days I have attached my …