Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Toyota Motor Company is expanding the production of their gas - electric hybrid drive systems and plans to shift production in the United States. To
Toyota Motor Company is expanding the production of their gaselectric hybrid drive systems and plans to shift production in the United States. To enable the expansion, they are contemplating investing $ billion in a new plant with an expected year life. The anticipated free cash flows from the new plant would be $ million the first year of operation and grow by for each of the next two years and then per year for the remaining seven years. As a newly hired MBA in the capital budgeting division you have been asked to evaluate the new project using the WACC, Adjusted Present Value, and FlowtoEquity methods. You will compute the appropriate costs of capital and the net present values with each method. Because this is your first major assignment with the firm, they want you to demonstrate that you are capable of handling the different valuation methods. You must seek out the information necessary to value the free cash flows but will be provided some directions to follow. This is an involved assignment, but at least you dont have to come up with the actual cash flows for the project!
Go to Nasdaq wwwnasdaq.com and get the quote for Toyota symbol: TM
a Click on the income statement. The income statements for the last three fiscal years will appear. Copy and paste the data into Excel.
b Go back to the Web page and select Balance Sheets from the top of the page. Repeat the download procedure for the balance sheets, then copy and paste them into the same worksheet as the income statements.
c Now go to Yahoo! Finance financeyahoo.com and get the quote for Toyota. Click Historical prices in the left column, and find Toyotas stock price for the last day of the month at the end of each of the past three fiscal years. Record the stock price on each date in your spreadsheet.
Create a timeline in Excel with the free cash flows for the years of the project.
DeterminetheWACCusingEq
a For
the cost of debt, rD:
b For
the cost of equity, rE:
i Go to finra
markets.morningstar.comBondCenterDefaultjsp and click to search. Enter Toyotas symbol, select the Corporate toggle, and press Enter
ii Look at the average credit rating for Toyota longterm bonds. If you find that they have a rating of A or above, then you can make the approximation that the cost of debt is the riskfree rate. If Toyotas credit rating has slipped, use Table to estimate the beta of debt from the credit rating.
i Get the yield on the year US Treasury Bond from Yahoo! Finance financeyahoo.com Click on Market Data then click on US Treasury Bond Rates. Enter that yield as the riskfree rate.
ii Find the beta for Toyota from Yahoo! Finance. Enter the symbol for Toyota and click Statistics The beta for Toyota will be listed there.
iii. Use a market risk premium of to compute rE using the CAPM. If you need to repeat the exercise to compute rD
c Determine the values for E and D for Eq for Toyota and the debttovalue and equitytovalue ratios.
i To compute the net debt for Toyota, add the longterm debt and the shortterm debt and subtract cash and cash equivalents for each year on the balance sheet.
ii Obtain the historical number of shares outstanding from Investing.com wwwinvesting.com Enter Toyotas ticker in the search box, click Financials Look on the income statement for Diluted Weighted Average Shares. Multiply
the historical stock prices by the number of shares outstanding you collected to compute Toyotas market capitalization at the end of each fiscal year.
iii. Compute Toyotas enterprise value at the end of each fiscal year by combining the values obtained for its equity market capitalization and its net debt.
iv Compute Toyotas debttovalue ratio at the end of each year by dividing its net debt by its enterprise value. Use the average ratio from the last four years as an estimate for Toyotas target debttovalue ratio.
d Determine Toyotas tax rate by dividing the income tax by earnings before tax for each year. Take the average of the three rates as Toyotas marginal corporate tax rate.
e Compute the WACC for Toyota using Eq
ComputetheNPVofthehybridengineexpansiongiventhefreecashflows you calculated using the WACC method of valuation.
DeterminetheNPVusingtheAdjustedPresentValueMethod,andalso using the FlowtoEquity method. In both cases, assume Toyota maintains the target leverage ratio you computed in Question c
Compare the results under the three methods and explain how the resulting NPVs are achieved under each of the three different methods.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started