ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   RONA Spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/263735-rona-spreadsheet.html)

dan

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

Brad

RONA Spreadsheet
 
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"



All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com