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.
Almost without exception, companies purchase physical assets to help them do business. Whether the purchases are relatively small such as computers and printers or large such as company cars and office buildings, these assets will go down in value over time. Reduction in value due to age is called depreciation. There is a difference between the physical life of an asset and the economic life of an asset. Physical life is the amount of time an asset will perform its function, i.e., how long will a building be standing and safe to occupy or a printer will turn out page of reasonable quality.
Economic life on the other hand refers to how long the asset will perform its function until it is rendered obsolete by wear and tear or falls so far behind the current technology that it's worth no more than what it could be sold for as scrap. According to the Modified Accelerated Cost Recovery System, an office building has an economic life of 39 years, while our computer or printer will have an economic life of five years. You can find more information about MACRS in IRS Publication 946, available on the IRS website.
At the end of an asset's economic life, it has what is called a salvage value. For example, if you have an old printer that you want to sell, you can either sell the printer at a substantial discount or have the technician pull out the usual parts and sell them to other repair shops that service the same model of printer. There are many different types of schedules that you can use to account for depreciation. Some of these techniques depreciate an asset more quickly than others. Why would you use an accelerated depreciation schedule? Perhaps because you expect to sell the building after using it for a few years.
Because you would hold on to the property for far less than its economic life, it would be to your advantage to capture the tax benefits of depreciation as soon as possible. Accountants have developed a wide variety of depreciation schedules for use by businesses. The schedules vary in the speed at which the assets are assumed to depreciate. Each approach has specific financial advantages and disadvantages.
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.