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

  Hospital overhead costs to patient services departments

Use an allocation table to allocate the hospital's overhead costs to the patient services departments.

  How much new stock will be issued next year

You are expected Sales to increase next year by 10% off of a base of $7,000 this year. How much new stock will be issued next year?

  What is the wacc for the company

The Saunders Investment Bank has the following financing outstanding. What is the WACC for the company?

  Considered when making a rent-or-buy decision

Sophia Hams IS a single woman in her late 20’s. She is renting an apartment in the fashionable part of town for $1,200 a month. After much thought, she’s seriously considering buying a condominium for $175,000. Given the information provided, use Wor..

  What is the internal rate of return and net present value

Testco Corporation is considering adding a new product line. what is the net present value of this project? What is the internal rate of return?

  Market value of shareholders common stock holdings

Shareholder wealth is measured by the MARKET VALUE of the shareholders' common stock holdings.

  How much is the future floating rate

How much is the future floating rate for the second 6-month period?

  How many days is the days-sales-in-inventory

Goods available for sale total $25,000, beginning inventory is $8,000, endings inventory is $12,000, and cost of goods sold is $10,000. How many days is the days-sales-in-inventory?

  Assume the rates are effective annual rates

A one-year STRIPS sells at interest rate of 3.54 percent and two-year STRIPS sells at interest rate of 3.49 percent. Assume the rates are effective annual rates

  What is the market value of mmcs common stock

Investors require a 12 percent rate of return to purchase MMC's common stock. What is the market value of MMC's common stock?

  After-tax net income difference in producing low calorie

Florida Citrus Inc. (FCI) estimates its taxable income at $9,000,000. The company is considering expanding its product line by introducing a low-calorie sport drink for next year. It expects that the additional taxable income next year from this spor..

  Make coupon payments semiannually

Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of €1,000, 15 years to maturity, and a coupon r..

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