The following video is needed for Questions 9 and 10. NPV and IRR Real Life Example Using Solver.Watch the video and then conduct the same calculation using the spreadsheet attached but change the Current House Price to $538,000 USD and leave all the other values unchanged. What is the yearly rate of return? Is this what you would expect the new yearly rate of return to be? Explain why.
Read DetailsAfter viewing the video from CFI (with link below) which shows how to calculate the WACC for Brick and Mortar Co, answer the following questions. CFI – Weighted Average Cost of Capital.In the video a tax rate of 30% was used. Redo the calculation with a tax rate of 15%. If the WACC is the total combination of cost of equity and cost of debt, which of these two components does the reduced tax rate affect and show if that component of the WACC increase or decrease with the reduction of the tax rate to 15%. Based on this calculation explain what happens when the tax rate is reduced to the cost of capital.
Read DetailsComplete the following statements by adding the missing words or selecting the correct option between the 2 alternatives presented as (X/X):One of the most important benefits of using comparative P/E ratios is that they can ________ stocks with different prices and various earnings levels.The P/B ratio does not work well for companies that primarily consist of ___________ assets such as __________.The two-stage DDM approach might be used to value a firm and its stock that experiences two stages of growth. These are a period of higher/lower growth and subsequently a period of higher/lower growth.A major shortcoming of the zero growth DDM model is that the model assumes a constant/growing dividend.The required inputs for the discounted cash flow (DCF) model are: historical/future cash flow amounts for the period analyzed; an estimated historical/future value that will result from the sale of the stock or asset; a discount rate to discount future cash flows to the present/future time.Features of preferred stock are a dividend paid out to stockholders before/after dividends are paid to common stockholders and priority/subordinate claim to assets before common stockholders. Operational efficiency refers to the _____ and _______ of processing a buy or sell order at the best available price. Computerized trading systems such as the Universal Trading Platform used on the Nasdaq, are designed to facilitate high transaction ________ and __________.___________ refers to how quickly a source reflects comprehensive information in the available trading prices.A price is efficient if the market has used all available information to set it implying that the stock always trades at a fair/inflated/deflated value.
Read DetailsView the video Calculate the Present Value for Multiple Cash Flows at the link below:https://www.youtube.com/embed/HxtM34msWGI 1. Provide a practical example from your own personal financial management of why an understanding ofthe present value of future cash flows would be important.2. You expect to receive $10,800 one year from now, $17,400 two years from now, nothing at the end of the third year, and $24,000 four years from now. If you discount all your cash flows at 7%, then with annualcompounding, what are these future cash amounts worth to you in total today? Check you answers using Excel. Submit both your hand-written calculations and your Excel file.
Read DetailsYou are presented with 2 investment opportunities with a 5-year horizon. Which of the following investments will produce a larger return: (HINT – which provides the highest future value.) Option 1: A $100 investment earning 10% per year for 5 years; or Option 2: A $130 investment earning 5% per year for 5 years?
Read Details