a.
To compute: Ratio of each year’s data with previous year’s data.
Introduction: All ratios shall be calculated by formula:
Ratio measures the change in data from a base value of 1.
b.
To compute: Growth of figures relative to last year.
Introduction: Since ratios are measuring change in base value of 1 from one year to next, growth rate can be calculated by subtracting 1 and multiplying the result by 100 to get growth in percentage terms.
c.
To compute: Arithmetic mean of growth for each item.
Introduction: Average function in excel will calculate the arithmetic mean of growth over the given period by dividing the sum of growth percentage by number of observations, that is, 4.
d.
To compute: Geometric mean of growth for each item.
Introduction: Geometric mean considers the impact of compounding, that is, change in base value due to impact of previous year’s growth.
e.
To state: Difference between arithmetic mean and geometric mean and possibility of geometric mean being greater than arithmetic mean.
Introduction: Arithmetic mean is derived by dividing the sum of observations by number of observations, on the other hand geometric mean is derived as the product of observations rooted by number of observations.
f.
To Compare:Results for geometric average and arithmetic average for given variables.
Introduction: Arithmetic mean is derived by dividing the sum of observations by number of observations, on the other hand geometric mean is derived as the product of observations rooted by number of observations.
Want to see the full answer?
Check out a sample textbook solutionChapter 1 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
- For the companies Lockheed-Martin (LMT) & Northrop-Grumman (NOC) Use Macrotrends data to calculate Return on Sales, Return on Assets, Debt Ratio, Inventory Turnover, Lead Time for each company Use Fintel to determine EPS forecasts for 2024-2027 for each company, and use those to calculate an average earnings growth rate for each - https://fintel.io/sfo/us/Imt https://fintel.io/sfo/us/noc Assuming MARR = WACC + 3%, calculate a fair market price for the stock of each company, assuming that earnings grow at the calculated rate for the next 50 years, with the following WACC LMT: NOC: 8.00% 8.25% Find the current stock price for each company Based on the above calculations, which company's stock would you buy, and provide your reasoning (If neither or both, explain reasoning)arrow_forwardLoreto Inc. has the following financial ratios: asset turnover = 1.60; net profit margin (i.e., net income/sales) = 6%; payout ratio = 30%; equity/assets = 0.50. a. What is Loreto's sustainable growth rate? b. What is its internal growth rate? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) A. Sustainable growth rate _______% B. Internal growth rate ______%arrow_forwardLoreto Inc. has the following financial ratios: asset turnover = 2.00; net profit margin (i.e., net income/sales) = 4%; payout ratio = 35%; equity/assets = 0.30. a. What is Loreto's sustainable growth rate? b. What is its internal growth rate? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)arrow_forward
- Hello, Please answer questions and show workarrow_forwardLoreto Incorporated has the following financial ratios: asset turnover = 2.00; net profit margin (i.e., net income/sales) = 7%; payout ratio = 30%; equity/assets = 0.60. a. What is Loreto's sustainable growth rate? b. What is its internal growth rate? Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. a. Sustainable growth rate b. Internal growth rate 14 % %arrow_forwardA company has the following items for the fiscal year 2020: Revenue =10 million Cost of goods sold = 3 million EBITDA = 5 million EBIT = 4 million Net income = 2 million Calculate the company’s net profit margin Write the formula for the following ratios and what each ratio measures: Current Ratio Quick Ratioarrow_forward
- Suppose a company has had the historic sales figures shown below. What would be the forecast for next years sales using the average approach?arrow_forwardBased on the financial statements calculate the (1) efficiency ratios, (2) liquidity ratios, (3) leverage ratios, and (4) profitability ratios for KPC Corporation for this year. Where data is available, also calculate ratios for last year. Use a 360-day year. All sales are on credit to business customers. Assume an income tax rate of 30 percent.arrow_forwardSuppose a firm has had the following historic sales figures. Year: Sales 2016 $1,900,000 2017 $2,150,000 2018 $1,800,000 2019 $2,400,000 2020 $2,000,000 What would be the forecast for next year's sales using the average approach? Next year's salesarrow_forward
- Category of industry is real estate. The analysis of Days Sales Outstanding is as follows: 2015: 254 days 2016: 338 days 2017: 332 days 2018: 169 days 2019: 81 days a. What is the simple trend analysis for that Days Sales Outstanding and why it is increasing and decreasing? b. Compare the ratio with the industry average.arrow_forwardSelected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021-2015 ($ thousands) Sales 2021 Cost of goods sold $ 1,769 1,271 2020 $ 1,549 2019 2018 2017 2016 2015 $ 1,410 $ 1,292 $ 1,206 $ 1,121 $ 919 1,034 889 778 723 676 539 Gross profit 498 515 521 514 483 445 380 Operating expenses Net income 377 295 271 200 173 171 142 $ 121 $ 220 $ 250 $ 314 $ 310 $ 274 $ 238 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021-2015 ($ thousands) Assets Cash Accounts receivable, net Merchandise inventory Other current assets Long-term investments Plant assets, net Total assets Liabilities and Equity 2021 2020 2019 2018 2017 2016 2015 $ 108 773 $ 142 812 $ 148 735 2,797 2,036 1,779 $ 151 564 1,499 $ 157 496 $ 155 $ 160 470 332 1,346 1,144 829 72 65 40 71 60 61 32 e B 220 220 220 220 3,422 3,409 2,982 1,683 $ 7,172 $ 6,464 $ 5,684 $ 4,188 $ 4,019 1,740 1,546 $ 3,596 $ 2,900 1,327 Current liabilities…arrow_forwardSuppose a firm has had the following historic sales figures. Year: 2016 Sales $1,420,000 2017 $1,720,000 Next year's sales 2018 2019 2020 $1,600,000 $2,010,000 $1,770,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. 27arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning