Ch 11 Student Form by neZV4w

VIEWS: 40 PAGES: 1

									                                    b82c048e-bf33-4332-b36f-7a5061911d01.xls
Chapter 11: Applying Excel

Data
Sales                                $25,000,000
Net operating income                  $3,000,000
Average operating assets             $10,000,000
Minimum required rate of return             25%

Enter a formula into each of the cells marked with a ? below
Review Problem: Return on Investment (ROI) and Residual Income

Compute the ROI
Margin                                         ?
Turnover                                       ?
ROI                                            ?

Compute the residual income
Average operating assets                      ?
Net operating income                          ?
Minimum required return                       ?
Residual income                               ?




                                                     Page 1

								
To top