Hiii
Greetings!!!
I have a worksheet with the following parameters
a) Sales Projected
b) Project Schedule
c) Payment Plan
A payment plan is to be derived by taking the following criterias:-
• When a person buys a unit he has to pay the cumulative percentage(multiplied by Bsp ) till date according to the payment plan.
• The rest will be paid according to the schedule the start dates of which has been shown in the sheet.
A cashflow is to be generated by using some formula. I can not figure that part out.
Spreadsheet attached for reference.
https://www.dropbox.com/s/o8k8khbpr35nqua/Excel Cashflow.xls.xlsx
Greetings!!!
I have a worksheet with the following parameters
a) Sales Projected
b) Project Schedule
c) Payment Plan
A payment plan is to be derived by taking the following criterias:-
• When a person buys a unit he has to pay the cumulative percentage(multiplied by Bsp ) till date according to the payment plan.
• The rest will be paid according to the schedule the start dates of which has been shown in the sheet.
A cashflow is to be generated by using some formula. I can not figure that part out.
Spreadsheet attached for reference.
https://www.dropbox.com/s/o8k8khbpr35nqua/Excel Cashflow.xls.xlsx
