Nothing Special   »   [go: up one dir, main page]

Kushagra Jaiswal

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

AMEYA STONE CRUSHER

KUSHAGRA JAISWAL

I. INVESTMENT REQUIRED

PARTICULARS AMOUNT (RS LAKH)


1. DESIGN AND MANUFACTURING PLANT
2. VIBRATOR SCREEN
3. ELECTRIC MOTORS 55.46
4. JAW CRUSHER

TOTAL INVESTMENT REQUIRED 55.46

II. SOURCES

PARTICULARS AMOUNT (RS LAKH)


1. LOAN FUND 42.00
2. OWN FUND 13.46

TOTAL INVESTMENT REQUIRED 55.46


AMEYA STONE CRUSHER
KUSHAGRA JAISWAL

III. REPAYMENT SCHEDULE

1. 12 % NEW LOAN FOR PURCHASE OF PROPERTY

REPAYMENT
YEAR LOAN O/S INTEREST 12% INTEREST PRINCIPAL O/S AMOUNT
2017-18 37.00 2.59 2.59 3.08 33.92
2018-19 33.92 4.07 4.07 5.29 28.63
2019-20 28.63 3.44 3.44 5.29 23.35
2020-21 23.35 2.80 2.80 5.29 18.06
2021-22 18.06 2.17 2.17 5.29 12.77
2022-23 12.77 1.53 1.53 5.29 7.49
2023-24 7.49 0.90 0.90 5.29 2.20
2024-25 2.20 0.26 0.26 2.20 0.00

2. LOAN FROM HDFC

REPAYMENT
YEAR LOAN O/S INTEREST INTEREST PRINCIPAL O/S AMOUNT
2017-18 14.57 1.22 1.22 4.26 10.31
2018-19 10.31 0.79 0.79 4.69 5.62
2019-20 5.62 0.32 0.32 5.16 0.46
2020-21 0.46 0.00 0.00 0.46 0.00

3.LOAN FROM BOM

REPAYMENT
YEAR LOAN O/S INTEREST 12% INTEREST PRINCIPAL O/S AMOUNT
2017-18 5.29 0.63 0.63 1.76 3.53
2018-19 3.53 0.42 0.42 1.76 1.76
2019-20 1.76 0.21 0.21 1.76 0.00
AMEYA STONE CRUSHER
KUSHAGRA JAISWAL
CASH FLOW

PARTICULARS 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25


OPENING BALANCE 1.79 0.71 0.66 0.53 0.84 2.49 5.56 10.08
RECEIPT
NET SALES AND TRUCK RECIEPTS 95.00 115.00 120.75 126.79 133.13 139.78 146.77 154.11
LOAN FROM BANK 37.00
OWN CONTRIBUTION 13.46
CC LIMIT UTILISED 5

TOTAL 150.46 115.00 120.75 126.79 133.13 139.78 146.77 154.11

