Final dividend calculation
This query is : Resolved
SHALINI MENDIRATTA
(Querist)
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.
Ram Avtar Singh
(Expert)
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
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Accounting treatment of AMC alongwith the purchase of Laptop
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- Taxation of crypto futures in India Fy 2026- 2027
- Issuing of delivery challan by seller of goods
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- MSME disclosure and disallowance
- EPF ECR NEW RULES Sep 17th 2026
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
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
