Scribd
Upload
5 views3 pages

Monthly Financial Overview 2024

The document outlines a detailed financial report for a business, including monthly sales, expenses, and cash flow estimates for the fiscal year 2024-25. It highlights various expense categories such as labor charges, direct expenses, and interest payments, along with projected cash inflows from debtors. The total sales amount to Rs. 42,800.00, while total expenses and liabilities are also detailed, indicating the financial health of the business over the specified period.

Uploaded by

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

Monthly Financial Overview 2024

The document outlines a detailed financial report for a business, including monthly sales, expenses, and cash flow estimates for the fiscal year 2024-25. It highlights various expense categories such as labor charges, direct expenses, and interest payments, along with projected cash inflows from debtors. The total sales amount to Rs. 42,800.00, while total expenses and liabilities are also detailed, indicating the financial health of the business over the specified period.

Uploaded by

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

Amount in Rs.

(Lakhs)
EXPENSES Mar-24 APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBRAURAY MARCH TOTAL

SALE 2,500.00 2,800.00 3,000.00 3,800.00 3,500.00 3,200.00 3,700.00 3,100.00 4,000.00 4,200.00 3,900.00 5,100.00 42,800.00 29,600.00
Interest income - - - - - - - - - - - - -

EXPENSES
LABOUR CHARGES 1,097.00 1,228.64 1,316.40 1,667.44 1,535.80 1,404.16 1,623.56 1,360.28 1,755.20 1,842.96 1,711.32 2,236.18 18,778.94 2,086.55 12,988.48
DIRECT EXPENSES 121.50 136.08 145.80 184.68 170.10 155.52 179.82 150.66 194.40 204.12 189.54 249.05 2,081.27 1,438.56
POWER & FUEL EXP 179.00 200.48 214.80 272.08 250.60 229.12 264.92 221.96 286.40 300.72 279.24 366.99 3,066.31 2,119.36
WAGES TOTAL 1,097.00 1,228.64 1,316.40 1,667.44 1,535.80 1,404.16 1,623.56 1,360.28 1,755.20 1,842.96 1,711.32 2,236.18 21,845.25 ### 16,054.79

2,495.52
INTEREST on Term loans 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.34 377.18 282.96 447.45
Interest on Bitumen - - 2,048.07
Interest on OD - -
Interest on recovery of advances - -
Bank Charges - -
TOAL INTEREST 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.44 31.34 377.18 282.96
SELLING & ADMINSTRATIVE EXP 23.00 25.76 27.60 34.96 32.20 29.44 34.04 28.52 36.80 38.64 35.88 48.32 395.16 387.26 272.32
-
PURCHASE 887.50 994.00 1,065.00 1,349.00 1,242.50 1,136.00 1,313.50 1,100.50 1,420.00 1,491.00 1,384.50 1,809.65 15,193.15 10,508.00
106.50 71.00 284.00 - 106.50 - 106.50 177.50 - 213.00 319.50 71.00 - 106.50 425.15 922.15 532.50
- -
LIABILITES - -
OD ACCOUNT 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 1,900.00 -3,800.00
INCREASED /DECREASED OD - - - - - - - - - - - - - -
SECURED LOAN 2,618.15 2,643.20 2,642.66 2,642.12 2,641.58 2,641.04 2,640.50 2,639.96 2,639.42 2,638.88 2,638.34 2,637.80 2,637.24 2,637.24 -5,276.14
INCREASED /DECREASED SECURED 25.05 - 0.54 - 0.54 - 0.54 - 0.54 - 0.54 - 0.54 - 0.54 - 0.54 - 0.54 - 0.54 - 0.56 19.09 20.73
UNSECURED LOAN 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 - -
INCREASED /DECREASED UNSECURED - - - - - - - - - - - - - -
CURRENT LIABILITES 3,305.06 3,284.99 3,264.92 3,244.85 3,224.78 3,204.71 3,184.64 3,164.57 3,144.50 3,124.43 3,104.36 3,084.29 3,064.18 3,064.18 -6,188.65
INCREASED /DECREASED CURRENT LIABILITES - 20.07 - 20.07 - 20.07 - 20.07 - 20.07 - 20.07 - 20.07 - 20.07 - 20.07 - 20.07 - 20.07 - 20.11 - 240.88 -180.63
FIXED ASSETS 4,033.63 4,103.63 4,173.63 4,243.63 4,313.63 4,383.63 4,453.63 4,523.63 4,593.63 4,663.63 4,733.63 4,803.63 4,836.45 4,836.45 - 9,537.26
INCREASED /DECREASED PURCHASED 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 32.82 802.82 630.00
NON CURRENT ASSETS - -
Investments 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.30 -24.60
-
-
TOTAL NON C/A 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 12.3 147.60 110.70
INCREASED /DECREASED NON CURRENT ASSETS - - - - - - - - - - - - - -
CASH Balance 4.5 4.37 4.24 4.11 3.98 3.85 3.72 3.59 3.46 3.33 3.20 3.07 2.94 2.94 -6.27
Bank Balance 233.32 233.45 233.58 233.71 233.84 233.97 234.10 234.23 234.36 234.49 234.62 234.75 234.88 234.88 -469.37
TOTAL CASH & BANK BALANCE 237.82 237.82 237.82 237.82 237.82 237.82 237.82 237.82 237.82 237.82 237.82 237.82 237.82 237.82 - 475.64
NET BALANCES -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 -1662.18 - 19,946.16 ###
- -
CURRENT ASSETS - -
STOCK 3,750.00 3827.20 3904.40 3981.60 4058.80 4136.00 4213.20 4290.40 4367.60 4444.80 4522.00 4599.20 4676.43 4,676.43 -9,121.20
ADVANCES - - - - - - - - - - - - - - -
SECURITIES - - - - - - - - - - - - - - -
OTHER CURRENT ASSETS 7,593.53 7,679.10 7,764.67 7,850.24 7,935.81 8,021.38 8,106.95 8,192.52 8,278.09 8,363.66 8,449.23 8,534.80 8,596.35 8,596.35 ###
ADVANCE PAYMENT TO SUPPLIERS 0 - - - - - - - - - - - - - -
- -
-
-
-
TOTAL CURRENT ASSETS 11343.53 11506.3 11669.07 11831.84 11994.61 12157.38 12320.15 12482.92 12645.69 12808.46 12971.23 13134 13272.78 13,272.78
INCREASED /DECREASED CURRENT ASSETS 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 138.78 1,929.25
-
- 0 0 0 0 0 0 0 0 0 0 0 -
-
-
-
DEBTORS 4,175.99 4,108.14 4,002.92 3,951.79 4,066.88 3,977.21 3,984.45 4,023.42 3,906.04 3,739.69 3,987.09 3,933.77 4,384.79 4,384.79
CREDITORS 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
-
SALE RELEASTION 2,567.85 2,905.22 3,051.13 3,684.91 3,589.67 3,192.76 3,661.03 3,217.38 4,166.35 3,952.60 3,953.32 4,648.98 42,591.20
PURCHASE PAYMENTS 887.50 994.00 1,065.00 1,349.00 1,242.50 1,136.00 1,313.50 1,100.50 1,420.00 1,491.00 1,384.50 1,809.65 15,193.15
-
-
-
-
op debtor/cred 4,175.99 1,000.00 5,175.99
42,800.00 15,193.15
TOTAL 46975.99 16,193.15
4,384.79 1,000.00
SALE REALI 42591.2
PURCH REALISATION 15,193.15
ADVANCE PAYAMENT
FY 2024-25
CASH FLOW ESTIMATION
[Link] Particulars Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25
Opening cash flow -1,662.18 -1,661.56 -1,626.12 -1,629.41 -1,737.48 -1,663.83 -1,710.13 -1,749.76 -1,679.12 -1,667.57 -1,700.05 -1,632.03
A) Cash Inflow
1 Receipt From Debtors 2,567.85 2,905.22 3,051.13 3,684.91 3,589.67 3,192.76 3,661.03 3,217.38 4,166.35 3,952.60 3,953.32 4,903.65
2 Receipt from other Income - - - - - - - - - - - -
3 Capital Infusion/Advances
4 Receipt from current assets other than
debtors and cash and bank balance

Total Cash InFlow (A) 905.67 1,243.66 1,425.01 2,055.50 1,852.19 1,528.93 1,950.90 1,467.62 2,487.23 2,285.03 2,253.27 3,271.62
B) Cash Outflow
1 Payment to Creditors 887.50 994.00 1,065.00 1,349.00 1,242.50 1,136.00 1,313.50 1,100.50 1,420.00 1,491.00 1,384.50 1,809.65
2 Power & Fuel 179.00 200.48 214.80 272.08 250.60 229.12 264.92 221.96 286.40 300.72 279.24 366.99
3 Labour /subcontractor Payments 1,097.00 1,228.64 1,316.40 1,667.44 1,535.80 1,404.16 1,623.56 1,360.28 1,755.20 1,842.96 1,711.32 2,236.18
4 Other direct expenses 121.50 136.08 145.80 184.68 170.10 155.52 179.82 150.66 194.40 204.12 189.54 249.05
5 Selling & Adminstrative Expenses 23.00 25.76 27.60 34.96 32.20 29.44 34.04 28.52 213.98 -138.54 35.88 48.32
6 withdrawal during the year
7 Payment of Taxes & liability 20.07 20.07 20.07 20.07 20.07 20.07 20.07 20.07 20.07 20.07 20.07 20.11
8 Increase in EMD , Deposit & advances 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 162.77 138.78
9 Purchase of Fixed Assets 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 70.00 32.82
10 Paymet towards BG Margin - - - - - - - - - - - -
11 Bank Interest and Bank TL Repayments 6.39 31.98 31.98 31.98 31.98 31.98 31.98 31.98 31.98 31.98 31.98 31.90
Total Cash OutFlow (B) 2,567.23 2,869.78 3,054.42 3,792.98 3,516.02 3,239.06 3,700.66 3,146.74 4,154.80 3,985.08 3,885.30 4,933.80
GAP FUNDING REQUIRED-C (A-B) -1,661.56 -1,626.12 -1,629.41 -1,737.48 -1,663.83 -1,710.13 -1,749.76 -1,679.12 -1,667.57 -1,700.05 -1,632.03 -1,662.18

1,662.18

You might also like