Pane Taskpane Taske concouy Save and cu aproau mc worm TVICE O URALKOILU you wany downloaded it from (Course materials/ case study 1). Make sure that you upload your file before the due date (Monday, Sep 20h) following is the balance sheet for Excel Inc. for the year ended Dec 31st, 2018. . Consolidated Balance sheet Excel inc. As of Dec 31, 2018 Assets Current Assets Cash Accounts Receivables Inventory Total Current Assets 40,000 4,000 14,000 58,000 Liabilities + Owners Equity Current Liabilities Accounts Payable 12,000 Notes Payable 6,000 Accrue Wages 1000 Total Current Liabilities 19,000 Long term debt 40,000 56,000 Fixed Assets Property, Plant, and Equipment Goodwill Total Fixed Assets 24,000 80,000 Owners' equity Common Shares Retained Earnings Total Owners equity Liabilities + O.E 40,000 39,000 79,000 138,000 Total Assets 138.000 In addition to that, you know the following facts about firm's operations throughout the year: revenues for the year includes the following: Domestic revenues $160,000. International revenues $80,000. cost of sales and direct labor is 50% of annual revenues. ds TK English (United States If you are given the following information about the year ended Dec 2017 (previous year). Total assets = $120,000, Total Equity = $70,000, Sales = 150,000, Net income = $35,000 11- Calculate Excel's profitability (ROE) for year ended Dec 2017 a) 2 b) 1.5 c) 0.5 d) 1.7 12- Calculate Excel's profitability (ROE) for year ended Dec 2018. a) 0.47 b) 0.44 C) 0.27 d) 1.7 4 following is the balance sheet for Excel Inc. for the year ended Dec 31st 2018. Consolidated Balance sheet Excel inc. As of Dec 31, 2018 Assets Current Assets Cash Accounts Receivables Inventory Total Current Assets 40,000 4,000 14,000 58,000 Liabilities + Owners Equity Current Liabilities Accounts Payable 12,000 Notes Payable 6,000 Accrue Wages 1000 Total Current Liabilities 19,000 Long term debt 40,000 56,000 Fixed Assets Property, Plant, and Equipment Goodwill Total Fixed Assets 24,000 80,000 Owners' equity Common Shares Retained Earnings Total Owners equity Liabilities + O.E 40,000 39,000 79,000 138,000 Total Assets 138,000 In addition to that, you know the following facts about firm's operations throughout the year: revenues for the year includes the following: Domestic revenues $160,000. International revenues $80,000. cost of sales and direct labor is 50% of annual revenues. . Because of the strong competition that it faces, Excel Inc. has a generous marketing plan. They signed a contract with the marketing planet Inc. by which the marketing agency will be responsible for Excel Inc, marketing for five years period started this year. The contract costs Excel $100,000 that will be paid evenly over the next five years, the company thinks this plan will affect its sales evenly over the five years period. Excel Inc. also spends $30,000 in the form of general and administrative expenses per year. The depreciable assets historical value is $40,000 and is depreciated on a straight-line basis over 10 years. Excel nave 10% interact rote on ite Tonn tom doht In addition to that, you know the following facts about firm's operations throughout the year: revenues for the year includes the following: Domestic revenues $160,000. International revenues $80,000. cost of sales and direct labor is 50% of annual revenues. Because of the strong competition that it faces, Excel Inc. has a generous marketing plan. They signed a contract with the marketing planet Inc. by which the marketing agency will be responsible for Excel Inc, marketing for five years period started this year. The contract costs Excel $100,000 that will be paid evenly over the next five years, the company thinks this plan will affect its sales evenly over the five years period. Excel Inc. also spends $30,000 in the form of general and administrative expenses per year. The depreciable assets historical value is $40,000 and is depreciated on a straight-line basis over 10 years. Excel pays 10% interest rate on its Long-term debt outstanding. Excel pays 40% of its taxable income as tax expense. 1 . Out of the year's net income, Excel Inc. is planning to repay $30,000 to its shareholders in the form of cash dividends. The company currently has 60,000 shares outstanding Please set up the income statement for Excel Inc: . Out of the year's net income, Excel Inc. is planning to repay $30,000 to its shareholders in the form of cash dividends. The company currently has 60,000 shares outstanding Please set up the income statement for Excel Inc: Consolidated Income Statement Excel Inc. As of Dec 31st, 2018 Revenues (-) Cost of goods sold Gross margin (-) Marketing expenses (-) General and administrative expenses (-) Depreciation EBIT Interest expenses EBT (-) Tax expenses Net income Dividends Additions to Retained Earnings If you are given the following information about the year ended Dec 2017 (previous year). Total assets = $120,000, Total Equity = $70,000, Sales = 150,000, Net income = $35,000 11- Calculate Excel's profitability (ROE) for year ended Dec 2017 a) 2 b) 1.5 c) 0.5 d) 1.7 12- Calculate Excel's profitability (ROE) for year ended Dec 2018. a) 0.47 b) 0.44 c) 0.27 d) 1.7 4