use excel

The following information is related to ALMA company: 1. ALMA company sold 1,500 units 2. Sales retun and alllowance is 150 units & sales discount is 120 units 3. The total purchases of ALMA company are KD 70,000, and purchases discount is 2% of total purchases. 4. The unit contribution is KD 100 and the unit variable cost is KD 250 5. Inventory from last year is KD 20,000, and inventory at the end of the current year is KD1,000 6. Purchases freight in cost is KD 3,000. 7. Marketing expenses are KD 5,000 8. Administrative and general expenses are 5% of total sales Required: Use the above information to prepare income statement for ALMA comnany