Buy Financial Modeling Discussion

Buy Financial Modeling Discussion
1. Submit your solutions to the specific questions below, electronically via Canvas. To
upload your solution, go to our Canvas page, select the ‘Assignments’ folder on the
left, choose Exam II, and click on “View Details and Submit.” Once you have attached
the file, please, click SUBMIT. Clicking SAVE AND EXIT is not enough! Please, do not
e-mail me your assignments.
2. Please, use the attached Excel template for your solutions.
3. You must submit your solution by 11:55 p.m. on Monday, April 5, 2021. Late
submissions are not accepted.
4. Please, submit just ONE file. You do NOT have to submit .docx or .pdf files along with
your Excel file.
5. Exams are individual assignments, and are not supposed to be done in groups.
1. (5 points) The 6 1
Buy Financial Modeling Discussion
4 T-bond (US) of August 15, 2023, was priced on March 28, 2014 to
yield 2.551% to maturity. What was the quoted price (in dollars per hundred dollars
of face value)? If you had bought the bond, how much would you have been
invoiced? State the quoted price in hundreds and 32nds. Note that you are required
to compute the bond’s price and accrued interest both using, and not using, Excel’s
PRICE() an ACCRINT() functions. Plot the price-yield relationship for the bond. To do
that, compute a set of bond’s clean prices for different yields-to-maturity in cells
E2:F42. To answer this question, use the spreadsheet tabbed “Bond Pricing” in the
attached file.
2. (5 points) The spreadsheet tabbed “Bond Data” contains US bond data from the
Wall Street Journal on March 15, 2014. For each bond, find the dates of previous and
next coupon payments (relative to March 15, 2014), the number of days in the
coupon period, the number of days elapsed since the last coupon payment, the
accrued interest, and the invoice price. Compute the yield-to-maturity for each bond.
3. (5 points) Given the information on the spreadsheet tabbed “Bond Data,” find the
price for a corporate 8 1
Buy Financial Modeling Discussion
8 US bond of March 15, 2017 on March 15, 2014. The static
spread for the bond is perceived by investors to be 3.5%. To do that, first find a set
of zero prices and spot rates on coupon payment dates for the bond, and then use
the method of replicating portfolios. Find the yield-to-maturity for the bond.
To answer this question, use the spreadsheet tabbed “Corporate Bond” in the
attached file.
4. (5 points) Given the information on the spreadsheet tabbed “Bond Data,” which of
the following two bonds is perceived by investors to be riskier (as measured by the
static spread)?
a. 3 1
4 corporate bond (US) of September 15, 2016 traded at 101
32 on March 15,
b. 1 6
8 corporate bond (US) of September 15, 2015 traded at 99
32 on March 15,
Find the yield-to-maturity for both bonds.
To answer this question, use the spreadsheet tabbed “Static Spread” in the attached

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:
The price is based on these factors:
Academic level
Number of pages
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 GRADE