Solve By Excel and Please show me the Calculation Process Please

The R & T Manufacturing Company was very satisfied with their xxx1 performance. The company had only begun operations the prior year, and as a result, sales had been slow. However, things had picked up considerably in xxx1 with sales more than doubling in volume. R & T had changed none of its business practices during the year and had managed to hold its cost of goods sold to 78% of sales. All sales were made on credit, and payment was required within 30 days of the sale. The company paid for its purchases in 30 days and maintained a cash balance of 20% in sales. The only thing that had changed during the year was the companys inventory turnover, which had jumped from 3 to 6. While R & Ts management was enthusiastic about the companys increased level of sales, it was concerned about the possible necessity of increasing its short-term debt. In order to assess the situation, the company was in the process of completing the financial statements shown below. (Inv. Turn = C.O.G.S/Inv.)

Complete the forms given. For xxx1, use short-term Notes Payable as the balancing account (a plug).

1. Compare ROE, ROA, EM, PM, A/R turnover, inventory turnover, fixed asset turnover for the years xxxoand xxx1.

2. Build the common size income statements for years xxxo and xxx1.

	xxxo	xxx1
Income Statement:
Sales	1,500,000	3,060,000
Cost of goods sold	1,170,000
Gross margin	330,000
Other expenses	240,000	240,000
Profit before tax	90,000
Taxes @ 40%	36,000
Profit after tax	54,000
Balance sheet:
Cash	300,000
Accounts receivable	123,288
Inventory	390,000
Total current assets	813,288
Net property, plant and equipment	480,000	456,000
Total assets	1,293,288
Accounts payable	96,162
Short-term Notes Payable	183,126
Total current liabilities	279,288
Long-term debt	360,000	360,000
Common stock	600,000	600,000
Retained earnings	54,000
Total long-term debt and equity	1,014,000
Total liabilities and equity	1293,288
Net working capital:
Current assets
Current liabilities
Net working capital