Question: Please solve using excel The last 5 year's results for Whitby Corp. are below. Build a financial model in Excel that values the company's stock

Please solve using excel

The last 5 year's results for Whitby Corp. are below. Build a financial model in Excel that values the company's stock based on a model of free cash flow (FCF) growth of your own design and the following additional facts.

Whitby Corp.'s 2019 year-end debt was $800 Million. The 2018 year- end debt was $750 Million

Whitby Corp.'s 2019 year-end cash was $37.5 Million

The company has 50,500,000 shares outstanding

Whitby's current stock price is $28.00

Whitby's stock beta is 1.40

The risk-free rate is 2%

The expected return of the market is 10%

Future FCF growth is expected to be 2%

Required:

Show the calculation of the annual free cash flows (FCF's) for the company.
Value Whitby's stock using 2019 FCF as the base year free cash flow.
Value Whitby's stock price using the 5 year average FCF as the base free cash flow.
Given the current market price of Whitby's stock, which base FCF is closer to the market's estimate?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The last 5 years results for Whitby Corp. are below. Build a financial model in Excel that values the companys stock based on a model of free cash flow (FCF) growth of your own design and the...

(please solve using excel) Whitby Corp. is considering investing in a new machine for its factory to produce brake pads. The company can choose either Machine A or Machine B. The life span of each...

The last 5 years results for Cambridge Corp. are below. Build a financial model in Excel that values the companys stock based on a model of free cash flow (FCF) growth. The following are additional...

please solve excel (20pts) The last 5 years' results of Niccair Corporation are given below. Value the company's stock based on a FCFF model. This means you will need to use the values below to...

Please solve using EXCEL Kendoll, a start-up, will produce the FredoB toy doll, a product that competes with other fantasy figurines. In year 0 (right now), Kendoll will incur costs of $1.75 million...

Problema 2. (Please Solve with Excel) Kanani Savings and Loan General Time Value of Money Concepts John D. Johnson Kanani is a small southern California based savings and loan dealing primarily with...

I have completed the spreadsheet portion of this assignment, but need help with the written aspects of it. SUBDOMAIN 319.1 - ACCOUNTING & FINANCE SUBDOMAIN 319.2 - INFORMATION TOOLS Competency...

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

Please Someone help me A B D G H M N O P Q R Answer each question on the specific sheet. Make sure all answers are in a green cell For any question that requires solving for the result For questions...

please please solve number 3-8-9 CASE 1 1 TIPTON ICE ICE CREAM FINANCIAL FORECASTING George Tipton began the Tipton Ice Cream Company nearly five decades ago. He patented a soft ice cream and right...

If you were the finance minister of Never-Never Land, how would you estimate the long-run exchange rate of your currency, the neverback? Defend your choice as well as discuss its possible failings.

Attorney Fox represented Davis in a number of drunk driving cases. Davis shows up at Fox's office to discuss having the attorney draw up a will for him. The attorney recognizes that Davis is clearly...

A company creates a $ 3 6 , 6 8 3 account for misc expenses. If the account provides 2 4 % nominal interest compounded quarterly, what is the maximum amount they can withdraw from the account per...

A hula hoop and solid disc of equal radii are rolled, from rest and without slipping, down an incline plane. Which one will reach the bottom of the inclined plane first? Explain.

How can your business location affect customers image and perception of your business?

Compare and contrast the advantages and disadvantages of buying, building, or leasing space for a small business. LO-2

Choose a business you would like to start or own. If you are writing a business plan for this course, include this assignment in your business plan. Using graph paper (or simple architectural...