| Independent | Total Revenues | Total Expenses | Net Income | Total Assets | Total Liabilities | Stockholder's |
| Companies | Equity | |||||
| A | $ 3,200,300 | $ 790,000 | $ 2,410,300 | $ 745,480 | $ 255,480 | $ 490,000 |
| B | $ 351,300 | $ 60,300 | $ 291,000 | $ 796,900 | $ 542,800 | $ 254,100 |
| C | $ 1,174,030 | $ 873,200 | $ 300,830 | $ 1,000,200 | $ 590,000 | $ 410,200 |
| D | $ 370,900.00 | $ 274,800.00 | $ 96,100.00 | $ 962,000.00 | $ 289,100.00 | $ 672,900.00 |
| Explanation | ||||||
| 1 | Net income = Total revenues - Total expenses | |||||
| 2 | Total assets = Total Liabilities + Stockholder's equity | |||||
| 3 | Total Expenses = Total revenues - Net income | |||||
| 4 | Total Liabilities = Total Assets - Stockholder's equity | |||||
| 5 | Total Revenues = Total Expenses + Net income | |||||
| 6 | Stockholder's equity = Total Assets - Total Liabilities | |||||
Part 1: Fill in the blanks below. Utilize the relationships on the Income Statement and Balance...
HOMEWORK #1 Due January 17, 5:00 pm 10 points Provide your solution to all 3 parts of the assignment in the space provided under each worksheet. Be sure to use the power of Excel (e.g., use Excel formulas to calculate sums and differences and refer to cells) in all situations. Do not use a calculator nor type in any numbers to the extent it is avoidable. Part 1: Fill in the blanks below. Utilize the relationships on the Income Statement...
I need some help understanding. thank you
File Home Insert Page Layout Formulas Data Review View Developer Help Share Commen AA 0 Custom PAE 15 A === F a Wrap Text Merge & Center D Times New Roman BIU A Font Insert elete - E J 48 0 Sort & Find & Filter Select 4 Ideas Pastel $ % | Sensitivity Conditional Format as Cell Formatting Table Styles Styles Format Clipboard Alignment Number Cells Editing Ideas Sensitivity F8 - x...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets for both companies. Note: Use "Total Sales" and "Total Assets" as the denominators for income statement and balance sheet, respectively. Compute for 2018, 2017, and 2016. (2) Prepare horizontal analysis on income statements and balance sheets for both companies. (3) Prepare ratio analyses (for 2018, 2017, and 2016) for both companies. You should include the following ratios in your computations: Profitability ratios o Gross...