EXCEL TIPS Archives

All January 27, 2021

Calculating Interest and Principal in a Monthly Payment / Υπολογίζοντας τον τόκο και το κεφάλαιο στη μηνιαία δόση

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…

All January 11, 2021

Computing Annual Payment for a Loan

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

All December 28, 2020

Υπολογισμός ωρών εργασίας με το Excel

Use Excel to calculate the hours worked for any shift / Υπολογισμός ωρών εργασίας με το Excel / #softexperia Steps 1. In A1, enter Time In. 2. In B1, enter Time Out. 3. In C1, enter Hours Worked. 4. Select A2 and B2, and press [Ctrl]1 to open the Format Cells dialog box. 5. On the Number tab, select Time from the Category list box, choose 1:30 PM from the Type list box, and click OK. 6. Right-click C2, and select Format Cells. 7. On the Number tab, select Time from the Category list box, choose 13:30 from the Type list box, and click OK. 8. In C2, enter the following formula: =IF(B2<A2;B2+1;B2)-A2 If you enter 11:00 PM as the Time In and enter 7:00 AM as the Time Out, Excel will display 8, the correct number of hours worked. — Βήματα 1. Στο κελί A1, εισάγετε Time In (Ώρα…

All October 20, 2020

Πως βρίσκετε μια συγκεκριμένη τιμή σ’ έναν πίνακα πολλών τιμών στο excel;

Πως βρίσκετε μια συγκεκριμένη τιμή σ’ έναν πίνακα πολλών τιμών στο excel; Πιο συγκεκριμένα, πως μπορείτε να βρείτε την τιμή 13 που αντιστοιχεί στον Κωδικό 2; Για να βρείτε την τιμή δηλ. το 13 που αντιστοιχεί στον Κωδικό 2, πρέπει να βάλετε στο κελί Ε2 τον τύπο : =VLOOKUP(D2;D4:E7;2;FALSE) και στη συνέχεια να πληκτρολογήσετε το κείμενο “Κωδικός 2” στο κελί D2. Mobile : 6945 849400 Email : info@softexperia.com FB Tags : #excel_tips #softexperia / fb : Softexperia.com / www.softexperia.com