please calculate the CASH SALES, CASH FROM ACCOUNT RECIVEABLE , BEGINNING CASH BALANCE AND ENDING CASH BALANCE. THANKS!! you can randomly chose a number if some numbers is non visible.

$ Operating capital Legal fees Salaries and wages Insurance Rent Rent deposits Agency fee Communication and utility deposits Advertising and promotions Transportation and distribution Licenses Beginning inventory Working capital (cash on hand) 19700.0 2400000.0 21133.8 150000.0 300000.0 75000.0 140450.0 140000.0 152000.0 58200.0 2236500.0 75263050.0 Fixed assets Leasehold improvement Equipment, Furniture and fixtures 1600000 15457400 Total required funds 98013434 F G H 1 L M N P Q R E biected Income Statement (With Monthly Detail) Prepare the Income Statement (With Monthly Detail) for the first year of operation of the new business Write down clearly all assumptions made. T Month 1 $ 11182500.00 Month 2 S 11182500.00 Month 3 $ 10650000.00 Month 4 $ 10650000.00 Months $ 10650000.00 Month 6 $ 10650000.00 Month S 10650000.00 Month 8 $ 10650000.00 Month 9 5 10650000.00 Month 10 s 10650000.00 Month 11 S 10650000.00 Month 12 $ 10650000.00 Totals $ 128865000.00 Sales Cost of goods sold 4473000.00 4473000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 51546000.00 Gross profit 6709500.00 6709500.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 77319000.00 Operating expenses Salaries expense Rent expense Communication and utilities Legal fees Insurance Agency fee Advertising and promotions expense Transportation and distribution expense Licenses 2400000.00 150000.00 140450.00 19700.00 21601.4 75000.00 140000.00 152000.00 13500.00 2400000.00 150000.00 140430.00 19700.00 21601.4 no 133000.00 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 126350.00 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 120032.50 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 114030.88 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 108329.33 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 102912.86 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 n10 97767.22 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 92878.86 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 88234.92 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 83823.17 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 79632.01 152000.00 13500.00 28800000.00 1800000.00 1683400.00 236400.00 25921728 75000.00 1286991.75 1824000.00 162000.00 Total operating expenses 3112251.44 3030251.44 3023601.44 3017283.94 3011282.32 3005580.77 3000164 30 2995018.68 2990130.30 2985486.36 2981074.61 2976883.45 36129009.03 Profit before taxes 3597248.56 3679248.56 3366398.56 3372716.06 3378717.69 3384419.23 3389835.70 3394981.34 3399869.70 3404513.64 3408925.39 3413116.35 41189990.97 Income taxes 593546.01 607076.01 555455.76 556498.15 557488.42 558429.17 559322.89 560171.92 560978.50 56174475 362472.69 563164.23 6796348.51 Net profit (loss) 3003702.55 3072172.55 2810942.80 2816217.91 2821229.27 2825990.06 2830512.81 2834809.42 2838891.20 2842768.89 2846452.70 2849952.32 34393642.46 ojected Cash Flow Statement (With Monthly Detail) 1 Prepare the Projected Cash Flow (With Monthly Detail) for the first year of operation of the new business. 2 Write down clearly all assumptions made. Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month & Month 9 Month 10 Month 11 Month 12 Totals Cash inflows Cash sales Cash from accounts receivable 0 0 Total inflows 0 0 0 0 0 0 0 0 0 0 0 0 0 Cash outflows Rent Insurance Salaries and wages Communication and utilities Legal fees Agency fee Advertising and promotions Transportation and distribution Licenses 150000 21133.8 2400000 140450 19700 75000 140000 152000 13500 150000 21133.8 2400000 140450 19700 no 133000 152000 13500 150000 21133.8 2400000 140450 19700 no 126350 152000 13500 150000 21133.8 2400000 140450 19700 no 120033 152000 13500 150000 21133.8 2400000 140450 19700 no 114031 152000 13500 150000 21133.8 2400000 140450 19700 no 108329 152000 13500 150000 21133.8 2400000 140450 19700 no 102913 152000 13500 150000 21133.8 2400000 140450 19700 no 97767 152000 13500 150000 21133.8 2400000 140450 19700 no 92879 152000 13500 150000 21133.8 2400000 140450 19700 no 88235 152000 13500 150000 21133.8 2400000 140450 19700 no 83823 152000 13500 150000 21133.8 2400000 140450 19700 no 79632 152000 13500 1800000 253605.6 28800000 1685400 236400 75000 1286992 1824000 162000 0 36123397 Total outflows 3111784 3029784 3023134 3016816 3010815 3005113 2999697 2994551 2989663 2985019 2980607 2976416 -3111784 -3029784 -3023134 -3016816 -3010815 -3005113 -2999697 -2994551 -2989663 -2985019 -2980607 -2976416 Net cash flow Beginning cash balance -36123397 0 Ending cash balance $ Operating capital Legal fees Salaries and wages Insurance Rent Rent deposits Agency fee Communication and utility deposits Advertising and promotions Transportation and distribution Licenses Beginning inventory Working capital (cash on hand) 19700.0 2400000.0 21133.8 150000.0 300000.0 75000.0 140450.0 140000.0 152000.0 58200.0 2236500.0 75263050.0 Fixed assets Leasehold improvement Equipment, Furniture and fixtures 1600000 15457400 Total required funds 98013434 F G H 1 L M N P Q R E biected Income Statement (With Monthly Detail) Prepare the Income Statement (With Monthly Detail) for the first year of operation of the new business Write down clearly all assumptions made. T Month 1 $ 11182500.00 Month 2 S 11182500.00 Month 3 $ 10650000.00 Month 4 $ 10650000.00 Months $ 10650000.00 Month 6 $ 10650000.00 Month S 10650000.00 Month 8 $ 10650000.00 Month 9 5 10650000.00 Month 10 s 10650000.00 Month 11 S 10650000.00 Month 12 $ 10650000.00 Totals $ 128865000.00 Sales Cost of goods sold 4473000.00 4473000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 4260000.00 51546000.00 Gross profit 6709500.00 6709500.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 6390000.00 77319000.00 Operating expenses Salaries expense Rent expense Communication and utilities Legal fees Insurance Agency fee Advertising and promotions expense Transportation and distribution expense Licenses 2400000.00 150000.00 140450.00 19700.00 21601.4 75000.00 140000.00 152000.00 13500.00 2400000.00 150000.00 140430.00 19700.00 21601.4 no 133000.00 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 126350.00 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 120032.50 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 114030.88 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 108329.33 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 102912.86 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 n10 97767.22 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 92878.86 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 88234.92 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 83823.17 152000.00 13500.00 2400000.00 150000.00 140450.00 19700.00 21601.4 no 79632.01 152000.00 13500.00 28800000.00 1800000.00 1683400.00 236400.00 25921728 75000.00 1286991.75 1824000.00 162000.00 Total operating expenses 3112251.44 3030251.44 3023601.44 3017283.94 3011282.32 3005580.77 3000164 30 2995018.68 2990130.30 2985486.36 2981074.61 2976883.45 36129009.03 Profit before taxes 3597248.56 3679248.56 3366398.56 3372716.06 3378717.69 3384419.23 3389835.70 3394981.34 3399869.70 3404513.64 3408925.39 3413116.35 41189990.97 Income taxes 593546.01 607076.01 555455.76 556498.15 557488.42 558429.17 559322.89 560171.92 560978.50 56174475 362472.69 563164.23 6796348.51 Net profit (loss) 3003702.55 3072172.55 2810942.80 2816217.91 2821229.27 2825990.06 2830512.81 2834809.42 2838891.20 2842768.89 2846452.70 2849952.32 34393642.46 ojected Cash Flow Statement (With Monthly Detail) 1 Prepare the Projected Cash Flow (With Monthly Detail) for the first year of operation of the new business. 2 Write down clearly all assumptions made. Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month & Month 9 Month 10 Month 11 Month 12 Totals Cash inflows Cash sales Cash from accounts receivable 0 0 Total inflows 0 0 0 0 0 0 0 0 0 0 0 0 0 Cash outflows Rent Insurance Salaries and wages Communication and utilities Legal fees Agency fee Advertising and promotions Transportation and distribution Licenses 150000 21133.8 2400000 140450 19700 75000 140000 152000 13500 150000 21133.8 2400000 140450 19700 no 133000 152000 13500 150000 21133.8 2400000 140450 19700 no 126350 152000 13500 150000 21133.8 2400000 140450 19700 no 120033 152000 13500 150000 21133.8 2400000 140450 19700 no 114031 152000 13500 150000 21133.8 2400000 140450 19700 no 108329 152000 13500 150000 21133.8 2400000 140450 19700 no 102913 152000 13500 150000 21133.8 2400000 140450 19700 no 97767 152000 13500 150000 21133.8 2400000 140450 19700 no 92879 152000 13500 150000 21133.8 2400000 140450 19700 no 88235 152000 13500 150000 21133.8 2400000 140450 19700 no 83823 152000 13500 150000 21133.8 2400000 140450 19700 no 79632 152000 13500 1800000 253605.6 28800000 1685400 236400 75000 1286992 1824000 162000 0 36123397 Total outflows 3111784 3029784 3023134 3016816 3010815 3005113 2999697 2994551 2989663 2985019 2980607 2976416 -3111784 -3029784 -3023134 -3016816 -3010815 -3005113 -2999697 -2994551 -2989663 -2985019 -2980607 -2976416 Net cash flow Beginning cash balance -36123397 0 Ending cash balance