Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you calculate interest expense on bonds?
Using Excel office on XP. Issued $1mill of 11% 20 year bonds, issued 4-1-04
and paying interest on a yearly bases on 3-31. Need to calculate interest expense for fiscal year ended 9-30-04 assuming a premium of $80,000 amoritized on a streight line bases. |
#2
|
|||
|
|||
Hi,
Try having a look at the =PRICE function in help. If this isn't exactly what you need then it should point you in the right direction. HTH, David Jessop "Sprout" wrote: Using Excel office on XP. Issued $1mill of 11% 20 year bonds, issued 4-1-04 and paying interest on a yearly bases on 3-31. Need to calculate interest expense for fiscal year ended 9-30-04 assuming a premium of $80,000 amoritized on a streight line bases. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
How do I calculate interest on actual date? | Excel Worksheet Functions | |||
Compound interest calculation | Excel Worksheet Functions | |||
How do I calculate interest and deduct late fees based on date pa. | New Users to Excel | |||
How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions |