Question

PLEASE I JUST DONT NEED THE TABLE BUT ALSO ALL THE CALCULATIONS IN DETAILS ON HOW YOU GET EACH FIGURE THANK YOU

Given the followingcost expenditures forasmall warehouse project to include direct and indirect charges), calculate the peak financial requirement, the average overdraft, and the ROR on invested money. Sketch a diagram of the overdraft profile. Assume 12% markup Retainage 10% throughout project Finance charge 15% month Payments are billed at end of anth and received one month later Month Indirect Direct Cost (5) $69.000 $21,800 $17.800 S40,900

Answer 1

Solution Month-5 Particulars Monthly cost Total billed (12% markup) Less Retained withheld (total billed * 10%) Payment Received after one month Month-1 $69,000 $77,280 $7,728 $69,552 Month-2 $21,800 $24,416 $2,442 $21,974 Month-3 $17,800 $19,936 $1,994 $17,942 Month-4 $40,900 $45,808 $4,581 $41,227 SO 43,981 23,661 17,800 41,461 Overdraft at beginning Add: money withdraw for cost at beginning Total balance for calculation of interest Add: interest expense (Above amount *1.5%) Less: Payment received Total amount of financing 69,000 69,000 1,035 $0 70,035 70,035 21,800 91,835 1,378 (69,552)| 23,661 622 20,108 40,900 61,008 915 (17,942)| 43,981 43,981 660 (41,227) 3,413 (21,974)| 20,108

- overdraft profile 80000 70000 70,035 ·09909 opaiser 50 to 50000 43981 40000 30000 23.1. 20109 20000 10000 y 3413 Monthe.