70.2K

Verified Solution

Link Copied!

B4:K4. JK. The ECC District is preparing to sell bonds to improve their carmpus. The cost of the project is $900,000 and the bond market has recently been unpredicta A B C D E You must make a copy before using this sheet. This is the master. File (right under the title) then make a copy to sive to your own Google Drive or Download as Microsoft Excel. Project \#4 - Bond Amortization 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. Option H1: The market interest rate at time of issuance was 6.5%. Proceeds from sale was $850,000. Method of amortization is Straight Line. Option \#2: The market interest rate at time of issuance was 5.75\%. Proceeds from sale was $916,760. Method of amortization is Effective. Round AlL answers to 2 decimal places. REQUIRED FOR POINTS: 1 Create a master/reference table for Option #1 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 individuat accounts and carrying value that would be 2 presented on the Balance Sheet. Edit View Insert Format Data Tools Extensions Help - Ix. 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 unpre \begin{tabular}{l} REQURED FOR POINTS: \\ \hline REQ \end{tabular} 1 Create a master/reference table for Option \#1 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 Option 42 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 Using the schedules created and linking/referencing amounts to the individual cellis... \begin{tabular}{|c|l|} \hline & For OPTION #1 \\ \hline 5 & Record the journal entry for the issuance of the bond. \\ \hline 6 & Record the joumal entry for ONIY the year one interest payment. \\ \hline 7 & Record the journal entry if the bond is retired on Jan 1, Year 8 with a price of 97. \\ \hline 8 & For OPTION #2 \\ \hline 9 & Record the journal entry for the issuance of the bond. \\ \hline 10 & Record the journal entry for ONLY the year one interest payment. \\ \hline \end{tabular} Copy of Project \#4 - Bond amortization 4 Edit View Insert Format Data Tools Extensions Help B$100%=$%.0.00123 Calibri =14+B=A. - If. 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 unpr \begin{tabular}{|c|l|} \hline & Link/reference the amortization schedule calculations to the master table and use Excel/Sheets math functionality full \\ \hline Using the schedules created and linking/referencing amounts to the individual cells... \\ \hline 5 & For OPTION #1 \\ \hline 6 & Record the journal entry for the issuance of the bond. \\ \hline 7 & Record the journal entry for ONLY the year one interest payment. \\ \hline 8 & Record the journal entry if the bond is retired on Jan 1, Year 8 with a price of 97. \\ \hline 9 & For OPTION \#2 \\ \hline 10 & Record the journal entry for the issuance of the bond. \\ \hline 11 & Record the journal entry for ONLY the vear one interest payment. \\ \hline & ExplainthedifnalentryifthebondisretiredonJan1,Year6withapriceof102.overtheother. \\ \hline \end{tabular} double click in the answer box and begin typing your answer; enter when done "11. Answer: For journal entry requirements \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ DATE } & DESCRIPTIONIACCOUNT & Debit & Credit \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} B4:K4. JK. The ECC District is preparing to sell bonds to improve their carmpus. The cost of the project is $900,000 and the bond market has recently been unpredicta A B C D E You must make a copy before using this sheet. This is the master. File (right under the title) then make a copy to sive to your own Google Drive or Download as Microsoft Excel. Project \#4 - Bond Amortization 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. Option H1: The market interest rate at time of issuance was 6.5%. Proceeds from sale was $850,000. Method of amortization is Straight Line. Option \#2: The market interest rate at time of issuance was 5.75\%. Proceeds from sale was $916,760. Method of amortization is Effective. Round AlL answers to 2 decimal places. REQUIRED FOR POINTS: 1 Create a master/reference table for Option #1 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 individuat accounts and carrying value that would be 2 presented on the Balance Sheet. Edit View Insert Format Data Tools Extensions Help - Ix. 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 unpre \begin{tabular}{l} REQURED FOR POINTS: \\ \hline REQ \end{tabular} 1 Create a master/reference table for Option \#1 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 Option 42 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 Using the schedules created and linking/referencing amounts to the individual cellis... \begin{tabular}{|c|l|} \hline & For OPTION #1 \\ \hline 5 & Record the journal entry for the issuance of the bond. \\ \hline 6 & Record the joumal entry for ONIY the year one interest payment. \\ \hline 7 & Record the journal entry if the bond is retired on Jan 1, Year 8 with a price of 97. \\ \hline 8 & For OPTION #2 \\ \hline 9 & Record the journal entry for the issuance of the bond. \\ \hline 10 & Record the journal entry for ONLY the year one interest payment. \\ \hline \end{tabular} Copy of Project \#4 - Bond amortization 4 Edit View Insert Format Data Tools Extensions Help B$100%=$%.0.00123 Calibri =14+B=A. - If. 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 unpr \begin{tabular}{|c|l|} \hline & Link/reference the amortization schedule calculations to the master table and use Excel/Sheets math functionality full \\ \hline Using the schedules created and linking/referencing amounts to the individual cells... \\ \hline 5 & For OPTION #1 \\ \hline 6 & Record the journal entry for the issuance of the bond. \\ \hline 7 & Record the journal entry for ONLY the year one interest payment. \\ \hline 8 & Record the journal entry if the bond is retired on Jan 1, Year 8 with a price of 97. \\ \hline 9 & For OPTION \#2 \\ \hline 10 & Record the journal entry for the issuance of the bond. \\ \hline 11 & Record the journal entry for ONLY the vear one interest payment. \\ \hline & ExplainthedifnalentryifthebondisretiredonJan1,Year6withapriceof102.overtheother. \\ \hline \end{tabular} double click in the answer box and begin typing your answer; enter when done "11. Answer: For journal entry requirements \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|c|}{ DATE } & DESCRIPTIONIACCOUNT & Debit & Credit \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer