Module 5 SPREADSHEET

Module 5 SPREADSHEET - Enter numbers in the blue below. For...

Info iconThis preview shows pages 1–18. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Enter numbers in the blue below. For Bond, if it is 6s12, then type in 6 for Bond. So if it is bs12, type in b in the bond cell. ANSWER Bond Vol High Low Close Net Chg Current Yield 6 62 5/8 9.58 % Rounded 9.58 % Example Problem ANSWER Bond Vol High Low Close Net Chg Current Yield 6 62 3/8 9.62 % Rounded 9.62 % 1) Grade for: Du Pont quotes: calculate closing yield Enter numbers in blue below. Bond Vol High Low Close Net Chg 62 3/8 0.5 Previous Close (Answer) 61 7/8 Example Problem Bond Vol High Low Close Net Chg 62 3/8 0.5 Previous Close (Answer) 61 7/8 1) Grade for: Du Pont quotes: previous close Current Yield Current Yield Enter numbers in blue below Bond Vol High Low Close Net Chg How many bonds? ANSWER This answer is simple the amount of Volume (Vol) you have. Example Problem Bond Vol High Low Close Net Chg 20 How many bonds? ANSWER 20 This answer is simple the amount of Volume (Vol) you have. 1) Grade for: Du Pont quotes: Number of bonds traded Current Yield Current Yield Enter numbers in blue below Bond Vol High Low Close Net Chg 62 5/8 Face Value 1000 *Hint: Face Value is almost always 1000 Answer 626.25 Example Problem Bond Vol High Low Close Net Chg 62 3/8 Face Value 1000 *Hint: Face Value is almost always 1000 Answer 623.75 5)Grade for: Du Pont quotes: calculate closing price Current Yield Current Yield Enter numbers in the blue below MAKE SURE TO COMPUTE IF ITS SEMIANNUAL, QUARTERLY, MONTHLY, or etc. For example if the bond matures in 4 years and its semiannual, enter 8 for N. Is it semiannual? quarterly? daily? If semiannual enter 2--> if quarterly enter 4--> etc Coupon Rate N FV I/Y PMT PV Dont mess with this --> Example Problem MAKE SURE TO COMPUTE IF ITS SEMIANNUAL, QUARTERLY, MONTHLY, or etc. For example if the bond matures in 4 years and its semiannual, enter 8 for N. Is it semiannual? quarterly? daily? If semiannual enter 2--> if quarterly enter 4--> etc Coupon Rate N FV I/Y PMT PV Dont mess with this --> 6) Grade for: Ecological Sciences VB coupon example problem #DIV/0! <-- Payment is calculated by ((Coupon Rate * FV)/2 "Semiannual") BUT ITS ANSWER #DIV/0! #DIV/0! Rounded #DIV/0! 2 7% 8 1000 4.50% 35 ANSWER $934.04 ($934.04) Rounded $934.00 S ALREADY DONE FOR YOU!! If your problem is worded exactly like this one, then your answer is your FACE VAL FACEVALUE!!! FV Pretty lame if you used this. --> LUE from the problem Listen closely! Type in the numbers in the blanks EXACTLY like you see them in the problem. Dont change them at Enter numbers below....
View Full Document

Page1 / 65

Module 5 SPREADSHEET - Enter numbers in the blue below. For...

This preview shows document pages 1 - 18. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online