J
jwildstein
I am having trouble creating a formula that will help me create a carry
forward stream of payments.
For example, I have the following columns:
Gross Sales - units sold x price per unit
Gross Receipts - Cash collected
Carry forward - Amount of cash that will be paid in future payments
The variables are:
Number of payments
% of customers paying full price up front
I am trying to create a formula that will allow me to alter the
variables and yet automatically calculate the future stream of
payments.
Meaning, if 50% of the customers pay me full price up front, and
another 50% pay only half price up front and the rest evenly in future
months how do I calculate that?
forward stream of payments.
For example, I have the following columns:
Gross Sales - units sold x price per unit
Gross Receipts - Cash collected
Carry forward - Amount of cash that will be paid in future payments
The variables are:
Number of payments
% of customers paying full price up front
I am trying to create a formula that will allow me to alter the
variables and yet automatically calculate the future stream of
payments.
Meaning, if 50% of the customers pay me full price up front, and
another 50% pay only half price up front and the rest evenly in future
months how do I calculate that?