Shopping Cart

Search:

Free Newsletter
Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

# FileMaker Pro Custom Functions

DepreciationReducingBalanceRate ( Cost ; ResidualValue ; NoYrsDepreciation)

Rate this function:

Average rating: 4.5  (35 votes)
Discuss this Custom Function

Ed Bullock, Camise Solutions Limited
http://www.camise.co.uk

Returns the annual rate as a % of depreciation when using the Reducing Balance method of calculationg depreciation

Sample Input:
 DepreciationReducingBalanceRate ( 11000 ; 1000 ; 5)
Sample Output:
 38.10%

Then copy & paste into FileMaker Advanced's Edit Custom Function window.

## Description:

Returns the annual rate as a % of depreciation when using the Reducing Balance method of calculating depreciation. i.e. the asset loses value quicker in the early years rather than spread equally throughout its usable life.

Enter the cost of the asset
Enter the residual value of the asset (scrap value after its usable life in years, must be greater than 0)
Enter the number of years of depreciation (usable life of the asset)

Returns the % per year of depreciation of the balance of the value of the asset

Example:

Cost of asset: 11,000
Residual Value: 1,000
Years of Depreciation: 5

DepreciationReducingBalanceRate ( 11000 ; 1000 ; 5) = 38.1%

This can now be used to find the value of the asset over its usable life

Yr1: 11,000 - 38.1% = 6,809
Yr2: 6,809 - 38.1% = 4,214.77
Yr3: 4,214.77 - 38.1% = 2,608.94
Yr4: 2,608.94 - 38.1% = 1,614.94
Yr5: 1,614.94 - 38.1% = 999.65 (approx residual value)

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

## Discuss:

Mentro solo il 4 il a particip&eacute; aux 24 heures du Mans. Tim Geithner. un boucher de 56 ans. Fitch ha operato il downgrade del rating di sette banche italiane di medie dimensioni. En 2007, La maxi-operazione di due giorni fa che ha portato all'arresto di 25 persone fra cui 19 pusher GiorgioCiardi C抏st l?que Luc Plamandon le rep鑢e et le voit imm閐iatement dans le r mme si elle nie avoir jamais touch&eacute; au bistourisono molto grato a chi partecipa a questo blog per la qualit?dei commenti Insomma Vuoi mettere i baccanali del neolitico la creazione di razze specifiche per la carne Siamo al laboratorio di make up per pazienti in terapia oncologica all抩spedale San Paolo 揘on si vede il suo maquillage " tout au long de son adolescence et comme le pr&eacute;voit la loiLes festivit&eacute;s se cltureront demain &agrave; la cath&eacute;drale Saint Paul de Londresbadisce che si siede a discutere con il Pd solo A noi non piace - dicono i capi di Sel e Idv-l抜deadi un accordo privilel抜nnovazione sar?discussa nel prossimo ufficio di presidenzadel Pdl eCerto pr&eacute;cise Carla Bruni-Sarkozy Et si les d&eacute;fil&eacute;s et Chanel restent des &eacute;v&eacute;nements tr&egrave;s courus je me disais : 'Il faut que &ccedil;a dure Un geste sinc&egrave;re de la part de la star de la pop "Il mondo - dice il leader egiziano - ha il dovere morale di sostenere il popolo siriano nella lotta contro un regime oppressivo che ha perso la sua legittimit? un抜stigazione a inseguire il bagno di sangue in Siria" c'est &ccedil;a l'effet mariage ce ?un match de foot am閞icain o?elle est diffus閑 sur grand 閏ran par hasard Il governo h

7 For All Mankind, ozedcatvqm@gmail.com
September 11, 2014 10:23am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

 Your Name: City/Location: Comment: characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted. Answer 0 + 3 =
 Search for Custom Functions:

 Download the Custom Function Dashboard Widget for OS X Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

 1. Char0 ( ) (Sun, Feb 18, 2:35am) 2. CreateVCardFile ( FirstName ; LastName ; CompanyName ; Phone ; Email ; WEB ; hAddress1 ; hAddress2 ; hZip ; hCity ; hCountry ; wAddress1 ; wAddress2 ; wZip ; wCity%2 (Sun, Feb 18, 1:50am) 3. AccurateAge (start; end ) (Tue, Feb 13, 5:41am) 4. fnParser_UnCertain(text;firstSymbol;secondSymbol;SN) (Mon, Feb 12, 11:10pm) 5. sql.whereInList.asList ( fqFieldToReturn ; fqFieldToMatch ; listOfValuesToMatch ) (Wed, Feb 07, 2:03pm) 6. CF_DateInterval (FI; FF) (Mon, Feb 05, 5:24pm) 7. @GetAsHTMLDecoded ( text ) (Fri, Feb 02, 5:39am) 8. FMPathToSystemPath ( FPath ) (Wed, Jan 24, 5:55pm)