Retainage for the cash flow calculations, use 10%

Bob undertakes a S5 million project (his costs) that will last one year. He has $200,000 in cash available at the start of the project. His indirect costs are $25,000 per month, interest on borrowed money is 10% and mark-up 15%. Direct costs to the project are shown in the table below, Month 1 Month 2 Month 3Month 4 Month 5 Month 6 $100,000 $200,000$300,000 $400,000$400,000$500,000 Month 7Month 8 Month 9 Month 10 Month 11Month 12 $550,000 $550,000$550,000$500,000$400,000$%250,000 Develop a spreadsheet to make a complete overdraft calculation table (similar to question 3 above) and determine: 1) total project amount, 2) monthly status, 3) maximum overdraft, 4) total borrowing costs, 5) final profit, 6) final payment amount, 7) final payment month