Cash Flow Analysis, trouble with assigning buttons, trouble all around.

Barqsman

New Member
[FONT=&quot]This is the first part of my assignment. I am about to go crazy because I cannot figure out how to do any of this. I know how to go to VBA and create the subroutine, but after that i'm pretty much lost. Anyone have any ideas. I am extremely desperate! I just need something to look at to learn from. I can't just read notes and understand what is being talked about. I know my teacher wants us to use "do, while" and "do until " statements. Thanks[/FONT]

[FONT=&quot]Barqsman[/FONT]

[FONT=&quot]Assignement:[/FONT]
[FONT=&quot]1. [/FONT][FONT=&quot]Create a subroutine called “NetPresentValue.” This subroutine calculates the Net Present Value of a cash flow. <?xml:namespace prefix = o /><o></o>[/FONT]
[FONT=&quot][/FONT]
[FONT=&quot]a. [/FONT][FONT=&quot]Allow the user to input the expected profits for each year for the next 10 years, as well as the expected interest rate. Ensure that the user is entering numerical values. Store these values on a spreadsheet called “UserInput.” Test the subroutine by calculating the Net Present Value.<o></o>[/FONT]
[FONT=&quot][/FONT]
[FONT=&quot]b. [/FONT][FONT=&quot]Create a button titled “Net Present Value.” Assign the subroutine to this button. On the click of the button have the Net Present Value calculated is displayed in a cell of the “Analyses” spreadsheet. [/FONT]
[FONT=&quot]<o></o>[/FONT]

Last edited by a moderator:

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Barqsman

New Member
I'm not real sure how this board works, does it take a while for results are do people read these alot?

Barqsman

New Member
I guess i'll have to keep posting messages so it stays at the top.

Barqsman

New Member
Can anyone help today with this?

Smitty

Legend
Welcome to the Board!

I think one reason for the lack of response is the fact that this is homework, which no one here is going to do for you. We will however, do everything we can to point you in the right direction(s).

You're much more likely to get help if you first detail what you've done/tried so far.

For starters if you're not familiar with how to calculate Net Present Value, I'd check it out in the helpfile. I'd start with setting up a worksheet as described in section a. and see if you can accurately arrive at NPV via formula.

Replies
3
Views
220
Replies
3
Views
233
Replies
0
Views
928
Replies
0
Views
425
Replies
0
Views
318

1,141,282
Messages
5,705,483
Members
421,398
Latest member
Rahat Anwar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back