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
- Could you help explain “How an exploratory case study could be goodness of work that is pleasing to the Lord?”arrow_forwardWhat are the case study types and could you help explain and make an applicable example.What are the 4 primary case study designs/structures (formats)?arrow_forwardThe Fortune Company is considering a new investment. Financial projections for the investment are tabulated below. The corporate tax rate is 24 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are paid in cash, and all cash flows occur at the end of the year. All net working capital is recovered at the end of the project. Year 0 Year 1 Year 2 Year 3 Year 4 Investment $ 28,000 Sales revenue $ 14,500 $ 15,000 $ 15,500 $ 12,500 Operating costs 3,100 3,200 3,300 2,500 Depreciation 7,000 7,000 7,000 7,000 Net working capital spending 340 390 440 340 ?arrow_forward
- What are the six types of alternative case study compositional structures (formats)used for research purposes, such as: 1. Linear-Analytical, 2. Comparative, 3. Chronological, 4. Theory Building, 5. Suspense and 6. Unsequenced. Please explainarrow_forwardFor an operating lease, substantially all the risks and rewards of ownership remain with the _________. QuestFor an operating lease, substantially all the risks and rewards of ownership remain with the _________: A) Tenant b) Lessee lessor none of the above tenant lessee lessor none of the aboveLeasing allows the _________ to acquire the use of a needed asset without having to make the large up-front payment that purchase agreements require Question 4 options: lessor lessee landlord none of the abovearrow_forwardHow has AirBnb negatively affected the US and global economy? How has Airbnb negatively affected the real estate market? How has Airbnb negatively affected homeowners and renters market? What happened to Airbnb in the Tax Dispute in Italy?arrow_forward
- How has AirBnb positively affected the US and global economy? How has Airbnb positively affected the real estate market? How has Airbnb positively affected homeowners and renters market?arrow_forwardD. (1) Consider the following cash inflows of a financial product. Given that the market interest rate is 12%, what price would you pay for these cash flows? Year 0 1 2 3 4 Cash Flow 160 170 180 230arrow_forwardExplain why financial institutions generally engage in foreign exchange tradingactivities. Provide specific purposes or motivations behind such activities.arrow_forward
- A. In 2008, during the global financial crisis, Lehman Brothers, one of the largest investment banks, collapsed and defaulted on its corporate bonds, causing significant losses for bondholders. This event highlighted several risks that investors in corporate bonds might face. What are the key risks an investor would encounter when investing in corporate bonds? Explain these risks with examples or academic references. [15 Marks]arrow_forwardTwo companies, Blue Plc and Yellow Plc, have bonds yielding 4% and 5.3%respectively. Blue Plc has a credit rating of AA, while Yellow Plc holds a BB rating. If youwere a risk-averse investor, which bond would you choose? Explain your reasoning withacademic references.arrow_forwardB. Using the probabilities and returns listed below, calculate the expected return and standard deviation for Sparrow Plc and Hawk Plc, then justify which company a risk- averse investor might choose. Firm Sparrow Plc Hawk Plc Outcome Probability Return 1 50% 8% 2 50% 22% 1 30% 15% 2 70% 20%arrow_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
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning