You can enter Financial functions in three ways.
1. Click on fx in the formula bar and then double click on the appropriate financial functio
the boxes that appear in the window.
2. Click on Formulas in the green menu ribbon and then Formula Builder and d
Activating the StatPlus LE package for regression analysis
2 Download the file.
3 Click on the zip file
4 Drag the program icon to the applications folder on the screen window in front of
An Important Point to Remember: After you have created any type of chart to
add titles, axis names, data labels, and other chart information be sure you have
clicked on the chart and the Chart Layout menu is displayed to the right of the
Activating the Solver Add-in
1 Click on Tools on the top ribbon of Excel.
2 Select Add-Ins.
3 Select Solver.Xlam and click OK.
4 Solver Add-in should now be under the DATA Tab in the green menu ribbon in t
en menu ribbon in the Analysis group.
Calculation of Harvesting Cost Per Acre for Wheat
Base Cost in $ per Acre
Additional Cost in $ per bushel if yield larger than Base Yield
Base Yield in bushels/acre
Actual Harvested Yield
Harvest Cost ($/acre)
This is 2% of $5,000
Calculate Net Present Value using the Formula 1/(1+interest rate)^Year
Discount (interest rate) for Part 1 >
Sum - Purchases Product
Electronics Furniture Garden