Hi i cannot match my balance so please i need monthly cash budget, income statement and balance sheet for whole year by month and month

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 requiring caiculations as follows: Other Operating Expenses are estimated as follows: All operating expenses are to be paid in the month following the purchase with the exception of the following which do not have credit terms: - Insurance - Property Taxes - Business Fees and Licenses - Interest and Bank Charges When preparing your assignment using a spreadsheet, follow the instructions below: - Round all numbers in your budget to the nearest dollar. - Use one workbook for the assignment but each financial statement should begin on a new tab. Name each sheet tab. - Use cell references in all formulas and functions (no Excel Tip: numbers). Use the freeze panes feature: - Use a formula or function for all calculations, don't type in the under the View tab when your answer. spreadsheet gets too larse to: - Use a formula for transferring data from one sheet to another. - Use the sum function appropriately. It should be used when adding more than two consecutive numbers. It should not be used when subtracting, multiplying or dividing. - Format accordingly: - Ensure all values are accompanied by an appropriate and clear label. - Ensure that numbers have consistent alignment and format. Ensure that columns are wide enough to display all data in the cell. Required Using Excel, prepare a monthly budgeted cash flow, income statement and balance sheet. 1. Print and pass in the cash flow, income statement and balance sheet. - Include a cover page with the assignment name, your group name, and students' names - Include the group participation form 2. Drop your Excel file on Brightspace called: Your Group Name Projected FS