VBA - For Next Loops

Some simple problems are used to demonstrate how to use For Next loops in Excel

  1. Text Completed

    Overview

    This path introduces you to For Next loops in Excel using four problems from your intro finance class, FV Lump Sum, FV Annuity, PV Lump Sum, and PV Annuity. Once you watch the videos describing the solution to FV Lump Sum, attempt to write VBA code that solves the three other problems before watching the videos. Finally, complete the challenge problem.

    Edit Remove Move
  2. video Completed

    Future Value Lump Sum on Paper

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  3. video Completed

    Future Value Lump Sum VBA

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  4. video Completed

    Future Value Annuity on Paper

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  5. video Completed

    Future Value Annuity VBA

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  6. video Completed

    Present Value Lump Sum on Paper

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  7. video Completed

    Present Value Lump Sum VBA

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  8. video Completed

    Present Value Annuity on Paper

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  9. video Completed

    Present Value Annuity on VBA

    Uploaded by Jonathan Godbey on 2015-10-29.

    Edit Remove Move
  10. Text Completed

    Challenge Problem

    Write VBA code, which uses For Next loops, to compute an individual's wealth at death. The user should be able to input her current wealth, annual deposit, years to retirement, interest rate in her per-retirement account, years in post-retirement, annual withdrawals, and interest rate in her post-retirement account. The output should be her wealth at death.

    Edit Remove Move

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy