discounted

Here's what I want to work out for my holiday rentals: Let's say (for a certain week) $540 is theprice... ALTHOUGH - I want this to look like a 10% discounted price (for example $600 - 10% = $540) Then I have to divide the $540 by 7 to get the discounted daily price. Get my drift? But how...

I am trying to discount cumulative interest over a period of time. Say I have an original mortgage for $100,000 and a term of 60 months, then the borrower prepays on month 1 for $50,000. I want to know what the cumulative interest lost over that period is at a discounted rate of 15%. I want...

Hi all, I’m building an invoice and for two products. If someone buys 1 - 30 of Product 1 it’s £300 per product. 31 - 60 its £250. 60+ it’s £200. Is there a way to automate the sum total amount to reflect the discounted rates. Ie. Qty 40 should equal 10,000 Any help would be greatly...

Good evening all, I've taken some excellent examples already from you forum, but now I'm struggling with a more complicated one which I can't find an answer for. To complete my timesheet. If I work less than 8 hours no break is discounted. Between 8 and 10 hours, 30 min. are discounted. More...