This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: BCOR 2200 Fall 2008 Dr. David M. Gross Project 2 Assignment – Due Friday October 17 at 5:00pm • Download the spreadsheet LAST_FIRST Project 2.xls from CULearn. • This is an individual assignment. You may not work with other students. You must work alone on this assignment. • Make sure to change the name of your spreadsheet using the format LAST_FIRST Project 2.xls before uploading your completed spreadsheet to the CULearn site. Replace just the words “Last” and “First”. So if you name is Robert Weir, your file will be “Weir_Robert Project 2.xls” • You must upload your completed spreadsheet to CULearn by Friday October 17 at 5:00pm. Your submission time will be recorded by the CULearn system NO LATE ASSIGNMENTS WILL BE ACCEPTED. EMAILED ASSIGNMENTS WILL NOT BE ACCEPTED. YOU MUST UPLOAD THEM TO CULEARN. 1. Produce four different working bond calculators using the built-in Excel time-value-of-money functions. These functions are PV(), PMT(), RATE() and NPER(). You can learn the proper syntax and input values for these Excel functions using the “help” feature built into Excel. You can also learn about them use the “function wizard” feature, accessed by the “ f x ” button to the left of the...
View Full Document
- Fall '08
- Calculation, YTM, face value bond