Excel 2010 Business Math 84: Annuities: FV, PV and PMT for End & Begin (9 Examples)

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Girvin at Highline Community College.
In this video learn how to calculate:
1. Savings Plan FV at end of month for given PMT amount
2. Savings Plan PMT at end of month for given FV amount
3. Savings Plan FV at beginning of month for given PMT amount
4. Savings Plan PMT at beginning of month for given FV amount
5. Borrower PMT at end of month given PV amount
6. Asset Valuation (PV) given cash flow at end of each year
7. Borrower PMT at beginning of month given PV amount
8. Asset Valuation (PV) given cash flow at beginning of each year
9. Retirement PV and calculate withdrawal each month (PMT)
Also:
1. Define Annuity: Equal Cash Flows at Equal Time Intervals
2. Ordinary Annuity (End): Cash Flow At End Of Each Period
3. Annuity Due (Begin): Cash Flow At End Of Each Period
4. Savings Plan: Save $50 at the end of each month
5. Savings Plan: How Much Do I have to put in bank each month for 35 years to become a millionaire?
6. Borrow Money: What is my monthly payment if I borrow $190,000?
7. Asset Valuation: How much should I pay for a machine if it will yield Cash Flow of $10,000 at the each of each year for the next 15 years?

Category:

Education

Tags:

• Excel
• 2010
• Business
• Math
• Mathematics
• Mike
• excelisfun
• Girvin
• Highline
• Community
• College
• Slaying
• Dragons
• Present
• Value
• of
• Future
• periodic
• payment
• Annuity
• Begin
• End
• Due
• Ordinary
• PV
• FV
• PMT
• functions
• Savings
• Plan
• Borrower
• Loan
• Cash
• Flow
• Asset
• Valuation
• type
• nper
• rate

[ExcelIsFun]

@krn14242 , yes, mouse free hand.

[krn14242]

Mike

Did you the first example picture freehand with a mouse? Great job.