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
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
14 October 2026
Asst. Manager/Dy Manager (Costing)

manufacturing

Pune

CMA

View Details
Company
13 October 2026
Accountant

Zerdi & Co. Chartered Accountants

Pune

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details