RONA Spreadsheet

D

Dan

I am in need of an Excel speadsheet that will calculate my company financal
RONA or "Return on Net Asset"
 
B

Brad

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells 14
Excel - Cross Check 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Student & Home? 1
where is my category? 1
Automatic creation of rows with various permutations of few columnvalues list 0
Where do I get the swivel command for custom emphasis effects in . 1
Need Help with Macro Security 1

Top