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)
SOLUTION IN DETAILS To calculate the weighted average cost of capital WACC for Lightning Power Co we ... 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...
-
The July bank statement for A & H Iron Works shows a balance of $37.94 and a service charge of $8.00. The account register shows deposits of $650 and $375.56 that do not appear on the statement....
-
How can more disclosure in the notes to the financial statements facilitate the analysis of foreign financial statements?
-
What do you understand by fluid mechanics? How does it differ from mechanics of solid or mechanics of the rigid body?
-
In this age of high, technology and computer-based information systems, why accountants are concerned about physical (human) controls?
-
Calculate the tension in the following figure: T 30 30 250 N T2
-
HTLM5 AND CSS View as TextDownload / 1 Exam 4: Video and Animation 1. Add video a1.mp4 to the page, size is 300px by 300px, letthe video play automatically, rewind to play automatically (15 points)...
-
Compute the effect of the new lease accounting standard on the following measures for American Airlines in 2019 (in other words, how different would these measures be under the old accounting...
-
A C.D. Howe Institute study says the legalized sale of marijuana could bring tax revenues of $675 million in 2018. But if governments get too greedy, consumers will go to the black market as they do...
-
When John Wicks opened his natural gas bill for January he was very happy. It was $147, not the usual $300 for the coldest month. Natural gas provider CenterPoint Energy said higher temperatures had...
-
If the $5 price described in the news clip were adopted, how would consumer surplus, producer surplus, and the deadweight loss change? The price of streaming services has been $10 a month or zero....
-
Write down the Haar matrix for \(m=4\).
-
In BPF domain, using the operational matrix \(\mathbf{P}\), we can integrate any time function expanded via block pulse functions. Why this matrix \(\mathbf{P}\) is called an 'Operational Matrix'? To...
-
(Figure 1)A roller coaster car may be approximated by a block of mass m. The car, which starts from rest, is released at a height h above the ground and slides along a frictionless track. The car...
-
Smthe Co. makes furniture. The following data are taken from its production plans for the year. Required: 1. Determine the hazardous waste disposal cost per unit for chairs and for tables if costs...
-
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...
-
In testing the claim that the mean IQ score of statistics students is greater than 100, the alternative hypothesis is expressed as > 100. Decide whether the statement makes sense (or is clearly...
-
A significance level of 0.05 indicates that the probability of making a type I error is 0.05.
-
H a : 2.55, n = 100, x = 2.58, = 0.29. Find the value of the standard score, z, and determine whether the alternative hypothesis is supported at a 0.05 significance level.
Study smarter with the SolutionInn App