1) Bond Amortization schedule if market interest rate is 8%:
a) Total payment or periods will this bond pay interest = 20 (i.e.) 10*2. Excel formulae has to be "<=c6*c8>"
b) & c) In the screenshot provided, excel row details like A,B,C.... or excel col details like 1,2,3,.... and other worksheet wherein the future value factor are provided, not available; thus not able to provide formulae to use in the yellow fields for most of the answers.
d) Amount of interest that will be paid on March 31st = $ 28,875 (i.e.) $ 825,000 *7%. Excel formulae has to be "<=c5*c7>"
e) Interest payment arrived at to calculate bond selling price - $ 56060
f) selling price of bond = $ 768,940. Excel formulae to use"<=c5-g31>"
g) In this case, market rate is more than stated rate, thus bond is issued at discount. Excel formulae to use in the answer cell "<=ifg33>c5,"Premium","Discount">"
2.Bond Amortization schedule if market interest rate is 6%:
a. & b. In the screenshot provided, excel row details like A,B,C.... or excel col details like 1,2,3,.... and other worksheet wherein the future value factor are provided, not available; thus not able to provide formulae to use in the yellow fields for most of the answers.
c) Amount of interest that will be paid on March 31st = $ 28,875 (i.e.) $ 825,000 *7%. Excel formulae has to be "<=c5*c7>"
d) Interest payment arrived at to calculate bond selling price= $ 61369
e) selling price of bond = $ 886,369. Excel formulae to use"<=c5+g53>"
f) In this case, market rate is less than stated rate, thus bond is issued at premium. Excel formulae to use in the answer cell "<=ifg55>c5,"Premium","Discount">"
The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th....
The Chestnut Street Company plans to issue $825,000, 10-year bonds that pay 7 percent semiannually on March 31st and September 30th. 3 5 5 7 Information relating to this bond is found below: Face Value: $ 825,000 Number of Years: 10 Stated Interest Rate: 7% 3 Number of Payments per Year: 21 20 Required: 1 Calculate or provide the information requested using a formula or cell reference unless 2 you are instructed to use a specific function: 3 4 1)...
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...
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,...
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,...
Preparing a Performance Report using Excel's ABS, IF and SUM Functions Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. 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...
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...
Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. 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...
Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating results of the Northern Division from last year. The Controller has asked you to compute the ROI and Residual Income based on data from last year and if the division adds a new product line. 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...
Lake Athletics has provided you with the Income Statements for two of its product lines for the year ended December 31. The Controller has asked you to perform the vertical analysis of the product lines and compare the two products. 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...