- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Bond Amortization in Excel
Posted on 8/31/12 at 9:45 am
Posted on 8/31/12 at 9:45 am
I haven't used Excel in a while and I'm getting confused with a Bond amortization schedule.
This is for my Advanced Accounting class btw and should seriously only take me 5 minutes
I am to give a face value. $100,000 seems good. Coupon Rate: 8% and Market Rate: 10% semi annual for 10 years (so 20 periods) So it is a discount amortization. Easy as could be with a pen and pad but I can't figure out how to get the Present Value using the PV function.
I'm sure I'm missing something simple but I can't figure it out. My lack of excel knowledge is bad right now.
Any help would be welcomed!
This is for my Advanced Accounting class btw and should seriously only take me 5 minutes
I am to give a face value. $100,000 seems good. Coupon Rate: 8% and Market Rate: 10% semi annual for 10 years (so 20 periods) So it is a discount amortization. Easy as could be with a pen and pad but I can't figure out how to get the Present Value using the PV function.
I'm sure I'm missing something simple but I can't figure it out. My lack of excel knowledge is bad right now.
Any help would be welcomed!
Posted on 8/31/12 at 10:01 am to MThawg
In an am table, PV = outstanding principle (beggining value).
In excel, the PV function is =pv(rate,nper,pmt,fv,type).
Not sure which one you are looking for.
If you need an excel template for bond amort tables, just google and there are a ton of good ones.
In excel, the PV function is =pv(rate,nper,pmt,fv,type).
Not sure which one you are looking for.
If you need an excel template for bond amort tables, just google and there are a ton of good ones.
Popular
Back to top
Follow TigerDroppings for LSU Football News