Nothing Special   »   [go: up one dir, main page]
Scribd
Upload
2 views6 pages

GLORY

Uploaded by

dmgfinserveoffice

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt

GLORY

Uploaded by

dmgfinserveoffice
2 views6 pages

Copyright

© © All Rights Reserved

Available Formats

DOCX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
2 views6 pages

GLORY

Uploaded by

dmgfinserveoffice

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 6

M/s abc

Term Loan- Rs 19.45 Lacs

FOR PURCHASE OF PLANT AND


MACHINERY
&
CC LIMIT OF Rs 100.00 LACS

FROM BANK
PROJECTED BALANCE SHEET
In Lacs
LIABILITIES 2025 2026 2027 2028 2029 2030 2031 2032

PROPRIETOR'S CAPITAL A/C 84.36 126.84 166.81 209.03 255.81 306.59 361.06 421.49
CAPITAL INTRODUCED 6.51 - - -
ADD: NET PROFIT DURING YEAR 37.57 41.57 45.82 51.78 56.78 62.28 68.93 75.90
128.44 168.41 212.63 260.81 312.59 368.86 429.99 497.39
LESS: WITHDRAWLS 1.60 1.60 3.60 5.00 6.00 7.80 8.50 12.00
CLOSING BALANCE 126.84 166.81 209.03 255.81 306.59 361.06 421.49 485.39

TERM LIABILITIES
EXISTING TERM LOANS 101.06 90.63 80.20 69.77 59.34 48.91 38.48 28.05
TERM LOAN CANARA BANK 18.10 15.32 12.54 9.76 6.99 4.21 1.43 -

CURRENT LIABILITES
CC LIMIT 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
SUNDRY CREDITORS 95.00 99.75 104.74 109.97 115.47 121.25 127.31 133.67
TOTAL 441.00 472.51 506.51 545.32 588.38 635.43 688.71 747.12

ASSETS Ist Yr IInd yr IIIrd yr IVth yr Vth yr Vth yr Vth yr Vth yr

FIXED ASSETS 34.20 32.49 29.24 26.32 23.69 21.57 20.44 19.49
LESS: DEPRECIATION 1.71 3.25 2.92 2.63 2.37 2.13 1.94 1.85
32.49 29.24 26.32 23.69 21.32 19.44 18.49 17.64
NON CURRENT ASSETS/INVEST 27.59 27.59 27.59 27.59 27.59 27.59 27.59 27.59

CURRENT ASSETS
STOCK 325.00 357.50 393.25 432.58 475.83 523.42 575.76 633.33
DEBTORS 52.33 53.37 54.44 55.53 56.64 57.77 58.93 60.10
CASH AND BANK BALANCES 3.59 4.81 4.91 5.94 7.01 7.22 7.95 8.45
TOTAL 441.00 472.51 506.51 545.32 588.38 635.43 688.71 747.12

COST AND PROFITABILITY STATEMENT


In Lacs
YEARS 2025 2026 2027 2028 2029 2030 2031 2032
LEVEL(%)

SALES 325.00 357.50 393.25 432.58 475.83 523.42 575.76 633.33


EXPENSES
PURCHASES 190.45 234.16 265.44 298.04 335.46 376.34 420.30 468.67
POWER & FUEL 11.38 12.51 13.76 15.14 16.65 18.32 20.15 22.17

201.83 246.68 279.21 313.18 352.12 394.66 440.45 490.83


Add:Op Stock 313.70 325.00 357.50 393.25 432.58 475.83 523.42 575.76
Less: Cl stock 325.00 357.50 393.25 432.58 475.83 523.42 575.76 633.33
TOTAL COST 190.53 214.18 243.46 273.86 308.86 347.07 388.11 433.26
GROSS PROFIT 134.48 143.33 149.79 158.72 166.97 176.34 187.64 200.08

DEPRECIATION 1.71 3.25 2.92 2.63 2.37 2.13 1.94 1.85


ADMIN & SELLING EXPENSES 32.50 35.75 39.33 43.26 47.58 52.34 57.58 63.33
SALARY 18.25 19.16 20.12 21.13 22.18 23.29 24.46 25.68
INTEREST ON CC LIMIT 11.35 11.35 11.35 11.35 11.35 11.35 11.35 11.35
INTEREST ON TERM LOAN 25.97 24.38 21.62 18.85 16.09 13.32 10.55 7.87
OTHER MISC EXP 0.50 0.53 0.55 0.58 0.61 0.64 0.67 0.70
TOTAL 90.28 94.42 95.89 97.80 100.18 103.07 106.55 110.78

NET PROFIT BEFORE TAX 44.20 48.91 53.90 60.92 66.80 73.27 81.09 89.29
TAXES 6.63 7.34 8.09 9.14 10.02 10.99 12.16 13.39
PROFIT AFTER TAX 37.57 41.57 45.82 51.78 56.78 62.28 68.93 75.90
RATIO ANALYSIS

YEAR 2025 2026 2027 2028 2029 2030 2031


CURRENT ASSETS 380.92 415.68 452.60 494.04 539.48 588.40 642.63
CURRENT LIAB 195.00 199.75 204.74 209.97 215.47 221.25 227.31
NWC 185.92 215.93 247.86 284.07 324.00 367.16 415.32
CURRENT RATIO 1.95 2.08 2.21 2.35 2.50 2.66 2.83
SALES 325.00 357.50 393.25 432.58 475.83 523.42 575.76
LEVERAGE RATIO 2.48 1.83 1.42 1.13 0.92 0.76 0.63
PROFITS 44.20 48.91 53.90 60.92 66.80 73.27 81.09
DEBT EQUITY RATIO 0.14 0.09 0.06 0.04 0.02 0.01 0.00

TOTAL OUTSIDE LIABILITY 314.16 305.70 297.48 289.51 281.80 274.36 267.22

TOL/TNW 2.48 1.83 1.42 1.13 0.92 0.76 0.63


ASSESSMENT OF WORKING CAPITAL LIMIT
CURRENT ASSETS 380.92 415.68 452.60 494.04 539.48 588.40 642.63
CURRENT LIAB (OTHER THAN BB) 95.00 99.75 104.74 109.97 115.47 121.25 127.31

WORKING CAPITAL GAP 285.92 315.93 347.86 384.07 424.00 467.16 515.32

25% OF CA 95.23 103.92 113.15 123.51 134.87 147.10 160.66


ACTUAL NWC 185.92 215.93 247.86 284.07 324.00 367.16 415.32

1 190.69 212.01 234.71 260.56 289.13 320.06 354.66


2 100.00 100.00 100.00 100.00 100.00 100.00 100.00
MPBF 100.00 100.00 100.00 100.00 100.00 100.00 100.00

You might also like