Prev: Average with Conditions
Next: count of number of rows within a range with a certain text
From: Dan on 13 May 2010 11:52
I am in need of an Excel speadsheet that will calculate my company financal
RONA or "Return on Net Asset"
From: Brad on 13 May 2010 15:06
From answer.com

The return on net assets (RONA) is a measure of financial performance of a
company which takes the use of assets into account.

Profit after tax / ( Fixed assets + working capital )

Therefore you need the three items above

if
(Profit after tax) is in A1
(Fixed assets) is in A2
and
(working capital) is in A3

Then the equation is =a1/(a2+a3)

--
Wag more, bark less


"Dan" wrote:

> I am in need of an Excel speadsheet that will calculate my company financal
> RONA or "Return on Net Asset"
 | 
Pages: 1
Prev: Average with Conditions
Next: count of number of rows within a range with a certain text