create a cashflow model template in Excel

This job is urgent and must be completed by 21st March- 7pm brisbane Australia. Only bid if you can achieve this as you will only be paid if it is delivered before then. It is not very complicated, i just don't have time. I need a cash flow template created for me to then enter in the raw numbers. The template is for 5 separate companies, that then needs to summarise into a single table. I.e. separate tabs for each company so that we can see the details of each country, but then a summary page that summarises a single overview for all companies. Each companies cashflow forecast must; 1) Be daily 2) Go out to the end of May 29th 3) Have lines for manual entry of cash received 4) Have lines for the total cash payments out for Creditors, Taxes, Payroll, Loan Repayments and Rent 5) HAve a table for manual entry for the actual names of the items that make up each payment combination i.e. the names of entities that make up creditors, taxes, Payrol, Loan Repayments and Rent and then columns where the amount that will be paid and on which date they will be paid. By entering specific details of the date and the amount of the payment, these will total up each day and become the totals for the lines for total cash payments for creditors, taxes, payroll, loan repayments and rent. 6) There will be a opening bank balance each day and a closing bank balance. For the fields that need to be manually entered, they are to be highlighted in yellow. e.g. the cash in line need manual entry by the user so that will be highlighted yellow. Then each of the companies will be summarized into a summary cashflow for the entire group for each line. The company names will be put in each tab; 1) Summary (this is a summary of all the companies added together 2) "SGL" 3)"SGH" 4)"SCC" 5)"CENSEO" 6)"QUSOL" Please see the picture attached for more information.