Question: You can use the below to build an amortization table and journal entries for a note issued at a premium. Try it. Build your own

You can use the below to build an amortization table and journal entries for a note issued at a premium.  Try it.  Build your own assumptions.
Face value Pick an amount in hundreds of thousands between $100,000 and $1,200,000 (such as $300,000 or $700,000). 
Stated rate Pick at a rate (whole number) between 3% and 8% (such as 4% or 7%). 
Market rate Pick at a rate (whole number) between 3% and 8% (such as 4% or 7%).
Premium Calculate this amount.
Periods Pick a whole year between 5 and 10 years.
Follow the example on the handout.  You'll have to look up the factors yourself.  Show your work.
Show your calculation of the present value of the note.
Record the journal entry to issue the note.  
Show your amortization table (follow my example).  
Show your journal entries (follow my example).
interest-bearing notes - note issued at a discount










Face value   400,000.00














Stated rate5.00%














Market rate12.00%














Discount   127,785.00

















































Amortization Table











PeriodBeginningCash rec'dInt incomeEnding











                  1   272,215.00    20,000.00     32,665.80  284,880.80











                  2   284,880.80    20,000.00     34,185.70  299,066.50











                  3   299,066.50    20,000.00     35,887.98  314,954.48











                  4   314,954.48    20,000.00     37,794.54  332,749.01











                  5   332,749.01    20,000.00     39,929.88  352,678.89











                  6   352,678.89    20,000.00     42,321.47  375,000.36











                  7   375,000.36    20,000.00     45,000.04  400,000.40Rounding of $0.40.









Total
  140,000.00   267,785.40














































Journal entries:Year 1Year 2Year 3Year 4Year 5Year 6Year 7


DRCRDRCRDRCRDRCRDRCRDRCRDRCRTotal
Cash
    20,000.00
    20,000.00
   20,000.00
   20,000.00
   20,000.00
    20,000.00
   20,000.00
  140,000.00
Discount amortization    12,665.80
    14,185.70
   15,887.98
   17,794.54
   19,929.88
    22,321.47
   25,000.04
  127,785.40
     Interest revenue
     32,665.80
   34,185.70
   35,887.98
   37,794.54
   39,929.88
   42,321.47
   45,000.04  267,785.40

Step by Step Solution

3.47 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Face value Stated rate 500000 7 5 64632 Market rate Premium Periods 8 Table values are based on n8 i ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!