Develop a set of forecasting parameters

Assignment Help Financial Management
Reference no: EM131981150

Assignment

This assignment may be completed using either J.W. Nordstrom or Sinclair Broadcasting.

Tasks:

· Enter the most recent year financial data into the "Forecast" tab of the forecasting spreadsheet.

· Develop a set of forecasting parameters, based on the methodology covered in class on Thursday, 1 March. (See video archive if you missed the live session.)

· Complete the forecast using your set of parameters.

· Make a change (increase or decrease) to your gross profit margin (if Nordstrom) or your sales growth (if Sinclair) parameter. Note the changes to the forecast outcome that result from the change in the parameter.

Assignment  (Required submission for any grade above C)

Use the forecast with which you are provided to create a worksheet page that calculates the net cash flow and equity valuation (per share) for the sample company. The WACC and horizon growth rate are given in the spreadsheet.

NOTE: Use the spreadsheet provided to create your own valuation calculation.

Reference no: EM131981150

Questions Cloud

At what point does a disease become an epidemic or endemic : At what point does a disease become an epidemic, endemic, or pandemic? What are the parameters that define each of these states of a disease's effect?
Define the terms public health and health promotion : Define the terms public health and health promotion. What current legislation has had the maximum impact on the way health care is provided?
Based on comparison of two rates and current inflation rate : Based on a comparison of the two rates, and the current inflation rate, you would prefer the _____ option over the _____ option.
Prepare an excerpt of the balance sheet : MAA261 FINANCIAL ACCOUNTING - Prepare an excerpt of the balance sheet which shows the non-current assets that Dream Furniture Pty Ltd has on hand as at 30 June
Develop a set of forecasting parameters : Develop a set of forecasting parameters, based on the methodology covered in class on Thursday, 1 March. (See video archive if you missed the live session.)
What is equivalent annual annuity of profitable project : Each project has a WACC of 9%. What is the equivalent annual annuity of the most profitable project? L cash flows are zero.
Order to effectively face the competition : Are there ways a company can improve its performance in order to effectively face the competition?
How appropriate do you think it security for a hospital : How appropriate do you think it would be for a hospital, whose patients trust with their private medical information every day, to hire such consultants.
Appropriate for different companies : Choose two or more competitive strategies and compare why each strategy may be appropriate for different companies.

Reviews

Write a Review

Financial Management Questions & Answers

  Remaining divisions have to contribute every month

How much will the remaining divisions have to contribute every month to second account that pays 8.4% compounded monthly in order to reach the $20 million goal?

  What is length of the cash cycle

A firm has an accounts payable period of 46 days, an inventory period of 56 days, What is the length of the cash cycle?

  What is the HPR on each of the two bonds

What is the HPR on each of the two bonds if the interest rate after one year is 4%?

  Maximum annual lease payment wolfson would be willing to pay

What is the maximum annual lease payment Wolfson would be willing to pay?

  Which one of the following will increase the cash cycle

Which one of the following will increase the cash cycle?

  Leverage at the financial break-even level of output

What is the accounting break-even quantity? What is the degree of operating leverage at the financial break-even level of output?

  What is current beta on mmes common stock

What is the current beta on MME's common stock? What would MME's beta be if the company had no debt in its capital structure?

  Short-term bond prices are more sensitive to interest rate

Short term interest rates are more volatile than long-term interest rates, so short-term bond prices are more sensitive to interest rate changes than are long-term bond prices. Is this statement true or false? Explain.

  What is the highest net profit possible for the speculator

What is the highest net profit possible for the speculator based on the information above?

  Using better inventory control systems

Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $6.0 million. The equipment will be depreciated straight line over 6 years to a value of zero, but in fact it can be sold after 6 years fo..

  Calculate the average return and standard deviation

Calculate the average return and standard deviation of this portfolio’s returns over the six-year period.

  The dividend growth rate is expected to be constant

ABC Company's last dividend was $3.7. The dividend growth rate is expected to be constant at 9% for 3 years, after which dividends are expected to grow at a rate of 4% forever. The firm's required return (rs) is 16%. What is its current stock price (..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd