Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE PUT IT IN EXCEL FORMULA, MY TEACHER ONLY ACCEPT EXCEL FORMULA, NOT JUST NUMBER. PLEASE PUT IT IN EXCEL FORMULA ACCORDING TO MY EXCEL
PLEASE PUT IT IN EXCEL FORMULA, MY TEACHER ONLY ACCEPT EXCEL FORMULA, NOT JUST NUMBER. PLEASE PUT IT IN EXCEL FORMULA ACCORDING TO MY EXCEL FORMAT THANK YOU I WILL SURELY THUMBS UP !!!
1. Calculate the price of a bond using the Excel PV function. XH5 Bond Pricing - Excel ? 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AA = % Paste BIU- A- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font B14 A B D E F G H 7 1 On January 1, Ruiz Company issued bonds as follows: 2 Face Amount $ 500,000 3 Number of Years: 15 4 Stated Interest Rate: 8% Interest payments per year 2 6 (Note: the bonds pay interest semi-annually.) 7 8 Required: 91) Given the different market interest rates below, calculate the following items. 10 Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all 11 function arguments as cell references. 12 13 a Market Interest Rate: 9% 14 Semi-annual interest payment: 15 Bond Selling Price: 16 17 b) Market Interest Rate: 6.0% 18 Semi-annual interest payment: 19 Bond Selling Price: 20 21 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. 22 23 The bond in (a) sold at a: 24 The bond in (b) sold at a: 25Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started