Scribd
Upload
9 views2 pages

Financial Modelling Project

The document presents the financial projections for SABJIWALA from 2023 to 2029, including revenue, COGS, gross profit, and net income. It outlines key assumptions such as revenue growth rates and expense percentages, along with a common size statement for comparative analysis. Additionally, a change analysis statement is provided to illustrate the impact of a 10% revenue increase on financial outcomes.

Uploaded by

Utkarsh Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views2 pages

Financial Modelling Project

The document presents the financial projections for SABJIWALA from 2023 to 2029, including revenue, COGS, gross profit, and net income. It outlines key assumptions such as revenue growth rates and expense percentages, along with a common size statement for comparative analysis. Additionally, a change analysis statement is provided to illustrate the impact of a 10% revenue increase on financial outcomes.

Uploaded by

Utkarsh Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SABJIWALA

INR 2023A 2024A 2025E 2026E 2027E

Income Statement - SABJIWALA


Revenue 2,00,000.0 25,00,000.0 27,50,000.0 30,25,000.0 33,27,500.0
COGS 8,000.0 9,000.0 11,00,000.0 12,10,000.0 13,31,000.0
Gross Profit 1,92,000.0 24,91,000.0 16,50,000.0 18,15,000.0 19,96,500.0
Selling & General Expenses 2,000.0 2,250.0 2,500.0 2,500.0 2,500.0
EBITDA 1,90,000.0 24,88,750.0 16,47,500.0 18,12,500.0 19,94,000.0
Depreciation 800.0 900.0 1,37,500.0 1,51,250.0 1,66,375.0
Interest 200.0 225.0 259.0 259.0 259.0
EBT 1,89,000.0 24,87,625.0 15,09,741.0 16,60,991.0 18,27,366.0
Taxes 2,700.0 3,037.5 4,52,922.3 4,98,297.3 5,48,209.8
Net Income 1,86,300.0 24,84,587.5 10,56,818.7 11,62,693.7 12,79,156.2

Assumption Drivers - SABJIWALA


Revenue Growth NA 1150.00% 10.00% 10.00% 10.00%
COGS % of Revenue 4.00% 0.36% 40.00% 40.00% 40.00%
S&G Expenses 2,000.0 2,250.0 2500.0 2500.0 2500.0
Depreciation % Sales 0.40% 0.04% 5.00% 5.00% 5.00%
Interest 200.0 225.0 259.0 259.0 259.0
Taxes 30.00% 30.00% 30.00% 30.00% 30.00%

Common Size Statement - SABJIWALA


Revenue 100.00% 100.00% 100.00% 100.00% 100.00%
COGS 4.00% 0.36% 40.00% 40.00% 40.00%
Gross Profit 96.00% 99.64% 60.00% 60.00% 60.00%
Selling & General Expenses 1.00% 0.09% 0.09% 0.08% 0.08%
EBITDA 95.00% 99.55% 59.91% 59.92% 59.92%
Depreciation 0.40% 0.04% 5.00% 5.00% 5.00%
Interest 0.10% 0.01% 0.01% 0.01% 0.01%
EBT 94.50% 99.51% 54.90% 54.91% 54.92%
Taxes 1.35% 0.12% 16.47% 16.47% 16.48%
Net Income 93.15% 99.38% 38.43% 38.44% 38.44%

Change Analysis Statement -SABJIWALA


10%
Revenue 2,20,000.0 27,50,000.0 30,25,000.0 33,27,500.0 36,60,250.0
COGS 8,800.0 9,900.0 12,10,000.0 13,31,000.0 14,64,100.0
Gross Profit 2,11,200.0 27,40,100.0 18,15,000.0 19,96,500.0 21,96,150.0
Selling & General Expenses 2,200.0 2,475.0 2,750.0 2,750.0 2,750.0
EBITDA 2,09,000.0 27,37,625.0 18,12,250.0 19,93,750.0 21,93,400.0
Depreciation 880.0 990.0 1,51,250.0 1,66,375.0 1,83,012.5
Interest 220.0 247.5 284.9 284.9 284.9
EBT 2,07,900.0 27,36,387.5 16,60,715.1 18,27,090.1 20,10,102.6
Taxes 2,970.0 3,341.3 4,98,214.5 5,48,127.0 6,03,030.8
Net Income 2,04,930.0 27,33,046.3 11,62,500.6 12,78,963.1 14,07,071.8
2028E 2029E

36,60,250.0 40,26,275.0
14,64,100.0 16,10,510.0
21,96,150.0 24,15,765.0
2,500.0 2,500.0
21,93,650.0 24,13,265.0
1,83,012.5 2,01,313.8
259.0 259.0
20,10,378.5 22,11,692.3
6,03,113.6 6,63,507.7
14,07,265.0 15,48,184.6

10.00% 10.00%
40.00% 40.00%
2500.0 2500.0
5.00% 5.00%
259.0 259.0
30.00% 30.00%

100.00% 100.00%
40.00% 40.00%
60.00% 60.00%
0.07% 0.06%
59.93% 59.94%
5.00% 5.00%
0.01% 0.01%
54.92% 54.93%
16.48% 16.48%
38.45% 38.45%

40,26,275.0 44,28,902.5
16,10,510.0 17,71,561.0
24,15,765.0 26,57,341.5
2,750.0 2,750.0
24,13,015.0 26,54,591.5
2,01,313.8 2,21,445.1
284.9 284.9
22,11,416.4 24,32,861.5
6,63,424.9 7,29,858.4
15,47,991.4 17,03,003.0

You might also like