Royal Posted July 17, 2012 Share Posted July 17, 2012 Does anyone have an Excel version of an amortization schedule? I seem to have misplaced the one I used in my days of collegiate glory. Thanks in advance. Link to comment Share on other sites More sharing options...
nsplayr Posted July 17, 2012 Share Posted July 17, 2012 Let me google that for you. Link to comment Share on other sites More sharing options...
HerkFE Posted July 17, 2012 Share Posted July 17, 2012 Check your PM. I attached a file but it doesn't look like the attachment went. Let me know and I'll resend if you didn't get it. Link to comment Share on other sites More sharing options...
Guest Posted July 17, 2012 Share Posted July 17, 2012 Amortization schedule is very broad. Are you specifically looking for a home mortgage shcedule? Link to comment Share on other sites More sharing options...
Royal Posted July 17, 2012 Author Share Posted July 17, 2012 (edited) Let me google that for you. Though it was oh so tempting to download every item the interweb had to offer, I wanted a file that at least one person on here has already used and has vetted for. Check your PM. I attached a file but it doesn't look like the attachment went. Let me know and I'll resend if you didn't get it. Thanks, Herk. Check your inbox. Amortization schedule is very broad. Are you specifically looking for a home mortgage shcedule? Yup, I should've said that; I'm running some numbers on home financing. Edited July 17, 2012 by Royal Link to comment Share on other sites More sharing options...
rancormac Posted July 18, 2012 Share Posted July 18, 2012 It's pretty easy to make your own in excel using the financial functions PV = Present Value FV = Future Value PMT = payment installations Interest per payment can be calculated by (Remaining Principal) * (Annual Interest Rate) / (# of payments per year) Then take monthly payment, subtract interest above, and the rest subtracts from principal. Repeat until principal is $0 Link to comment Share on other sites More sharing options...
HerkFE Posted July 18, 2012 Share Posted July 18, 2012 It's pretty easy to make your own in excel using the financial functions PV = Present Value FV = Future Value PMT = payment installations Interest per payment can be calculated by (Remaining Principal) * (Annual Interest Rate) / (# of payments per year) Then take monthly payment, subtract interest above, and the rest subtracts from principal. Repeat until principal is $0 I would need those instructions in a Powerpoint. 1 Link to comment Share on other sites More sharing options...
Royal Posted July 18, 2012 Author Share Posted July 18, 2012 It's pretty easy to make your own in excel using the financial functions PV = Present Value FV = Future Value PMT = payment installations Interest per payment can be calculated by (Remaining Principal) * (Annual Interest Rate) / (# of payments per year) Then take monthly payment, subtract interest above, and the rest subtracts from principal. Repeat until principal is $0 That's probably beyond what my work ethic would allow in my limited free time; I'll start fidgeting around with the financial functions, though. Link to comment Share on other sites More sharing options...
rancormac Posted July 18, 2012 Share Posted July 18, 2012 I am making one right now. I can make you one if you want. PM me if interested. Im assuming basic loan? Fixed APR, monthly payments, and you just want to see the breakdown of payments each month? If you send me all the #s you got, I can do it real quick Link to comment Share on other sites More sharing options...
Royal Posted July 19, 2012 Author Share Posted July 19, 2012 I am making one right now. I can make you one if you want. PM me if interested. Im assuming basic loan? Fixed APR, monthly payments, and you just want to see the breakdown of payments each month? If you send me all the #s you got, I can do it real quick No worries, dude. Herk sent me exactly what I needed. I appreciate it though. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now