Managerial Accounting:
Potter486
ch_11_garrison_15e_applying_excel_student_form.xlsxChapter 11 Form
| 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 | ? |
1
2
3
4
5
6
7
8
9
10
11
A
B
Chapter 11: Applying Excel
Data
Sales
$2,50,00,000
Net operating income
$30,00,000
Average operating assets
$1,00,00,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
