ExcelBanter - Creating an Amortization schedule ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Creating an Amortization schedule ? (https://www.excelbanter.com/excel-discussion-misc-queries/4442-creating-amortization-schedule.html)

Creating an Amortization schedule ?

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" wrote in message
...
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
wrote:

Anyone know how to do this in Excel??