ࡱ> #%"U@  bjbj 0  ceeeeee$R, HHH"cHcH$Hl3 ^64 W 0, " 3 3$H$2Intermediate Accounting I Dr. Edward Nathan Handout Problem for Chapter 11 Due with second exam Boyette Company borrows $60,000 at 12% for 30 years. Their monthly payment is $617.17 for 360 months (30 years). Assuming the bank uses the effective interest method for amortization prepare a spreadsheet amortization schedule using either Excel or Lotus covering the 30 years (360 months at 1% per month). Assuming the bank uses the Rule of 78s prepare a spreadsheet amortization schedule using either Excel or Lotus covering the 30 years (360 months at 1% per month). Hint: We worked some of this problem in class so use the class answers as check figures to make sure your amortization schedules are accurate. IJMab; ? h.gh=0CJOJQJ^Jh=0h=0>*CJOJQJ^Jh.gCJOJQJ^Jh=0CJOJQJ^Jh.gh.gCJOJQJ^J ,bc : ; hh^hgd=0 & Fhgd=0hgd.g @d]@gd.g  .P:p=0/ =!"#z$ %hhR@R .gNormal5$7$8$9DH$B*_HmH phsH tH DA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List >O> @Style 1$d`a$ ,bc:;0000x0 0 000   cj28IJM28 Edward Nathan0Q~+M^`Mo() ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.0Qd        .g@=0@99)99@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New"qhev&ev&j`j`#r43QH)?.gIntermediate Accounting I Edward Nathan Edward Nathan Oh+'0  $0 L X dpxIntermediate Accounting I.nteEdward Nathanccdwadwa Normal.dotaEdward Nathancc2waMicrosoft Word 10.0@@.E64@.E64j`՜.+,0 hp|  m{ Intermediate Accounting I Title  !$Root Entry F`1^64&1Table WordDocument0SummaryInformation(DocumentSummaryInformation8CompObjj  FMicrosoft Word Document MSWordDocWord.Document.89q