Projection MALLIGA

PARTICULARS OF THE PROJECT
1 Name of the Applicant : D. Mallika
2 Address of the Applicant : No.4/161, 7th street ,

Ulaganathapuram, Ennore
Chennai - 600 057.
3 Puropose of Loan : Capital Expenditure - Purchase of

Stocks
4 Cost of the Project : Rs. 11,50,500
5 Own Contribution : Rs. 1,80,500
6 Term Loan From Bank : Rs. 9,70,000
7 Number of Installments : 60 Monthly Installments
8 Depreciation : As per Income Tax Act
9 Repayment Source : Out of Income from Business

10 Financial Assistance : MUDRA
COST OF THE PROJECT AND MEANS OF FINANCING
COST OF THE PROJECT
S.No. DESCRIPTION AMOUNT
1 Rice Bags 26 kgs each @ 11,50,500

Rs.2000/- per bag
TOTAL 11,50,500
MEANS OF FINANCING
S.No. DESCRIPTION AMOUNT
1 OWN CAPITAL 1,80,500
2 TERM LOAN FROM BANK OF INDIA 9,70,000
TOTAL 11,50,500
PROJECTED PROFITABILITY STATEMENT
DESCRIPTION YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5
INCOME :
Sale Receipts 14,22,000 15,54,300 16,99,340 17,84,302 18,73,517
TOTAL 14,22,000 15,54,300 16,99,340 17,84,302 18,73,517
EXPENDITURE:
Purchase cost 5,14,100 5,79,000 6,51,700 6,99,800 7,51,100

Transportation Expenses 1,67,796 1,83,408 2,00,520 1,99,840 1,87,352
Salaries & Wages 3,06,000 3,24,000 3,78,000 4,14,000 4,50,000
Repairs & Maintenance 11,400 12,600 13,800 15,000 17,400
Depreciation 86,288 1,59,632 1,35,687 1,15,334 98,034
TOTAL 10,85,584 12,58,640 13,79,707 14,43,974 15,03,886
PROFIT BEFORE INTEREST & TAX 3,36,417 2,95,660 3,19,633 3,40,328 3,69,631
Interest on Term Loan 1,01,388 83,242 62,946 40,246 14,855
PROFIT BEFORE TAX 2,35,029 2,12,418 2,56,687 3,00,082 3,54,776
Less: Provision for Tax (Ref Note:1) - - - - -
PROFIT AFTER TAX 2,35,029 2,12,418 2,56,687 3,00,082 3,54,776

Add: Depreciation 86,288 1,59,632 1,35,687 1,15,334 98,034
NET CASH ACCRUALS 3,21,316 3,72,049 3,92,374 4,15,416 4,52,810
Note: The Income is below the taxable limit. Hence Tax on Income will be NIL.
" Compiled, based on the Data provided to us"

PROJECTED BALANCE SHEET
LIABILITIES :
Capital 3,55,529 4,95,946 6,73,433 8,86,395 11,45,339
Term Loan - Bank of India 8,16,852 6,45,559 4,53,970 2,39,680 -
Current Liabilities 73,500 81,400 93,200 96,400 91,500
TOTAL 12,45,881 12,22,905 12,20,603 12,22,475 12,36,839
ASSETS :
Fixed Assets 10,64,213 9,04,581 7,68,894 6,53,560 5,55,526
Advances, Deposits 40,000 48,500 54,900 59,400 64,400
Other Current Assets 33,500 32,900 38,300 37,000 27,100
Cash & Bank Balances 1,08,169 2,36,925 3,58,509 4,72,516 5,89,813
12,45,881 12,22,905 12,20,603 12,22,475 12,36,839

DEBT SERVICE COVERAGE RATIO
Profit after tax 2,35,029 2,12,418 2,56,687 3,00,082 3,54,776
Depreciation 86,288 1,59,632 1,35,687 1,15,334 98,034
4,22,704 4,55,292 4,55,320 4,55,662 4,67,665
REPAYMENT OBLIGATIONS :
Term Loan - Principal Repayment 1,53,148 1,71,293 1,91,589 2,14,290 2,39,680
2,54,535 2,54,535 2,54,535 2,54,535 2,54,535
Debt Service Coverage Ratio 1.66 1.79 1.79 1.79 1.84
Average Debt Sevice Coverage Ratio 1.77

REPAYMENT SCHEDULE OF TERM LOAN & INTEREST CALCULATION
Amount of Term Loan in Rs. 9,70,000
Number of Installments 60
Monthly Installment - EMI 21,211
Rate of Interest 11.25%
PARTICULARS YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5
Opening Balance - 8,16,852 6,45,559 4,53,970 2,39,680

Add: Loan Availed 9,70,000 - - - -
Interest 1,01,388 83,242 62,946 40,246 14,855
Principal Repayment 1,53,148 1,71,293 1,91,589 2,14,290 2,39,680
Closing balance 8,16,852 6,45,559 4,53,970 2,39,680 -

BASIS OF CALCULATIONS FOR PROJECTED PROFITABILITY STATEMENT
1 INCOME FROM OPERATIONS YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5
RICE BAG RECEIPTS 12,24,000 13,46,400 14,81,040 15,55,092 16,32,847

OIL CAN RECEIPTS 1,98,000 2,07,900 2,18,300 2,29,210 2,40,670
SALE RECEIPTS 14,22,000 15,54,300 16,99,340 17,84,302 18,73,517
2 SALES RECEIPTS YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5
TOTAL COST OF SALES 5,14,100 5,79,000 6,51,700 6,99,800 7,51,100
3 ADMINSTRATIVE EXPENSES YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5
TOTAL COST OF ADMIN 1,67,796 1,83,408 2,00,520 1,99,840 1,87,352
4 SALARIES & WAGES

