Sachin Daneshwari

Download as pdf or txt
Download as pdf or txt
You are on page 1of 2

PROJECTED PROFITABILITY STATEMENT

Particular 31.3.2023 1 2 3
Sales 25,50,000.00 29,32,500.00 32,25,750.00 35,48,325.00

Purchases 13,24,280.00 14,56,708.00 16,02,378.80 17,62,616.68


Wages To worker 6,67,500.00 7,34,250.00 8,07,675.00 8,88,442.50
Sub Total 19,91,780.00 21,90,958.00 24,10,053.80 26,51,059.18
Add:Opg.Stock 77,660.00 2,63,220.00 2,89,542.00 3,18,496.20
Sub Total 20,69,440.00 24,54,178.00 26,99,595.80 29,69,555.38
Less:Clg.Stock 2,63,220.00 2,89,542.00 3,18,496.20 3,50,345.82
Sub Total 18,06,220.00 21,64,636.00 23,81,099.60 26,19,209.56

Gross Profit 7,43,780.00 7,67,864.00 8,44,650.40 9,29,115.44


(% to sales) 29.17 26.18 26.18 26.18
Indirect Expenses:
Electrical Charges 5,500.00 6,050.00 6,110.50 6,721.55
Primises Rent 60,000.00 60,600.00 66,660.00 73,326.00
Salary Expenses 50,000.00 50,500.00 55,550.00 61,105.00
Transpotation Expenses 22,000.00 7,452.00 8,197.20 9,016.92
Vehicle Expenses 12500.00 13,750.00 15,125.00 16,637.50
Telephone Charge 15000.00 16,500.00 18,150.00 19,965.00
Bank charges/OD Int 30000.00 33,000.00 36,300.00 39,930.00
Depriation 40000.00 39,000.00 33,600.00 28,965.00
Postatge & Courier 28971.00 31,868.10 35,054.91 38,560.40
Office Expences 8059.00 8,864.90 9,751.39 10,726.53
Sub Total 2,72,030.00 2,58,720.10 2,74,747.61 2,94,227.37

Profit before Tax 4,71,750.00 5,09,143.90 5,69,902.79 6,34,888.07


Add : Other Income 0.00 0.00 0.00 0.00
Sub Total 4,71,750.00 5,09,143.90 5,69,902.79 6,34,888.07
Less:Income Tax 0.00 0.00 0.00 0.00
Profit after Tax 4,71,750.00 5,09,143.90 5,69,902.79 6,34,888.07
PROJECTED BALANCE SHEET
Assets 31.3.2023 1 2 3
Fixed Assets:
Furnitures & Fixtures 1,00,000.00 90,000.00 81,000.00 72,900.00
Vehicle 50,000.00 42,500.00 36,125.00 30,706.25
Machinary 1,50,000.00 1,27,500.00 1,08,375.00 92,118.75

Sub Total 3,00,000.00 2,60,000.00 2,25,500.00 1,95,725.00

Current assets:
Stocks 2,63,220.00 2,89,542.00 3,18,496.20 3,50,345.82
Receivables 1,50,770.00 1,65,847.00 1,82,431.70 2,85,674.87
Cash/Bank 19,045.00 21,185.68 40,441.03 44,485.13
Advance payments 150000.00 1,59,322.96 -
Other Current Assets 262836.00 2,65,464.36 3,72,507.60 4,17,208.51
Deposits/Inv. 400000.00 400000.00 4,90,000.00 3,97,601.83
Sub Total 12,45,871.00 13,01,362.00 14,03,876.52 14,95,316.16
Total 15,45,871.00 15,61,362.00 16,29,376.52 16,91,041.16
Liability
Capital 3,50,000.00 8,21,750.00 8,80,893.90 9,55,796.69
Add:Profit after tax 4,71,750.00 5,09,143.90 5,69,902.79 6,34,888.07
Additions 0.00 - - -
Less:Drawings 4,50,000.00 4,95,000.00 4,99,950.00
Total 8,21,750.00 8,80,893.90 9,55,796.69 10,90,734.76

Loans:
Term Loan 451000.00 3,97,035.00 3,48,767.00 3,06,950.00
Bank O/D 1,70,000.00 1,70,000.00 1,70,000.00 1,70,000.00
Current Liabilities:
Sundry Creditors 53,856.00 59,241.60 95,202.18 1,04,722.40
Salary payable 14,000.00 15,400.00 16,940.00 18,634.00
Other Payables 35,265.00 38,791.50 42,670.65
Sub Total 1,03,121.00 1,13,433.10 1,54,812.83 1,23,356.40
Total 15,45,871.00 15,61,362.00 16,29,376.52 16,91,041.16

You might also like