Final dividend calculation
This query is : Resolved
19 May 2025
Hi Everyone
Can anyone pls share a dividend calculation excel template to calculate final dividend to be paid by a private limited company. Need a bit urgently.
Thanks a lot.
Can anyone pls share a dividend calculation excel template to calculate final dividend to be paid by a private limited company. Need a bit urgently.
Thanks a lot.
24 May 2025
Main Dividend Calculation Table
Particulars Amount (INR) Remarks
Net Profit After Tax (PAT) = As per Profit & Loss Statement
Retained Earnings (if any) = Optional – Previous year profits
Total Amount Available for Dividend = PAT + Retained Earnings
Proposed Dividend Rate (%) = e.g., 10%
Number of Equity Shares = e.g., 10,000
Dividend Per Share (INR) = Dividend Rate × FV FV = Face Value of Share (e.g., ₹10 or ₹100)
Total Dividend Payable = No. of Shares × Dividend Per Share
Dividend Distribution Tax (DDT) Not applicable Abolished post 2020
Total Outflow for Company = Total Dividend Payable
Particulars Amount (INR) Remarks
Net Profit After Tax (PAT) = As per Profit & Loss Statement
Retained Earnings (if any) = Optional – Previous year profits
Total Amount Available for Dividend = PAT + Retained Earnings
Proposed Dividend Rate (%) = e.g., 10%
Number of Equity Shares = e.g., 10,000
Dividend Per Share (INR) = Dividend Rate × FV FV = Face Value of Share (e.g., ₹10 or ₹100)
Total Dividend Payable = No. of Shares × Dividend Per Share
Dividend Distribution Tax (DDT) Not applicable Abolished post 2020
Total Outflow for Company = Total Dividend Payable
Message likes :
1 times
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CAPITAL GAIN REDEVELOPED FLAT
- Requirement under FEMA &RBI
- CLOSING STOCK QUERY
- GST ISD Query on various AMCs
- Technical Glitch in ITR-4 Online Form (AY 2026-27): Sec 44AE Partner Remuneration not mapping to E8
- Residential status of non resident
- Short Term Gain Reporting ITR
- F&O reporting in ITR
- Itr processing refund
- Gst reverse charge mechanism to be claimed in the month of payment
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
- Query regarding reporting of exempt foreign remuneration in ITR (AY 2026-27)
- FEMA/RBI treatment — Amazon.ca arbitrage (US buy, Canada sell, goods never enter India)
- Goods return by customer
- INWARD REMITTANCE FOREIGN
- CPC and SAC
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
