FYInance

Posts Tagged ‘Community’

Learn what an annuity is and how to make calculations for annuities. Future Value and Present Value Annuities and the math formulas seen written out by hand. See how to use the Excel function FV to make a future value calculation for an annuity. This is a Highline Community College Business Math Class, Busn 135, taught by Mike Gel excelisfun Girvin

If you're new to FYInance, we're going to make it worth your while to subscribe to our FYInance RSS feed. It will keep you up to date, on your terms!

See how to create array formulas for Portfolio Return & Standard Deviation. See how to calculate individual stock return and standard deviation given different assumed states of the future economy. See how to use probability, stock weights and assumed stock returns to calculate individual stock return and standard deviation and Portfolio Return & Standard Deviation. In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and …

See how to create array formulas for Portfolio Return & Standard Deviation. See the array functions: MMULT, COLUMN, TRANSPOSE. See how to do this given different assumed states of the future economy. See how to use probability, stock weights and assumed stock returns to calculate Portfolio Return & Standard Deviation. See of to use the MMULT to matrix algebra. See of to use the COLUMN and TRANSPOSE functions to create a vertical array of ones. In this series see how to create array formulas …