- 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
imputed interest table?
Posted on 5/15/13 at 3:52 pm
Posted on 5/15/13 at 3:52 pm
I need a table showing the monthly amount of imputed interest on annual payments but everything I find online shows monthly payments based on principle and interest rate.
I need to find an amortization schedule based on once a year payments that shows interest accruing monthly and will give me the beginning principle balance since the payments include imputed interest. Anybody have any tips?
I need to find an amortization schedule based on once a year payments that shows interest accruing monthly and will give me the beginning principle balance since the payments include imputed interest. Anybody have any tips?
1
Posted on 5/15/13 at 4:02 pm to Crbello4Hiceman
You can do that with a Hewlett Packard BAII
Posted on 5/15/13 at 4:06 pm to Broke
I can calc the total principle to start- I need a table showing the monthly interest compounding and for it to show me the beginning principle balance that agrees to the table..... monthly journal entries are what this is for so I need a beginning to end schedule that works for a 5 yr period.
Posted on 5/15/13 at 4:21 pm to Crbello4Hiceman
Oh I can't help with that.
Excel??
Excel??
Posted on 5/15/13 at 4:32 pm to Broke
Yessir.
Basically I need beginning balance (function of interest calc/rounding of table), then month by month interest accrual, then principle/interest payment at the end of each year for the next 5 years.
The beginning balance will vary depending on the rounding of the monthly interest amounts... it's like I'm working backwards because I know the rate and ending amount paid but I can't find a table that shows it monthly and would calculate the beginning balance.
Basically I need beginning balance (function of interest calc/rounding of table), then month by month interest accrual, then principle/interest payment at the end of each year for the next 5 years.
The beginning balance will vary depending on the rounding of the monthly interest amounts... it's like I'm working backwards because I know the rate and ending amount paid but I can't find a table that shows it monthly and would calculate the beginning balance.
Posted on 5/15/13 at 4:52 pm to Crbello4Hiceman
If I were you, I would start here LINK.
If it is of no help, or if you need further help, please follow up with some example data to work off of.
If it is of no help, or if you need further help, please follow up with some example data to work off of.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News