what is the formula to calculate discount?
1831
Remember the formula for finding the discount price of an item. Where S = sale price, r = discount percentage rate and p = original price, the discount formula is: S = p - rp.
1161469
Thus, a product that normally costs $50 with a 13 percent discount will cost you $43.50, and you saved $6.50. You can also calculate how much you save by simply moving the period in 13.00 percent two spaces to the left, and then multiply the result by $50 as follows: $50 x . 13 = $6.50 savings.
270042
['Formula to calculate cost price if selling price and profit percentage are given: CP = ( SP * 100 ) / ( 100 + percentage profit).', 'Formula to calculate cost price if selling price and loss percentage are given: CP = ( SP * 100 ) / ( 100 – percentage loss ).']
263324
Thus, a product that normally costs $20 with a 40 percent discount will cost you $12.00, and you saved $8.00. You can also calculate how much you save by simply moving the period in 40.00 percent two spaces to the left, and then multiply the result by $20 as follows: $20 x . 40 = $8.00 savings.
746616
To calculate the present value of any cash flow, you need the formula below: Present value = Expected Cash Flow ÷ (1+Discount Rate)^Number of periods.
82023
['=NPV(discount rate, series of cash flow)', 'Step 1: Set a discount rate in a cell.', 'Step 2: Establish a series of cash flows (must be in consecutive cells).', 'Step 3: Type “=NPV(“ and select the discount rate “,” then select the cash flow cells and “)”.']
588251
['Convert the Percentage to a Decimal.', 'Multiply the Original Price by the Discount.']
638961
As with any formula in Excel, you need to start by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. The basic formula for calculating a percentage is =part/total. Say you want to reduce a particular amount by 25%, like when you're trying to apply a discount.
1278021
For example, if the original price of the item equals $24, you would multiply 0.2 by $24 to get $4.80. Finally, subtract the value of the dollar discount from the original price to find the price of the item after the discount.
1048832
You will pay $11.25 for a item with original price of $15 when discounted 25%. In this example, if you buy an item at $15 with 25% discount, you will pay 15 - 3.75 = 11.25 dollars.
958854
Thus, a product that normally costs $70 with a 20 percent discount will cost you $56.00, and you saved $14.00. You can also calculate how much you save by simply moving the period in 20.00 percent two spaces to the left, and then multiply the result by $70 as follows: $70 x . 20 = $14.00 savings.
1344674
Thus, a product that normally costs $2 with a 5 percent discount will cost you $1.90, and you saved $0.10. You can also calculate how much you save by simply moving the period in 5.00 percent two spaces to the left, and then multiply the result by $2 as follows: $2 x . 05 = $0.10 savings.
326582
['First, divide the discounted price by the original price. ... ', 'Subtract this result from 1. ... ', 'On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.']
629250
Thus, a product that normally costs $80 with a 25 percent discount will cost you $60.00, and you saved $20.00. You can also calculate how much you save by simply moving the period in 25.00 percent two spaces to the left, and then multiply the result by $80 as follows: $80 x . 25 = $20.00 savings.
424127
Sale Price = $44 (answer). This means the cost of the item to you is $44. You will pay $44 for a item with original price of $55 when discounted 20%. In this example, if you buy an item at $55 with 20% discount, you will pay 55 - 11 = 44 dollars.
624921
Thus, a product that normally costs $23 with a 3 percent discount will cost you $22.31, and you saved $0.69. You can also calculate how much you save by simply moving the period in 3.00 percent two spaces to the left, and then multiply the result by $23 as follows: $23 x . 03 = $0.69 savings.
190533
Thus, a product that normally costs $45 with a 15 percent discount will cost you $38.25, and you saved $6.75. You can also calculate how much you save by simply moving the period in 15.00 percent two spaces to the left, and then multiply the result by $45 as follows: $45 x . 15 = $6.75 savings.