Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Net working capital with correct level of maintenance cash
cell A1 current assets = 10,000
cell A2 current liabilities = 13,000 cell A3 cash =30,000 cell A4 cost of goods sold is 50,000 Cell A5 maintenance cash = ? cell A6 a formula that reutrns net working capital = CA - CL + maintenance cash Is there simple way to always keep NWC positive, but no more than 2000, by using excess cash? For example, what formula would allocate 5000 from cash (not subtract from cash) as maintenance cash and add it to NWC, so I get 2000? what i've done, but is not working: formula in cell a6: =if(and(a1-a2<0,.25*A4<a3),a1-a2+(.25*a4),a1-a2+some minimum level of cash assuming there is enough cash for that minumum level) this formula does nothing for me -- I've nested this formula into other permutations, but some variable always makes it wrong. Any suggestions? There is one more tricky issue -- it has to do with maintenance cash maintaining some kind of relationship to COGS, lets get to that later if anyone's interested. thaniks for taking a look... SteveC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping my cash expenses from subtracting the cash balance | New Users to Excel | |||
World Cup tipping | Excel Worksheet Functions | |||
World Cup tipping | New Users to Excel | |||
sum sub levels. | Excel Discussion (Misc queries) | |||
sum sub levels. | Excel Worksheet Functions |