payment terms

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13) 2/ the Cash position (cashout) based on payment terms, total cost expense...

Hi, I am trying to model my in- and outgoing cash flow and want to have them dynamically change when I change the payment terms. Any ideas? Thanks! <colgroup><col width="184" style="width: 138pt;"><col width="128" style="width: 96pt;"><col width="87" span="9" style="width...

I was wondering if anyone knew of a way to create a spreadsheet that would allow someone to enter an invoice date and have Excel automatically calculate payment terms of 2% 10th net 25? Example: Customer is invoiced 7/24. They must pay by 8/10 to get the 2% discount. Payment is due in full on...

I Need some help. I want to calculated if data will uploaded on the 1st or the 15th based on today date. So for example if today is 11/27/2012 then the next data upload will be on 12/1/2012. And come 12/1/2012 next data upload will be on 12/15/2012. I've used formula below to calculate but when...

I am trying to determine the amount of finance charges due based on 18% APR when I have the payment terms in one column (ie Net 15), the invoice date in one column (ie 1/15/12), the balance due in a column (ie $790.00), and the statement date in a column (ie 5/18/12). Suggestions? Also, to add...