ANSWER SHEET FOR QUESTION NO 5 (a) KEYIN YOUR ANSWERS IN BOXES WITH YELLOW BACKGROUND
a) Spreadsheets Q4a_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 "AnsPntcolumn. The relevant cells are editable for your answers. (15 marks) ANSWER SHEET FOR QUESTION NO 5 L KEYIN YOUR ANSWERS IN BOXES WITH YELLOW BACKGROUND STUDENT ID Monthly Figure M2 MZ Variables MO M3 erret 2 1.0 10 2.0 BUSINESS PLANNING SMIRLATE Financial Forecast FINANCIAL FORECAST. PART1 Assumption A.ARACI & LOSS Description/Variables 1. Customers Total GroetbBate/Month New 11 Revenue RM /Month 12 Total One Off Reg Fee RM/New Customer 2. Totale 3. Customer Acquisition Cost RM/New Customer 4.Net Revenue 5. Capex 10 3.0 10 4.0 5.0 15 6.0 7.0 400 400.0 100 100.0 8.0 5.1 Fixed and Mobile Asset perating License 5.3 Total Cape 6. Depreciation or Appreciation 6.1 Fixed and Mobile Asset Der Operating License Appr Net Op Appr 7. Cast Rate / Year D.2 9.0 Rate / Year DZ 10.0 110 7.1 Direct Cost of Net Revenue 0.2 120 of Net Revenue 0.3 13.0 14.0 72 Operating cost 73 Loan Interest 7.4 Net DAPC Appr 75 Total Cost 15.0 16.0 5 PET 17.0 FINANCIAL FORECAST MO MI M2 M3 18.0 19.0 B.CASHFLOW 9.TOTAL INFLOW 10.OUTFLOW 10.1. Total Capes 10.2. Total Cast - Net Our Apprl) 10.3. Loan Repayment 11. TOTAL OUTFLOW 12. DEFICIT/SURPLUS 20.0 210 220 23.0 13. PAID UP CAPITAL 100 100.0 400 400.0 14.LOAN 15.TOTAL FUND 24.0 25.0 16 SURPLUS/DEFICIT 17.CURRENT ACCOUNT 26.0 FINANCIAL FORECAST PART 2 18. LOAN SCHEDULE 18.1 Interest Calculation MO M MZ M3 Variables 0.12 18.1.1 Interest Rate Per Annum 18.1.2 Drawdown 27.0 MO 28.0 MI M2 M3 18.2 Total interest 29.0 MO MI MZ M3 19. LOAN REPAYMENT 19.1. Payback Period Months 60 19.2. Drawdown 30.0 MO 310 MI M2 M3 320 19.2. Total Repayment 19. 4.LOAN CURRENT BALANCE 33.0 a) Spreadsheets Q4a_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 "AnsPntcolumn. The relevant cells are editable for your answers. (15 marks) ANSWER SHEET FOR QUESTION NO 5 L KEYIN YOUR ANSWERS IN BOXES WITH YELLOW BACKGROUND STUDENT ID Monthly Figure M2 MZ Variables MO M3 erret 2 1.0 10 2.0 BUSINESS PLANNING SMIRLATE Financial Forecast FINANCIAL FORECAST. PART1 Assumption A.ARACI & LOSS Description/Variables 1. Customers Total GroetbBate/Month New 11 Revenue RM /Month 12 Total One Off Reg Fee RM/New Customer 2. Totale 3. Customer Acquisition Cost RM/New Customer 4.Net Revenue 5. Capex 10 3.0 10 4.0 5.0 15 6.0 7.0 400 400.0 100 100.0 8.0 5.1 Fixed and Mobile Asset perating License 5.3 Total Cape 6. Depreciation or Appreciation 6.1 Fixed and Mobile Asset Der Operating License Appr Net Op Appr 7. Cast Rate / Year D.2 9.0 Rate / Year DZ 10.0 110 7.1 Direct Cost of Net Revenue 0.2 120 of Net Revenue 0.3 13.0 14.0 72 Operating cost 73 Loan Interest 7.4 Net DAPC Appr 75 Total Cost 15.0 16.0 5 PET 17.0 FINANCIAL FORECAST MO MI M2 M3 18.0 19.0 B.CASHFLOW 9.TOTAL INFLOW 10.OUTFLOW 10.1. Total Capes 10.2. Total Cast - Net Our Apprl) 10.3. Loan Repayment 11. TOTAL OUTFLOW 12. DEFICIT/SURPLUS 20.0 210 220 23.0 13. PAID UP CAPITAL 100 100.0 400 400.0 14.LOAN 15.TOTAL FUND 24.0 25.0 16 SURPLUS/DEFICIT 17.CURRENT ACCOUNT 26.0 FINANCIAL FORECAST PART 2 18. LOAN SCHEDULE 18.1 Interest Calculation MO M MZ M3 Variables 0.12 18.1.1 Interest Rate Per Annum 18.1.2 Drawdown 27.0 MO 28.0 MI M2 M3 18.2 Total interest 29.0 MO MI MZ M3 19. LOAN REPAYMENT 19.1. Payback Period Months 60 19.2. Drawdown 30.0 MO 310 MI M2 M3 320 19.2. Total Repayment 19. 4.LOAN CURRENT BALANCE 33.0
