Hello, if you can please answer these questions in the attached word doc. I have provided a template for your convenience

Cash flow analysis 2009Q1 - 2020Q1 1. Number of cars sold 2. Unit price 3. Unit cost 4. Revenue 5. Cost of goods sold (1 3) 6. Wages and other costs 7. Depreciation 8. EBIT (4 - 5 - 6 - 7) 9. Net interest 10. Pretax proit (8 - 9) 11. Tax (.35 10) 12. Net proit (10 - 11) 1150 100 90 23000 20700 750 400 1150 568 582 203.7 378.3 Balance sheet 2020Q1 2019Q1 Cash Receivable Inventory Total current assets Fixed asset, net Total assets 10 10,500 10 0 Bank loan Payables Total current liabilities Sharesholders equity Total liabilities plus equity 9,731 230 5,400 4,500 15,910 4,510 1,280 1,760 17,190 6,270 5,400 4,500 15,131 4,730 2,059 1,540 17,190 6,270 Operation cash flow = EBIT -tax + Depr EBIT tax Depr Operation cash flow ?? ?? ?? ?? net capital spending = change in net fixed asset + depr change in net fixed asset dper ?? ?? net capital spending (NCS) ?? change in net operating working capital (NOWC) NOWC = CA - (CL - bank loan) Change in NOWC 2020Q1 ?? ?? 2019Q1 ?? Cash flow from asset = OCF - NCS - Change in NOWC CFFA ?? 2008 Q4 250 20 18 5000 4500 200 80 220 4 216 75.6 140.4 2009 Q1 200 20 18 4000 3600 150 80 170 0 170 59.5 110.5 Q2 200 20 18 4000 3600 150 80 170 76 94 32.9 61.1 Q3 225 20 18 4500 4050 150 80 220 153 67 23.45 43.55 Q4 250 20 18 5000 4500 150 80 270 161 109 38.15 70.85 2020 Q1 275 20 18 5500 4950 150 80 320 178 142 49.7 92.3 Forecasting Additional Fund needed using percentage of sales method Current Net sales Total assets Accounts payable Accrued liabilities Net Income Retention ratio NS0 TA0 AP0 AL0 NI0 RR0 ? ? ? ? ? ? Next period Sales growth rate NS1 g NS0 * (1+g) ? Change NS1 - NS0 NS ? AFN Change in TA, or TA (TA0 / NS0) * NS (AP + AL) ((AP0 + AL0)/ NS0) * NS addition to retained earnings (NS1 * (NI0 / NS0) * RR0) (TA) - (AP+AL) - (addition to Retained earnings) 20% ? ? ? ? Pro-forma financial statements Income statement Sales (S) Cogs (80% of S) Gross Profit Depreciation Other expense (7% of S) EBIT Interest EBT Tax (40%) Net Income Sep-14 700 560 140 10 49 81 Oct-14 1000 800.0 200.0 10.0 70.0 120.0 0 81 32 49 12.0 108.0 43.2 64.8 dividend addition to retained earnings previous total borrowings Nov-14 1500 Dec-14 3000 Nov-14 Dec-14 0.0 64.8 1,200.0 Balance sheet Cash A/R Inventories Total C/A Fixed Asset Total Asset A/P N/P LT debt cumulative additional Fund needed Total liabilities Equity Total liabilities & Equity Sep-14 50 700 500 1250 750 2000 Oct-14 80.0 1,000.0 500.0 1,580.0 740.0 2,320.0 0 800 400 0.0 800.0 400.0 0 1200.00 800 2000 255.2 1,455.2 864.8 2,320.0 Cash Budget ($ in Thousands) Collection fom Recivables Purchases (cogs) Interest Payments Payment of Taxes Other Expense Net Monthly Cash Flow 700.0 800.0 12.0 43.2 70.0 -225.2 beginning cash cash balance required additional funds needed cumlative additional fund needed 50.0 80.0 255.2 0 255.2 Statement of Cash Flow ($ in Thousands) Net Income plus: Depreciation less: Increase In AR less: Increase In Inventory Cash flow from Operation Cash flow from investing Cash flow from Financing (excluding additional borrowing) Additional Funds Needed Total cash flow from financing 64.8 10.0 300.0 0.0 -225.2 0.0 0.0 255.2 255.2 Net Cash Flow 30.0 Beginning Cash Balance Ending Cash Balance 50.0 80.0