Json not generate ITR file from Excel

I had maney times try to generate json file from Excel itr form, but not generate, what to do, please guide me
Replies (3)
Quick Summary
This discussion addresses issues encountered when trying to generate a JSON file for Income Tax Return (ITR) from Excel. While the initial query is about generating the JSON file, the conversation expands to include explanations of financial calculations. These include formulas for average capital employed, dividend per share (DPS), dividend payout ratio, book value, and market value. The provided answers detail how to calculate each of these metrics using financial statement data.

Which assessment year?

@ honourable Dhirajlal Lal rambhia sir


what is the formula to find out average capital employed??

1.how to find out dividend per share ?? in financial statement consolidate

2.dividend payout ratio how to find out??

3.book value and market values how to find out ??

A.   Invested Capital Formula = Total Debt (Including Capital Lease) + Total Equity & Equivalent Equity Investments + Non-Operating Cash...

B.  Dividend per share (DPS) is the sum of declared dividends issued by a company for every ordinary share outstanding.  DPS is calculated by dividing the total dividends paid out by a business, including interim dividends, over a period of time, usually a year, by the number of outstanding ordinary shares issued. 

C   The dividend payout ratio is the proportion of earnings paid out as dividends to shareholders, typically expressed as a percentage.   Dividend Payout Ratio= Net Income / Dividends Paid​​.

D.  The book value literally means the value of a business according to its books or accounts, as reflected on its financial statements. Theoretically, it is what investors would get if they sold all the company's assets and paid all its debts and obligations. Therefore, book value is roughly equal to the amount stockholders would receive if they decided to liquidate the company.

The market value represents the value of a company according to the stock market. It is the price an asset would get in the marketplace. In the context of companies, market value is equal to market capitalization. It is a dollar amount computed based on the current market price of the company's shares.

Market value—also known as market cap—is calculated by multiplying a company's outstanding shares by its current market price.

Market cap of a company=Current market price (per share)∗Total number of outstanding shares

 

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
Featured 11 September 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details
Company
30 September 2026
Senior Accountant

Codeboard Technology

Chennai

B.Com

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 01 October 2026
Articled Assistant

KPSN & Associates LLP

Chennai

CA Inter

View Details