Req a: | ||||||
n = 60 | ||||||
I = 4.50% | ||||||
Cashflows | Amount | PVF | Present value | |||
Semi annual payment | 17500 | 20.63802 | 361165.4 | |||
Maturity amount | 500000 | 0.071289 | 35644.5 | |||
Price of bonds | 396809.9 | |||||
Semi annual interest | 17500 | |||||
Price | 396810 | |||||
Req b; | ||||||
n = 60 | ||||||
I = 2.75% | ||||||
Cashflows | Amount | PVF | Present value | |||
Semi annual payment | 17500 | 29.22266 | 511396.6 | |||
Maturity amount | 500000 | 0.196377 | 98188.5 | |||
Price of bonds | 609585.1 | |||||
Semi annual interest | 17500 | |||||
Price | 609585 | |||||
The bonds in a sold at | Discount | |||||
The bonds in b sold at | Premium | |||||
Ch 14 Excel Simulation G 1 Calculate the price of a bond using the Excel PV...
Bond Pricing Using Tables Bond Pricing Using Tables 1. Calculate the price of a bond using tables. D Bond Pricing - Excel 7 - X . . HOME FILE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in B T U . A Alignment Number - Cells Editing Paste Clipboard A1 3- Font Conditional Format as Cell Formatting Table Styles Styles X 1 On January 1, Ruiz Company issued bonds as follows: 1 On January 1, Ruiz Company issued bonds...
Bond Pricing Excel FILE HOME INSERT PAGE LAYOUT FORMULAS Sign In DATA REVIEW MEW Calibri 11 A A Paste Conditional Format as Formatting Table Styles Styles Alignment Number Cell I U Cells Editing Clipboard Font H11 H E G 1 On January 1, Ruiz Company issued bonds as follows: 2 Face Value: 3 Number of Years: 4 Stated Interest Rate: 5 interest payments per year 6 (Note: the bonds pay interest semi-annually.) 500,000 30 7 % 2 8 Required: 9...
Please help me with calculating the price of bonds. On Januaty 1, Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 500,000 15 796 Required: 1) Calculate the bond selling price given the two market interest rates below. Use formulas that reference data from this worksheet and from the appropriate future or present value table(found by clicking the tabs at the bottom of this worksheet) Note: Rounding is not required Annual...
Workbook Views Show Zoom B15 G A B С D E F 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% 5 Interest payments per year 2 6 (Note: the bonds pay interest semi-annually.) 7 8 Required: 9 1) Given the different market interest rates below, calculate the following items. 10 Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Ente...
Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 10 points (8 02:46:24 eBook Print References • Cell Reference: Allows you to refer to data from another...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel’s Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B2” was entered,...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel’s Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B2” was entered,...
Please how in excel with functions 3. Using the Excel PV function, determine the proceeds of the bond issuance assuming a 4 percent effective (market) annual interest rate. Use two present value tables to compute the price of the bonds. Show it on the Excel document On January 1, 2018, the Blue Devil Corporation issued $100,000 of ten-year bonds. The bonds carried a stated annual interest rate of 5 percent, with interest payable semiannually on June 30 and December 31.
Please use excel and show the function inputs Using the Excel PV function, determine the proceeds of the bond issuance assuming a 6 percent effective (market) annual interest rate. (This was step 2) On January 1, 2018, the Blue Devil Corporation issued $100,000 of ten-year bonds. The bonds carried a stated annual interest rate of 5 percent, with interest payable semiannually on June 30 and December 31.
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B2” was entered,...