Question: Excel Assignment #7-Income Statement Using the below information, develop a multi-step income statement in the proper format. Note that subtotal date must be calculated.
Excel Assignment #7-Income Statement Using the below information, develop a multi-step income statement in the proper format. Note that subtotal date must be calculated. Earnings per share date it not needed. Note that not all of the information in the problem below is needed for the income statement. Port of the challenge is determining what is needed. For simplicity, use one column for all account or subtotal lobels and the second column for all amounts. No indentation or special formatting is required for any subtotal lines. You should not need any more lines than the ones included in the box below, and depending on how you decide to space each section you may not even need all of those lines. Cost of Goods Sold Provision for Income Taxes Interest expense Selling, General, and Administrative Expenses Net Soles Accounts Receivable Dividends Paid 480,770 15,270 33,780 236,960 775,430 24,540 13.100 Jensen and Co. Consolidated Income Statement For the Year Ending December 31, 2021
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
