Anyone know how to do this in Excel??
Anyone know how to do this in Excel??
ASSUME MONTHLY AMORTIZATION TABLE
A1 = "Principal"
B1 = The amount to be amortized [assume $100,000]
A2 = "Annual Rate"
B2 = Annual Percentage rate of loan [assume 10%]
A3 = "Period in Years"
B3 = Period in years over which loan will be amortized [assume 30 years]
A5 = "Period"
B5 = "Payment"
C5 = "Interest"
D5 = "Principal"
E5 = "Add'l Payments"
F5 = "Balance"
F6 formula =B1
A7 thru A366 = 1 to 360 [# of periods in amortization of 30yrs x 12 months]
B7 thru B366 formula =-PMT($B$2/12,$B$3*12,$B$1,0)
C7 thru C366 formula =ROUND(F6*($B$2/12),2)
D7 thru D366 formula =B7-C7
F7 thru F366 formula =F6-D7-E7
HTH,
Gary Brown
"Joveni" <Joveni@discussions.microsoft.com> wrote in message
news:68187563-7665-4B56-92B0-8FECDB5E3893@microsoft.com...
> Anyone know how to do this in Excel??
Joveni
There is a downloadable loan amortization template at the MS template gallery.
http://office.microsoft.com/en-us/te...CT011377171033
Gord Dibben Excel MVP
On Fri, 21 Jan 2005 18:15:02 -0800, Joveni <Joveni@discussions.microsoft.com>
wrote:
>Anyone know how to do this in Excel??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks