Kushagra Jaiswal
Kushagra Jaiswal
Kushagra Jaiswal
KUSHAGRA JAISWAL
I. INVESTMENT REQUIRED
II. SOURCES
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
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
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
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
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
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
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
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