Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course.
The most straightforward method you can use to calculate depreciation is the straight-line method. As the name implies, the straight-line method assigns depreciation evenly over the economic life of an asset. The starting amount is the asset's purchase price or initial cost, and the ending value is the asset's salvage value. If your asset has an economic life of ten years and the salvage value of zero, for example, the asset will depreciate by 10% each year, until its value reaches zero.
To calculate straight-line depreciation, you use the SLN function. The SLN function calculates the amount of depreciation for a given period, which is usually a year. The SLN function has three arguments: the initial cost of the asset, which is in cell B5, the salvage value of the asset, which is in cell B7, in this case, and the economic life of the asset, which I have in cell B9.
Close the parenthesis and there is the value. You'll see that in each of the five years of this asset's economic life, it will depreciate by $230 until it reaches its salvage value of $150. Straight-line depreciation is the most conservative approach you can take to depreciation. It assumes that you will hold on to the asset until the end of its economic life, so you should spread out the tax benefits of the depreciation while you still own the asset.
There are currently no FAQs about Excel 2007: Financial Analysis.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.