I need help with parts b, c, and e. I completed part A. May I please get the excel formula.

Bonds - Excel Project

Complete your work in Excel using formulas.

Situation:

BU Curriculum Corporation issued $800,000 of 9% bonds on September 1, 2021, due on September 1, 2026. The interest is to be paid twice a year on March 1 and September 1. The bonds were sold to yield 12% effective annual interest. BU Curriculum Corporation closes its books annually on December 31.

(a) Complete an amortization schedule for the above bond (for all periods) in a similar format as below using Excel. There should only be formulas in your table - NO hardcoded numbers. You can round to the nearest dollar or penny. Use theeffective-interest method.

Date	Credit Cash	Debit Interest Expense	Credit Bond Discount	Carrying Amount of Bonds
Sep. 1, 2021				Use the NPV or PV formula in Excel; see posted bond excel sheet in the classroom
Mar. 1, 2022 ....continue schedule (use Excel)

Bonds Proceeds		800,000
No. of periods of 6 months each	10
Coupon Payment Rate per annum	9%
Coupon Payment Rate per period (9%/2)	4.50%
Coupon Payment per period	36,000
Effective annual Interest per annum	12%
Effective annual Interest per period (12%/2)	6%
Carrying Amount of Bonds on Sep 1 2021	$711,678.96
Discount on Bonds		$88,321.04
Date	Credit Cash	Debit Interest Expense	Credit Bond Discount	Carrying amount of Bonds
Sep 1,2021				$711,678.96
Mar 1,2022	36000	$42,700.74	$6,700.74	$718,379.69
Sep 1,2022	36000	$43,102.78	$7,102.78	$725,482.47
Mar 1,2023	36000	$43,528.95	$7,528.95	$733,011.42
Sep 1,2023	36000	$43,980.69	$7,980.69	$740,992.11
Mar 1,2024	36000	$44,459.53	$8,459.53	$749,451.63
Sep 1,2024	36000	$44,967.10	$8,967.10	$758,418.73
Mar 1,2025	36000	$45,505.12	$9,505.12	$767,923.86
Sep 1,2025	36000	$46,075.43	$10,075.43	$777,999.29
Mar 1,2026	36000	$46,679.96	$10,679.96	$788,679.25
Sep 1,2026	36000	$47,320.75	$11,320.75	$800,000.00

(b) Prepare the journal entries for the following:

1. September 1, 2021 bond issue (the originating entry)

2. Adjusting entry for December 31, 2021 (adjusting entry should cover 4 months)

3. March 1, 2022 entry

4. September 1, 2022 entry

5. Adjusting entry from December 31, 2022

6. March 1, 2023 entry

(c) Compute the interest expense to be reported on the income statement for the year ended December 31, 2021 and December 31, 2022.

(d) This workbook is for your director who may want to print your tables. Therefore, part of your design is to make sure your tables are on one page. You can have multiple pages that print, but your amortization table should not be split onto multiple tables. You can use multiple sheets or place all the requirements on one sheet.

(e) Complete a second amortization schedule for the above bond (for all periods) using thestraight-line amortization method(entries are not required).