Results 1 to 5 of 5

VBA Code for Financial Function Userforms

Threaded View

wooley1985 VBA Code for Financial... 04-06-2012, 10:45 AM
tigeravatar Re: VBA Code for Financial... 04-06-2012, 11:14 AM
PingPing Re: VBA Code for Financial... 04-06-2012, 11:24 AM
wooley1985 Re: VBA Code for Financial... 04-06-2012, 11:58 AM
Whizbang Re: VBA Code for Financial... 04-06-2012, 12:08 PM
  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    Grand Rapids, MI
    MS-Off Ver
    Excel Mac 2011
    Posts
    2

    VBA Code for Financial Function Userforms

    Last night I was out with a friend of mine and he was complaining because how difficult of an Exel project he was putting together. I got sick of listening to him and told him that I could do it in my sleep. In reality, I know very little about excel and almost nothing about VBA. We made a bet on it and i have to have it e-mailed to him before he leaves for work at 5pm EST today. PLEASE HELP!!!
    I must...
    Create a multipages form.
    Page one: Finance
    For page 1, create sub procedures to calculate:
    1. PMT
    2. Loan duration
    3. Interest Rate
    4. Present value
    5. Future value

    Page 2: Depreciation
    Calculate the depreciation function.

    Page 3: Profitability
    Calculate:
    1. NPV
    2. IRR
    3. ROI
    4. Payback period

    He knew I wasn't going to be able to complete it so he sent me an e-mail with the attached pictures this morning of his finished product.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1