a-d using excel with formulas

Hard Rock Co's tecument Sales Cost of Goods Sold Gran Profile Selling and G&A Expenses Depreciation ERIT Interest Expense Earnings Before Texas Taxes Net Income 7,250,000 5400,000 1.250,000 95.000 350,000 335,000 130000 205,000 71.750 6,750,000 $310.000 1.420,00 32.000 550.000 230,000 110.000 12000 4,900 Notes: Tax Rate Share Outstanding Earnings per Share Dividends per Share Addition to RE per Share Dividend Payout Ratio 0.35 75.000 1.78 0.89 0.89 5096 0.362 65,000 1.12 0.73 0.49 60% Hard Rock Co's Balance Sheet Cash Account Receivable Inventory Total Current Aarete Plant & Equipment Acumulated Depreciation Ner Flued at Total Assen Liabilities and Ouneral Accounts Payable Notes Payable Total Current Late Long Debt 149.970 370.000 870,000 1,389,970 6,570,000 1.930,000 4,640,00 6,029,970 2016 100,000 347.000 315.000 982,000 5,010,000 110,000 3.630,000 4.592.000 420,000 166695 586.623 350.000 321,440 22.960 544,400 95.00 1.262.220 2001400 Tullin Common stock Additional Paldi-Capital Retained in Total Shareholders quity Tallinen 2520000.00 772000.00 01145.00 4,00 LOT 714 200 de all the film Metalye of god RON UND Hard Rock Co's tecument Sales Cost of Goods Sold Gran Profile Selling and G&A Expenses Depreciation ERIT Interest Expense Earnings Before Texas Taxes Net Income 7,250,000 5400,000 1.250,000 95.000 350,000 335,000 130000 205,000 71.750 6,750,000 $310.000 1.420,00 32.000 550.000 230,000 110.000 12000 4,900 Notes: Tax Rate Share Outstanding Earnings per Share Dividends per Share Addition to RE per Share Dividend Payout Ratio 0.35 75.000 1.78 0.89 0.89 5096 0.362 65,000 1.12 0.73 0.49 60% Hard Rock Co's Balance Sheet Cash Account Receivable Inventory Total Current Aarete Plant & Equipment Acumulated Depreciation Ner Flued at Total Assen Liabilities and Ouneral Accounts Payable Notes Payable Total Current Late Long Debt 149.970 370.000 870,000 1,389,970 6,570,000 1.930,000 4,640,00 6,029,970 2016 100,000 347.000 315.000 982,000 5,010,000 110,000 3.630,000 4.592.000 420,000 166695 586.623 350.000 321,440 22.960 544,400 95.00 1.262.220 2001400 Tullin Common stock Additional Paldi-Capital Retained in Total Shareholders quity Tallinen 2520000.00 772000.00 01145.00 4,00 LOT 714 200 de all the film Metalye of god RON UND