Export
Export
CMA Data
Shivam Internet
Executive Summary
Business Details
BUY NOW
Project Details
BUY NOW
Business Scenario
Shivam Internet is planning to setup a project of Cyber Cafe. The Business firm and its owners have
the *********************************and make it run as a ************************** in
years to come.
BUY NOW
Shivam Internet will make a healthy profit for its owners and financers, as well
as************************. The Business intends to achieve the Sales and Profit Growth (in the
projected financials) by (a) ******************************** (b) financing
******************************.
Project Prospects
Shivam Internet is planning to setup a project of Cyber Cafe. The Business firm and its owners have
the relevant*********************and make it run as*********************** years to come.
By focusing on its ****************, as well as Management Team's Core Values, Shivam Internet
will increase its sales to Rs. ************ in 7 years time, while also improving the
*********************************************.
Shivam Internet have thoroughly evaluated the prospects of setting up Cyber Cafe business and the
prospects look very promising. The Business firm has studied
the******************************* they expect to reach profitability
***********************. Based on market study, the firm expects to achieve
*********************************************. Shivam Internet wants to become the
********************
Target Market
Sr No. Target Customer Expected Share
in Sales
1 Our initial plan is to target the customer base in our 75.00%
locality. The local customer base is large and we will
also get direct feedback from our customers
BUY NOW
Our Business
10
-
FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
INCOME
Revenue Income / Gross
Sales **** **** 5,55,543.9
EXPENSES
Purchases (Stock,
Inventory, Raw Material,
etc) **** 1,15,195.5 1,69,491.9
Changes in Inventory
(Refer Annexure 2) **** **** (6,218.5)
Salary & Wages 35,000.0 **** Get Complete Report for 999 only 80,708.7
Electricity, Fuel & Water **** 14,364.0 19,969.2
Advertising & Marketing 6,600.0 13,765.5 ****
Other Expenses 6,180.0 **** 17,140.2
BUY NOW
Depreciation &
Amortisation 54,000.0 67,400.0 **** 40,921.5 *** *** 23,966.3 ***
Interest Expense 76,330.3 87,855.8 68,229.7 46,386.6 22,076.2 2,171.2 0.0 0.0
Profit Before Tax **** **** 8,836.6 **** 96,233.3 **** **** ****
PROFIT AFTER TAX **** **** 8,836.6 **** **** 1,28,871.8 **** ****
CMA DATA
Projected Balance Sheet
Rs in Actual
Remaining
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
SOURCES OF FUNDS
A. Own Funds
Total Sources of Funds **** **** 9,27,735.7 11,11,300.1 **** **** **** ****
Rs in Actual
Remaining
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
APPLICATION OF FUNDS
B. Current Assets
Cash & Bank Balance **** **** BUY NOW 4,48,946.3
Trade Receivables **** 47,904.9 ****
Raw Material Stock - **** ****
WIP Stock - **** ****
Finished Goods / Stock In
Trade **** **** 61,342.6
Total Application of
Funds **** **** 9,27,735.7 11,11,300.1 **** **** **** ****
CMA DATA
Cash Flow Statement
Remaining Rs in Actual
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
Remaining
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
Long-term Solvency Ratios
Debt Equity Ratio *** **** **** 0.40 **** **** **** ****
Debt Ratio **** 0.75 0.00
TOL/TNW **** *** ****
Interest Coverage
Debt Service Coverage
0.56 ****
Get Complete Report for 999 only ****
Profitability Ratios
Gross Profit Margin 62.0% **** *****
EBIDTA Margin **** 28.6% ****
Net Profit Margin **** **** BUY NOW 27.7%
Return on Assets (other
than cash) **** -4.8% ****
Remaining Rs in Actual
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
Total Current Assets (A) **** *** 6,39,582.8
Total Current Liabilities
(other than Bank
Borrowing) (B) 13,789.4 ***
Get Complete Report for 999 only ***
PAT + Depreciation +
Interest *** *** 1,28,656.2 *** *** 1,59,096.1 *** ****
Interest payment 76,330.3 87,855.8 68,229.7 46,386.6 22,076.2 2,171.2 0.0 0.0
Principal Repayment of
Term Loan 80,144.4 1,73,747.1 *** *** *** *** *** ***
Principal Repayment of
Working Capital Limit *** *** *** *** *** *** *** ***
Total Repayment during
the year *** *** *** *** 2,61,602.9 *** *** ***
BUY NOW
Term Loan Repayment Schedule
Term Loan Amount ₹ 9,40,500
Loan O/s after Moratorium Period ****
Monthly EMI Amount ₹ 21,715
Year Interest Charged Total Payment to Principal Repaid Closing Loan O/s
Bank
FY 25-26 75,649 **** 80,144 ****
FY 26-27 86,835 **** 1,73,747 ****
FY 27-28 67,208 2,60,582 **** 5,18,738
FY 28-29 45,365 **** **** *****
FY 29-30 21,055 **** **** ****
FY 30-31 1,150 **** 63,995 ****
FY 31-32 0 **** ***** *****
FY 32-33 0 - **** 0
**** **** ****
BUY NOW
Break Even Sales
The term “break-even sales” refers to the sales value at which *************************. In
other words, the break-even sales are the amount of revenue
************************************************
Remaining Rs in Actual
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
Remaining
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
STRENGTHS WEAKNESSSES
1. ************
2. Talented********* with strong
********** 1. Lack of Availability of ********
3. Quick to************* 2. Yet to create ***********
4. ********* resulting 3. Staff ****** & ******* is to be achieved
in*************making
OPPORTUNITIES THREATS
To Overcome Weakness
To Overcome Threats
Rs in Actual
Remaining
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
Scenario 2
Increase in Variable Cost 7%
Rs in Actual
Remaining
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32 FY 32-33
Scenario 3
Increase in Fixed Cost (other than
Depreciation) 7%
Remaining
Current Year Projection Years --->
Particulars FY 25-26 FY 26-27 FY 32-33
Operational Capacity
It is assumed that post*******************, the business would reach************************ in the following manner.
Estimated Sales
Over the years the Daily sales are estimated at an trend as shown below. The trend in sales is mainly after
considering ***************************************, we will be able to command premium due to Business Goodwill
Estimated Expenses
Based on the working experience and market study, the Promoters have assumed that at 100% operational
capacity, following expenses would be incurred
Total ₹ 23,200
BUY NOW
Assumptions Used
Adjustment for Inflation
In Sales & Expenses, both, nominal adjustment for price increase due to inflation is made
Business Team
The Company plans to hire 0 employees. Later as the business expands the entity will increase its employee
strength for which increase in salary expenenses is considered in financial projections.
Conclusion
Shivam Internet setting and expanding business in Sultanpur will allow the firm to offer
*************************************. As per the financial projections, it is expected that the Business will
c*******************************************
Shivam Internet, to conclude wants to run the business of Cyber Cafe as a ***************************. The
Business Entity has already made lot of efforts in *****************************, as well as making the financial
projections. The entity will make ****************************************. Thus with your financial help, we can
postively************************************as well as create more *****************************
END OF REPORT
Contact Person Shivam Rao
Contact Number 8081388296
Annexure 1
Monthly EMI Schedule
Month Opening O/s Interest Paid EMI Principal Paid Balance O/s
Jul-25 9,40,500 8,425 - - 9,48,925
Aug-25 9,48,925
Sep-25 9,57,426
Oct-25 9,66,003
Nov-25 9,52,942
Dec-25 *****
Jan-26 9,26,467
Feb-26 9,13,051
Mar-26 8,99,516
Apr-26 8,85,859
May-26 8,72,079
Jun-26 8,58,177
Jul-26 8,44,149
Aug-26 *****
Sep-26 8,15,717
Oct-26 8,01,309
Nov-26 7,86,772 BUY NOW
Dec-26 7,72,105
Jan-27 7,57,307
Feb-27 *****
Mar-27 7,27,311
Apr-27 7,12,112
May-27 6,96,776
Jun-27 6,81,303
Jul-27 *****
Aug-27 6,49,939
Sep-27 6,34,046
Oct-27 6,18,011
Nov-27 6,01,832
Dec-27 5,85,509
Jan-28 5,69,039 5,098 21,715 16,617 5,52,421
Feb-28 5,52,421 4,949 21,715 16,766 5,35,655
Mar-28 5,35,655 4,799 21,715 **** ****
Apr-28 5,18,738 4,647 21,715 17,068 5,01,670
May-28 ***** 4,494 21,715 17,221 4,84,449
Jun-28 4,84,449 4,340 21,715 17,375 4,67,074
Jul-28 4,67,074
Aug-28 4,49,543
Sep-28 4,31,855
Oct-28 4,14,009
Nov-28 3,96,002
Dec-28 *****
Jan-29 3,59,504
Feb-29 3,41,010
Mar-29 3,22,350
Apr-29 3,03,522
May-29 2,84,526
Jun-29 2,65,360
Jul-29 *****
Aug-29 2,26,511
Sep-29 2,06,825
Oct-29 1,86,962
Nov-29 1,66,922
Dec-29 1,46,702
Jan-30 1,26,301
Feb-30 1,05,718
Mar-30 *****
Apr-30 63,995
May-30 42,854
Jun-30 21,522
Jul-30 0
Aug-30 0 0 - (0) 0
Sep-30 0 0 - **** ****
Oct-30 0 0 - (0) 0
Nov-30 0 0 - (0) 0
Dec-30 0 0 - **** 0
Jan-31 ***** 0 - (0) ****
Feb-31 0 0 - (0) 0
Mar-31 0 0 - (0) 0
Apr-31 0 0 **** (0) ****
May-31 0 0 - (0) 0
Annexure 1
Monthly EMI Schedule
Month Opening O/s Interest Paid EMI Principal Paid Balance O/s
Jun-31 0 0 - (0) 0
Jul-31 0 0 - (0) 0
Aug-31 0 0 - (0) 0
Sep-31 0 0 - (0) 0
Oct-31 0 0 - (0) 0
Nov-31
Dec-31
Jan-32 Get Complete Report for 999 only
Feb-32
Mar-32
Apr-32 BUY NOW
May-32
Jun-32
Annexure 2
Changes in Inventory Working
Remaining Rs in Actual
Current Year Projection Years --->
Particulars FY 24-25 FY 25-26 FY 26-27 FY 27-28 FY 28-29 FY 29-30 FY 30-31 FY 31-32
Opening Inventory
Raw Material *** - ***
Work in Process *** - Get Complete Report for 999 only -
Finished Goods - **** 55,124.1
Total Opening Inventory (A)
**** **** ****
Closing Inventory
BUY NOW
Raw Material - **** ****
Work in Process - *** ****
Finished Goods *** *** 61,342.6
Total Closing Inventory (B)*** 25,251.7 61,342.6
Your Average DSCR Ratio should not be very low (<1.5) nor very high (>5). If your DSCR value is not in this
range, then please click below link to know how to improve your DSCR
https://fortriskconsulting.com/dscr/
Your Working Capital Loan Limit should not be more than permissible limit (MPBF), If yes, then kindly reduce
the loan limit to met the requirement. Refer MPBF calculation sheet to check the permissible limit
Also, your working capital loan value should not be in excess than required. Check the cash balance in the
Balance Sheet, it should not be more than 50% of the working capital loan. This would mean that your
working capital loan amount is lying idle in cash and not used for business. Try to keep the working capital
loan not more than twice the monthly expenses amount
Try to maintain your GP Ratio or EBITDA margin within acceptable limits of your industry average. You can
change the ratio by changing the Sales Values - Edit Sales using Sales and Operational Capacity
Finally, every Bank has its own criteria to approve loan. You can always change and download a revised
report multiple times on our website for 21 days after payment
You can refer our complete step by step guide on specific Loan Schemes & Project Reports: