注意 可转债券 部分转股票时的分录
60%没有转，40%转了

8-复习

8

报名了中国历史博物馆的义工，里头有人让我可以试着做会计义工。。

Hi Class!

I know that a lot of you are confused by the issue price calculation. Totally understandable. Most of you are not familiar with Excel (or a similar program) and Bonds Payable is confusing at first. I set up a template in Excel to enter information in and I've screenshot it below for you. The example I'm using has the following: Issued $500,000 bonds with a stated rate of 6%, Market Rate was 8% on date of issuance. The term of the bonds is 10 years. Bonds pay interest Semi-Annually (twice per year). I've written the "formula" for this specific example below. You can try entering it in Excel and see if you get the same answer. It's a great way to practice and you can use it as guidance for your problems.
The table I use is below and is the full amortization schedule, but I want you to get some practice and didn't include it.
So I plugged in the info. Principal (Face Value of Bonds Issued), stated rate etc. into the chart at the top left.
The issue price, it's the present value of future interest/principal payments.
The calculation in words is given below. Oftentimes, students mess up the interest rate (forget to take 50% of interest rate into consideration, you do that when you pay interest semi-annually as your problem does. The interest rates are ANNUAL rates, so if you pay interest 2x per year, 1/2 is paid at one date, the other half is paid at another date. Second number would not be doubled for # of pmts if annual.)
Here is your formula:
=-PV(.04,20,15000,50000)
1/2 market (8% * 1/2) (10 year term * 2) (Interest PAID is based on Stated Rate= Face Value ($500,000) * 6% (stated rate) * 1/2= $15,000 paid twice per year), (last number is face value of bonds issued.)
**If you forget the negative sign, just know that the number will come out as a negative number, and just enter it as a positive number.