imputed interest table? | TigerDroppings.com

Posted byMessage
Crbello4Hiceman
LSU Fan
Lurking
Member since May 2011
431 posts

imputed interest table?


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?







Back to top
Share:
Broke
LSU Fan
AKA Buttercup
Member since Sep 2006
55408 posts

re: imputed interest table?


You can do that with a Hewlett Packard BAII





Back to top
Crbello4Hiceman
LSU Fan
Lurking
Member since May 2011
431 posts

re: imputed interest table?


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.





Back to top
Broke
LSU Fan
AKA Buttercup
Member since Sep 2006
55408 posts

re: imputed interest table?


Oh I can't help with that.

Excel??






Back to top
Crbello4Hiceman
LSU Fan
Lurking
Member since May 2011
431 posts

re: imputed interest table?


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.






Back to top
RickAstley
LSU Fan
Reno, Nevada
Member since May 2011
1596 posts

re: imputed interest table?


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.






Back to top


Back to top




//