Home » Equity & Fixed Income Securities

Equity & Fixed Income Securities

I was wondering if someone could help me with questions 3 and 4? I keep running formula’s but I the answers I’m getting just can’t be right.. Please review the ‘overview’ tab. I need the fx function formulas for PV, FV and RATE for sure just regular formulas for the rest. Thanks so much!

Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the “Analysis ToolPak” or “Solver Add-In” be installed in Excel.
To install these, click on the Office button
then “Excel Options,” “Add-Ins” and select
“Go.” Check “Analyis ToolPak” and
“Solver Add-In,” then click “OK.”
The concept of time value of
money and bonds go hand in hand.
In these examples, you will be able
to solve time value of money
problems with Excel.
These components are required
for each problem that you solve.
To begin a function, start with the
fx on your toolbar
Once you select fx
on your tool bar,
search for the PV
function
PV
FV
PMT
N
I
Once you select
on your tool bar,
search for the
function
ce you select fx
your tool bar,
arch for the PV
Once you select fx
on your tool bar,
search for the FV
function
Enter any payment amount.
Usually 0, or the coupon
payment if calculating bond
prices.
Once you select fx
on your tool bar,
search for the RATE
function
Make sure you
calculate the correct
number of
payments.
Sample problem
Present Value
Output area:
Input area:
Present value
($505.07)
($4,688.96)
($12,708.73)
($1,009.46)
Years
Interest rate Future value
15
5% $
1,050
25
4% $
12,500
10
7% $
25,000
20
2% $
1,500
Future Value
Output area:
Input area:
Future value
$2,182.87
$33,322.95
$49,178.78
$2,228.92
Years
Interest rate Present value
15
5% $
(1,050)
25
4% $
(12,500)
10
7% $
(25,000)
20
2% $
(1,500)
Interest Rate
Output area:
Input area:
Interest Rate
5%
4%
7%
2%
Years Future Value Present value
15
2,183 $
(1,050)
25
33,323 $
(12,500)
10
49,179 $
(25,000)
20
2,229 $
(1,500)
The present value will always come
out negative (red or in parenthesis) in
Excel. Think of it as you are taking the
amount out of your pocket right now,
so you would be in the negative!
1.
PV
FV
PMT
N
I
2.
The Piedmont Flyers have issued a 30-year bond with a face value of $100
$751.82
($1,000)
-50
30
7%
The Piedmont Flyers have issued a 30-year bond with a face value of $1000
PV
$723.24
FV
($1,000)
PMT
-20
N
60
I
3%
3.
The Piedmont Flyers have issued a 8-year bond with a face value of $1000.
PV
FV
PMT
N
I
4.
PV
FV
PMT
N
I
The Piedmont Flyers have issued a 30-year bond with a selling price of $75
ith a face value of $1000 and a 5% coupon rate. The market is yielding 7%, what is the current selling price
th a face value of $1000 that pays semiannually with a 4% coupon rate. The market is yielding 6%, what is
h a face value of $1000. The price of the bond is $880. The market rate is 10% annually. What is the coupon
th a selling price of $750 and a coupon payment of $100. The face value is $1000. What is the return on th
is yielding 6%, what is the current selling price of the bond?

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYHELP