Using Excel, determine the proceeds of the bond sale on
1/1/19.
Part A
Proceeds of bond sale on 1/1/19 = PV of interest + PV of redemption value
Amount of interest = $500000 * 8% = $40000
Year | Interest | Redemption value | Total cash flow | PVIF @ 6% | Present Value |
1 | 40000 | 40000 | 0.94340 | 37735.85 | |
2 | 40000 | 40000 | 0.89000 | 35599.86 | |
3 | 40000 | 40000 | 0.83962 | 33584.77 | |
4 | 40000 | 40000 | 0.79209 | 31683.75 | |
5 | 40000 | 500000 | 540000 | 0.74726 | 403519.41 |
542123.64 |
Proceeds of bond sale on 1/1/19 = $ 542,123.64
Part B
Proceeds of bond sale on 1/1/19 = PV of interest + PV of redemption value
Amount of interest = $1,250,000 * 7% * 6/12 = $43750
Market rate of interest = 10%
Effective half yearly market rate of interest = 10% * 6/12 = 5%
Half Year | Interest | Redemption value | Total cash flow | PVIF @ 5% | Present Value |
1 | 43750 | 43750 | 0.95238 | 41666.67 | |
2 | 43750 | 43750 | 0.90703 | 39682.54 | |
3 | 43750 | 43750 | 0.86384 | 37792.89 | |
4 | 43750 | 43750 | 0.82270 | 35993.23 | |
5 | 43750 | 43750 | 0.78353 | 34279.27 | |
6 | 43750 | 43750 | 0.74622 | 32646.92 | |
7 | 43750 | 43750 | 0.71068 | 31092.31 | |
8 | 43750 | 43750 | 0.67684 | 29611.72 | |
9 | 43750 | 43750 | 0.64461 | 28201.64 | |
10 | 43750 | 43750 | 0.61391 | 26858.70 | |
11 | 43750 | 43750 | 0.58468 | 25579.72 | |
12 | 43750 | 1250000 | 1293750 | 0.55684 | 720408.41 |
1083814.03 |
Proceeds of bond sale on 1/1/19 = $ 1,083,814.03
Using Excel, determine the proceeds of the bond sale on 1/1/19. PART A Sparty Corporation issued...
PART A Sparty Corporation issued five-year, 8% bonds with a total face value of $500,000 on January 1, 2019. Interest is paid annually on December 31. The market rate of interest on this date was 6%. Sparty uses the effective interest rate method. Required: 1. Using Excel, determine the proceeds of the bond sale on 1/1/19. 2. Using the present value of a dollar table (found in Appendix E of your text), what factor would you use to calculate the...
PART B Bill Corporation issued six-year, 7% bonds with a total face value of $1,250,000 on January 1, 2019. Interest is paid semi-annually on June 30 and December 31. The market rate of interest on this date was 10.0%. Bill uses the effective interest rate method. Required: 1. Determine the proceeds of the bond sale on 1/1/19. Explain your method of calculation. 2. Using the present value of a dollar table (found in Appendix E of your text), what factor...
Use financial formulas in Excel to show work for Requirement #1 and #5 of each part Bill Corporation issued six-year, 7% bonds with a total face value of $1,250,000 on January 1, 2019. Interest is paid semi-annually on June 30 and December 31. The market rate of interest on this date was 10.0%. Bill uses the effective interest rate method. Required: Determine the proceeds of the bond sale on 1/1/19. Explain your method of calculation. Using the present value of...
You should turn in your answers in ONE Excel document. Use financial formulas in Excel to show work for Requirement #1 and #5 of each part. An assignment submitted that doesn’t demonstrate your formulas within Excel will receive an unsatisfactory grade. PART A Sparty Corporation issued five-year, 8% bonds with a total face value of $500,000 on January 1, 2019. Interest is paid annually on December 31. The market rate of interest on this date was 6%. Sparty uses the...
[The following information applies to the questions displayed below.] Cron Corporation is planning to issue bonds with a face value of $700,000 and a coupon rate of 13 percent. The bonds mature in five years and pay interest semiannually every June 30 and December 31. All of the bonds were sold on January 1 of this year. Cron uses the effective-interest amortization method. Assume an annual market rate of interest of 12 percent. (FV of $1, PV of $1, FVA...
Using the column of data HEADLEN, the head length in inches: Construct a frequency distribution by hand with 5 or 6 classes. Sort the data. Identify the minimum and maximum data and the class information: class width, class limits, class boundaries, and class midpoints. Show all work and the resulting frequency distribution table. Hand draw the histogram for the frequency distribution. Make it look professional; title and label appropriately. Use a ruler. Describe the shape of the histogram,...
I need the bottom part done On January 1, 2021, Whispering Co. issued ten-year bonds with a face value of $4,900,000 and a stated interest rate of 10%, payable semiannually on June 30 and December 31. The bonds were sold to yield 12%. Table values are: Present value of 1 for 10 periods at 10% Present value of 1 for 10 periods at 12% Present value of 1 for 20 periods at 5% Present value of 1 for 20 periods...
Fill out the tables below of the starting material and pure product by using the given NMR spectrums. Identify if the pure isomer of methyl nitrobenzoate as ortho, meta, or para. Complete the table below using your proton NMR spectrum of your starting material. Be sure to include all peaks. Note: The table is expandable. Use the structure below for the letter assignments in your table. Splitting Integration Assignment Peak (ppm) Other Notes -7.95 -7.92 0627 -787 785 7.30 751...
Question 1 Using a range of WACC of 8% to 10% and an EBITDA multiple of 9 to 11 times to calculate the terminal value, please establish a valuation range (EV) for ARAG. In Excel, you will need to use the NPV function (=NPV) and the data table of the What-If Analysis to answer this question (see instructions in the template). Questions (SECTION 1) Question 1 Year 1 Year 2 Year 3 Year 4 Year 5 UFCF 11.0 ...
Ex. 2-Calculate market price of a bond. On January 1, 2014 Lance Co. issued five-vear bonds with a face value of $700.000 and a stated Interest rate of 12% payable semiannually on July 1 and January 1. The bonds were sold to yield 10%. Present value table factors are: Present value of 1 for 5 periods at 10% .62092 Present value of 1 for 5 periods at 12% .56743 Present value of 1 for 10 periods at 5% .61391 Present...