Microsoft Excel Functions and Formulas 3E by Held Bernd & Richardson Theodor

Author:Held, Bernd & Richardson, Theodor [Held, Bernd]
Language: eng
Format: epub, pdf
Tags: Computing, Internet
ISBN: 9781937585501
Publisher: Mercury Learning and Information
Published: 2014-11-24T22:00:00+00:00

salvage: The value of the asset at the end of the depreciation period.

life: The number of periods over which the asset is depreciated.

To calculate depreciation:

In cell B1, enter the initial cost.

In cell B2, enter the number of periods as years.

Enter the salvage in cell B3.

Calculate the depreciation in the fifth year in cell B5 with the following formula:

=SLN($B$1,$B$3,$B$2).

Press <Enter>.

FIGURE 7–2

USE THE PV FUNCTION TO DECIDE THE AMOUNT TO INVEST

In this example, you have to decide on the amount of money you want to invest. To solve this problem, you use the PV function, which returns the present value of an investment. This is the total amount that a series of future payments is worth now.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.