I need to create a cash budget for the year in Excel using the information provided.

Unit 5 Projected Financial Statements Management has developed a sales projection for the next twelve months. Based on industry standards, 75% of sales are expected to be collected in the current month and the remaining 25% will be collected in the month following the sale. Based on industry standards, the following are the basis for Cost of Goods Sold: Materials 45% of sales Direct Labor 15% of sales Subcontractors 15% of sales Mi Casa ignores overhead. Materials and subcontractors are paid in the month following the purchase. Direct labour is paid in the month the employees work. Sarah and Matthew will deposit approximately $20,000 in the bank at the beginning of October. $100 of these funds will be used to pay for their common shares and the remaining $19,900 will be set up as a loan from the shareholder with no interest and no set terms of repayment. The corporate income tax rate for Mi Casa is 17%. Operating Expenses reoulrine calculatinns as follows: Other Operating Expenses are estimated as follows: Loan Calculator