Assignment 5-4 Worksheet

xlsx

School

Indiana Wesleyan University, Marion *

*We aren’t endorsed by this school

Course

320

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

32

Uploaded by ConstableLapwingPerson2642

Report
Assignment 5.4 Exercises Problem 1: Calculating Holding Period Return Information about three securities is listed below: Security End of Year Price Stock A $106.35 $112.40 $1.85 Stock B $1.65 $1.85 $0.00 Bond X $1,052.00 $1,028.00 $47.00 Use the information provided above to answer the following questions. a) What is the Holding Period Return for each of these securities? Use the Template Provided Below to Create Your Solution - Pay close attention Input / Output area: Security Starting Price ($) Ending Price ($) Income ($) Stock A $ 106.35 $ 112.40 $ 1.85 Stock B $ 1.65 $ 1.85 $ - Bond X $ 1,052.00 $ 1,028.00 $ 47.00 b) Intepretation: How does repurchasing shares affect the calculation for Ho Beginning of Year Price Interest or Dividend Paid During Year b) Suppose that during the year, the executives of Stock A decided to spend spent $1 calculation of the Holding Period Return? Share repurchases, or buybacks, affect the Holding Period Return indirectly by inf Period Return formula includes capital gain (loss) and dividend yield. Since share Consequently, while repurchases can affect metrics like earnings per share (EPS)
5 Points to the formulas and formatting of the inputs, and be sure to ans Change in Price Capital Gain (loss) + Dividend Yield $ 6.05 5.69% 1.74% $ 0.20 12.12% 0.00% $ (24.00) -2.28% 4.47% olding Period Return? 185 million repurchasing the company's shares. How, if at all, does th fluencing the number of outstanding shares but not the price changes repurchases don't alter the beginning and ending prices, their primar ), their direct impact on the Holding Period Return is limited as this re
swer both parts of the question. = Holding Period Return 7.43% 12.12% 2.19% his information affect the s or dividends directly used in the calculation. The Holding ry impact is on the number of shares outstanding. eturn is mainly driven by price changes and dividends.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Assignment 5.4 Exercises Problem 2: Calculating Holding Period Return Information about three securities is listed below: Security End of Year Price Preferred A $10.00 $10.00 $0.75 Common B $38.00 $36.50 $3.35 Bond C $985.00 $1,035.00 $78.00 Use the information provided above to answer the following questions for EACH securi a) What is the Capital Gain (loss) in dollar terms? What is the Capital Gain Yield (%)? b) What is the Dividend Yield (%)? c) What is the total Holding Period Return (%)? Create your Original Solution Below - Be sure to show all calculations and clearly Security Starting Price ($) Ending Price ($) Income ($) Common B $ 38.00 $ 36.50 $ 3.35 Preferred A $ 10.00 $ 10.00 $ 0.75 Bond C $ 985.00 $ 1,035.00 $ 78.00 Beginning of Year Price Interest or Dividend Paid During Year
5 Points ity. y indicate answers. Change in Price Capital Gain (loss) + Dividend Yield $ (1.50) -3.95% 8.82% $ - 0.00% 7.50% $ 50.00 5.08% 7.92%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
= Holding Period Return 4.87% 7.50% 12.99%
Assignment 5.4 Exercises Problem 3: Calculating Return Components 5 Points a) What was the dividend yield, in percentage terms? b) What was the capital gain from price appreciation on the stock, in percentage terms c) What was the total return in dollars? What was the total return, in percentage terms Create your Original Solution Below - Be sure to show all calculations and clear Purchase Price ($) $ 50.00 Selling Price ($) $ 55.00 Dividends Received ($) $ 7.00 Output area: a) Dividend Yield 14.0% b) Capital Gain ($) $ 5.00 Capital Gain (%) 10.0% c) Total Return ($) $ 12.00 Total Return (%) 24.0% An investor purchases one share of stock for $50. After one year, they sell the share for $55. During the year, they receive $7 in dividends.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
s? s? rly indicate answers.
Assignment 5.4 Exercises Problem 4: Calculating Dollar Returns with Exchange Rates 5 Points a) What was the purchase price in US Dollars? c) What was the bond's selling price, in US Dollars? d) What was the investor's total earnings during the year, in US Dollars? Use the Template Provided Below to Create Your Solution - Pay close attention Input area: Purchase Price (euros) 1,023.00 Par Value (euros) 1,000.00 Exchange Rate at Purchase (USD/EUR) 1.24 Coupon Rate (%) 8.0% Selling Price (euros) 918.00 Exchange Rate at Sale (USD/EUR) 1.10 Output area: a) Purchase Price (dollars) $ 825.00 e) Intepre b) Coupon Interest Earned (dollars) $ 72.73 Capital Loss (dollars) $ (95.45) Gain from Exchange Rate (dollars) 105 c) Sale Price (dollars) $ 834.55 d) Total Earnings (dollars) $ 82.27 Total Earnings (%) 9.97% An American investor purchases a single Eurobond from their personal financial advis their American dollars to make the purchase. The bond sells for 1023 euros, and has exchange rate is $1 US Dollar per 1.24 Euros. The coupon rate on the bond is 8%, p sells the bond for 918 euros. The exchange rate at the time of sale has fallen to $1 U b) How much money did the investor earn from coupon interest, in dollars? How muc decline in the bond's price? How much did they gain from the change in the exchang e) The bond fell in value dramatically during the year. Its price fell by over 10% in Eur money, in US Dollars, than they bought it for, and earned a substantial return. How is Bonds giv from the g
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
to the formulas and formatting of the inputs, and be sure to answer all parts of the ques etation: How is it possible to earn a substantial return even though the bond's price fell sor. The bond is denominated in Euros, but the investor uses s a par value of 1000 euros. At the time of purchase, the paid annually. One year later, the coupon is paid and the investor US Dollar per 1.10 Euros. ch did they lose due to the e rate? ros! Nevertheless, the investor sold the bond for more s this possible? Explain. ves a fixed income, so as prices decline, the bond rate will not change for the price you paid fo greater price of the bond at which you purchased it.
stion. dramatically? or it.You will profit
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Assignment 5.4 Exercises Problem 5: Determining Issue Costs a) At what price will the shares be sold to the public? b) What price per share will the company actually receive? c) How many shares must the company sell to raise the desired funds? d) How much money will the investment banking syndicate earn on the s e) What is the total cost of raising the funding, due to both investment ba Use the Template Provided Below to Create Your Solution - Pay clo Input area: Desired Funds ($) $ 275,000,000 Current Stock Price ($ per share) $ 38.00 Underpricing (%) 9.0% Investment Banker's Spread (%) 8.0% Output area: a) Price shares will be sold at: $ 34.58 b) Net price company will receive: $ 31.81 c) Shares that must be issued: 8,644,102 d) Investment bank earnings: $ 23,913,043 Cost of underpricing: 29562828.475872 e) Total cost of raising funds: $ 53,475,872 Cost as percentage of funds raised: 19.45% A growing company wants to raise $275 million in a new stock issue. Its underpricing to attract new investors. They will also charge an 8 percent public stock price, while the spread represents a cut of the issue price. T
5 Points sale? ank costs and underpricing? ose attention to the formulas and formatting of the inputs. s investment banker indicates the sale of stock will require 9 percent t spread. Underpricing is expressed as a percentage of the current The company's current stock price is $38 per share.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Assignment 5.4 Exercises Problem 6: Determining Issue Costs a) At what price will the shares be sold to the public? b) What price per share will the company actually receive? c) How many shares must the company sell to raise the desired funds? d) How much money will the investment banking syndicate earn on the s e) What is the total cost of raising the funding, including all costs? Create your Original Solution Below - Be sure to show all calculatio Desired Funds ($) $ 680,000,000 Current Stock Price ($ per share) $ 53.00 New Issue Price ($ per share) $ 50.35 Investment Banker's Spread (%) 4% Adminstrative and Legal Costs ($) $ 1,850,000.00 Underpricing 5% Output area: a) Price shares will be sold at: $ 50.35 b) Net price company will receive: $ 48.34 c) Shares that must be issued: 14,068,189 d) Investment bank earnings: $ 28,333,333 Cost of underpricing: 37280701.7543859 e) Total cost of raising funds: $ 65,614,035 Cost as percentage of funds raised: 9.65% A large, mature company wants to raise $680 million in a new stock issu percent underpricing to attract new investors. They will also charge a 4 p legal and adminstrative fees to raise these funds. The company's curren
10 Points sale? ons and clearly indicate answers. ue. Its lead investment banker indicates the sale of stock will require 5 percent spread. The company expects they will incur $1,850,000 in nt stock price is $53 per share.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Assignment 5.4 Exercises Problem 7: Impact of Financial Leverage Use the Template Provided Below to Create Your Solution - Pa Input area: Expected EBIT After Project ($ millions) Funding Needed ($ millions) Annual Interest on Existing Debt ($ millions) Interest Rate on New Debt (%) Sinking Fund Payments on Existing Debt ($ millions) Sinking Fund Payment on New Debt ($ millions) Common Stock Price ($ per share) Price of New Issue of Stock ($ per share) Common Shares Outstanding (millions) Effective Tax Rate (%) Output area: a) Equity Funding Times-Interest-Earned Ratio Times-Burden-Covered Ratio New Shares to Issue (millions) Earnings per Share Behemoth Enterprises needs to raise $10 Billion to fund a major n executives are debating whether to raise the money by issuing deb goes through, the company's Earnings Before Interest and Taxes ( project, they will have to pay interest of 5% on this new debt, along Billion the company already pays in interest on its existing debt, pl issue new shares of stock, their investment banker predicts they w Billion shares outstanding at $11.50 per share. The company's eff a) If the company raises the funding with equity, what will be its tim What will be its earnings per share? b) If the company raises the funding with debt, what will be its time will be its earnings per share?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
b) Debt Funding Interest Payments on New Debt ($ millions) Times-Interest-Earned Ratio Times-Burden-Covered Ratio Earnings per Share
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
5 Points ay close attention to the formulas and formatting of the inputs. $ 9,700,000,000.00 $10,000,000,000.00 $ 2,750,000,000.00 5.0% $ 2,300,000,000.00 $ 200,000,000.00 $ 11.50 $ 10.00 $ 8,700,000,000.00 21.0% 3.53 1.71 1000000000.00 $ 0.57 new project designed to reinvigorate the giant company's growth. The company's top bt or by issuing new shares of stock. Their team of analysts predict that if the project (EBIT) will increase to $9.7 Billion. However, if the company uses debt to fund the g with $200 million in annual sinking fund payments. This would be on top of the $2.75 lus $2.3 Billion in annual sinking fund payments. If the company instead chooses to will be able to issue additional shares at $10 per share. The company currently has 8.7 fective tax rate is 21%. mes-interested earned ratio? What will be its times-burden-covered ratio? es-interested earned ratio? What will be its times-burden-covered ratio? What
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$ 500,000,000.00 2.98 1.51 $ 0.59
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Assignment 5.4 Exercises Problem 8: Impact of Financial Leverage c) Which option would you suggest Doug pursue? Why? Create your Original Solution Below - Be sure to show all calculations and clea Expected EBIT After Project ($) $ 350,000.00 Funding Needed ($) $ 200,000.00 Annual Interet on xExisting Debt ($) $ 10,000.00 Interest Rate on New Debt (%) 8.0% Sinking Fund Payments on Existing Debt ($) $ 3,000.00 Sinking Fund Payment on New Debt ($ ) $ 7,500.00 Common Stock Price ($ per share) $ 15.00 Price of New Issue of Stock ($ per share) $ 10.00 Common Shares Outstanding (# of shares) 80,000 Effective Tax Rate (%) 21.0% Output area: a) Equity Funding Times-Interest-Earned Ratio 35.00 Times-Burden-Covered Ratio 25.37 New Shares to Issue (shares) 20,000.00 Earnings per Share $ 2.69 Pipsqueak Co. has an exciting opportunity to buy out its main local competitor for $2 the combined EBIT of the merged companies would be $350,000. To pay for the ac backed by his home mortgage, at an interest rate of 8%. In addition, $7500 of princi only has a small amount of existing debt, necessitating $10,000 in annual interest pa Pipsquek's competitor has offered to instead take stock as a form of payment, rather per share, and the competitor's current owner would become a part-owner in Pipsqu about $15 per share. Doug owns all 80,000 existing shares. The company's tax rate a) If the company raises the funding with equity, what will be its times-interested earn What will be its earnings per share? b) If the company raises the funding with debt, what will be its times-interested earne What will be its earnings per share?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
b) Debt Funding Interest Payments on New Debt ($) $ 16,000.00 Times-Interest-Earned Ratio 13.46 Times-Burden-Covered Ratio 8.91 Earnings per Share $ 3.20 c) Which option would you suggest Doug pursue? Why? Doug's financing decision hinges on his priorities. If he values ownership control Doug is open to debt, he might consider debt financing. It boils down to Doug's sp recommended before deciding.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
10 Points arly indicate answers. 200,000. Doug Kindle, owner/operator of the business, calculates cquisition, he is considering taking out a loan with his local bank, ipal payments would be due each year. Fortunately, the company ayments and $3000 in principal payments. However, the owner of r than cash. In this case, Doug would issue shares of stock at $10 ueak Co. Doug's accountant tells him his current stock is worth e is 21%. ned ratio? What will be its times-burden-covered ratio? ed ratio? What will be its times-burden-covered ratio?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
and risk avoidance, equity financing is suitable, albeit with a lower EPS. If maximizing EP pecific goals and preferences. Seeking advice from financial experts for a thorough evalu
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
PS is a priority and uation is
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help