Scribd
Upload
2 views6 pages

Project Report

The document presents a provisional balance sheet, profit and loss account, and cash flow statement for a company from March 2027 to March 2033. It outlines the sources and applications of funds, projected gross receipts, expenses, and profits over the years. The financial projections indicate growth in share capital, profits, and cash flows, with detailed breakdowns of income and expenses.

Uploaded by

hellorakeshverma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views6 pages

Project Report

The document presents a provisional balance sheet, profit and loss account, and cash flow statement for a company from March 2027 to March 2033. It outlines the sources and applications of funds, projected gross receipts, expenses, and profits over the years. The financial projections indicate growth in share capital, profits, and cash flows, with detailed breakdowns of income and expenses.

Uploaded by

hellorakeshverma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

XXXXXXXXXXXXXXXXXX

Factory Location: xxxxxxxxxxxxxxxxxxxxx


Office Location: xxxxxxxxxxxxxxxxxxxxxx

PROVISIONAL BALANCE SHEET AS ON


31 March 2027 31 March 2028 31 March 2029 31 March 2030 31 March 2031 31 March 2032 31 March 2033
Estimated Projected Projected Projected Projected Projected Projected
SOURCE OF FUNDS
Owner's Funds
Share Capital 82,95,000 1,08,53,950 1,71,89,043 2,45,19,435 3,22,86,299 4,04,17,533 4,97,49,760
Profit during year 45,58,950 88,35,093 1,17,30,392 1,25,66,864 1,31,31,234 1,43,32,227 1,62,63,512
Less: Withdrawal during year 20,00,000 25,00,000 44,00,000 48,00,000 50,00,000 50,00,000 60,00,000
Closing Balance 1,08,53,950 1,71,89,043 2,45,19,435 3,22,86,299 4,04,17,533 4,97,49,760 6,00,13,272
Loan Funds
Unsecured Loan 15,00,000 15,00,000 13,00,000 12,00,000 10,00,000 8,00,000 6,00,000
Secured Loan
Cash Credit 1,00,00,000 1,00,00,000 1,00,00,000 1,00,00,000 1,00,00,000 1,00,00,000 1,00,00,000
Term Loan 5,40,77,174 4,76,13,902 4,04,38,356 3,24,72,039 2,36,27,807 1,38,08,911 29,07,937
6,55,77,174 5,91,13,902 5,17,38,356 4,36,72,039 3,46,27,807 2,46,08,911 1,35,07,937
Current Liabilities & Provisions
Short Term Borrowing 5,25,000 4,75,000 4,50,000 5,00,000 5,85,000 7,25,000 7,50,000
Account Payable 23,80,000 25,99,500 28,25,000 32,95,000 41,25,000 46,75,000 55,49,500
Short Term Provision - - - - - - -
29,05,000 30,74,500 32,75,000 37,95,000 47,10,000 54,00,000 62,99,500

TOTAL LIABILITY 7,93,36,124 7,93,77,445 7,95,32,791 7,97,53,338 7,97,55,340 7,97,58,671 7,98,20,709

Page 1
APPLICATION OF FUNDS
Fixed Assets
Gross Fixed Assets 6,62,95,000 5,65,65,500 4,82,92,700 4,12,50,867 3,52,51,852 3,01,37,878 2,57,76,049
Addition During Year - - - - - - -
Less: Sales of Assets - - - - - - -
Less: Depreciation 97,29,500 82,72,800 70,41,833 59,99,015 51,13,974 43,61,829 37,21,982
Net Fixed Assets 5,65,65,500 4,82,92,700 4,12,50,867 3,52,51,852 3,01,37,878 2,57,76,049 2,20,54,067
Investments
Security Deposit & Investment 25,00,000 50,00,000 1,00,00,000 1,40,00,000 1,70,00,000 2,00,00,000 2,25,00,000
Current Assets, Loans & Advances
Trade Receivable 31,15,000 36,98,700 39,28,750 51,20,000 63,50,000 65,89,000 67,25,000
Loans & Advances 4,50,000 5,25,000 7,50,000 8,00,000 9,85,000 10,00,000 11,00,000
Other Current Assets 21,15,000 23,62,000 25,00,000 28,25,000 31,50,000 34,65,000 36,75,000
Cash & Bank Balances 1,45,90,624 1,94,99,045 2,11,03,174 2,17,56,486 2,21,32,462 2,29,28,622 2,37,66,642
2,02,70,624 2,60,84,745 2,82,81,924 3,05,01,486 3,26,17,462 3,39,82,622 3,52,66,642

