QUESTION 5 (30 Marks) (a) TableQ5(a) shows and empty financial forecast template. Create a complete 4 year (YO, Y1, Y2, Y3) financial forecast for your entrepreneurship venture. Complete the forecast template in editable cells marked with light blue background ONLY. Do not write anything anywhere else. (20 Marks) (b) Compile and compose 4 year bar charts and brief report for the following items i) Total and New Customers. ii) Sales Price, Total Revenue and Net Revenue. iii) PBT. iv) Cash balance in current account. v) Total Out Flow and report on spending trend. (10 Marks) Table Q5(a) Answers : Fill in values in light blue CELLS ONLY KEYIN ANSWERS BLUE CELLS ONLY BUSINESS PLANNING TEMPLATE : Financial Forecast FINANCIAL FORECAST : PART1 A.PROFIT & LOSS Assumption Marks Yearly Figure Y2 ATTAIN Variable YO Y1 Y3 1.Customers Total Growth Rate/year 3 1,000 1 New 1,000 1,000 1 100 1 RM /year RM/New Customer 100 1 1 RM/New Customer 20 1 1 200,000 200,000 50,000 50,000 1 0.2 1.1 Revenue 1.2 Total One Off Reg Fee 2. Total Revenue 3. Customer Acquisition Cost 4.Net Revenue 5. Capex 5.1 Fixed and Mobile Asset 5.2 Operating License 5.3 Total Capex 6. Depreciation or Appreciation 6.1 Fixed and Mobile Asset @ Depr 6.2 Operating License Appr 6.3 Net Depr - Appr) 7. Cost 7.1 Direct Cost 7.2 Operating cost 7.3 Loan Interest 7.4 Net Depr-Appr 7.5 Total Cost 8.PBT FINANCIAL FORECAST B.CASHFLOW 9.TOTAL INFLOW 1 % Rate / Year * Rate / Year 0.3 1 1 % of Net Revenue 0.15 1 % of Net Revenue 0.15 1 1 1 1 1 1 10.OUTFLOW 1 10.1. Total Capex 10.2. Total Cost - (Net (Depr. Appr)) 10.3. Loan Repayment 1 1 11. TOTAL OUTFLOW 1 12.DEFICIT/SURPLUS 1 13. PAID UP CAPITAL 100,000 14.LOAN 1 1 15. TOTAL FUND 16.CURRENT SURPLUS/DEFICIT 17.CURRENTACCOUNT 1 1 FINANCIAL FORECAST PART2 18. LOAN SCHEDULE 18.1 Interest Calculation Variables YO Y1 Y2 Y3 18.1.1 Interest Rate Per Annum 0.12 18.1.2 Drawdown 1 YO 1 Y1 Y2 Y3 Total Interest 19. LOAN REPAYMENT YO Y1 Y2 Y3 19.1. Payback Period Years 19.2. Drawdown 1 YO 1 Y1 Y2 Y3 19.3. Total Repayment 19.4.LOAN CURRENT BALANCE TOTAL MARKS 1 34 20/20 QUESTION 5 (30 Marks) (a) TableQ5(a) shows and empty financial forecast template. Create a complete 4 year (YO, Y1, Y2, Y3) financial forecast for your entrepreneurship venture. Complete the forecast template in editable cells marked with light blue background ONLY. Do not write anything anywhere else. (20 Marks) (b) Compile and compose 4 year bar charts and brief report for the following items i) Total and New Customers. ii) Sales Price, Total Revenue and Net Revenue. iii) PBT. iv) Cash balance in current account. v) Total Out Flow and report on spending trend. (10 Marks) Table Q5(a) Answers : Fill in values in light blue CELLS ONLY KEYIN ANSWERS BLUE CELLS ONLY BUSINESS PLANNING TEMPLATE : Financial Forecast FINANCIAL FORECAST : PART1 A.PROFIT & LOSS Assumption Marks Yearly Figure Y2 ATTAIN Variable YO Y1 Y3 1.Customers Total Growth Rate/year 3 1,000 1 New 1,000 1,000 1 100 1 RM /year RM/New Customer 100 1 1 RM/New Customer 20 1 1 200,000 200,000 50,000 50,000 1 0.2 1.1 Revenue 1.2 Total One Off Reg Fee 2. Total Revenue 3. Customer Acquisition Cost 4.Net Revenue 5. Capex 5.1 Fixed and Mobile Asset 5.2 Operating License 5.3 Total Capex 6. Depreciation or Appreciation 6.1 Fixed and Mobile Asset @ Depr 6.2 Operating License Appr 6.3 Net Depr - Appr) 7. Cost 7.1 Direct Cost 7.2 Operating cost 7.3 Loan Interest 7.4 Net Depr-Appr 7.5 Total Cost 8.PBT FINANCIAL FORECAST B.CASHFLOW 9.TOTAL INFLOW 1 % Rate / Year * Rate / Year 0.3 1 1 % of Net Revenue 0.15 1 % of Net Revenue 0.15 1 1 1 1 1 1 10.OUTFLOW 1 10.1. Total Capex 10.2. Total Cost - (Net (Depr. Appr)) 10.3. Loan Repayment 1 1 11. TOTAL OUTFLOW 1 12.DEFICIT/SURPLUS 1 13. PAID UP CAPITAL 100,000 14.LOAN 1 1 15. TOTAL FUND 16.CURRENT SURPLUS/DEFICIT 17.CURRENTACCOUNT 1 1 FINANCIAL FORECAST PART2 18. LOAN SCHEDULE 18.1 Interest Calculation Variables YO Y1 Y2 Y3 18.1.1 Interest Rate Per Annum 0.12 18.1.2 Drawdown 1 YO 1 Y1 Y2 Y3 Total Interest 19. LOAN REPAYMENT YO Y1 Y2 Y3 19.1. Payback Period Years 19.2. Drawdown 1 YO 1 Y1 Y2 Y3 19.3. Total Repayment 19.4.LOAN CURRENT BALANCE TOTAL MARKS 1 34 20/20