Microsoft Excel has built-in functions for multiple depreciation methods for businesses’ fixed assets. The straight-line method (or straight-line basis) uses a built-in function, SLN, which ...

Using the $ sign helps keep the assumptions static so that you can easily copy the formula to the right for multiple assets. In this case, we get an expected return of 4.36% for Tesla.

Carol M. Kopp edits features on a wide range of subjects for Investopedia, including investing, personal finance, retirement planning, taxes, business management, and career development. Some ...