rona.xlsx
RONA
| | Sales Revenue |
| | $400 | | Gross Margin |
| | - | | $150 |
| | Cost of Goods Sold |
| | $250 | | | | Profit |
| | | | - | | $20 | | Net Profit Margin |
| | | | | | ÷ | | 5.00% |
| | | | | | Sales Revenue | | (Net Profit ÷
Net Sales) |
| | | | Total
Op. Expenses | | $400 |
| | | | $130 | | | | | | Return
on Assets |
| | | | | | | | x | | 8.00% |
| | | | | | | | Asset Turnover |
| | | | | | ÷ | | 1.60 |
| | Other current assets |
| | $20 |
| | + |
| | Accounts Receivable | | Current Assets |
| | $75 | | $195 | | Total Assets |
| | + | | + | | $250 |
| | Inventory | | Fixed Assets |
| | $100 | | $55 |
3% Increase
| | Sales Revenue |
| | $412 | | Gross Margin |
| | - | | 154.50 |
| | Cost of Goods Sold |
| | 257.50 | | | | Profit |
| | | | - | | $25 | | Net Profit Margin |
| | | | | | ÷ | | 6.13% |
| | | | | | Sales Revenue | | (Net Profit ÷
Net Sales) |
| | | | Total
Op. Expenses | | $400 |
| | | | $130 | | | | | | Return
on Assets |
| | | | | | | | x | | 9.80% |
| | | | | | | | Asset Turnover |
| | | | | | ÷ | | 1.60 |
| | Other current assets |
| | $20 |
| | + |
| | Accounts Receivable | | Current Assets |
| | $75 | | $195 | | Total Assets |
| | + | | + | | $250 |
| | Inventory | | Fixed Assets |
| | $100 | | $55 |
3% Decrease
| | Sales Revenue |
| | $412 | | Gross Margin |
| | - | | 162.00 |
| | Cost of Goods Sold |
| | 250.00 | | | | Profit |
| | | | - | | $32 | | Net Profit Margin |
| | | | | | ÷ | | 8.00% |
| | | | | | Sales Revenue | | (Net Profit ÷
Net Sales) |
| | | | Total
Op. Expenses | | $400 |
| | | | $130 | | | | | | Return
on Assets |
| | | | | | | | x | | 12.80% |
| | | | | | | | Asset Turnover |
| | | | | | ÷ | | 1.60 |
| | Other current assets |
| | $20 |
| | + |
| | Accounts Receivable | | Current Assets |
| | $75 | | $195 | | Total Assets |
| | + | | + | | $250 |
| | Inventory | | Fixed Assets |
| | $100 | | $55 |
10% Reduced Inv.
| | Sales Revenue |
| | $412 | | Gross Margin |
| | - | | 162.23 |
| | Cost of Goods Sold |
| | 249.77 | | | | Profit |
| | | | - | | $32 | | Net Profit Margin |
| | | | | | ÷ | | 8.06% |
| | | | | | Sales Revenue | | (Net Profit ÷
Net Sales) |
| | | | Total
Op. Expenses | | $400 |
| | | | $130 | | | | | | Return
on Assets |
| | | | | | | | x | | 13.43% |
| | | | | | | | Asset Turnover |
| | | | | | ÷ | | 1.67 |
| | Other current assets |
| | $20 |
| | + |
| | Accounts Receivable | | Current Assets |
| | $75 | | $185 | | Total Assets |
| | + | | + | | $240 |
| | Inventory | | Fixed Assets |
| | $90 | | $55 |
RONA #6
| | Sales Revenue |
| | $400 | | Gross Margin |
| | - | | $150 |
| | Cost of Goods Sold |
| | $250 | | | | Profit |
| | | | - | | $20 | | Net Profit Margin |
| | | | | | ÷ | | 5.00% |
| | | | | | Sales Revenue | | (Net Profit ÷
Net Sales) |
| | | | Total
Op. Expenses | | $400 |
| | | | $130 | | | | | | Return
on Assets |
| | | | | | | | x | | 8.00% |
| | | | | | | | Asset Turnover |
| | | | | | ÷ | | 1.60 |
| | Other current assets |
| | $20 |
| | + |
| | Accounts Receivable | | Current Assets |
| | $75 | | $195 | | Total Assets |
| | + | | + | | $250 |
| | Inventory | | Fixed Assets |
| | $100 | | $55 |