Suppose we want to put the following data into the appropriate income statement format: Revenues 50000 Expenses

Question:

Suppose we want to put the following data into the appropriate income statement format:

Revenues 50000 Expenses Cost of Goods Sold 20000 Research and Development Expenses 10000 Selling, General, and Administrative Expenses 10000 Interest Expense 3000 Required:
1.. Add a comma as a 1000 separator for each number.
2.. Insert the words Total Expenses below the list of expenses.
3.. Calculate subtotal for Total Expenses using the SUM() command.
4.. Insert a single bottom border under Interest Expense and under the Total Expenses subtotal.
5.. Insert the words Net Income, and calculate Net Income (Revenues –
Total Expenses).
6.. Format the top and bottom numbers of the column with a $ currency sign.
7.. Insert a Bottom Double Border to underline the final Net Income total.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

ISE Data Analytics For Accounting

ISBN: 9781265094454

3rd Edition

Authors: Ryan A. Teeter, Vernon Richardson, Katie L. Terrell

Question Posted: