Prepare a profit and loss statement using the following values; complete

using excel format. $(15$pts$).$

Sales returns $$5,000$

Freight In $15,000$

Insurance expense $2,000$

Merchandise inventory

$7/1/2140,000$

Salary expense $25,000$

Interest expense $11,000$

Merchandise inventory

$6/30/2245,000$

Sales $270,000$

Supply expense $15,000$

Utility expense $15,000$

Advertising expense $10,000$

Delivery expense $15,000$

Travel expense $10,000$

Purchases $115,000$

Purchase returns&allow. $3,000$

how do i do this profit and loss statment on excel