A Gateway Inc. has an issue of preferred stock that pays $3.40 dividend every year in perpetuity. If this issue currently sells for $91 per share, what is the required 1 return?
Q: a. Calculate the size of the periodic sinking fund deposit. Round your answer up to the next cent b.…
A: Please note that as per the guidelines, only the first three questions a, b and c are to be…
Q: ABC Corporation plans to purchase a call option for 1,000 Red Corp. ordinary shares at a strike…
A: Stock Price P…
Q: A landscaping company buys a new bulldozer for $61,000.00. The company makes a down payment of…
A: The loans are paid by the monthly payments that are equal monthly payments these carry the payment…
Q: Determine the Future Value after 20 years for an annuity of $500 deposited every 3 months,…
A: We need to use below mention TVM functions to calculate future value. N=Number of periods I/Y…
Q: It is likely that airplane tickets will increase 6% in each of the next 3 years. The cost of a plane…
A: Annual increase in tickets = 0.06 Interest rate = 0.01 or 1% Year Increase in ticket price Ticket…
Q: Rafner Manufacturing identified the following budgeted data in its two production departments.…
A: Overhead are those expenses which is incurred during the production of any product. it will be…
Q: Q 6. An Investor has €20000 and faces an interest of 5% in the Euro Zone or he could his Euro for…
A: Exchange rate as per Interest rate parity theorem can be computed as follows Forward Rate = Spot…
Q: A loan can be repaid in two ways: (i) a perpetuity- due with annual payment $1000; (ii) a 3-year…
A: Deferred Annuituy occurs where the payment is delayed by a specified period. During this period the…
Q: ABC Company issued a $250,000 bond at the coupon rate of 2 percent payable semi-annually. Now, the…
A: i. Par value or maturity value of the bond (Z) = $250,000 Semiannual coupon rate = 0.01 (i.e.…
Q: ABC Co., a private contractor, wins a bid to construct an expressway for a provincial government,…
A: As per the Provision of PFRS 115 revenue from contract with customers, revenue can be recognize on…
Q: PLease how to obtain YTM without excel and mathematical calculator. i really need to know how to…
A: Formula for YTM: YTM =C+(FV - PV)n(FV+PV)2 Where C= Coupon payment FV= Face value of security PV=…
Q: Irving Corp. has no debt but can borrow at 7.25 percent. The firm's WACC is currently 13 percent,…
A: When firm does not have debt, cost of equity = WACC. Firm's cost of equity when it has 25% debt:…
Q: Compute the missing variable for each of the following alternatives of investments to accumulate…
A: The present value can be converted the future value using the technique of compounding, while the…
Q: A firm wants to reduce its cash conversion cycle sharply. Which of the following actions should it…
A: Cash conversion cycle is an important metric used in finance. Essentially this metric determines the…
Q: Trapper Corporation is comparing two different capital structures, an all-equity plan (Plan I) and a…
A: MM Proposition I maintains that the capital structure of the company has no bearing on its value…
Q: Mickey and Minnie just bought a zero coupon bond for $597.97, but they cannot recall when it…
A: A zero coupon bond is a bond that pays no coupons. Instead this bond is issued at a deep discount…
Q: The graph below charts the past five years of returns for two different assets. Percentage Return…
A: The correlation between returns is used to measure the effect of the change of the return of one…
Q: (Related to Checkpoint 9.2) (Yield to maturity) The market price is $1,100 for a 12-year bond…
A: Solution:- Yield to maturity (YTM) means the rate of return yielded by bond, if bond is hold until…
Q: DYC Co is a medium sized manufacturing company that plans to increase capacity by purchasing new…
A: NPV is a capital budgeting techniques which help in decision making on the basis of future cash…
Q: George took out a mortgage loan of $1 120 000 for 12 years at 4.55% p.a. compounding weekly. What is…
A: Mortgage loan = $1,120,000 Time Period = 12 Years Interest Rate = 4.55%
Q: What is the present value of the following set of cash flows at an interest rate of 6% p.a.…
A: Present Value: The present value is the current value of a series of fixed payments. The series of…
Q: A call option for a P5,000,000-face value bond has a strike price of 101. If the market value of the…
A: Strike price = $5,000,000 * 1.01 = $5,050,000 (i.e. Face value * priced at) Market value =…
Q: What is the price of the following quarterly bond? years face value: maturity: coupon rate: discount…
A:
Q: Your company has earnings per share of $8. It has 1 million shares outstanding, each of which has a…
A: Answer a:- * Calculation of number of shares after merger:- We are given that our company has a…
Q: What is the most we should pay for a bond with a par value of $1000, coupon rate of 4.2% paid…
A: The most that we should pay for a bond is its present value. Present value of a bond is essentially…
Q: a. Calculate the total book value of Meyer's common stock. b. What is the book value per share of…
A: Cumulative Preferred Stock: A preference stock that benefits a stockholder by providing the previous…
Q: Doisneau 22-yearbonds have an annual coupon interest of 11percent, make interest payments on a…
A: Data given: Par value = $ 1000 Coupon rate = 11% (semi-annual) = 11%/2 = 5.5% N=22 year n=Period =…
Q: Saylor, who earned $152 906 profit from his gamble on bitcoin, decides to invest half of the money…
A: Given: Particulars Amount Profit earned $152,906 Years 10 Interest rate 9.25%
Q: The par value of 10% debenture is $1,000 with maturity is 3 years. What would be the price if…
A: Data given: Coupon rate = 10% Par value = $1000 n= 3 years Required: Price if interest rate is a)…
Q: Suppose you just won the state lottery, and you have a choice between receiving $3,550,000 today or…
A: Choice-1 Amount to receive today is $3,550,000 Choice -2 Annuity amount is $250,000 Time period is…
Q: machine has a first cost of P800,000 and a salvage value of P50,000 at the end of its life after 10…
A: The return on investment is the profit earned annually above the annual cost of operating on initial…
Q: h. Return on equity J. Compound leverage ratio k. Net cash provided by operating activities %
A: Cash flow from operating activities is the cash flow generated from operations by the firm. The net…
Q: VALUATION METHOD DISCOUNTED CASH FLOW METHOD
A: CAGR: It is a measure of the smoothed rate of return. It helps investors to compare the compounded…
Q: what is an available-for-sale security?
A: Securities are financial instruments that can be traded easily. The entities use these securities to…
Q: 18. Which of the following statements is false? Select one: a. Simple interest relates to present…
A: Simple interest is a quick and simple method for calculating loan interest. The daily interest rate…
Q: If you invested $12,000 for ten years at 7.25% p.a. compounded fortnightly, how much in total would…
A: FV = PV* (1 + r / n)nt Where, PV = Present value FV = Future value r = Rate of interest (percentage…
Q: Tan Company purchased a large server for $23,000. The company paid 40.00% of the value as a…
A: The concept in the question is of Annuity. Annuity is a stream of equal payments/receipts made at…
Q: The MM irrelevance capital structure theory proved that a firm’s value is unaffected by its capital…
A: The MM irrelevance capital structure theory states that a firm’s valuation is unaffected by its…
Q: Using exact interest, what is the amount due on Php 20,000 invested at 0.09% simple interest for 150…
A: Given: Interest rate =0.09% Days = 150 Days Amount = Php 20,000
Q: 8. Your father has promised you a large sum of money. He has offered you the following THREE…
A: Present value of annuity is the current value of the future payments that are calculated using the…
Q: Assume that Skye uses the book value of each capital compoent for the weights of capital components.…
A: WACC: It is the average cost of capital of the business and is estimated by the sum of all costs of…
Q: Use the option data from the table to determine the rate Buffin would have paid if it had issued…
A: The yield on the debt is defined as the rate of return that is expected by an investor to earn on…
Q: (Related to Checkpoint 9.3) (Bond valuation) Pybus, Inc. is considering issuing bonds that will…
A: Price / Present Value can be calculated using PV function in excel PV (rate, nper, pmt, [Fv],…
Q: How much interest (to the nearest dollar) would be saved on the following loan if the home were…
A: Mortgage/ Borrowings: Borrowings are the loans taken by an individual, from banks or non-banking…
Q: Courtney purchased a house for $475,000. She made a down payment of 25.00% of the value of the house…
A: Here, To Find: Part 1. Monthly payment =? Part 2. Principal Balance at the end of 3 years =? Part…
Q: ich of the following will not reduce risk in a portfolio? Select one: a. Selecting two…
A: Portfolio risk :- A portfolio is a combination of various assets that carries a risk that the value…
Q: The Corner Grocer has a 7-year, 6 percent annual coupon bond outstanding with a GHS 1,000 par value.…
A:
Q: Calculate the simple interest earned on an investment of: $2 000 at 4% per annum for three years…
A: Here, Investment Amount (P) is $2,000 Time Period (T) is 3 years Rate (R) is 4%
Q: What is the balance of the loan at the end of year 3? $0.00 Round to the nearest cent c. By how much…
A: Loans are paid by the monthly equated payments that carry the payment for loan principal amount and…
Q: ELECTRON Computers just issued a bond that matures in 8 year equal to $1,000 and its coupon rate is…
A: Price of bond is present value of coupon payment and present value of par value of bond taken on the…
What's the equation in excel?
Step by step
Solved in 3 steps with 2 images
- Start with the partial model in the file Ch09 P18 Build a Model.xlsx on the textbook’s Web site. The stock of Gao Computing sells for $50, and last year’s dividend was $2.10. A flotation cost of 10% would be required to issue new common stock. Gao’s preferred stock pays a dividend of $3.30 per share, and new preferred stock could be sold at a price to net the company $30 per share. Security analysts are projecting that the common dividend will grow at a rate of 7% a year. The firm can issue additional long-term debt at an interest rate (or a before-tax cost) of 10%, and its marginal tax rate is 35%. The market risk premium is 6%, the risk-free rate is 6.5%, and Gao’s beta is 0.83. In its cost-of-capital calculations, Gao uses a target capital structure with 45% debt, 5% preferred stock, and 50% common equity.Start with the partial model in the file Ch09 P18 Build a Model.xlsx on the textbook’s Web site. The stock of Gao Computing sells for $50, and last year’s dividend was $2.10. A flotation cost of 10% would be required to issue new common stock. Gao’s preferred stock pays a dividend of $3.30 per share, and new preferred stock could be sold at a price to net the company $30 per share. Security analysts are projecting that the common dividend will grow at a rate of 7% a year. The firm can issue additional long-term debt at an interest rate (or a before-tax cost) of 10%, and its marginal tax rate is 35%. The market risk premium is 6%, the risk-free rate is 6.5%, and Gao’s beta is 0.83. In its cost-of-capital calculations, Gao uses a target capital structure with 45% debt, 5% preferred stock, and 50% common equity. A: Calculate the cost of each capital component—in other words, the after-tax cost of debt, the cost of preferred stock (including flotation costs), and the cost of equity…Start with the partial model in the file Ch11 P18 Build a Model.xlsx. The stock of Gao Computing sells for $70, and last year's dividend was $4.38. Security analysts are projecting that the common dividend will grow at a rate of 7% a year. A flotation cost of 11% would be required to issue new common stock. Gao's preferred stock sells for $21.74, pays a dividend of $2.20 per share, and new preferred stock could be sold with a flotation cost of 8%. The firm has outstanding bonds with 20 years to maturity, a 9% annual coupon rate, semiannual payments, and $1,000 par value. The bonds are trading at $839.54. The tax rate is 25%. The market risk premium is 6%, the risk-free rate is 6.5%, and Gao's beta is 1.2. In its cost-of-capital calculations, Gao uses a target capital structure with 40% debt, 10% preferred stock, and 50% common equity. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below.…
- Start with the partial model in the file Ch11 P18 Build a Model.xlsx. The stock of Gao Computing sells for $70, and last year's dividend was $4.38. Security analysts are projecting that the common dividend will grow at a rate of 7% a year. A flotation cost of 11% would be required to issue new common stock. Gao's preferred stock sells for $21.74, pays a dividend of $2.20 per share, and new preferred stock could be sold with a flotation cost of 8%. The firm has outstanding bonds with 20 years to maturity, a 9% annual coupon rate, semiannual payments, and $1,000 par value. The bonds are trading at $839.54. The tax rate is 25%. The market risk premium is 6%, the risk-free rate is 6.5%, and Gao's beta is 1.2. In its cost-of-capital calculations, Gao uses a target capital structure with 40% debt, 10% preferred stock, and 50% common equity. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below.…(Calculating rates of return) On December 17, 2007, the common stock of Google Inc. (GOOG) was trading for $ 669.23. One year later the shares sold for only $ 315.24. Google has never paid a common stock dividend. What rate of return would you have earned on your investment had you purchased the shares on December 17, 2007? Question content area bottom Part 1 The rate of return you would have earned is enter your response here %. (Round to two decimal places.)will you recommend investing in Apple by buying stock? September 24, 2022 September 25,2021 % Change Total Net Sales($ in millions) 394328 365817 7.79% Operating Income ($ in millions) 119437 108949 9.63% EPS(Basic) ($) 6.15 5.67 8.47%
- Ma3. Question 7 The PX exchange uses maker/taker pricing: orders that add liquidity receive a rebate of $0.001 per share; orders that take liquidity pay $0.002 per share. Sam just entered an order to buy 100 shares limit $20. This order goes into the book. Shortly thereafter Mona enters an order to sell 100 shares, limit $19. a. What is the price paid by Sam net of maker-taker pricing? b. What is the price received by Mona net of maker-taker pricing?Arianna just made another fantastic investment: She purchased 400 shares in Great Gains Corporation for $31.5831.58 per share. Yesterday the stock closed at $86.2986.29 per share. In order to lock in her gains, she has decided to employ a stop-loss order. Assuming she set the order at $85.8185.81, what is likely to happen? Why might this not be a wise decision? At what price would you recommend setting the stop-loss order? Why? Question content area bottom Part 1 In order to lock in her gains, she has decided to employ a stop-loss order. Assuming she set the order at $85.8185.81: (Select the best answer below.) A. It is unlikely that the position will be sold as the stock fluctuates around its closing price. B. There is not enough information to answer this. C. It is likely that the position will be sold as the stock fluctuates around its closing price. Your answer is correct. Part 2 At what price would you recommend setting the…hoose a publicly traded company that interests you and find the price of its stock on your last birthday and yesterday. Calculate the difference in its stock value between yesterday and your last birthday. Calculate how much you would have made or lost if you had purchased 1000 shares of that stock on your last birthday and sold it yesterday. Show all your calculations in your response Company :Amazon stock price today: 129.33 stock price on last DOB 8/26/92: 136.55
- TJMaxx (TJX) stock is currently selling for $796.96. You are thinking about buying it and you hope to sell it for $1141.71 in 4 years. What is the implied return? Round to 2 decimal places. Include a dollar sign ($) or percent (%) as appropriate.3. Using your iphone, you noticed that IBM was trading at a bargain price, so you decided to purchase 100 shares of stock that is traded on the New York Stock Exchange using your primary stock trading app. What kind of transaction was this? Primary market Secondary market Futures market Private Placement 4. P&G reported the following information for its fiscal year end: On net sales of $51.4 billion, the company earned net income after taxes of $6.5 billion. It had cost of goods sold of $25.1 billion and EBIT of $9.8 billion. Using the information in question 3, calculate the gross margin Using the information in question 3, calculate the operating margin (EBIT margin) Using the information in question 3, calculate the net profit marginY8 Sarah bought stock on margin 8 months ago borrowing $10,000 at 7% EAR. She has just received a margin call for $3000 and her maintenance and initial margin was 15%. What must be the current value of the assets, BEFORE THE CALL, in her margin account? [Choose closest] a) Cannot be determined with the information provided, we need the number of shares b) Cannot be determined with the information provided, we need to know the original asset value c) $0 d) $9,310.51 e) $12,310.51 The answer is d) but why?