ACCT& 202 Lab 2- Bonds Payable (Summer 2016 On-Line Class) hould be a cell releresce objectve Ue Vecnonoft Excel to calcalate theisoe peice of bends isond at a discount and bonds istord t a peenium, constrect as amotiaunion schedule for each of the bond isoes, and make the joumad mtries to secced the lsance of he bands and the flast wo miinsual interest Hold your ourser over thesed tingles in the comers of selected cells for hep creaning the fonmula for Your schedule should look siilar to ITustzacian 919 rom o Est Points Possible: 15 Copythe Excel eeplase for this lab fon ou course's Casvas webise to you deknop e tudest H: drive. Opem the fle Problem Data Rosd Discount Problba On Jasuury 1. 2016, Waterfall Lodge & Auseent Park isoued $6,000,000 of 6% benda, due i. 10 yean Th* "Akot iaterest ate foe bada ofumila nsk and matutity is 7%, tinerest is paid senianneally on June 30 and December 31 each yea Boed PremistPvoblem: Assume that the market iaterest tate is isead e47 Aswame all ode givm amounts aee the sane as tated in the bond diseount problem Reqeired the boads June 30, 2014, to record the first sea anesainerwr paymeet; azd. December 31, 2016 te recerd the secead miasal isteret payrt Te uiethe Present Vale Function, elick in cell C7 Type-PV andm se cetl reesences to mter the aegumes for the PV Eunczien RateMaket intmest rae, divided by 2 is this peoblem becasse isteeet is paid Xpet Numbet of periods premium pesbles to compate the issse price of the bends(peesent value) censtt amotization schedule, and recoed the three jounal enits Yoe schedale should leek similar to Bustrtien 9-14 frm test Pant The amount of thesmianual eash interest payment The Eemmula to caleuate i Face meuat of the bood". Stated interest ste . 2 the bends TypeLeave this d4Mank Deing so adicates paymens are made at the ead ofde 3.500 00 95 Nete: Exee wa.weseekeb penarw@ncenive member. T.maheiz poiive you eam ACCT& 202 Lab 2- Bonds Payable (Summer 2016 On-Line Class) hould be a cell releresce objectve Ue Vecnonoft Excel to calcalate theisoe peice of bends isond at a discount and bonds istord t a peenium, constrect as amotiaunion schedule for each of the bond isoes, and make the joumad mtries to secced the lsance of he bands and the flast wo miinsual interest Hold your ourser over thesed tingles in the comers of selected cells for hep creaning the fonmula for Your schedule should look siilar to ITustzacian 919 rom o Est Points Possible: 15 Copythe Excel eeplase for this lab fon ou course's Casvas webise to you deknop e tudest H: drive. Opem the fle Problem Data Rosd Discount Problba On Jasuury 1. 2016, Waterfall Lodge & Auseent Park isoued $6,000,000 of 6% benda, due i. 10 yean Th* "Akot iaterest ate foe bada ofumila nsk and matutity is 7%, tinerest is paid senianneally on June 30 and December 31 each yea Boed PremistPvoblem: Assume that the market iaterest tate is isead e47 Aswame all ode givm amounts aee the sane as tated in the bond diseount problem Reqeired the boads June 30, 2014, to record the first sea anesainerwr paymeet; azd. December 31, 2016 te recerd the secead miasal isteret payrt Te uiethe Present Vale Function, elick in cell C7 Type-PV andm se cetl reesences to mter the aegumes for the PV Eunczien RateMaket intmest rae, divided by 2 is this peoblem becasse isteeet is paid Xpet Numbet of periods premium pesbles to compate the issse price of the bends(peesent value) censtt amotization schedule, and recoed the three jounal enits Yoe schedale should leek similar to Bustrtien 9-14 frm test Pant The amount of thesmianual eash interest payment The Eemmula to caleuate i Face meuat of the bood". Stated interest ste . 2 the bends TypeLeave this d4Mank Deing so adicates paymens are made at the ead ofde 3.500 00 95 Nete: Exee wa.weseekeb penarw@ncenive member. T.maheiz poiive you eam