After viewing the video titled – Cash Flow Forecasting Explained with link below, answer questions 9 and 10 that follow:https://www.youtube.com/embed/4SNWA_HbF6UAssume you are the financial manager for a large electronics retailer. What benefits could you gain from preparing a cash forecast? Identify at least 5. Your answer should be no more than 300 words.

Complete the following statements by adding the missing words or selecting the correct option between the 2 (or 3) alternatives presented as (X/X or X/X/X):The ___________ analysis is a type of financial statement analysis which is most commonly used to create a baseline estimate for financial forecasts.The ___________ on the income statement is a key element which is used to estimate several other key income statement lines.In the context of a firm’s financial statements, pro forma means historical/forward looking/audited.The most common length of a forecast if the goal is to forecast cash and assess possible short-term growth, is ________.When completing a first pass at a forecasted income statement, variable/fixed costs are assumed to be tied directly to sales.In the cash forecast, if cash inflows exceed cash outflows, this creates a cash deficit/surplus.

The Orange Corporation has to make a decision as to which of four investment proposals it should pursue. The four projects have the following NPVs and initial investment amounts: Project A: NPV = 1,000, initial investment = -100 Project B: NPV = 2,400, initial investment = -300 Project C: NPV = 750, initial investment = -83 The firm has limited funds available to spend on capital projects this year. How would you rank these projects in terms of their priority? A, C, B B, C, A A, B, C B, A, C

Westland Manufacturing spends $20,000 to update the lighting in its factory to more energy-efficient LED fixtures. This will save the company $4,000 per year in electricity costs. The company estimates that these fixtures will last for 10 years. What is the IRR of this project? Use Microsoft Excel and submit your Excel file.

Optimist Company can sell common shares at $30 per share and can obtain debt funding at 8 percent. It has a marginal income tax rate of 25 percent. The yield on US Treasury securities is 3 percent. The market risk premium is 6.0 percent, and the firm’s beta is 0.9. It has a targeted debt-to-equity ratio of 1:1. What is its after-tax cost of debt?

After viewing the video which discusses the optimal capital structure for real estate with link below answer the following questions:Optimal Capital Structure Commercial Real Estate Explain in no more than 350 words, why the optimal capital structure for commercial real estate cannot be uniform (i.e. a “one-size fits all”) for all commercial real estate entities. Present a scenario where you would recommend a highly levered capital structure and a scenario when you would recommend an unlevered capital structure in the commercial real-estate market and explain why.  

SodaFizz paid a dividend of $2 per share last year; its dividend has been growing at a rate of 2% per year, and that growth rate is expected to continue into the future. The stock of SodaFizz is currently trading at $19.50 per share According to the constant dividend growth model, what is the cost of equity capital for SodaFizz?

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. 

After 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.

If Westland Manufacturing finds that its cost of funds is 11%, what will happen to the NPV of the project in problem 3?