Description:
Quick and Easy Excel Tips and Tutorials
10 Podcasts:
 1. Fresh_Excel_Tips-How_to_use_the_PV_functio .. (played 2 times)
2. Fresh_Excel_Tips-How_to_use_the_PV_functio .. (played 3 times)
3. Fresh_Excel_Tips-How_to_Use_the_SLN_functi .. (played 4 times)
4. Fresh_Excel_Tips-How_to_Use_the_SYD_functi .. (played 4 times)
5. Fresh_Excel_Tips-How_to_Use_the_LCM_functi .. (played 2 times)
6. Fresh_Excel_Tips-How_to_use_the_GCD_functi .. (played 2 times)
7. Fresh_Excel_Tips-How_to_Use_the_RATE_funct .. (played 2 times)
8. Fresh_Excel_Tips-How_to_Use_the_FV_functio .. (played 2 times)
9. Fresh_Excel_Tips-How_to_Use_the_PMT_functi .. (played 2 times)
10. Fresh_Excel_Tips-Use_the_DDB_function_to_c .. (played 2 times)
Content:
(Play It)
How to Use the RATE function to calculate interest rate in Excel
Let’s say a bank advertises that if you deposit $500 each month for 12 years, you will have $100,000 at the end of the period. What is the interest rate the bank is paying? To answer this question, use the RATE function, which returns the interest rate per period of an annuity. Here is the [...]
Click here to play
(Play It)
How to Use the FV function to calculate total savings account balance
In this example you want to save money for five months. The interest rate is 3.5%. Every month you deposit $500 at the bank. How much money is in your bank account after five months? This question can be answered by using the FV function. It returns the future value of an investment based on [...]
Click here to play
(Play It)
How to Use the PMT function to determine the payment of a loan
To determine the payment amount for a loan based on constant payments and a constant interest rate, you can use the PMT function. Here is the syntax that is used:
PMT(rate, nper, pv, fv, type)
rate: The interest rate of the loan.
nper: The total number of payments for the loan.
pv: The present value. This is also referred [...]
Click here to play
(Play It)
Use the DDB function to calculate double-declining balance method
The DDB function returns the depreciation of an asset for a specified period, using the double-declining balance method or some other method that can be specified.
DDB(cost, salvage, life, period, factor)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the depreciation.
life: The number of periods over which the asset is being [...]
Click here to play
(Play It)
How to use the PV function to compare investments in Excel
Two investments have to be compared. The amount of each investment, the number of periods, the interest, and the estimated return are given. To calculate and compare, use the PV function as described below.
To compare investments:
In cells B2 and C2 enter the investment amounts.
In cells B3 and C3 enter the interest rates.
In cells B4 and [...]
Click here to play
(Play It)
How to use the PV function to decide how much money 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. Here is the syntax that is used for [...]
Click here to play
(Play It)
How to Use the SLN function to calculate straight-line depreciation
Here we want to calculate the straight-line depreciation of an investment. Use the SLN function, which returns the straight-line depreciation of an asset for one period. Here is the syntax that is used:
SLN(cost, salvage, life)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the depreciation.
life: The number of periods over [...]
Click here to play
(Play It)
How to Use the SYD function to calculate depreciation in Excel
In this tip, we calculate the depreciation of an investment. To do so, use the SYD function, which returns the sum-of-years’ digits depreciation of an asset for a specified period. Here is the syntax that is used:
SYD(cost, salvage, life, per)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the deprecation.
life: [...]
Click here to play
(Play It)
How to Use the LCM function to determine the least common multiple
In this example, we will show you how to determine the least common multiple of two integers. Excel provides the LCM function through the Analysis ToolPak add-in. You will need to install and load the add-in to perform these steps. Here is the syntax that is used:
LCM(number1, number2, …)
number1, number2, …: From 1 to 29 [...]
Click here to play
(Play It)
How to use the GCD function to determine the greatest common divisor
In this example, the greatest common divisor of two integers has to be determined. To do so, use the GCD function. This function is only available if you have the Analysis ToolPak add-in installed. Here is the syntax that is used:
GCD(number1, number2, …)
number1, number2, …: From 1 to 29 values for which you want to [...]
Click here to play
Home
|
