x******i
发帖数: 148 | 1 Hello, everyone
I have a question regarding how to caculate the notes payable interest. We
have a old excel file and someone create like below:
I can not get that interest rate caculation, Is any one know how I can get
that number us 12% annual rate.
Loan amount $110,000.00
Annual interest rate 12.000%
Loan period in years 7
Start date of loan 5/25/2006
Monthly payment $-
Number of payments 1 Due Upon Demand
Total interest $62,274.00
Total cost of loan $172,274.00
Payments Made 0
Year Period Principal Interest Total Amount Status
1 2006-2007 110,000.00 7,280.00 117,280.00 1
Year Extension
2 2007-2008 117,280.00 7,762.00 125,042.00 1
Year Extension
3 2008-2009 125,042.00 8,276.00 133,318.00 1
Year Extension
4 2009-2010 133,318.00 8,824.00 142,142.00 1
Year Extension
5 2010-2011 142,142.00 9,408.00 151,550.00 1
Year Extension
6 2011-2012 151,550.00 10,030.00 161,580.00 1
Year Extension
7 2012-2013 161,580.00 10,694.00 172,274.00 1
Year Extension
Amount as of last period 161,580.00 10,694.00 172,
274.00 |
|
