Week 5 Discussion Board Exploring Financial Tools and Functions
Using the Internet, conduct a thorough search for more information on exploring financial tools and functions in Excel. Choose one bullet listed below and explain and also include a reason to use in your worksheet for your bullet from the following:
Work with financial functions to analyze loans and investments
Create an amortization schedule
Calculate interest and principal payments for a loan or investment
Perform calculations for an income statement
Interpolate and extrapolate a series of values
Calculate a depreciation schedule
Determine a payback period
Calculate a net present value
Calculate an internal rate of return
Trace a formula error to its source
