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
- Firm has the following revenues. Forecast the firm's year 4 revenue using the average annual growth rate. Year 1: $17,864. Year 2: $17,149. Year 3: $19,359.arrow_forwardLoreto Incorporated has the following financial ratios: asset turnover = 1.60; net profit margin (i.e., net income/sales) = 6%; payout ratio = 25%; equity/assets = 0.80. What is Loreto's sustainable growth rate? What is its internal growth rate? Note: Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.arrow_forwardA firm has reported the following revenues. Forecast the firm's year 4 revenue using the average annual growth rate. Year 1: $17,864. Year 2: $17,149. Year 3:$19,359. Year 4: ?arrow_forward
- Based 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_forwarda. By what percentage did Mydeco’s revenues grow each year from 2013 to 2016? *Use the Data Table*arrow_forwardCalculate the following ratios for 2021 using working Excel formulas. Make sure to label each appropriately using the following cell (number of days, number of times, etc.) Round each answer to 2 decimal places (example: ROE of .1678 should display as 16.78%): Current Ratio Quick Ratio Debt to Equity Ratio Equity Multiplier Times Interest Earned Dividend Yield Inventory Turnover Days’ Sales in Inventory Receivables Turnover Days’ Sales in Receivables Total Asset Turnover Profit Margin Return on Assets Return on Equity P/E Ratio 2.Calculate Return on Equity (ROE) for 2021 using the Dupontarrow_forward
- Loomis, Inc. reported the following on the company’s income statement in two recent years: Please see the image for details: a. Determine the times interest earned ratio for the current year and the prior year. Round to one decimal place.b. Is this ratio improving or declining?arrow_forwardFor 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 = 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
- Using data available in the case, calculate the annual growth rate from 2020 to 2021 (in percentages). All calculations should be rounded to two decimals (e.g., 12.77%). > Answer is complete but not entirely correct. 2021 2020 2020-2021 Revenue 2,057,622 1,736,432 18.50 % Cost of Goods Sold 1,259,830 921,980 36.64 % Gross Profit 797,792 814,452 (1.02) % Operating Expenses 789,795 570,245 38.50 % Operating Income 7,997 244,207 2,953.73% Net Income 14,553 191,960 (92.42) %arrow_forwardSuppose we want to compute the four-quarter moving average of Company ABC’s sales as of the beginning of the first quarter of 2022. ABCs sales in the previous four quarters were as follows: 1Q 2021, R 1,200,000; 2Q 2021, R 800,000; 3Q 2021, R 750,000; and 4Q 2021, R 1,600,000. Calculate the four-quarter moving average of sales as of the beginning of the first quarter of 2022.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
- 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