TOTAL ASSETS 7,93,36,124 7,93,77,445 7,95,32,791 7,97,53,338 7,97,55,340 7,97,58,671 7,98,20,709


Page 2
XXXXXXXXXXXXXXXXXX
Factory Location: xxxxxxxxxxxxxxxxxxxxx
Office Location: xxxxxxxxxxxxxxxxxxxxxx

PROVISIONAL PROFIT & LOSS A/C AT THE YEAR ENDED


31 March 2027 31 March 2028 31 March 2029 31 March 2030 31 March 2031 31 March 2032 31 March 2033
Estimated Projected Projected Projected Projected Projected Projected
Gross Receipt
By Sales of Products 26,27,10,000 32,78,88,000 39,72,78,000 46,78,56,000 50,62,77,000 54,57,78,000 56,08,44,000
Other Income
BY Interest Received 1,50,000 3,00,000 6,00,000 8,00,000 10,00,000
Total Operating Income 26,27,10,000 32,78,88,000 39,74,28,000 46,81,56,000 50,68,77,000 54,65,78,000 56,18,44,000
Expenses
To Raw Materials 22,80,00,000 28,80,00,000 35,28,00,000 42,24,00,000 45,90,00,000 49,68,00,000 50,76,00,000
To Salary & Wages 71,71,200 77,76,000 97,63,200 1,08,28,800 1,32,76,800 1,42,56,000 1,68,48,000
To Staff Welfare 2,50,000 3,00,000 3,60,000 4,32,000 5,18,400 6,22,080 7,46,496
To Repair & Maintenance 2,42,250 2,66,475 2,93,123 3,22,435 3,54,678 4,25,614 4,68,175
To Electricity & Generator 11,85,560 13,04,116 14,34,528 17,21,434 18,93,577 22,72,292 24,99,521
To Travelling & Conveyance 8,35,500 9,19,050 10,10,955 11,12,051 12,23,256 13,45,581 14,80,139
To Business Promotion Exp. 2,50,000 2,75,000 3,02,500 3,32,750 3,66,025 4,02,628 4,42,891
To Printing & Stationary 22,800 25,080 27,588 30,347 33,382 36,720 40,392
To Postage & Courier 11,560 12,716 13,988 15,386 16,925 18,617 20,479
To Newspaper & Periodicals 15,650 17,215 18,937 20,830 22,913 25,204 27,724
To Insurance Charges 87,500 96,250 1,05,875 1,16,463 1,28,109 1,40,920 1,55,012
To Fire Protection Exp. 20,000 22,000 24,200 26,620 29,282 32,210 35,431
To Pest Control 9,000 9,900 10,890 11,979 13,177 14,495 15,945
To Water and Sanitation 8,45,500 9,30,050 10,23,055 11,25,361 12,37,897 13,61,686 14,97,855
To Telephone & Internet Exp. 5,400 5,940 6,534 7,187 7,906 8,697 9,567

Page 3
To Filling Fees 12,000 12,000 15,000 18,000 20,000 20,000 25,000
To Misc. Expenses 2,78,500 3,06,350 3,36,985 3,70,684 4,07,752 4,48,527 4,93,380
To Bank Charges & Commission 6,750 7,425 8,168 8,985 9,884 10,872 11,959
To Audit Fee 15,000 15,000 20,000 20,000 25,000 25,000 30,000
Total Operating Expenses 23,92,64,170 30,03,00,567 36,75,75,525 43,89,21,311 47,85,84,962 51,82,67,143 53,24,47,966

Operating Profit Before Depr. Intt.


2,34,45,830 2,75,87,433 2,98,52,475 2,92,34,689 2,82,92,038 2,83,10,857 2,93,96,034
& Tax

Less : Depreciation 97,29,500 82,72,800 70,41,833 59,99,015 51,13,974 43,61,829 37,21,982

Operating Profit Before Intt. &


1,37,16,330 1,93,14,633 2,28,10,642 2,32,35,674 2,31,78,064 2,39,49,028 2,56,74,052
Tax(PBIT)

Interest on Cash Credit @11% p.a. 11,00,000 11,00,000 11,00,000 11,00,000 11,00,000 11,00,000 11,00,000
Interest on Term Loan 59,89,949 53,72,928 46,60,654 38,69,884 29,91,968 20,17,303 9,35,227

Profit Before Tax (PBT) 66,26,381 1,28,41,705 1,70,49,988 1,82,65,790 1,90,86,096 2,08,31,725 2,36,38,825

Taxation @31.2% 20,67,431 40,06,612 53,19,596 56,98,926 59,54,862 64,99,498 73,75,313

Profit After Tax (PAT) 45,58,950 88,35,093 1,17,30,392 1,25,66,864 1,31,31,234 1,43,32,227 1,62,63,512

Cash Accruals 1,42,88,450 1,71,07,893 1,87,72,225 1,85,65,879 1,82,45,208 1,86,94,056 1,99,85,494

Cash Profit Plus Interest on Cash


2,13,78,399 2,35,80,821 2,45,32,879 2,35,35,763 2,23,37,176 2,18,11,359 2,20,20,721
Credit & Term Loan (X)

Note: Interest on Cash Credit is assumed to be 11% Page 4


XXXXXXXXXXXXXXXXXX
Factory Location: xxxxxxxxxxxxxxxxxxxxx
Office Location: xxxxxxxxxxxxxxxxxxxxxx

PROVISIONAL/ESTIMATED CASH FLOW AT THE YEAR ENDED


Year Ended
PARTICULARS
31 March 2027 31 March 2028 31 March 2029 31 March 2030 31 March 2031 31 March 2032 31 March 2033
Cash Flows from Operating Activities
Net income 45,58,950 88,35,093 1,17,30,392 1,25,66,864 1,31,31,234 1,43,32,227 1,62,63,512
Adjustments for:
Depreciation 97,29,500 82,72,800 70,41,833 59,99,015 51,13,974 43,61,829 37,21,982
Increase in Trade Receivable -31,15,000 -5,83,700 -2,30,050 -11,91,250 -12,30,000 -2,39,000 -1,36,000
Increase in Other Current Assets -21,15,000 -2,47,000 -1,38,000 -3,25,000 -3,25,000 -3,15,000 -2,10,000
Increase in Account Payables 23,80,000 2,19,500 2,25,500 4,70,000 8,30,000 5,50,000 8,74,500
Increase in Loans & Advances -4,50,000 -75,000 -2,25,000 -50,000 -1,85,000 -15,000 -1,00,000
Cash Generated from Operations 1,09,88,450 1,64,21,693 1,84,04,675 1,74,69,629 1,73,35,208 1,86,75,056 2,04,13,994
Cash Flows from Investing Activities
Purchase of Fixed Assets -6,62,95,000 - - - - - -
Increase in Investment -25,00,000 -25,00,000 -50,00,000 -40,00,000 -30,00,000 -30,00,000 -25,00,000
Net Cash used in Investing Activities -6,87,95,000 -25,00,000 -50,00,000 -40,00,000 -30,00,000 -30,00,000 -25,00,000
Cash Flows from Financing Activities
Increase in Capital Investment 82,95,000
Decrease in Capital Investment -20,00,000 -25,00,000 -44,00,000 -48,00,000 -50,00,000 -50,00,000 -60,00,000
Increase in Working Capital 1,00,00,000 - - - - - -
Increase in Secured Loan 5,80,00,000 - - - - -
Decrease in Secured Loan -39,22,826 -64,63,272 -71,75,546 -79,66,317 -88,44,232 -98,18,896 -1,09,00,974
Increase in Unsecured Loan 15,00,000
Decrease in Unsecured Loan - -2,00,000 -1,00,000 -2,00,000 -2,00,000 -2,00,000

Page 5
Increase in Short Term Borrowing 5,25,000 -50,000 -25,000 50,000 85,000 1,40,000 25,000
Decrease in Short Term Borrowing - - - - - -
Net Cash used in Financing Activities 7,23,97,174 -90,13,272 -1,18,00,546 -1,28,16,317 -1,39,59,232 -1,48,78,896 -1,70,75,974

Net increase in cash and cash equivalents 1,45,90,624 49,08,421 16,04,129 6,53,312 3,75,976 7,96,160 8,38,020

Cash and cash equivalents at beginning of


- 1,45,90,624 1,94,99,045 2,11,03,174 2,17,56,486 2,21,32,462 2,29,28,622
period
Cash and cash equivalents at end of
1,45,90,624 1,94,99,045 2,11,03,174 2,17,56,486 2,21,32,462 2,29,28,622 2,37,66,642
period

Page 6

You might also like