I ALWAYS RAYE GOOD! The ECC District is preparing to sell bonds to improve their campus. The cost of the project is $900,000 and the bond market has recently been unpredictable. They are offering a $900,000 bond with a 6% interest rate payable annually. Maturity will be in 10 years.
The ECC District is preparing to sell bonds to improve their campus. The cost of the project is $900,000 and the bond market has recently been unpredictable. They are offering a $900,000 bond with a 6% interest rate payable annually. Maturity will be in 10 years. They need to consider 2 possible outcomes and need information for both. Case \#1: The market interest rate at time of issuance is 6.5%. Proceeds from sale will be $850,000. Method of amortization is Straight line. Case #2 : The market interest rate at time of issuance is 5.75%. Proceeds from sale will be $916,7%Q. Method of amortization is Effective. Round ALL answers to 2 decimal places. REQUIRED FOR POINTS: 1 Create a master/ reference table for Case H1 with all the required information needed to prepare a schedule. Create a bond amortization schedule using the Straight-line method of amortization for all 10 years. Include all columns on the schedule for the interest journal entry and the individual accounts and carrying value that would be presented on the Balance Sheet. Link/reference the amortization schedule calculations to the master table and use Excel/sheets math functionality fully 3 Create a master/reference table for Case H2 with all the required information needed to prepare a schedule. Create a bond amortization schedule using the Effective method of amortization for all 10 years. Include all columns on the schedule for the interest journal entry and the individual accounts and carrying value that would be presented on the Balance Sheet. link/reference the amortization schedule calculations to the master table and use Excel/Sheets math functionality fully. \begin{tabular}{|l|l|l} \hline Using the schedules created and linking/referencing amounts to the individual cells... \\ \hline For CASE #1 \end{tabular} For CASE H1 Record the journal entry for the issuance of the bond. Record the journal entry for ONLY the year one interest payment. wurking space for requirements \# 1-10. For journal entry requirements