how to make a simple finance record in excel
Tuesday, December 29th, 2009Watch the vid,any questions comment or message me.
Posts Tagged ‘Excel’
Excel Finance Trick #3: PMT function Lender or Borrower
Saturday, December 19th, 2009See how to use the PMT function for the Lender or Borrower. Cash Flows matters in Finance and so using the PMT function is very different for the Lender and Borrower. In ThisSeries learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or …
Intro to Quant Finance: Periodic Rate of Return
Tuesday, December 15th, 2009Periodic rate of return
Binomial distribution
Tuesday, December 1st, 2009The binomial is one of the basic distributions, yet surprisingly common in risk and quant finance. Here I take a look at its key properties and compare the formula to Excel’s built in =BINOMDIST() … Excel Quant Finance