Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can some one work out on MS excel Financial highlights for year ending march 31 2019 2018 2017 2016 2015 2014 Net Sales 3351 3314

Can some one work out on MS excel

Financial highlights for year ending march 31 2019 2018 2017 2016 2015 2014 Net Sales 3351 3314 2845 2796 2493 2160 EBIT -9 312 256 243 212 156 Interest 37 63 65 58 48 46 Taxes 3 60 46 43 39 34 net profit -49 189 145 142 125 76 earnings per share -0.15 0.55 0.44 0.42 0.37 0.25 Current Assets 669 469 491 435 392 423 Net Fixed Assets 923 780 753 680 610 536 Total Assets 1592 1249 1244 1115 1002 959 Current Liabilities 680 365 348 302 276 320 Long-term Debt 236 159 297 311 319 315 Stockholders Equity 676 725 599 502 407 324 Number of Stores 240 221 211 184 170 157 Employees 13057 11835 9810 9790 9075 7825 Income Statement ending march 31 2019 Net Sales 3351 cost of goods sold 1990 selling, general, and administrative expenses 1211 Depreciation Expense 159 (EBIT) earnings before interest and taxes -9 Net interest expense 37 Taxable income -46 income taxes 3 Net income -49 allocation of net income Addition to to retained earnings -49 dividends 0 Consolidated balance sheet Assets Mar.31,2019 Mar.31,2018 Current assets cash and marketable securities 14 72 Receivables 176 194 Inventory 479 203 Total Current Assets 669 469 Fixed assets Property, plant and equipment 1077 910 Less accumulated depreciation 154 130 Net fixed assets 923 780 Total Assets 1592 1249 Liabilities and shareholders equity Mar.31,2019 Mar.31,2018 Current liabilities Debt due for repayment 484 222 Accounts Payable 94 58 Other Current Liabilities 102 85 Total current liabilities 680 365 Long-term debt 236 159 Stockholders equity Common stock and other paid-in capital 155 155 Retained earnings 521 570 total stockholders equity 676 725 total liabilities and stockholders equity 1592 1249 2019 2018 Current Ratio 0.98 1.28 Quick Ratio 0.28 0.73 Net Margin Ratio -1.46% Debt/Equity 0.35 0.22 Return on Equity -31.61%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Optimization Methods In Finance

Authors: Gerard Cornuejols, Reha Tütüncü

1st Edition

0521861705, 978-0521861700

More Books

Students also viewed these Finance questions