Problem: Cash Flow Analysis
For the attached Gantt chart, the following information is available:
Invoices are sent at the end of each month.
Mark up is 20% on each invoice.
Invoices are paid one moth later.
The retained amount is 10% of the invoice value
All retained amounts are received 1 month after the completion of the project
Plot the cash-in and cash-out curve for the project and tabulate the amount to be financed every month.