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.
Bookmarks