Download an Excel template for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren.
The US Solar Company has data for the four divisions for the year, and wants the results for the three specified key performance indicators (KPIs).

Requirements
1. Create an Excel table from the data.
2. Rename the table as Solar_KPI
3. Select another table style for the table.
4. Use table arithmetic for the formulas (rounded to three decimal places) for
a. Profit Margin Ratio
b. Asset Turnover Ratio
c. Return on Investment (ROI)