Question

Please show work, if completed in Excel, please show details:

Practice Question:

part a: What is the annual rate of return for this mutual fund: price $25 (January 1),12/31 price $22.50 (December 31), annual dividend $1.25?

part b: What is the total rate of return to an investor who buys a bond for $1,100 when the bond has a 9% coupon rate and five years remaining until maturity and then sells the bond after one year for $1,085?

*** for part b, I'm not sure if I calculate the bond interest at $1000, as with most bond questions, or at $1100 (.09x1000 or .09x1100) Please explain.

Answer #1

ANSWER DOWN BELOW. FEEL FREE TO ASK ANY DOUBTS. THUMBS UP PLEASE.

A. Annual rate of return = (ending price+dividend-starting price)/starting price

= (22.5+1.25-25)/25

= -0.05

=-5% (ANSWER)

B. Coupon amount (or Interest) is always calculated on the face
value of the bond. Because the company pays interest on the face
value of the bond.

The total rate of return = (selling price of the bond+ coupon
amount-buying price of the bond)/Buying price of the bond.

=(1085+90-1100)/1100

= 6.82% (answer)

Please show all calculations. If using Excel, please show
formulas.
Practice Question:
Calculate the NPV & IRR for the following 5 year
project:
- discount rate of 10%
- ncf yr 0 = -250,000
- ncf yr 1 = 200,000
- ncf yr 2 = 350,000
- ncf yr 3 = 300,000
- ncf yr 4 = 300,000
- ncf yr 5 = -50,000

Please show all calculations. If using Excel, please show
formulas and data.
Practice 9:
You started with a market price of $30 and 10,000 shares.
Calculate number of shares after the split and the per share
price:
*please do this example 2 ways.
part a: calculate as 4 individual splits
part b: calculate splits as successive.... begin with the
original market price and number of shares and calculate the price
and number of shares after 4 consecutive splits
split 1:...

Please show all calculations and formulas. If using Excel (or
tables), please show data, formulas, etc.
Practice question 14:
Calculate the company’s w.a.c.c. using the info
below.
***assume this is a corporate bond that pays 2x annually when
calculating the PV of the bond
Harvey LLC’s capital structure consists of a 25-year bond issued
5 years ago with a coupon of 6% and a par value of $14,000,000. The
company’s main competitor just issued a similar bond paying 5%. The...

Please answer each step to get to the final answer without using
excel. Thank you!
Suppose that an investor with a 10-year investment horizon is
considering purchasing a 20-year 8% coupon bond selling for $900.
The par value of the bond is $1000. The original YTM on the bond is
10%, but the investor expects that he can reinvest the coupon
payments at an annual interest rate of 7% and that at the end of
the investment horizon this 10-year...

PLEASE ANSWER QUESTION A PART 1 and 2 QUESTION B Part 1 and 2
and QUESTION C Part 1
Pleae complete it on excel or copy paste it from excel
A.
ClassCo sells Convertible Bond with warrant to convert into
stock
Bond with face
$1,000
Face Rate
8.00%
Term
3
Yrs.
Market rate @ sale
8.50%
issued:
6/30/2018
maturity
6/30/2021
Interest paid annually
Bond sold for
996.00
Part 1) determine value received from sale, Discount or
Premium?
Part 2)...

Please show how to solve using EXCEL ONLY.
10. Calculate the duration of a $1,000, 12‐year
zero coupon
bond using annual compounding and a current market rate
of 9 percent.
12. Calculate the duration for a $1,000, 4‐year
bond with a
4.5 percent annual coupon, currently selling at par. Use the
bond’s duration to estimate the percentage change in the
bond’s price for a decrease in the market interest rate to
3.5 percent. How different is your answer from the...

Please show all work with equations. No excel please!
Thanks!
QZY Inc. is evaluating new widget machines offered by three
companies.
MARR = 15%. From which company, if any, should you buy the
widget machine? Use rate of return analysis.
Company A
Company B
Company C
First Cost, $
15,000
25,000
20,000
Maintenance & Operating Costs, $
1,600
400
900
Annual Benefit, $
8,000
13,000
9,000
Salvage Value, $
3,000
6,000
4,500
Useful Life, in years
3
3
3

Ques 1 a) Assume an original issue bond with 30 years remaining
to maturity which has a coupon rate of 4.5 % and the going rate of
interest in the market is 4.5%. Its par value is $1000.
b. What would its price be? Show all calculations, either in
formulas or in Excel.
c. In a above, did you actually have to calculate the price?
Could make a reason that the price should be $1000.
Ques 2. a) If the...

Please use Excel
to answer the following TVM questions. You can use this spreadsheet
to set up your calculations if you so desire. Unless indicated
otherwise, assume that all of the problems are ordinary annuities
(payment made at the end of the
period).
Part 4 I need $1,000,000 in 20 years if I am going to retire
(Fat Chance!!) I currently have $100,000 saved for my retirement (I
wish!!). A slick Wallstreet investment expert with the last name of
Madoff...

*Please show work and explain*
An investor bought 100 shares of Copier Corp. for $90 a share.
The firm paid an annual dividend of $4 a share; the margin
requirement was 60 percent with an interest rate of 8 percent on
borrowed funds, and commissions on the purchase were $15 and on the
sale were another $15. The price of the stock rose to $120 in one
year.
What is the percentage return earned on the investment if the
stock...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 17 minutes ago

asked 17 minutes ago

asked 18 minutes ago

asked 19 minutes ago

asked 20 minutes ago

asked 30 minutes ago

asked 34 minutes ago

asked 34 minutes ago

asked 38 minutes ago

asked 38 minutes ago

asked 40 minutes ago