Please help answer all questions and find the most recent 10-K and 10-Q so that all answers all accurate. Please show all work using excel and show all steps. For example, = A14+B21 with an explanation.
I would need it by 12 pm tomorrow (11/29/21); very important assignment. Thank you so much in advance!
Mini Case COST OF CAPITAL FOR SWAN MOTORS You have recently been hired by Swan Motors, Inc. (SMI), in its relatively new treasury man- agement department. SMI was founded eight years ago by Joe Swan. Joe found a method to manufacture a cheaper battery with much greater energy density than was previously possible, giving a car powered by the battery a range of 700 miles before requiring a charge. The cars manufactured by SMI are midsized and carry a price that allows the company to compete with other mainstream auto manufacturers. The company is privately owned by Joe and his family and had sales of $97 million last year. SMI primarily sells to customers who buy the cars online, although it does have a limited number of company-owned dealerships. The customer selects any customization and makes a deposit of 20 percent of the purchase price. After the order is taken, the car is made to order, typically within 45 days. SMI's growth to date has come from its profits. When the company had sufficient capital, it would expand production. Relatively little formal analysis has been CHAPTER 13 Risk, Cost of Capital, and Valuation 427 Un used in its capital budgeting process. Joe has read about capital budgeting techniques and has come to you for help. For starters, the company has never attempted to determine its cost of capital and Joe would like you to perform the analysis. Because the company is privately owned, it is difficult to determine the cost of equity for the company. Joe wants you to use the pure play approach to estimate the cost of capital for SMI and has chosen Tesla Motors as a representative company. The following questions will lead you through the steps to calcu- late this estimate. 1. Most publicly traded corporations are required to submit 10-Q (quarterly) and 10-K (annual) reports to the SEC detailing their financial operations over the previous quarter or year, respectively. These corporate filings are available on the SEC website at www.sec. gov. Go to the SEC website, follow the Company Filings" link, and search for SEC filings made by Tesla. Find the most recent 10-Q and 10-K and download the forms. Look on the balance sheet to find the book value of debt and the book value of equity. If you look further down the report, you should find a section titled either "Long-Term Debt" or "Long-Term Debt and Interest Rate Risk Management" that will list a breakdown of Tesla's long-term debt. 2. To estimate the cost of equity for Tesla, go to finance.yahoo.com and enter the ticker symbol "TSLA." Follow the various links to find answers to the following questions: What is the most recent stock price listed for Tesla? What is the market value of equity, or market capitalization? How many shares of stock does Tesla have outstanding? What is the beta for Tesla? Now go back to finance.yahoo.com and follow the "Markets" and "U.S. Treasury Bonds Rates" links. What is the yield on 3-month Treasury bills? Using a 7 percent market risk premium, what is the cost of equity for Tesla using the CAPM? 3. Go to www.reuters.com and find the list of competitors in the industry. Find the beta for each of these competitors and then calculate the industry average beta. Using the industry average beta, what is the cost of equity? Does it matter if you use the beta for Tesla or the beta for the industry in this case? 4. You now need to calculate the cost of debt for Tesla. Go to finra-markets.morningstar. com/BondCenter, enter Tesla as the company, and find the yield to maturity for each of Tesla's bonds. What is the weighted average cost of debt for Tesla using the book value weights and the market value weights? Does it make a difference in this case if you use book value weights or market value weights? 5. You now have all the necessary information to calculate the weighted average cost of capital for Tesla. Calculate the weighted average cost of capital for SMI using book value weights and market value weights assuming SMI has a 21 percent marginal tax rate. Which cost of capital number is more relevant? 6. You used Tesla as a representative company to estimate the cost of capital for SMI. What are some of the potential problems with this approach in this situation? What improve ments might you suggest
