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)

Transcribed Image Text:

Division East North South West Operating Income Average Total Assets Net Sales Revenue $1,580,000.00 $ 12,000,750.00 $25,900,000.00 650,000.00 4,875,000.00 6,337,500.00 275,050.00 995,090.00 855,770.00 2,300,000.00 13,800,000.00 9,200,000.00 Profit Margin Asset Turnover Ratio Ratio Return on Investment (ROI)