its all together, please do answer it

QUESTION 4 (25 marks) a) Spreadsheets Q4(a) is an incomplete brief monthly financial forecast with customer acquisition cost is set to be RM15 per new customer. Create a complete financial forecast by filling up the items (IN YELLOW Cells ONLY) on each rows marked ONE to THIRTY THREE (1.0 - 33.0) under "AnsPnt column. The relevant cells are editable for your answers. (15 marks) NOTE If you attempt Question 4(a) do not forget to write your Student ID in the box provided b) Compose an executive financial summary which covers 1. Total customers and New customer registration, 2. Tariff Structures. Total Revenue and Net Revenue, 3. Customer Acquisition Cost and Net Revenue. 4 Total Cost 5. Profit and Loss Before Tax. 6. Cash In Flow and Out Flow. 7. 4 Months Spending Pattern. 8. Funding Requirement and 9. Current Account ( 10 marks ) QUESTION 4 ANSWER SECTIONS AITOR OURO NOS REY FOUR ANSWAARD WITH ALLOW MACKOND TLINENT BUSINESS PLANNING TOWALATE Fence FINANO A FOST PARTI Ammation Monthly Figure ADET War MO MT M A 1 Ohm Tata Month Now Month 1 Toon on HAN Entomer 2. To 1 Lom Acquision IN Dutomer Nat va bed and Mabat S? Optin e Total Depreciation of Appreciation Grand Mall De LENA RY ta 6 Nazor - Papri Dhe satta na AND pat FOREST DESHOW TE maratil Dear RASPORT TOLED FINANOIL FORECAST PAR 11 LOAN SOTEDULE 1.1 Intertitution MO MI MZ MO El pata Pwum PRED MI NE 230 19. LOREMENT MO MI IM MO 19.1. Pwyback Period Month 19.2Dawn HL MO MI VE 19 Total Repayment HALLOAN CURENT TALANT QUESTION 4 (25 marks) a) Spreadsheets Q4(a) is an incomplete brief monthly financial forecast with customer acquisition cost is set to be RM15 per new customer. Create a complete financial forecast by filling up the items (IN YELLOW Cells ONLY) on each rows marked ONE to THIRTY THREE (1.0 - 33.0) under "AnsPnt column. The relevant cells are editable for your answers. (15 marks) NOTE If you attempt Question 4(a) do not forget to write your Student ID in the box provided b) Compose an executive financial summary which covers 1. Total customers and New customer registration, 2. Tariff Structures. Total Revenue and Net Revenue, 3. Customer Acquisition Cost and Net Revenue. 4 Total Cost 5. Profit and Loss Before Tax. 6. Cash In Flow and Out Flow. 7. 4 Months Spending Pattern. 8. Funding Requirement and 9. Current Account ( 10 marks ) QUESTION 4 ANSWER SECTIONS AITOR OURO NOS REY FOUR ANSWAARD WITH ALLOW MACKOND TLINENT BUSINESS PLANNING TOWALATE Fence FINANO A FOST PARTI Ammation Monthly Figure ADET War MO MT M A 1 Ohm Tata Month Now Month 1 Toon on HAN Entomer 2. To 1 Lom Acquision IN Dutomer Nat va bed and Mabat S? Optin e Total Depreciation of Appreciation Grand Mall De LENA RY ta 6 Nazor - Papri Dhe satta na AND pat FOREST DESHOW TE maratil Dear RASPORT TOLED FINANOIL FORECAST PAR 11 LOAN SOTEDULE 1.1 Intertitution MO MI MZ MO El pata Pwum PRED MI NE 230 19. LOREMENT MO MI IM MO 19.1. Pwyback Period Month 19.2Dawn HL MO MI VE 19 Total Repayment HALLOAN CURENT TALANT