In Millions of USD except Per Share12 Months EndingRevenuePassengerOtherFreightRevenue Growth %OtherPassengerFreightFY 201412/31/201418 605,017 658,0772,0175,0-5,205,606,70FY 201512/31/201519 820,018 299,01 170,0179,0FY 201612/31/201620 425,018 594,01 660,0171,0FY 201712/31/201721 146,019 763,01 210,0173,0FY 201812/31/201821 965,020 455,01 335,0175,0 You work a junior analyst in the investment bank. Your first project is to build a model for the company above.Your senior manager asked you to prepare a segment analysis. She made a following comment: "The industryhad some fluctuations prior to 2016, but based on the industry report the growth is coming back. We shouldexpect the same growth rate for the passenger segment as in the last year. Freight growth most likely will bethe average of the last two years. "Other" segment is not clear, we probably should keep the same per cent ofthe total as in the last 5 years.1) Prepare a table showing relative weights of each segment of revenue over the five year period2) Calculate growth rates for each segment over the periods presented3) Make a forecast for the Segments and Total Revenue for 2019

In a financial modeling exercise, we have to find the pat trends and make forecast for the next…

In Millions of USD except Per Share 12 Months Ending Revenue Passenger Other Freight Revenue Growth % Other Passenger Freight FY 2014 12/31/2014 18 605,0 17 658,0 772,0 175,0 -5,20 5,60 6,70 FY 2015 12/31/2015 19 820,0 18 299,0 1 170,0 179,0 FY 2016 12/31/2016 20 425,0 18 594,0 1 660,0 171,0 FY 2017 12/31/2017 21 146,0 19 763,0 1 210,0 173,0 FY 2018 12/31/2018 21 965,0 20 455,0 1 335,0 175,0

In Millions of USD except Per Share 12 Months Ending Revenue Passenger Other Freight Revenue Growth % Other Passenger Freight FY 2014 12/31/2014 18 605,0 17 658,0 772,0 175,0 -5,20 5,60 6,70 FY 2015 12/31/2015 19 820,0 18 299,0 1 170,0 179,0 FY 2016 12/31/2016 20 425,0 18 594,0 1 660,0 171,0 FY 2017 12/31/2017 21 146,0 19 763,0 1 210,0 173,0 FY 2018 12/31/2018 21 965,0 20 455,0 1 335,0 175,0

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter10: Forecasting Financial Statement

Section: Chapter Questions

Problem 4QE: Suppose you are analyzing a firm that is successfully executing a strategy that differentiates its...

See similar textbooks

Similar questions

Medina Weeks, a manufacturing company headquartered in Canada, has a competitive advantage that will probably deteriorate over time. Analyst Flavio Torino expects this deterioration to be reflected in declining sales growth rates as well as declining profit margins. To value the company, Torino has accumulated the following information: Current sales are C$600 million. Over the next six years, the annual sales growth rate and the net profit margin are projected to be as follows: Beginning in year 6, the 7 percent sales growth rate and 10 percent net profi t margin should persist indefinitely.· Capital expenditures (net of depreciation) in the amount of 60 percent of the sales increase will be required each year.· Investments in working capital equal to 25 percent of the sales increase will also be required each year.· Debt financing will be used to fund 40 percent of the investment in net capital items and working capital.· The beta for Medina Weeks is 1.10; the…
The financial manager of Company X has just received the sales forecast for next year and it indicates that the year's sales are expected to double in the second half. What are the challenges that Company X might face in increasing its production to meet the sales projections and how can these challenges be overcome? What risks does Company X face by ramping-up production to meet the sales forecast?
A firm is considering several policy changes to increase sales. It will increase inventory by $10,000 it will offer more liberal sales terms but will result in average receivables increasing by $65,000. These actions are expected to increase sales by $800,000 per year, and cost of goods will remain at 80% of sales. Because of the firm’s increased purchase of its won production needs, average payable increases by $35,000.What factors should they consider when making these decisions? What effects would they have on the firm’s cash cycle? Please select three financial ratios they should consider and why
Suppose you are analyzing a firm that is successfully executing a strategy that differentiates its products from those of its competitors. Because of this strategy, you project that next year the firm will generate 6.0% revenue growth from price increases and 3.0% revenue growth from sales volume increases. Assume that the firms production cost structure involves strictly variable costs. (That is, the cost to produce each unit of product remains the same.) Should you project that the firms gross profit will increase next year? If you project that the gross profit will increase, is the increase a result of volume growth, price growth, or both? Should you project that the firms gross profit margin (gross profit divided by sales) will increase next year? If you project that the gross profit margin will increase, is the increase a result of volume growth, price growth, or both?
Economy will improve vastly next year, and that many freight customers will gradually switch from cheaper sea freight to faster airfreight. Hence, you are interested to invest in the stocks of two listed companies, Delta Aircraft Ltd and Alpha Air Ltd. Delta Aircrafts manufactures airfreight planes for goods forwarders like DHL. Alpha Air produces software and hardware for airfreight planes. The following information applies for the following year in the table listed below State of Return on Delta Return On Alpha The Economy Strong 0.7 14% 22% Normal And Weak 0.3 6% 3% Required:a. Compute the expected returns and the standard deviation of returns for each stock. b. Compute the covariance between the returns of the two stocks. c. Compute the expected return and standard deviation of a portfolio that comprise 60 percent of funds in Delta Aircrafts and the balance in Alpha Aird. Given your answers in parts a, b and c above, evaluate the diversification effect of…
A firm is considering several policy changes to increase sales. It will increase the variety of goods it keeps in inventory, but this will increase inventory by $12,000. It will offer more liberal sales terms, but this will result in average receivables increasing by $69,000. These actions are expected to increase sales by $820,000 per year, and cost of goods will remain at 80% of sales. Because of the firm’s increased purchases for its own production needs, average payables will increase by $37,000. What effect will these changes have on the firm’s cash cycle? (Use 365 days in a year. Do not round your intermediate calculations. Round your answer to 2 decimal places.) Change in cash cycle days
Garret Simpson Investments is evaluating a firm (Garp, Inc.) for recommendation to its clients and trying to evaluate the firm's current stock price. The firm is about to offer its shares to the public and had earnings last year of $2.50 a share, which the analysts believe is expected to grow by 20% next year. Similar firms in the industry are currently selling for price-earnings ratios ranging from ten to fifteen times current period earnings. However, these competitor firms are already public entities and have relatively low growth expectations for their earnings. What is your estimate of an appropriate price range for the shares of Garp? Defend your answer.
Imagine you are the manager of operations for a manufacturing company. Your vice president wants to expand production by building a new facility, and she would like you to develop a business case for the project. Assume that your company’s weighted average cost of capital is 13%, the after-tax cost of debt is 7%, preferred stock is 10.5%, and common equity is 15%. As you work on the business case, you surmise that this is a fairly risky project because of a recent slowing in product sales. In fact, when using the 13% weighted average cost of capital, you discover that the project is estimated to return about 10%, which is quite a bit less than the company’s weighted average cost of capital. Your vice president suggests that the project could be financed from a mix of retained earnings (50%) and bonds (50%). She reasons that retained earnings do not cost the company anything because it is cash you already have and the after-tax cost of debt is only 7%. That would lower your weighted…
Imagine you are the manager of operations for a manufacturing company. Your vice president wants to expand production by building a new facility, and she would like you to develop a business case for the project. Assume that your company’s weighted average cost of capital is 13%, the after-tax cost of debt is 7%, preferred stock is 10.5%, and common equity is 15%. As you work on the business case, you surmise that this is a fairly risky project because of a recent slowing in product sales. In fact, when using the 13% weighted average cost of capital, you discover that the project is estimated to return about 10%, which is quite a bit less than the company’s weighted average cost of capital. Your vice president suggests that the project could be financed from a mix of retained earnings (50%) and bonds (50%). She reasons that retained earnings do not cost the company anything because it is cash you already have and the after-tax cost of debt is only 7%. That would lower your weighted…
The financial manager for "ERR" industrial Company would extend the credit terms from "net 30" to "net 45" in order to stimulate credit sales. 'ERR' Company also benefits from relaxing of terms from its suppliers from "net 30" to "net 35". The manager is wondering how to estimate the financial impact of these alternatives would have on the shareholder's wealth. The financial manager estimates that the daily sales increase at a growth rate equals 10% following the extension of DSO. You gathered the following information:Purchase amount = 40% of sales amount Annual sales amount = $31,025,000 The annual cost of capital = 10% Inventory turnover =18.25 1- Calculate the daily NPV of the current terms. 2- Calculate the daily NPV of the proposed terms. 3- Based on your own calculations, what is your recommendation? Why? 4- Calculate the NPVCCP of the present terms. Interpret. 5- Calculate the ANPVCCP-aggregate of the Company. Interpret.
The company you cofounded last year isgrowing rapidly and has strong prospects for an IPO inthe next year or two. The additional capital that an IPOcould raise would let you hire the brightest people inthe industry and continue to innovate with new productresearch. There is one potential glitch: You and therest of the executive team have been so focused onlaunching the business that you haven’t paid muchattention to financial control. You’ve had plenty offunds from venture capitalists and early sales, soworking capital hasn’t been a problem, but anexperienced CEO in your industry recently told youthat you’ll never have a successful IPO unless youclean up the financial side of the house. Yourcofounders say they are too busy chasing greatopportunities right now, and they want to wait untilright before the IPO to hire a seasoned financialexecutive to put things in order. What should you doand why?
The High-Flying Growth Company (HFGC) has been expanding very rapidly in recent years, making its shareholders rich in the process. The average annual rate of return on the stock in the past few years has been 19%, and HFGC managers believe that 19% is a reasonable figure for the firm's cost of capital. To sustain a high growth rate, HFGC's CEO argues that the company must continue to invest in projects that offer the highest rate of return possible. Two projects are currently under review. The first is an expansion of the firm's production capacity, and the second project involves introducing one of the firm's products into a new market. Cash flows from each project appear in the following table: Year Plant expansion Product introduction 0 -3,500,000 -500,000 1 2,500,000 350,000 2 1,750,000 375,000 3 3,000,000 375,000 4 2,250,000…