Scribd
Upload
93 views6 pages

Projection Sheet: INCOME PROJECTION-High Visibility Areas

This document contains income projections for two scenarios: high visibility areas and low visibility areas. For the high visibility scenario, projected monthly sales are ₹650,000 with a profit before tax of ₹124,438 (19%). The payback period is estimated at 12 months. For the low visibility scenario, projected monthly sales are ₹500,000 with a profit before tax of ₹107,688 (22%) and a payback period of 14 months. The total investment required is approximately ₹1,488,000 with an expected ROI of 100% for high visibility areas and 87% for low visibility areas.

Uploaded by

shriyansh agrawal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
93 views6 pages

Projection Sheet: INCOME PROJECTION-High Visibility Areas

This document contains income projections for two scenarios: high visibility areas and low visibility areas. For the high visibility scenario, projected monthly sales are ₹650,000 with a profit before tax of ₹124,438 (19%). The payback period is estimated at 12 months. For the low visibility scenario, projected monthly sales are ₹500,000 with a profit before tax of ₹107,688 (22%) and a payback period of 14 months. The total investment required is approximately ₹1,488,000 with an expected ROI of 100% for high visibility areas and 87% for low visibility areas.

Uploaded by

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

Projection Sheet

INCOME PROJECTION-High Visibility Areas


% Assumptions
MONTHLY SALES 100% ₹ 650,000 ₹ 650,000
Less:
Cost of Goods (27%) 27% ₹ 175,500
GST (5%) 5% ₹ 32,500
Royalty (8.5%+18% GST) 10% ₹ 61,935
GROSS PROFIT ₹ 380,065
Less: OPERATING EXPENSE
Rent Approx(Inc. GST) 12% ₹ 80,000
Salary (5 personnel) 10% ₹ 65,000
Electricity 3% ₹ 20,000
Water 0% ₹ 2,500
Transport 2% ₹ 13,000
Online Commisions(18%+GST) 9.6% ₹ 62,127
Misc expenditures (Marketing) 2% ₹ 13,000
PROFIT Before TAX 81% ₹ 124,438 19%

Payback Period (Months) 12


INCOME PROJECTION-Low Visibility Areas
% Assumptions
MONTHLY SALES 100% ₹ 500,000 ₹ 500,000
Less:
Cost of Goods (27%) 27% ₹ 135,000
GST (5%) 5% ₹ 25,000
Royalty (8.5%+18% GST) 10% ₹ 47,643
GROSS PROFIT ₹ 292,358
Less: OPERATING EXPENSE
Rent Approx(Inc. GST) 10% ₹ 50,000
Salary (5 personnel) 12% ₹ 60,000
Electricity 3% ₹ 15,000
Water 1% ₹ 2,500
Transport 2% ₹ 10,000
Online Commisions(18%+GST) 7.4% ₹ 37,170
Misc expenditures (Marketing) 2% ₹ 10,000
PROFIT Before TAX 79% ₹ 107,688 22%

Payback Period (Months) 14


APPROX RETURN ON INVESTMENT -High Visibility Areas
Total Investment (approx.) ₹ 1,488,000
Annual Net Profit ₹ 1,493,253
ROI 100%
Estimated Payback Period (Months) 11.96

Royalty

Our Royalty is 8.5% on NET Sales (Excluding Taxes).


APPROX RETURN ON INVESTMENT -Low Visibility Areas
Total Investment (approx.) ₹ 1,488,000
Annual Net Profit ₹ 1,292,250
ROI 87%
Estimated Payback Period (Months) 13.82

Royalty

Our Royalty is 8.5% on NET Sales (Excluding Taxes).


Approx Investment
ITEM RATE
Franchisee fees 413,000
Project Cost ( Interiors, Flooring & ceiling). 500,000
Signage(ACP,Logo,Counter Vinyl,Frames,Decals) 100,000
Equipments for Kitchen 250,000
Fridge, Freezer, A/C, Computer etc 100,000
LED Panels (43''- 2 Piece) 60,000
Manager's Travelling for store Launch (3 days) -
Travel & Accomodation for Staff Training(Approx) 65,000
INITIAL INVESTMENT 1,488,000
REFUNDABLE SECURITY DEPOSIT 150,000
TOTAL FUNDING 1,638,000
rox Investment
DESCRIPTION
Rs 3,50,000/- + 18% GST
Approx rate for 200 sqft
Approx rate for 200 sqft
Will be provided by the franchisor
To be purchased locally by the franchisee owners
Will be provided by the Franchisor
On Actuals ( Approx cost Rs. 35,000/-) Borne by the Franchisee
15 Days training in Mumbai (Approx Estimate) for 5 people

For the Tenure Period

You might also like