want to make balance sheet and income statement and ratio of this question please help me.

ni (Body) IU 1. A A A A X X A.2.AE A ABC ABCD AaBb AaBbcc AaB Normal No Spac... Heading! Heading 2 Tele E Paragraph For all requirements, be sure to show all your work, including all inputs for calculated amounts (eg, subtotals, ratios, and other formulas), so that I can award partial credit for any responses you may get incorrect. 1) In a Microsoft Excel workbook, and using the information provided for The Wolf Hotel in Appendix A, prepare the following: a) The Wolf Hotel's balance sheets at December 31, 2019, December 31, 2018, and December 31, 2017 (Remember your assets should equal your liabilities plus stockholder's equity!). b) At the bottom of the balance sheet, calculate the networking capital for all three years. c) The Wolf Hotel's income statement years ended December 31, 2019 and December 31, 2018. d) in completing (a) and (bl your financial statements must include headings as well as subtotals for each of the following: 0) Current assets and current liabilities ) Total assets, total liabilities, and total shareholders' equity ii) EBIT, taxable for "pretax income, and net income 2) At the bottom of the income statement, calculate the average tax rate, cash flow and after tax net income for the years ended December 31, 2019 and December 31, 2018 3) in the Same Microsoft Excel workbook, complete a ratio analysis for the Wolf Hotel for all the ratios listed below. Use the information from (1) above to calculate 2019 and 2018 ratios. For each ratio, discuss what the ratio is telling us and if the ratios have improved or worsened from the prior year. If ratios include both an income statement number and a balance sheet number, then you can assure we are using the average balance sheet method for calculating the ratios. a) Performance Market Capitalization Market Value Added ) Market-to-Book Ratio b) Profitability Return on Capital Return on Assets Return on Equity Paragraph MAN 225 Financial Statements Project c) Efficiency i) Asset Turnover ii) Receivables Turnover I) Average Collection Period iv) Inventory Turnover v) Average Days in Inventory vi) Profit Margin d) Leverage i) Long-term Debt Ratio ii) Long-term Debt to Equity Ratio ili) Total Debt Ratio iv) Times Interest Earned v) Cash Coverage Ratio e) Liquidity i) Net Working Capital to Assets i) Current Ratio iil) Quick Ratio iv) Cash Ratio How View Help Grammarly Search ** A. AE . IT Thomas Heating! Heading 2 . T Font Style The Wolf Hotel - Datasheet As of and for the Years Ended Total Sales Other current liabilities Selling expenses Accounts receivable, net Long term debt Property, plant, and eglupment, net General and administrative expenses Retained earnings other operating expenses Inventories Interest expense Depreciation expreses Intangible assets Cost of goods sold Other long term assets Accounts payable Cach Short-term debt Common stock and paid in capital Other current assets December 31, 2019 December 31, 2018 December 31, 2017 16,689,000 16.285.000 661,000 585,000 725.000 859.000 736.000 791,000 740,000 710.000 2,700,000 2,900,000 3.100.000 2,850,000 2093,800 1,934.400 4,654,000 4,482.000 1.163.000 263,800 229.000 423,000 415,000 430,000 410,000 375,000 254,000 273,000 756,000 935,000 1.549,000 1.549.000 1.549.000 9,150,000 8,613,000 455.000 425.000 433 000 1,319,000 1.218.000 1,161,000 2.716.000 3.123,000 3.055.000 1,300,000 1230.000 2.000.000 2,000,000 2.000.000 355,000 35,000 345.000 Taxable income, $ Tax Rate, % 0-50,000 50,001-75,000 75,001-100,000 Over 100,000 ni (Body) IU 1. A A A A X X A.2.AE A ABC ABCD AaBb AaBbcc AaB Normal No Spac... Heading! Heading 2 Tele E Paragraph For all requirements, be sure to show all your work, including all inputs for calculated amounts (eg, subtotals, ratios, and other formulas), so that I can award partial credit for any responses you may get incorrect. 1) In a Microsoft Excel workbook, and using the information provided for The Wolf Hotel in Appendix A, prepare the following: a) The Wolf Hotel's balance sheets at December 31, 2019, December 31, 2018, and December 31, 2017 (Remember your assets should equal your liabilities plus stockholder's equity!). b) At the bottom of the balance sheet, calculate the networking capital for all three years. c) The Wolf Hotel's income statement years ended December 31, 2019 and December 31, 2018. d) in completing (a) and (bl your financial statements must include headings as well as subtotals for each of the following: 0) Current assets and current liabilities ) Total assets, total liabilities, and total shareholders' equity ii) EBIT, taxable for "pretax income, and net income 2) At the bottom of the income statement, calculate the average tax rate, cash flow and after tax net income for the years ended December 31, 2019 and December 31, 2018 3) in the Same Microsoft Excel workbook, complete a ratio analysis for the Wolf Hotel for all the ratios listed below. Use the information from (1) above to calculate 2019 and 2018 ratios. For each ratio, discuss what the ratio is telling us and if the ratios have improved or worsened from the prior year. If ratios include both an income statement number and a balance sheet number, then you can assure we are using the average balance sheet method for calculating the ratios. a) Performance Market Capitalization Market Value Added ) Market-to-Book Ratio b) Profitability Return on Capital Return on Assets Return on Equity Paragraph MAN 225 Financial Statements Project c) Efficiency i) Asset Turnover ii) Receivables Turnover I) Average Collection Period iv) Inventory Turnover v) Average Days in Inventory vi) Profit Margin d) Leverage i) Long-term Debt Ratio ii) Long-term Debt to Equity Ratio ili) Total Debt Ratio iv) Times Interest Earned v) Cash Coverage Ratio e) Liquidity i) Net Working Capital to Assets i) Current Ratio iil) Quick Ratio iv) Cash Ratio How View Help Grammarly Search ** A. AE . IT Thomas Heating! Heading 2 . T Font Style The Wolf Hotel - Datasheet As of and for the Years Ended Total Sales Other current liabilities Selling expenses Accounts receivable, net Long term debt Property, plant, and eglupment, net General and administrative expenses Retained earnings other operating expenses Inventories Interest expense Depreciation expreses Intangible assets Cost of goods sold Other long term assets Accounts payable Cach Short-term debt Common stock and paid in capital Other current assets December 31, 2019 December 31, 2018 December 31, 2017 16,689,000 16.285.000 661,000 585,000 725.000 859.000 736.000 791,000 740,000 710.000 2,700,000 2,900,000 3.100.000 2,850,000 2093,800 1,934.400 4,654,000 4,482.000 1.163.000 263,800 229.000 423,000 415,000 430,000 410,000 375,000 254,000 273,000 756,000 935,000 1.549,000 1.549.000 1.549.000 9,150,000 8,613,000 455.000 425.000 433 000 1,319,000 1.218.000 1,161,000 2.716.000 3.123,000 3.055.000 1,300,000 1230.000 2.000.000 2,000,000 2.000.000 355,000 35,000 345.000 Taxable income, $ Tax Rate, % 0-50,000 50,001-75,000 75,001-100,000 Over 100,000