Docstoc

Straight Line Amortization Calculator - Excel

Document Sample
Straight Line Amortization Calculator - Excel Powered By Docstoc
					Present Value 2 Some common accounting examples

Example 1:         XYZ company has sold goods in exchange for a non-interest bearing note receivable. The note is
                   in the amount of $6,000 and is due in two years. XYZ requires a rate of return of 10% on notes of
                   this type. How much revenue should be recognized in the current year?

                   This is an example of a single sum present value problem:

                                     =
                   $6,000 * PV(10%, 2) X
                   $6,000 * .82645   =X
                    $       4,958.70 = X               = revenue and net (less discount) note receivable

                   This would then be recorded as follows:

                   dr. Note receivable                       6000
                     cr. Revenue                                         4958.7
                     cr. Discount on note receivable                     1041.3

                   On the balance sheet:

                   Note receivable (net of discount)                     4958.7

                   What happens to the discount? It becomes interest income in each of the two years.
                   (You did not really believe that the company would not charge interest, did you?)

                   using straight line amortization:

                   end of year 1:

                   dr. discount                            520.65
                     cr. Interest income                                 520.65

                   at the end of the first year the note will now appear on the balance sheet as follows:

                   Note receivable (net of discount)                   5479.35

Example 2:         Bond issuance
          XYZ company is issuing bonds with a face value of $ 100,000. The bonds pay 10% interest and mature
          (the principal will be paid) in 5 years. Interest is paid semi- annually.

          How should the bonds be recorded on the balance sheet? That depends on how much money the
          company actually receives for the bonds. And that, in turn, depends on how much investors (the
          market) want to earn on an investment of this type.

Case 1:   Bonds are issued at par (face value)

          If investors want to earn 10%, then the following calculation will take place:

          Principal              coupon       Interest    semi-annual
                                 rate         payment     payment
                      $100,000            10%     $10,000      $5,000

          Bonds are discounted at 5% (10% compounded semi-annually):

                       100000 PV(5%, 10)         0.61391     $61,391
                         5000 Pva(5%,10)         7.72173     $38,609
                                                            $100,000

          to record the bond issue:

          dr. cash                              $100,000
            cr. Bonds payable                               $100,000

Case 2:   What if the market wants to earn 12% (or 6% semi-annually)?

                       100000 PV(6%, 10)         0.55839     $55,839
                         5000 Pva(6%,10)         7.36009     $36,800
                                                             $92,639 Bonds are issued at a discount

          to record the bond issue:

          dr. cash                               $92,639
          dr. discount                            $7,361
                      cr. Bonds payable                               $100,000

Case 3:              What if the market wants to earn only 8%?

                                100000 PV(4%, 10)        0.67556       $67,556
                                  5000 Pva(4%,10)         8.1109       $40,555
                                                                      $108,111 Bonds are issued at a premium

                     to record the bond issue:

                     dr. cash                          $108,111
                       cr. Bonds payable                              $100,000
                       cr. Premium                                      $8,111

                     What happens to the premium or discount? It will be amortized as part of interest expense.

Example III          Which is the better choice? Cash or a note payable?

                     XYZ company is negotiating with WWW company to purchase equipment. WWW offers the
                     alternatives:

                     The equipment could be purchased for $100,000 cash or XYZ could pay $ 108,000 in one year.
                     XYZ can earn 12% on its investments.


Equation:            Amount              PV(12%,1) Present value
$108,000*PV(12%,1)            $108,000      0.89286   $96,429 < $100,000

                     XYZ should sign the note and in the meantime invest the $100,000 at 12%.

                     What if XYZ cold earn only 6% on its investments?

                                                      Present value
                     108000 x PV (6%, 1)
                               108000        0.9434    101887.2 >                100000

                     XYZ shold pay the $100,000 now.
Example IV   Buying a car                    (you will not need this for either accounting 200, 300 or 301)

             The car could be purchased for cash $30,000 or for 5 annual payments of $7,514. The payments are to be
             made at the end of each of the next five years. What is the interest rate that is being charged?

             30,000 = $7,514xPVa(x%,5)

             30,000/7.514 =                   3.9925472 look up in the PV table for 5 periods and determine that the
                                                        interest rate is 8%

             Or the question could be asked as follows:

             You could either pay $30,000 now or make 5 payments, at 6%. What would be the amount of each
             payment (end of the year!)

             30,000/Pva(6%,5) = X
                               Pva(6%,5) annual payments
                        30000     4.21236 $7,121.90

             Obviously, car payments are made monthly, but, once you understand the principle involved, you use
             a finacial calculator or a computer to calculate the payments or annual interest rate.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:134
posted:8/22/2011
language:English
pages:4
Description: Straight Line Amortization Calculator document sample