PAYMENT
PURCHASES 75.5 90 95.5 108.05 113.45 119.12 125.08 131.33
ADMIN AND OTHER EXPENSES 3 3.5 3.68 3.86 4.05 4.25 4.47 4.69
REPAYMENT OF NEW TERM LOAN 3.08 5.29 5.29 5.29 5.29 5.29 5.29 2.20
REPAYMENT OF LOAN FROM HDFC 4.26 4.69 5.16 0.46 0.00 0.00 0.00 0.00
REPAYMENT OF LOAN FROM BOM 1.76 1.76 1.76
INTEREST ON NEW LOAN 2.59 4.07 3.44 2.80 2.17 1.53 0.90 0.26
INTEREST ON CC 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53
INTEREST ON LOAN FROM HDFC 1.22 0.79 0.32 0.00
INTEREST ON LOAN FROM BOM 0.63 0.42 0.21
WITHDRAWALS 3.50 4.00 5.00 5.50 6.00 6.00 6.00 6.00
MACHINERY PURCHASE 55.46
AND INSTRALLATION CHARGES
`
TOTAL 151.54 115.05 120.88 126.48 131.48 136.72 142.25 145.01
SURPLUS/DEFICIT -1.08 -0.05 -0.13 0.31 1.65 3.07 4.52 9.10
CLOSING BALANCE 0.71 0.66 0.53 0.84 2.49 5.56 10.08 19.18
AMEYA STONE CRUSHER
KUSHAGRA JAISWAL
PROFIT AND LOSS ACCOUNT

PARTICULARS 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24


INCOME
NET SALES AND TRUCK RECIEPTS 95.00 115.00 120.75 126.79 133.13 139.78 146.77

TOTAL 95.00 115.00 120.75 126.79 133.13 139.78 146.77


EXPENDITURE
PURCHASES 75.50 90.00 95.50 108.05 113.45 119.12 125.08
ADMIN AND OTHER EXPENSES 3.00 3.50 3.68 3.86 4.05 4.25 4.47
INTEREST ON NEW TERM LOAN 2.59 4.07 3.44 2.80 2.17 1.53 0.90
INTEREST ON CC 0.53 0.53 0.53 0.53 0.53 0.53 0.53
INTEREST ON LOAN FROM HDFC 1.22 0.79 0.32 0.00 0.00 0.00 0.00
INTEREST ON LOAN FROM BOM 0.63 0.42 0.21 0.00 0.00 0.00 0.00

TOTAL 83.47 99.31 103.67 115.23 120.19 125.43 130.97


PROFIT/ LOSS 11.53 15.69 17.08 11.55 12.94 14.35 15.81

DSCR CALCULATION

PROFIT AFTER INTEREST 11.53 15.69 17.08 11.55 12.94 14.35 15.81
ADD INTEREST 4.97 5.81 4.49 3.33 2.69 2.06 1.42
EBIDTA (A) 16.50 21.50 21.58 14.88 15.63 16.41 17.23
INTEREST EXPENSES 4.97 5.81 4.49 3.33 2.69 2.06 1.42
PRINCIPLE REPAYMENT 16.50 11.74 12.21 5.75 5.29 5.29 5.29
TOTAL DEBT SERVICE (B) 21.47 17.55 16.70 9.08 7.98 7.34 6.71
DSCR (A/B) 0.77 1.23 1.29 1.64 1.96 2.23 2.57
AVERAGE DSCR 2.22
2024-25

154.11

154.11

131.33
4.69
0.26
0.53
0.00
0.00

136.81
17.30

17.30
0.79
18.09
0.79
2.20
2.99
6.05
AMEYA STONE CRUSHER
KUSHAGRA JAISWAL
BALANCE SHEET

PARTICULARS 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25


ASSET
LAND AND EQUIPMENTS 51.34 106.80 106.80 106.80 106.80 106.80 106.80 106.80
ADDITION DURING THE YEAR 55.46
TOTAL 106.80 106.80 106.80 106.80 106.80 106.80 106.80 106.80

CASH AND BANK BALANCE 0.71 0.66 0.53 0.84 2.49 5.56 10.08 19.18
OTHER CURRENT ASSETS 3.52 3.52 3.52 3.52 3.52 3.52 3.52 3.52

TOTAL 111.04 110.99 110.86 111.18 112.83 115.90 120.42 129.52


LIABILITY
OP CAPITAL 26.30 47.79 59.48 71.56 77.62 84.55 92.90 102.71
ADD PROFIT DURING THE YEAR 11.53 15.69 17.08 11.55 12.94 14.35 15.81 17.30
ADD ADDITION DURING THE YEAR 13.46
LESS WITHDRAWALS 3.50 4.00 5.00 5.50 6.00 6.00 6.00 6.00
CLOSING CAPITAL 47.79 59.48 71.56 77.62 84.55 92.90 102.71 114.01

LOAN FROM FRIENDS AND RELATIVES 10.50 10.50 10.50 10.50 10.50 10.50 10.50 10.50
LOAN FROM HDFC BANK 10.31 5.62 0.46 0.00 0.00 0.00 0.00 0.00
TERM LOAN ( BOM) 3.53 1.76 0.00 0.00 0.00 0.00 0.00 0.00
NEW LOAN 33.92 28.63 23.35 18.06 12.77 7.49 2.20 0.00
CC 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00

TOTAL 111.04 110.99 110.86 111.18 112.83 115.89 120.41 129.51


0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
AMEYA STONE CRUSHER

DEPRECIATION FOR THE YEAR 2017-18

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 0.00 Err:509 Err:509


VEHICLE 15% 0 Err:509 0 Err:509 Err:509

TOTAL 0.00 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2018-19

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509

TOTAL Err:509 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2019-20

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509

TOTAL Err:509 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2020-21

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509

TOTAL Err:509 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2021-22

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509

TOTAL Err:509 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2022-23

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509

TOTAL Err:509 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2023-24

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509

TOTAL Err:509 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2024-25

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509

TOTAL Err:509 Err:509 0.00 Err:509 Err:509

DEPRECIATION FOR THE YEAR 2025-26

PARTICULARS RATE OP BAL ADDITION TRANFERED GROSS BLOCK DEP


ASSET

BUILDING 5% Err:509 Err:509 Err:509 Err:509


VEHICLE 15% Err:509 Err:509 Err:509 Err:509
TOTAL Err:509 Err:509 0.00 Err:509 Err:509
NET BLOCK

Err:509
Err:509

Err:509

NET BLOCK

Err:509
Err:509

Err:509

NET BLOCK

Err:509
Err:509

Err:509

NET BLOCK

Err:509
Err:509

Err:509

NET BLOCK
Err:509
Err:509

Err:509

NET BLOCK

Err:509
Err:509

Err:509

NET BLOCK

Err:509
Err:509

Err:509

NET BLOCK

Err:509
Err:509

Err:509

NET BLOCK

Err:509
Err:509
Err:509

You might also like