Calculate discount as a percentage from sale price and discount amount.
=C2/B2

Calculate a percentage discount.
=B2-C2*B2

Calculate simple interest.
=A2*B2*C2 (calculate simple interest)
=A2+D2 (amount)
where A2 is the Principal
B2 is the interest rate as a percentage
C2 is the time in years
