Answered step by step
Verified Expert Solution
Question
1 Approved Answer
By doing a proforma forecast I have identified the % but please help to advise how do I justify each percentage based on what factors?
By doing a proforma forecast I have identified the % but please help to advise how do I justify each percentage based on what factors? Please advise line by line factors that contribute to the % factors
For eg. Assuming -37.7% projected COGS (Revenue / COGS) due to xxxxxxx
Particulars | Notes | Actual | % | Forecast |
2021 | 2022 | |||
Revenue | 1 | 9,203,000 | 100% | 10,031,270 |
Cost of goods sold | 2 | (3,472,000) | -37.7% | 3,784,480 |
Gross profit | 5,731,000 | 62.3% | 6,246,790 | |
Spectrum license fees | 3 | (271,000) | -2.9% | (295,390) |
Network Cost | 4 | (479,000) | -5.2% | (522,110) |
Staff and resource costs | 5 | (735,000) | -8.0% | (801,150) |
Operation and Maintenance Cost | 6 | (401,000) | -4.4% | (437,090) |
Marketing Cost | 7 | (180,000) | -2.0% | (196,200) |
Impairment of receivables and deposit net | 8 | (17,000) | -0.2% | (18,530) |
Government Grant and other income | 9 | 271,000 | 2.9% | 295,390 |
Other Operating Expenses | 10 | (95,000) | -1.0% | (103,550) |
Depreciation and Amortisation | 11 | (1,649,000) | -17.9% | (1,797,410) |
Finance income | 12 | 60,000 | 0.7% | 65,400 |
Finance cost | 13 | (473,000) | -5.1% | (515,570) |
(3,969,000) | -43.1% | (4,326,210) | ||
Profit before taxation | 9,700,000 | 10,573,000 | ||
Taxation | 14 | (454,000) | -4.9% | (494,860) |
Profit for the financial year, representing total comprehensive income | 9,246,000 | 10,078,140 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started