Please show work in excel formulas, thank you! A1 2 4 5 6 7 fx Accessibility tab
Fantastic news! We've Found the answer you've been seeking!
Question:
Please show work in excel formulas, thank you!
Transcribed Image Text:
A1 2 4 5 6 7 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. A B C D E F G H I J K Given the following information for Lightning Power Co., find the WACC. Assume the company's tax rate is 21 percent. Debt: 12,000 bonds with a 4.6 percent coupon outstanding, $1,000 par value, 25 years to maturity, selling for 105 percent of par; the bonds make semiannual payments. Common stock: 575,000 shares outstanding, selling for $81 per share; the beta is 1.04. Preferred stock: 30,000 shares of 3.4 percent preferred stock outstanding, a $100 par value, currently selling for $94 per share. Market: 7 percent market risk premium and 3.2 percent risk-free rate. Input Area: Tax rate Debt Bonds outstanding 8 9 Settlement date 10 Maturity date 11 Annual coupon rate 12 Coupons per year 13 14 Bond price (% of par) Redemption (% of par) 21% 12,000 1/1/2020 1/1/2045 4.60% 2 105 100 A1 2 4 5 6 7 fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. A B C D E F G H I J K Given the following information for Lightning Power Co., find the WACC. Assume the company's tax rate is 21 percent. Debt: 12,000 bonds with a 4.6 percent coupon outstanding, $1,000 par value, 25 years to maturity, selling for 105 percent of par; the bonds make semiannual payments. Common stock: 575,000 shares outstanding, selling for $81 per share; the beta is 1.04. Preferred stock: 30,000 shares of 3.4 percent preferred stock outstanding, a $100 par value, currently selling for $94 per share. Market: 7 percent market risk premium and 3.2 percent risk-free rate. Input Area: Tax rate Debt Bonds outstanding 8 9 Settlement date 10 Maturity date 11 Annual coupon rate 12 Coupons per year 13 14 Bond price (% of par) Redemption (% of par) 21% 12,000 1/1/2020 1/1/2045 4.60% 2 105 100
Expert Answer:
Answer rating: 100% (QA)
Calculating WACC for Lightning Power Co Step 1 Calculate the Market Value of Debt excel B8B15B13100 ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
The shareholders equity section of Rodman Corporation as of December 31, 2011, follows: Common stock ............ $ 80,000 Additional paid-in capital (C/S) ....... 10,000 Retained earnings...
-
The partnership of Jordan and O'Neal began business on January 1, 20X7. Each partner contributed the following assets (the noncash assets are stated at their fair values on January 1, 20X7): The land...
-
The following is the shareholders equity section of Suozzi Corp. at December 31, 2012: Preferred shares, a authorized 100,000 shares; issued 25,000 shares $ 750,000 Common shares (200,000...
-
Let n=102 +r, where , re N, 0r9. A number a is chosen at random from the set {1, 2, 3, ..., n} and let pn denote the probability that (a 1) is divisible by 10. 70. If r = 0, then npn equals (a) 22...
-
Explain the rights and obligations created in the following transactions. (a) A manufacturer sells goods with terms FOB shipping point. (b) A manufacturer sells goods with terms FOB destination...
-
The following information has been extracted from the books of Hayes Limited for the year to 31 December 2016: Additional information: 1 The directors are extremely concerned about the large bank...
-
Which of the following statement(s) is/are accurate: (a) Related party transactions should be assessed in the context of the companys overall governance structure (b) The definition of related...
-
A mixture containing 65.0 mole% acetone (Ac) and the balance acetic acid (AA) is separated in a continuous distillation column at 1 atm. A flowchart for the operation is as follows: The overhead...
-
A company has just paid a dividend of 3.64$. Its discount rateis 10.2%, and the expected perpetual growth rate is 4.6%. Whatwould you expect to be the stock's price IN ONE YEAR? 2 answers
-
In this task your line manager wants to assess your understanding and ability to prepare and produce the appropriate final accounts such as profit and loss account, owners equity statement, and...
-
Lease Classification, Considering Firm Guidance Facts: On 1 / 1 / 2 0 X 3 , Investor, Inc. ( Lessee ) signed a Lease Agreement with Developer Inc. ( Landlord ) to lease Landlord s newly constructed...
-
Post your response to this week's question, and post a reply to at least one other post: In 1996, allegations were made against Moody's that it was issuing ratings on bonds it had not been hired to...
-
High-power experimental engines are being developed by the Stevens Motor Company for use in its new sports coupe. The engineers have calculated the maximum horsepower for the engine to be 600 HP....
-
Explain what a Futures Contract is. What are the five important components of a Futures Contract? What assets might be underlining the assets of a Futures Contract? Identify the main advantages of a...
-
Rhetoric and Communication: Rhetoric is the art of language. It can change minds and impress people of all kinds. In this regard, rhetoric is planned out ahead of time and can be very technical. With...
-
The comparative statement of financial position of Pina Colada Inc. as at June 30, 2023, and a statement of comprehensive income for the 2023 fiscal year follow: PINA COLADA INC. Statement of...
-
The value of a share of common stock depends on the cash flows it is expected to provide, and those flows consist of the dividends the investor receives each year while holding the stock and the...
-
A company buys a machine for $61,700 on January 1, 2012. The maintenance costs for the years 2012-2015 are as follows: 2012, $4,900; 2013, $4,700; 2014, $12,400 (includes $7,800 for cost of a new...
-
On January 1, 2015, Rapid River Realty sold a tract of land to three doctors as an investment. The land, purchased 10 years ago, was carried on Rapid River's books at a value of $210,000. Rapid River...
-
On January 3, 2007, Merris Company spent $89,000 to apply for and obtain a patent on a newly developed product. The patent had an estimated useful life of 10 years. At the beginning of 2011, the...
-
2. In the documentary movie, Expelled: No Intelligence Allowed, there is a 15-second clip of "Imagine," a song by John Lennon. His wife and sons, who held the copyright, sued to block this use of the...
-
3. For many years, the jacket design for Webster's Ninth New Collegiate Dictionary featured a bright red background. The front was dominated by a "bull's-eye" logo. The center of the bull's-eye was...
-
4. Question: Hey, Paula," a pop hit that spent months on the music charts, was back on the radio 30 years later, but in a form the song's author never intended. Talk-show host Rush Limbaugh played a...
Study smarter with the SolutionInn App