Answer in Excel sheet and show the calculation. Pls do not copy paste from other source include your expert friend

Centennial Exchange of St. Louis, Missouri, imports and exports grains. The company has a September 30 fiscal year-end. The periodic inventory system and the weightedaverage cost flow method are used by the company to account for inventory cost. The company negotiated the following transactions during 2019 (assume forward contracts exist for the krone and forint).

Sept. 1 Sold 1,000,000 bushels of wheat to a Norwegian company for 16,500,000 krone. The account is to be settled on October 30.

Sept. 1 The management of Centennial was concerned that the krone would decline in value. They therefore entered into a forward contract to sell 16,500,000 Krone on October 30 for $.1442 per krone.

Sept. 5 Sold 1,000,000 bushels of wheat to a Tokyo company for $5,300,000. The account is to be settled on November 5.

Sept. 15 Purchased grain from an exporting company that operates in Hungary. The contract provides for the payment of 20,000,000 forint on October 15.

Sept. 15 Entered into a forward contract to buy 20,000,000 forint on October 15 for $.006490 per Forint.

Sept. 18 Sold 500 tons of soybean meal to Able & Born, Ltd., a Toronto company, for 48,000 Canadian dollars. The account is to be settled on December 17.

Oct. 15 Completed the forward contract to buy 20,000,000 forint and then submitted payment to pay for the grain purchased on September 15.

Oct. 30 Received 16,500,000 Krones from the Norwegian customer and settled forward contract.

Nov. 5 Received payment in full for the wheat sold on September 5 to the Tokyo company.

Dec. 17 Received payment from Able & Born, Ltd. for the September 18 sale.

Direct exchange quotations for specific dates are presented below:

	NorwayKrone	JapanYen	HungaryForint	CanadaDollar
September 1	$.1480	$.00738	$.006427	$.8250
September 5	.1458	.00740	.006428	.8248
September 15	.1456	.00741	.006430	.8246
September 18	.1456	.00737	.006431	.8245
September 30	.1455	.00736	.006433	.8243
October 15	.1458	.00734	.006435	.8241
October 30	.1457	.00732	.006370	.8241
November 5	.1456	.00730	.006439	.8244
December 17	.1453	.00731	.006438	.8250

On September 30, the forward rate for krone (with an October 30 settlement) was $.1450 and the forward rate for forints (with an October 15 settlement) was $.00640.

Required:

Prepare journal entries, including year-end adjustments, to record the above transactions.