Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Answer the following questions in a separate document. Explain how you reached the answer or show your work if a mathematical calculation is needed, or both. Submit your assignment using the assignment link.
Bad Boys, Inc. is evaluating its cost of capital. Under consultation, Bad Boys, Inc. expects to issue new debt at par with a coupon rate of 8% and to issue new preferred stock with a $2.50 per share dividend at $25 a share. The common stock of Bad Boys, Inc. is currently selling for $20.00 a share. Bad Boys, Inc. expects to pay a dividend of $1.50 per share next year. An equity analyst foresees a growth in dividends at a rate of 5% per year. The Bad Boys, Inc. marginal tax rate is 35%. If Bad Boys, Inc. raises capital using 45% debt, 5% preferred stock, and 50% common stock, what is Bad Boys, Inc.’s cost of capital?
If Bad Boys, Inc. raises capital using 30% debt, 5% preferred stock, and 65% common stock, what is Bad Boys, Inc.’s cost of capital?
Imagine yourself as a financial manager in a company, and you are requested to provide a financial report including the calculation of the current market rate of return from the investor's perspective for each of the four investment options, taking into consideration the followings:
Common stocks available for investment are:
2,500,000 shares of common stock, with a par balance of $1 per share.
The current market value of the common share is $24.43 per share.
Annual earnings per share $1.95.
Bonds available for investment
$1,750,000 bonds (A) with an interest of 6.25%, with a current market value of $104 per bond (price of $104 per $100).
$2,250,000 Notes B, with an interest rate of 5.75%, with a current market value of $94.50 (price $94.50 per $100 note).
The corporate tax rate is 35%.
Preferred shares available for investment
950,000 outstanding preferred shares with a par value of $10 with a preferential dividend payment…
The attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends.
On a stand-alone basis which corporation is the least risky?
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Calculate stock and bond valuations for PepsiCo. Specifically, the following critical elements must be addressed: Stock Valuation Based on the figures provided from the financial information you prepared for your selected company, calculate each of the following in Part I of the spreadsheet tab: Stock and Bond Valuation: Fill in the yellow highlighted cells with the matching data prepared for your selected company. Identify the new dividend yields if the company increased its dividend per share by $1.75. Identify the dividend yield if the firm doubled its outstanding shares using a stock split. Note that other numbers will be affected by a stock split such as new stock price, actual dividends paid, and number of outstanding shares. Stockholders' equity will not change. Calculate the rate of return on investment based on the data you calculated in Question 1. What effect would each of the calculations you performed have on shareholder value? In other words, suppose the company's…arrow_forwardWas hoping for clarification about a stock capital concept, assume the following information: A potential investor is interested in buying all the common shares of a private company (ASPE), and becoming the owner. One of the due diligence discovered is: Currently, the company owns both preferred and common shares. There are 500 preferred shares with a cost and redemption value of $10 and $12 per share, respectively, and a 6% mandatory, cumulative dividend yield. These shares will be retained by the current owners of the company. Furthermore, the capital stock currently stated on the financial statements are $55,000 I was wondering, given this information, are there any accounting entries or changes to the SFP that need to be made? From what I know, there should be a dividend payable for the preferred shares. Is there anything else I am missing? Should there be any changes made to the capital stock account? Will this effect the purchase price of company (purchase price is based on net…arrow_forwardResearch walmart and Review its most recent 10-K report and announcement of quarterly or annual dividends per share, an announcement of a stock split of one to two and the purchase of treasury stock. Choose ONE of the questions below to discuss: Discuss the primary reporting alternatives the company has for the repurchase of its own shares and how each option would affect total shareholders’ equity. How would the stock split of one for two be accounted for and how would it affect shareholder’s equity and why? How would the company account for the cash dividends from declaration to the date of payment? What are the important dates for dividends payment and how would it affect the balance sheet and why? Work to demonstrate your understanding of the material from this module and, where necessary, include your sources.arrow_forward
- You own stocks in an oil palm plantation company, and you read in the financial press that a recent bond offering has raised the firm’s debt-equity ratio from 30 percent to 55 percent. Discuss how this change would affect your required rate of return on the common stock of the company. Provide your justification(s) to support your views in the answer space provided.arrow_forwardKoko Services, Inc., has just declared a 2-for-1 stock split. The company’s pre-split common stockholders’ equity was as follows: If the pre-split price of common stock was $28.50, what will the new common equity section of the balance sheet look like? Show all of your calculation work and label all of your work so I can follow your calculation process.arrow_forwardThe Findlay Computer Company has the following selected financial results. The company is considering a capital restructuring to increase leverage from its present level of 10% of capital.Show all of your calculation work and label all of your work so I can follow your calculation process. 1. Calculate Findlay’s ROE and EPS under its current capital structure. 2. Restate the financial statement line items shown, the number of shares outstanding, ROE, and EPS if Findlay borrows money and uses it to retire stock until its capital structure is 40% debt assuming EBIT remains unchanged and the stock continues to sell at its book value. (Develop the second column of the chart shown.)Recalculate same figures assuming Findlay continues to restructure until its capital structure is 75% debt. (Develop the third column of the chart.) Current Capital Structure 10% Debt 40% Debt 75% DebtDebt $10,000 $40,000 $75,000 Equity 90,000…arrow_forward
- You are valuing Estelle Company, a private firm that manufactures shop tools, and you have identified several comparable firms that are publicly owned from which to calculate an estimated price-to-earnings multiple to use in your valuation. One of the comparable firms, Comp A, has a market value per share of $53.40, earnings per share for last year of $4.20 per share, a dividend for last year that was $1.10 per share, forecast earnings per share for the next year of $7.05, and a dividend that is expected to be unchanged. The forward price-to-earnings multiple for Comp A is: a. 17.2 b. 12.7 c. 9.0 d. 7.6 e. None of the above.arrow_forwardYou have been hired as a financial analyst in a consulting firm which primary deals with financial institutions to provide services related to mergers and acquisitions of businesses.As your first project you have been teamed up with a division in your company which specialize in investment appraisals and currently have following tasks in hand: ⦁ Fintech corporation (a long term client) need advice based on higher dividend payout as it is considering to invest in stocks and have following couple of options: RUBIK LLC : Share is currently trading at $56 with expected growth rate of 6% , whereas investor’s required rate of return is 9 % . WOODWORKS LLC : Share is currently trading at $23 with expected growth rate of 2.5% , whereas investor’s required rate of return is 9 % (same as above). You are expected to calculate dividend per share by Divided Growth Model for RUBIK and WOODWORKS.arrow_forwardYou have been presented with the following set of financial statements for National Property Trust, a REIT that is about to make an initial stock offering to the public. This REIT specializes in the acquisition and management of warehouses. Your firm, Blue Street Advisors, is an investment management company that is considering the purchase of National Property Trust shares. You have been asked to prepare a financial analysis of the REIT. National Property Trust Panel A. Operating Statement Summary Net revenue $ 101,000,000 Less: Operating expenses 40,400,000 Depreciation and amortization 23,000,000 General and administrative expenses 6,100,000 Management expense 3,100,000 Income from operations 28,400,000 Less: Interest expense* 6,400,000 Net income (loss) $ 22,000,000 *At 8% interest only. Panel B. Balance Sheet Summary Assets Cash $ 51,600,000 Rents receivable 2,600,000 Properties @ cost 710,000,000 Less: Accumulated depreciation…arrow_forward
- You have been presented with the following set of financial statements for National Property Trust, a REIT that is about to make an initial stock offering to the public. This REIT specializes in the acquisition and management of warehouses. Your firm, Blue Street Advisors, is an investment management company that is considering the purchase of National Property Trust shares. You have been asked to prepare a financial analysis of the REIT. National Property Trust Panel A. Operating Statement Summary Net revenue $ 112,000,000 Less: Operating expenses 44,800,000 Depreciation and amortization 34,000,000 General and administrative expenses 7,200,000 Management expense 4,200,000 Income from operations 21,800,000 Less: Interest expense* 6,400,000 Net income (loss) $ 15,400,000 *At 8% interest only. Panel B. Balance Sheet Summary Assets Cash $ 52,700,000 Rents receivable 3,700,000 Properties @ cost 820,000,000 Less: Accumulated depreciation…arrow_forwardThe attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, and then calculate average returns over the five-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the index. Also, you cannot calculate the rate of return for 2015 because you do not have 2014 data.)arrow_forwardSeveral investors are in the process of organizing a new company. The investors believe that P2,600,000 will be needed to finance the new company’s operation, and they are considering three methods of raising this amount of money. Method A: All P2,600,000 would be obtained through issue of common stock Method B: P 1,300,000 would be obtained through issue of common stock and the other P1,300,000 would be obtained through issue of P100 par value, 12% preferred stock. Method C: P 1,300,000 would be obtained through issue of common stock, and the other P 1,300,000 would be obtained through issue of bonds carrying an interest ate of 12%. The investors organizing the new company are confident that it can earn P520,000 each year before interest and taxes. The tax rate will be 30%. Required: 1. Assuming that the investors are correct in their earnings estimate, compute the net income that would go to the common stockholders under each of the three financing methods listed above. 2. Using the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
What is liquidity?; Author: The Finance Storyteller;https://www.youtube.com/watch?v=XtjS7CfUSsA;License: Standard Youtube License