NO OF EMPLOYEES 3 3 3 3 3
AVERAGE SALARY PER MONTH 8,500 9,000 10,500 11,500 12,500
SALARIES & WAGES 3,06,000 3,24,000 3,78,000 4,14,000 4,50,000
5 REPAIRS & MAINTENANCE
REPAIRS & MAINTENANCE 11,400 12,600 13,800 15,000 17,400
6 DEPRECIATION
MUSICAL EQUIPMENTS 11,50,500

Opening balance 10,64,213 9,04,581 7,68,894 6,53,560
Depreciation @ 15 % 86,288 1,59,632 1,35,687 1,15,334 98,034
Closing WDV 10,64,213 9,04,581 7,68,894 6,53,560 5,55,526
TOTAL DEPRECIATION 86,288 1,59,632 1,35,687 1,15,334 98,034
Closing WDV 10,64,213 9,04,581 7,68,894 6,53,560 5,55,526

Projection MALLIGA

Uploaded by

Copyright:

Available Formats

Projection MALLIGA

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Projection MALLIGA

Uploaded by

Copyright:

Available Formats

PARTICULARS OF THE PROJECT

1 Name of the Applicant : D. Mallika

2 Address of the Applicant : No.4/161, 7th street ,

3 Puropose of Loan : Capital Expenditure - Purchase of

4 Cost of the Project : Rs. 11,50,500

5 Own Contribution : Rs. 1,80,500

6 Term Loan From Bank : Rs. 9,70,000

7 Number of Installments : 60 Monthly Installments

8 Depreciation : As per Income Tax Act

9 Repayment Source : Out of Income from Business

COST OF THE PROJECT

S.No. DESCRIPTION AMOUNT

1 Rice Bags 26 kgs each @ 11,50,500

S.No. DESCRIPTION AMOUNT

1 OWN CAPITAL 1,80,500

2 TERM LOAN FROM BANK OF INDIA 9,70,000

DESCRIPTION YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5

Sale Receipts 14,22,000 15,54,300 16,99,340 17,84,302 18,73,517

TOTAL 14,22,000 15,54,300 16,99,340 17,84,302 18,73,517

Purchase cost 5,14,100 5,79,000 6,51,700 6,99,800 7,51,100

TOTAL 10,85,584 12,58,640 13,79,707 14,43,974 15,03,886

Interest on Term Loan 1,01,388 83,242 62,946 40,246 14,855

PROFIT BEFORE TAX 2,35,029 2,12,418 2,56,687 3,00,082 3,54,776

Less: Provision for Tax (Ref Note:1) - - - - -

PROFIT AFTER TAX 2,35,029 2,12,418 2,56,687 3,00,082 3,54,776

NET CASH ACCRUALS 3,21,316 3,72,049 3,92,374 4,15,416 4,52,810

" Compiled, based on the Data provided to us"

DESCRIPTION YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5

Capital 3,55,529 4,95,946 6,73,433 8,86,395 11,45,339

Term Loan - Bank of India 8,16,852 6,45,559 4,53,970 2,39,680 -

Current Liabilities 73,500 81,400 93,200 96,400 91,500

TOTAL 12,45,881 12,22,905 12,20,603 12,22,475 12,36,839

Fixed Assets 10,64,213 9,04,581 7,68,894 6,53,560 5,55,526

Advances, Deposits 40,000 48,500 54,900 59,400 64,400

Other Current Assets 33,500 32,900 38,300 37,000 27,100

Cash & Bank Balances 1,08,169 2,36,925 3,58,509 4,72,516 5,89,813

12,45,881 12,22,905 12,20,603 12,22,475 12,36,839

DESCRIPTION YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5

Profit after tax 2,35,029 2,12,418 2,56,687 3,00,082 3,54,776

Depreciation 86,288 1,59,632 1,35,687 1,15,334 98,034

Interest on Term Loan 1,01,388 83,242 62,946 40,246 14,855

4,22,704 4,55,292 4,55,320 4,55,662 4,67,665

Term Loan - Principal Repayment 1,53,148 1,71,293 1,91,589 2,14,290 2,39,680

Interest on Term Loan 1,01,388 83,242 62,946 40,246 14,855

2,54,535 2,54,535 2,54,535 2,54,535 2,54,535

Debt Service Coverage Ratio 1.66 1.79 1.79 1.79 1.84

Average Debt Sevice Coverage Ratio 1.77

Amount of Term Loan in Rs. 9,70,000

Monthly Installment - EMI 21,211

Rate of Interest 11.25%

PARTICULARS YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5

Opening Balance - 8,16,852 6,45,559 4,53,970 2,39,680

Interest 1,01,388 83,242 62,946 40,246 14,855

Principal Repayment 1,53,148 1,71,293 1,91,589 2,14,290 2,39,680

Closing balance 8,16,852 6,45,559 4,53,970 2,39,680 -

1 INCOME FROM OPERATIONS YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5

RICE BAG RECEIPTS 12,24,000 13,46,400 14,81,040 15,55,092 16,32,847

SALE RECEIPTS 14,22,000 15,54,300 16,99,340 17,84,302 18,73,517

2 SALES RECEIPTS YEAR-1 YEAR-2 YEAR-3 YEAR-4 YEAR-5

TOTAL COST OF SALES 5,14,100 5,79,000 6,51,700 6,99,800 7,51,100