ACCT& 202 Lab 3 Student Template Winter 2020 Comments AutoSaveF AGES Home Insert Draw Page Layout Arial 12 Pesic BI U C A2 X v fx Given Data: Formulas A A A Data Review = = = ES View = Tell me what you want to do wraa Text General E Werge & Center -% 2nsert I Delete .. Share EAY-O. 2 . Sort! Find & Ideas X Filler Select -43 Sensitivity Formatting as Teile Styles Format 2 Glvon Data 4 Denver Fire District 5 On Jan 1, 2020. Denver Fire District issued bonds. Interest is payable semiannually on June 30 and Dec. 31 of each year. Bond Discount Problem Data: 9 Face amount $ 10 Stated interest rate 11 Markel interest rate 12 Length of bonds, in years 20,000,000.00 6.0% 7.0% 19 14 Bond Premium Problem Data: 15 Face amount $ 16 Stated interest rate 17 Market interest rate 18 Length of bonds. in years 20.000.000.00 6.0% 5.0% 10 Bond Discount Bond Premium Given Data 2 - + 100% ACCT& 202 Lab 3 Student Template Winter 2020 Comments AutoSaveF AGES Home Insert Draw Page Layout Formulas Aral 12A A Peste BIV A D1 x fx Data Review = = = View = Tell me what you want to do wa Text Text 3 Merge & Center % Insert Share SAYO. - 48 Conditional Format Formelling us Table call Styles Delete El Parmat Farmat u X Sensitivity Ideas X Find & Select Filler - Bond Premium Problem - Use cell linking when possible and Excel formulas for all calculated amounts. 6 You must use Excel's PV function to receive credit for this assignment Print your assignment twice: 6 once with amounts displayed once with formulas displayed. Submit both. 8 Company name: Denver Fire District 11 Cash interest Payment Market interest rate per period Number of periods Issue price: Die sportive number 13 Carrying Value Cash Paide Interest Internet 38 In the space below, enter the journal entry for Jan 1, 2020 to record the issuance of the bonde. Then make the journal entries to record the first two semiannual Interest payments. 42 TYPE IN THE ACCOUNT NAMES and une cell linking for amounts. No descriptions are required.) Account Debit Credit Jan 1, 2020 17 June 30, 2020 Dec 31, 2020 Bond Discount Bond Premium Given Data + # E 2 - 82% ACCT& 202 Lab 3 Student Template Winter 2020 View Share Comments AutoSaveF AGES Home Insert Draw Page Layout X Arial 12 Peste BIV A D1 x fx Formulas A A Data = Review = Tell me what you want to do 95 Wraa Text Text Merge & Center % Insert AY-O. 2 -3 Delete El Parmat Format w V X Sensitivity Ideas Styles Formelling us Table Find & Select X Filler 4 Bond Discount Problem - Use cell linking when possible and Excel formulas for all calculated amounts. 5 You must use Excel's PV function to receive credit for this assignment. Print your assignment twice: Gonce with amounts displayed, once with formulas displayed. Submit both. & 10 11 12 13 Company name: Denver Fire District Face amount Cash interest payment Market Interest rate per period Number of periode Issue price: Dapiny positive rumore Increase in Carrying Value Carrying Value End of Period) 38 In the space below, enter the Joumal entry for Jan 1, 2020 to record the lasuance of the bonds 39 Then make the journal entries to record the first two semiannual interest payments. 40 (TYPE IN THE ACCOUNT NAMES and use cell linking for amounts. No descriptions are required.) Account Debit Credit 42 Jan 1, 2020 27 June 10. 2020 52 Dec 31, 2020 O Bond Discount Bond Premium Given Data + # 3 - + 89%