In: Accounting
Amount of mortgage | $900,000 | |||||||||
Monthly interest rate | 0.479167% | (5.75/12) | 0.479167 | |||||||
Number of Months | 240 | (20*12) | ||||||||
Monthly payment | $6,318.75 | (Using PMT function withRate=0.479167%,Nper=240,PV=-900000) | ||||||||
N | P | |||||||||
Month | Principle | (Using PPMT Function of excel with Rate=0.479167%,Per=N,Nper=240, PV=-900000 | ||||||||
Payment | ||||||||||
1 | $2,006.25 | |||||||||
2 | $2,015.86 | |||||||||
3 | $2,025.52 | |||||||||
4 | $2,035.23 | |||||||||
5 | $2,044.98 | |||||||||
6 | $2,054.78 | |||||||||
7 | $2,064.63 | |||||||||
8 | $2,074.52 | |||||||||
9 | $2,084.46 | |||||||||
10 | $2,094.45 | |||||||||
11 | $2,104.48 | |||||||||
12 | $2,114.57 | |||||||||
SUM | $24,719.73 | |||||||||
Current Portion=Payment of principle in next 12 months | ||||||||||
Current portion of Mortgage Payable on Day1 | $24,719.73 | |||||||||
2 | In Straight line method, the Bond Discount is | |||||||||
Amortised over the life of the bond in equal | ||||||||||
amount per period. | ||||||||||
Example: | ||||||||||
Face Value=$100,000 | ||||||||||
Annual Coupon payment =9% | ||||||||||
Maturity =10 years | ||||||||||
Market return=10% | ||||||||||
Bond is sold at $93845 | ||||||||||
Discount amount=(100000-93845)= | $ 6,155 | |||||||||
Amortization per period=6155/10=$615.50 | ||||||||||
Coupon payment at the end of year= | $9,000 | (0.09*100000) | ||||||||
Journal entry for discount amortization in year 1 | ||||||||||
Debit : Interest expense | $ 9,615.50 | |||||||||
Credit : Discount | $ 615.50 | |||||||||
Credit: Cash | $9,000 | |||||||||
Every year $615.50 will be credited to discount account | ||||||||||
Interest expense will be $9,615 every year | ||||||||||
Interest expense and discounts are constant | ||||||||||
Effective Interest Method: | ||||||||||
Under this method, the interest expense is recorded as Market interest rate Times the Carrying amount in the beginning of year | ||||||||||
Interest expense=Interest for the period at market rate | ||||||||||
Carrying amount at the beginning of year 1 | $93,845 | |||||||||
Interest expense in year 1 | $9,384.50 | (93845*0.1) | ||||||||
Interest paid | $9,000 | |||||||||
Amortization of discount | $384.50 | (9384.50-9000) | ||||||||
Journal entry for discount amortization in year 1 | ||||||||||
Debit : Interest expense | $9,384.50 | |||||||||
Credit : Discount | $384.50 | |||||||||
Credit: Cash | $9,000 | |||||||||
Interest expense will increase every year as the carrying amount increases | ||||||||||
Amortization will also increase every year | ||||||||||
3 | The Price of a Bond at a given time is the Sum of Present value of all future cash flows discounted at market rate | |||||||||
If the market rate is same as the coupon rate, the Bond Price will be same as Face Value | ||||||||||
If the market rate is higher than the coupon rate,the present value of cash flow discounted at market rate | ||||||||||
Will be lower than face value | ||||||||||
Hence bBond will Sell at discount | ||||||||||
If market rate is lower than the coupon rate , the Present value of Cash flows will be higher than face value | ||||||||||
The Bond price will be higher than face value | ||||||||||
Bond will sell at Premium | ||||||||||
|