Tech Support Guy banner

Excel 2010: Loan Interest End Date Calculation

1123 Views 1 Reply 2 Participants Last post by  Keebellah
I'm trying to create a formula that will input the maturity date of a particular loan. The spreadsheet contains the interest (fixed rate), the monthly payments, and the current balance of the loan (see below).



The current date will be displayed at the top in a separate cell that we can use to base the maturity date off of, but I guess I just don't understand how to do the math to begin with.

Eventually, I'd like to add a separate sheet with the amortization schedule which could easily just be referenced on this sheet instead of doing all the math here, but if I can understand the math first, I can take it from there.

Any ideas? Thanks in advance.
See less See more
Status
Not open for further replies.
1 - 2 of 2 Posts
Hi, I was just curious to see how many Excel posts have gone unanserede and cam accross your post.

I'm not in to economics or finacila calculations, but Excel does have a function named EDATE()
description and syntax is described in the link below:
http://office.microsoft.com/en-001/excel-help/edate-HP005209073.aspx

Amorization table in ExceL:
https://www.google.com/?hl=en&gws_rd=ssl#hl=en&q=amortization function excel 2010

Maybe this will help you along.
1 - 2 of 2 Posts
Status
Not open for further replies.
Top