Αν θέλετε να ελέγξετε/συγκρίνετε ποσό δανείου, χρόνο αποπληρωμής, δόση δανείου και επιτόκιο δανείου, τότε αυτό το αρχείο excel μπορεί να σας φανεί χρήσιμο. If you want to check/compare interest rate, years of loan, monthly payment and loan amount, then you might find this excel file useful. For example, if you take a 30000 euro loan for 10 years with an interent rate of 3% (payment due : end of period), your monthly payment will be 289,68 euro. Πατήστε εδώ για να κατεβάσετε αυτό το αρχείο excel… / Click here to download this excel file… Mobile : 6945 849400 Email : info@softexperia.com FB Tags : #excel_tips #calculations #loan_and_interest #loan_analysis_worksheet #σύγκριση_όρων_δανείου / fb : Softexperia.com / www.softexperia.com
Imagine that you are about to take out a 25-year fixed-rate mortgage. The terms of the loan specify an initial principal balance (the amount borrowed) of 100000 euro and an APR of 5,75%. Payments will be made monthly. What will be the monthly payment? How much of the first payment will be interest, and how much will be principal? Answer : Monthly payment will be 629,11 euro. 479,17 euro of the first monthly payment will be interest and 149,94 euro will be principal. * Next time you discuss about a loan and you ask for a 1% lower interest rate and they tell you : “Come on, it is only 1% percent more and it does not matter.”, show them this table. And then tell them that it is only 1% more but it does matter. Α 1% lower interest rate makes a difference i.e. paying less 17696,71 euro for…
Consider a loan with an annual interest rate of 6%, a 20-year duration, a present value of 150,000 EUR (amount borrowed) and a future value of 0 (that’s what you hope to achieve when you pay off a loan). Present Value (pv) 150000 Future Value (fv) 0 Annual Interest Rate (rate) 6% Terms (Years) (nper) 20 Compounding periods per year 1 Annual Payment (pmt) -13.077,68 € Calculate the annual payment of a loan with the PMT function Τύπος κελιού F10 =PMT(F7;F8;F5;F6;0) softexperia.com