Some of the figures are incorrect, can you please help me rectify?

File Tools View Assessment_feedback_E0903290_32648-01_1_1590474301 - Last Modified: 10h ago X 5% on cost - distributed evenly over . GST Collected $12,822.31 Depreciation of furniture & fittings 3 months F&F cost $20,000 Telephone July, August, Sept $300.00 per month . PAYG Tax payable $6,400.00 $2000.00 for July & August, Freight July, August, Sept $3,000 for Sept . Learners are to calculate amount owning by customers (trade debtors) Staff amenities distributed evenly over 3 months $2,520.00 Superannuateon July, August, Sept 9.5% of wage . Retained profits is the amount of Net Profit as per the Projected Profit and Loss Statement $6,500 per week (average of 4 Wages (including Site Supervisor) July, August, Sept weeks/month) . Each owner contributed $100,000.00 to the business as start-up capital Rent July, August, Sept $1,800.00 per month Insurance July, August, Sept $3,200.00 p.a Electricity July, August, Sept $325.00 per month Interest paid July, August, Sept $720.00 per month Note: Learners are to calculate income earned each month Additional information to complete the Balance Sheet . Cash at Bank as at 30 September is $410,600.00 . Inventory on hand is $3,250.00 . Vehicles have a total value of $80,000.00 (Accumulated depreciation is $1.990.00) . Equipment is valued at $40,000.00 (Accumulated depreciation is $4000.00) . Furniture and fittings are valued at $20,000 (Accumulated depreciation is $1000.00) . Amounts owing on credit cards is $24,450.00 . Amounts owning to suppliers $54,420.00 . Bank loan $250,000.00 . GST paid $21,500.20 Screenshot saved The screenshot was added to your OneDrive. OneDrive Screens 8-9 of 27 U,TOCUS Type here to search w G O )ENG 7:49 AM 28/05/2020File Tools View Assessment_feedback_E0903290_32648-01_1_1590474301 - Last Modified: 10h ago X Appendix A Preliminaries 10,000 10,000 Statement of Cash Flow for the month of July Hire items 3,200 3,200 3,200 9,600 Temporary Services 600 600 600 1,800 Cash from operating activities Surveyors 3,000 3,000 6,000 Receipts from customers 81,037.05 Payments to suppliers (38,640.00) Site preparation 15,000 15,000 Payments to employees (26,000.00) Concrete slab 14,000 14,000 Interest payments (720.00) (1,300.00) Termite protection 2,50 2,50 Taxes paid GST paid (11,500.00) Bricklayer 15,000 15,000 GST collected 7,900.00 Frame carpenter 6,000 6,000 General expenses (38,305.00) Structural stee 5,000 5,000 Net cash flow for operating activities (27,527.95) Cash flow from investing activities Roof plumber 3,00 3,000 Purchase of new vehicle (40,000) 3,00 3,000 Net cash flow for investing activities (40000) Roof tiler Cash flow from financing activities Windows 8,000 8,000 Proceeds from borrowings 0 Net cash flow for financing activities Skylights 2,000 2,000 Net Increase (decrease) in cash held (67527.95) 3,000 3,000 6,000 Cash at beginning of period 350,000 Electrician Cash at end of period 282472.05 Plumber 5,00 5,000 10,000 Mechanical services 5,00 5,000 Appendix B Insulation 2,500 2,500 Projected Profit & Loss Statement for the 3 ending 30 September Plasterer 8,000 8,000 7,500 7,500 July August September Total Renderer 6,500 6,500 13,000 Revenue Tiling & Flooring Construction 81,037.05 270, 123.50 108,049.40 459,209.95 Carpentry 18,000 18,000 Construction Costs Joinery Screenshot saved Painter The screenshot was added to your OneDrive. OneDrive Screens 10-11 of 27 U,TOCUS Type here to search O Ei 9 w (" () ENG 7:49 AM 28/05/2020File Tools View Assessment_feedback_E0903290_32648-01_1_1590474301 - Last Modified: 10h ago X Appendix C $ $ Break-even sales point and sales Assets Current Assets Break-even sales point Cash on Hand 410,600.00 Fixed costs: 114105 Inventory 3,250.00 Variable costs: 240300 Trade Debtors 81 037.05 Total cost: 354405 Total income July-sept: 459209.95 Wages to partners: 100,000 Total Current Assets 494 887.05 Break Even Point: 454405 Non-Current Assets Vehicles 80,000 Profit for build Less accumulated 1990.00 depreciation Build price to sept: 45209.95 Equipment 40,000 Less accumulated 4000 loss for sept: 454405-459209.95=4804.95 depreciation Furniture and fittings 20,000 House price: 540,247 1000 Profit for build: $85842 Total Non-Current Assets 133,010 Total Assets 627,897.05 Liabilities Current Liabili Credit Card Appendix D Trade creditors Screenshot saved Balance Sheet projected as at 30 September The screenshot was added to your OneDrive. OneDrive Screens 14-15 of 27 Type here to search w @ )ENG 7:49 AM 28/05/2020File Tools View Assessment_feedback_E0903290_32648-01_1_1590474301 - Last Modified: 10h ago X GST Paid 21500.20 Appendix E GST Collected 12,822.31 Business Ratios Q PAYG Tax payable 6,400.00 Ratio Total Current Liabilities 119592.51 Current Ratio Current ratio=(Current Assets)/(Current Liabilities) Non-Current Liabilities 494 887.05/76,592.11=6.5 Bank loan 250,000.00 6.5:1 Total Non-Current 250,000 Liquid Ratio Liabilities Current Assets - Inventory - Prepayments Total Liabilities 369592.5 Current liabilities - Bank overdraft Net Assets 258304.55 194 887.05 - 3,250.00 /6,592.11 = 6.4 6.4:1 Shareholders Capital Gross Profit rate 218,909.50 Rob 100,000 gross profit ratio = 540,247 x 100 = 40.5% Jake 100,000 Net Profit Rate 114,112.00 Retained Profits net profit rate - - x 100 = 21% 104804.5 540,247 Return on Assets 114112 return to assets = - 627,897.05 = 18% Return on Equity 114112 312112 = 37% Debt to Equity 250000 312112 7= 80% Total debts to Total assets 326,592.11 627,897.05 = 52% Part B Screens 16-17 of 27 Focus - 1 + 100% Type here to search w 6 0 0)ENG 7:49 AM 28/05/2020File Tools View Assessment_feedback_E0903290_32648-01_1_1590474301 - Last Modified: 10h ago X The following amounts have been provided to complete the projected financial reports: Costs of Construction Incurred Amount Preliminaries July $10,000.00 Hire items July, August, September $3,200.00 per month Temporary Services July, August, September $600.00 per month Cash flow amounts for the month of July: Surveyors July, September $3,000 per month Site preparation July $15,000.00 Concrete slab July $14,000.00 July $2,500.00 Payments to suppliers $38,640.00 Termite protection Bricklayer August $15,000.00 Payments to employees $26,000.00 Frame carpenter August $6,000.00 Structural steel August $5,000.00 Interest payments $720.00 Roof plumber August $3,000.00 August $3,000.00 $1,300.00 Roof tiler Taxes paid Windows August $8,000.00 GST Paid $11,500.00 Skylights Sept $2,000.00 Electrician August, Sept 3,000 per month GST Collected $7,900.00 Plumber August, Sept $5,000.00 per month General expenses $38,305.00 Mechanical services Sept $5,000.00 Insulation Sept $2,500.00 Plasterer August $8,000.00 Renderer jep $7,500.00 Tiling & Flooring August, Sept $6,500.00 per month Carpentry Sept $18,000.0 . Sullivon Constructions plans to buy a new Holden Ute in July with a cash price of $40,000.00. Joinery Sept $35,000.00 $16,000.00 (90% paid in The company already purchased another Holden Ute earlier in the year Painter ep September) Garage door Sept $1,500.00 . Cash at Bank at 1st July was $350,000.00 Glazing Sept $1,500.00 Fixtures & fittings Sept $5,000.00 . A new loan of $250,000.00 will be taken out in July. This loan is to be repaid in 2026 Appliances Sept $12,000.00 Note: Receipts from customers are to be calculated by the learner Fixed Costs Postage $50.00 per month Office supplies $200.00 per month The Projected Profit & Loss figures for the 3 months ending 30 September are as follows: Motor vehicle expenses $400.00 per month Depreciation of vehicles $550 for July, thereafter $720 10% on cost - distributed evenly Depreciation of equipment over 3 months Equipment cost $40,000 Screens 6-7 of 27 Focus - I + 100% Type here to search O Ei 9 w (" () ENG 7:49 AM 28/05/2020