Excel discount formula

How to calculate discount and sale price?

You can find the discount by subtracting its sale price from its marked price. So, Discount = Marked price – Sale price .

Discount and Proceeds If an amount M is borrowed for a time t at a discount rate of r per year, then the discount D is. D=M⋅r⋅t . The proceeds P, the actual amount the borrower gets, is given by. P=M−DP=M−Mrt. or P=M(1−rt)