Codible
Rank: 1814 / 5440
4 selected videos
Excel tutorial: Present value (PV) in excel 2010
Download excel file: http://codible.com/pages/58
Present value (PV) function lets you calculate the present discounted value of a series of future cash flows. In this example we see how to calculate the loan amount you can borrow for a given series of equal monthly payments like, say a car loan payment. Follow us on twitter: https://twitter.com/codible
Related topics : loan payment calculator car / calculating loan payments in excel
Excel finance tutorial: calculating IRR for a loan
Shows how to calculate IRR for a loan, and compare with available interest rates from other sources.
Related topics : loan calculator excel / interest rates loan
Excel finance: calculate the cost of that interest free loan
Should you accept that -interest free loan- or make a full payment? This video shows you how to make this decision using Excel. Follow us on twitter: https://twitter.com/codible
Related topics : interest loan calculator
Excel tutorial: Creating a loan amortization table in Excel 2010
Download excel file: http://www.codible.com/pages/59
When repaying a loan (e.g. car loan) with a fixed monthly payment, this video shows you how to detail the principal and interest components of the payments over the period of repayment. Follow us on twitter: https://twitter.com/codible
Related topics : amortization loan excel / payment car loan
4 Resources