Forum Login | Courses Login

DEPRECIATION (DB) Formula in Excel

DEPRECIATION (DB) Formula in Excel

by | Jun 22, 2020 | Online Business Courses

How to Use the DEPRECIATION (DB) Formula in Excel DEPRECIATION (DB) Formula in Excel is used to return the depreciation of an asset for a specified period using the fixed-declining balance method. Formula Explanation Cost (required): The historical cost of the asset....
PMT Formula in Excel

PMT Formula in Excel

by | Jun 18, 2020 | Online Business Courses

How to Use the PMT Formula in Excel The PMT Formula calculates the payment for a loan based on constant payments and a constant interest rate. Formula Explanation Rate (required): The interest rate for the loan. Nper (required): The total number of payments for the...
ROUND Formula in Excel

ROUND Formula in Excel

by | Jun 18, 2020 | Online Business Courses

How to Use the ROUND Formula in Excel The ROUND function in Excel is used to round numbers to the whole number or decimal depending on your preference. The three formulas we have here allow you to round up, down, or to the nearest whole number or decimal depending on...