Calculator excel tutorials folder under the files

Assignment Help Finance Basics
Reference no: EM132477785

1. Pickett Inc. forecasts the free cash flows (FCFs) (in millions) shown below. The weighted average cost of capital (WACC) is 8%, and the FCFs are expected to continue growing at a 3% rate after Year 4. The firm has $90.14 million of market-value debt, but it has no preferred stock or any other outstanding claims. There are 25 million shares outstanding.

Year                          1                    2               3               4    

FCF                         $10                 $20           $40         $65

a. What is the value of the stock price today (Year 0)? 

b. Set up a simple Excel data table where you show how the estimated intrinsic value varies as the long-run growth rate varies over the following range (2.00%, 2.25%, 2.50%, 2.75%, 3.00%, 3.25%, 3.50%, 3.75%, 4.00%, 4.25%, 4.50%, and 4.75%) - assuming everything else stays constant. When correctly set up, an Excel Data Table will automatically recalculate when input variables are changed. Refer to the Calculator Excel Tutorials folder under the Files page on the Canvas website for the Excel file and video explaining how to create data tables. 

Reference no: EM132477785

Questions Cloud

Calculate the value of the all-equity : (a) Calculate the value of the all-equity ( i.e. unlevered) business. Show calculations (b) Calculate interest expense after the company issues debt.
Examine the movement and specific work : Examine the movement and specific work in relation to historical and political influences of the movement. Include a one paragraph summary of the plot before.
Discuss savage inequalities - children in america schools : Irl Solomon's history class Jennifer's views on schools in poor area (Bronx & East St. Louis) Contrast East St Louis with the school in Rye, New York
What is the investor return in us dollars : At that time the Nikkei is trading at 12,220.63 and the exchange rate is 95.26 yen per dollar. What is the investor's return, in U.S. dollars.
Calculator excel tutorials folder under the files : Refer to the Calculator Excel Tutorials folder under the Files page on the Canvas website for the Excel file and video explaining how to create data tables.
Deduce the expected exposure-valuation : Is this enough to deduce the expected exposure / valuation (again measured at time 0) of that portfolio, corresponding to time horizon T? If so, what is it?
How plan to find interviewees or observation setting : How you will operationalize your concept(s), what your population of interest will be, how you plan to find your interviewees or observation setting
How controversies relate to the four core ethical principles : Review the sectioned headed, Two Ethical Exemplars in Chapter 22 of the textbook (Melnyk and Fineout-Overholt, 2015, pages 518-519). Discuss three main ethical.
Estimate of the cost of equity for arkansas lighting : What would be an appropriate estimate of the cost of equity for Arkansas Lighting?

Reviews

Write a Review

Finance Basics Questions & Answers

  Discussions with somebody and a contract was created

You had verbal discussions with somebody and a contract was created. Everything was placed in writing at the time

  What is valentine wacc

The Valentine Company has the following capital accounts stated at market value and component capital costs.

  How us co inc could implement a money market hedge

Assume that US Co Inc has net receivables of CHF100,000 in 90 days. The spot rate of the franc is $.50, and the Swiss interest rate is 2 per cent over 90 days (not 2 per cent per annum). Suggest how US Co Inc could implement a money market hedge.

  How does a pile support its applied load

When sloping the sides of an excavation in type A soil, what maximum slope may be used if the excavation will be 15 ft (4.6 m) deep and will be open less.

  What is the origin of international currency market

What is the role of international currency market (also including the impact to the whole market). What is the origin of international currency market

  Self-insure its workers compensation loss exposure

During a "hard" insurance market, a manufacturing company decided to self-insure its workers compensation loss exposure. The company hired a third party to administer the workers compensation claims.

  What is the slope of slope of the capital allocation line

a) How would you form a portfolio that has an expected outcome of $114? b) What is the slope of slope of the Capital Allocation Line formed with the risky asset and the risk-free asset?

  What is the expected return on the portfolio

The following information is available in general and about investments in stocks J and K.

  Is your finance professor right

You follow your broker’s advice and make a substantial investment in Hannah stock so that,considering only your risky investments, 60% is in the Natasha Fund and 40% is in Hannah stock. When you tell your finance professor about your investment, he s..

  Quantitative models of debt ratings

List THREE financial ratios that represent three different factors and explain why these ratios can capture the company's ability to meet its financial

  Review case study of the botany bay corporation

Botany Bay Corporation. Botany Bay Corporation of Australia seeks to borrow US$30,000,000 in the eurodollar market. Funding is needed for two years.

  Estimate the investment in receivables

estimate the investment in receivables if net sales were $1,300,000 in 2011 d. how much of a change in the 2011 receivables occurred?

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