expand icon
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

النسخة 4الرقم المعياري الدولي: 978-1111581565
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

النسخة 4الرقم المعياري الدولي: 978-1111581565
تمرين 6
PROBLEM DATA
The University Club recently issued $1,500,000 of 10-year, 9% bonds at an effective interest rate of 10%. Bond interest is payable annually.
REQUIREMENT
The bond pricing formula utilizes the NPV (Net Present Value) function on your spreadsheet program. The formula is broken into two parts as identified by the letters in parentheses above the formula. See Appendix A in Excel Quick for a discussion on the NPV function, and then explain the meaning of each part of the formula.
PROBLEM DATA  The University Club recently issued $1,500,000 of 10-year, 9% bonds at an effective interest rate of 10%. Bond interest is payable annually. REQUIREMENT  The bond pricing formula utilizes the NPV (Net Present Value) function on your spreadsheet program. The formula is broken into two parts as identified by the letters in parentheses above the formula. See Appendix A in Excel Quick for a discussion on the NPV function, and then explain the meaning of each part of the formula.     a. b.
a.
b.
التوضيح
موثّق
like image
like image

When working with a spreadsheet, a formu...

close menu
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
cross icon