| Item | Format | Input | |||||||||||||||||||||||||
| General Information | |||||||||||||||||||||||||||
| Investment Amount | INR | 1,50,00,000 | |||||||||||||||||||||||||
| EBITDA MULTIPLIER | Times | 4 | |||||||||||||||||||||||||
| Income Tax : | % | 26% | |||||||||||||||||||||||||
| REVENUE MODELS : | Year 1 | Year 2 | Year 3 | ||||||||||||||||||||||||
| Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total | |||||||||||||
| Visual Sense (Subscription) | |||||||||||||||||||||||||||
| Average Ticket Size | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | ||||||||||||||||
| Leads | 15,000 | 15,000 | 15,000 | 45,000 | 30,000 | 30,000 | 30,000 | 30,000 | 1,20,000 | 45,000 | 45,000 | 45,000 | 45,000 | 1,80,000 | |||||||||||||
| Customers | - | 2,250 | 2,250 | 2,250 | 5,100 | 4,500 | 4,500 | 4,500 | 6,750 | 6,750 | 6,750 | 6,750 | |||||||||||||||
| Existing Customer | - | - | - | 2,250 | 2,250 | 2,250 | 5,100 | 6,750 | 6,750 | 6,750 | |||||||||||||||||
| Revenue (New Customers) | 67,50,000 | 67,50,000 | 67,50,000 | 1,53,00,000 | 1,35,00,000 | 1,35,00,000 | 1,35,00,000 | 2,02,50,000 | 2,02,50,000 | 2,02,50,000 | 2,02,50,000 | ||||||||||||||||
| Revenue(Existing Customers) | - | - | - | - | 67,50,000 | 67,50,000 | 67,50,000 | 1,53,00,000 | 2,02,50,000 | 2,02,50,000 | 2,02,50,000 | ||||||||||||||||
| Revenue | - | 67,50,000 | 67,50,000 | 67,50,000 | 2,02,50,000 | 1,53,00,000 | 2,02,50,000 | 2,02,50,000 | 2,02,50,000 | 7,60,50,000 | 3,55,50,000 | 4,05,00,000 | 4,05,00,000 | 4,05,00,000 | 15,70,50,000 | ||||||||||||
| Album Sense | |||||||||||||||||||||||||||
| Subscriptions | 15,00,000 | 15,75,000 | 16,53,750 | 17,36,438 | 18,23,259 | 20,42,051 | 22,87,097 | 25,61,548 | 28,68,934 | 32,13,206 | 35,98,791 | 40,30,646 | |||||||||||||||
| Growth | 5% | 5% | 5% | 5% | 12% | 12% | 12% | 12% | 12% | 12% | 12% | 12% | |||||||||||||||
| Revenue | 15,00,000 | 15,75,000 | 16,53,750 | 17,36,438 | 64,65,188 | 18,23,259 | 20,42,051 | 22,87,097 | 25,61,548 | 87,13,955 | 28,68,934 | 32,13,206 | 35,98,791 | 40,30,646 | 1,37,11,576 | ||||||||||||
| OPERATING COSTS : | |||||||||||||||||||||||||||
| Year 1 | Year 2 | Year 3 | |||||||||||||||||||||||||
| Marketing and growth | ₹ 70,00,000 | ₹ 1,20,00,000 | ₹ 1,80,00,000 | ||||||||||||||||||||||||
| Advisory & Prof services | ₹ 2,40,000 | ₹ 2,64,000 | ₹ 2,90,400 | ||||||||||||||||||||||||
| Rent | ₹ 3,60,000 | ₹ 3,96,000 | ₹ 4,35,600 | ||||||||||||||||||||||||
| Tech support & services | ₹ 3,00,000 | ₹ 3,30,000 | ₹ 3,63,000 | ||||||||||||||||||||||||
| Insurance | ₹ 2,00,000 | ₹ 2,20,000 | ₹ 2,42,000 | ||||||||||||||||||||||||
| Utilities | ₹ 1,00,000 | ₹ 1,10,000 | ₹ 1,21,000 | ||||||||||||||||||||||||
| Salaries | ₹ 48,00,000 | ₹ 52,80,000 | ₹ 58,08,000 | - | |||||||||||||||||||||||
| CAPITAL EXPENDITURE : | |||||||||||||||||||||||||||
| Inventory | INR | 20,00,000 | |||||||||||||||||||||||||