Given the cost expenditures for a small project as shown in Table 1,

1. Calculate the overdraft and determine the peak financial requirement;
2. Develop the cash flow profile that is needed to calculate the rate of return of the project;
3. Find the rate of return from the project.

Assume: 25% markup

10% retainage for only the first two months Interest rate = 1% per month

Payments are billed at the end of a month and received one month later

Table 1. Overdral Calclations 2 $65,000 $10,000 $75,000 3 $15,000 $10,000 $25,000 Month $25,000 $10,000 $35,000 $55,000 $10,000 $65,000 Direct cost Indircct cost Subtal 25% marku Marku Total billed 10% Retainage withheld Payment received Total cost to date Total amount billed to date Total amount paid to date Ovcrdraft incurred Interest on overdraft balance (100 per month Accumulated overdraft Note Direct and indirect cost occur at the beginning of the month Retainage is only taken for the firs two months. Table 1. Overdral Calclations 2 $65,000 $10,000 $75,000 3 $15,000 $10,000 $25,000 Month $25,000 $10,000 $35,000 $55,000 $10,000 $65,000 Direct cost Indircct cost Subtal 25% marku Marku Total billed 10% Retainage withheld Payment received Total cost to date Total amount billed to date Total amount paid to date Ovcrdraft incurred Interest on overdraft balance (100 per month Accumulated overdraft Note Direct and indirect cost occur at the beginning of the month Retainage is only taken for the firs two months