Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Accounting

Authors: Needles, Powers, crosson

11th Edition

1439037744, 978-1133626985, 978-1439037744

More Books

Students also viewed these Accounting questions