I have included a simple capital investment problem which is in Course Documents. We are going to use the same numbers for several classes and look at some of the ways that capital investments are evaluated.
This week we will look at the pay back method. This method looks at how long it takes to get the money back from an initial investment or cash outflow. There is an extensive amount of information on the internet if you run into trouble on this.
To get full credit please do the following: Define the technique.
Analyze the numbers in the problem using an excel spreadsheet. You must use Excel formulas which are on the ribbon in Excel marked Fx to make your calculations whenever possible.
All information must be in Excel (Word documents will not be read and you will not get credit).
Attachment:- Capbudget.xls