I need to answer to these questions by using Excel functions.

As the accountant of Race Co., you have been requested to calculate (a) net sales, (b) cost of merchandise sold, (c) gross profit, and (d) net income from the following: gross sales, $40,000; sales returns, $3,000; beginning inventory, $6,000; net purchases, $8,000; ending inventory, $1,000; operating expenses, $9,200.

The total debt to total assets of the Rig Company was .33. The total of Rigs assets was $205,000. What is the amount of total debt to Rig Company?

The Moore Co. has a current ratio of 1.8. The acid-test ratio is 1.3. The current liabilities of Moore are $15,000. Calculate the dollar amount of merchandise inventory (assume no prepaid expenses).

The asset turnover of Jones Company in 7.1. The total assets of Jones are $68,000. What were Joness net sales?

Jim Smith received a memo requesting that he complete a trend analysis of the following using 2014 as the base year. Round each percent to nearest whole percent.

2011

2012

2013

2014

Sales

$660,000

$680,000

$720,000

$800,000

Gross profit

180,000

240,000

340,000

500,000

Net income