Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default SLN & Annual rate of Depreciation

I have a problem trying to set up a worksheet using SLN function to show a
straight-line depreciation and a formula to determine the annual rate of
depreciation. Cost=$96,345; Salvage=$25,000; Life= 6 yrs; Annual Rate of
Depreciation = SLN/Cost.

Create a data table showing straight-line depression and annual rate of
depreciation (forklift) for salvage from $20,000 to $29,000 in $500
increments.
Help. Much Thanks

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,069
Default SLN & Annual rate of Depreciation

To create the data table you need to start with your first data so in A2 put
the cost, A3 the Salvage & A4 the years. Cell D1 = SLN(A2,A3,A4).
cells C2 to C21 put 20000 to 29500 in 500 increments. Select cells C1:D21.
Select Data Table from the Data Menu and for the column input put A3. This
is all the SLN values. for the % put in E2=D2/$A$2 and fill this to E21
Hope this is of help
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"CAnn" wrote:

I have a problem trying to set up a worksheet using SLN function to show a
straight-line depreciation and a formula to determine the annual rate of
depreciation. Cost=$96,345; Salvage=$25,000; Life= 6 yrs; Annual Rate of
Depreciation = SLN/Cost.

Create a data table showing straight-line depression and annual rate of
depreciation (forklift) for salvage from $20,000 to $29,000 in $500
increments.
Help. Much Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Effective Annual Interest Rate John Excel Worksheet Functions 4 April 4th 23 12:45 PM
Finding Annual Growth Rate Assad Excel Worksheet Functions 7 June 8th 07 07:43 PM
XNPV vs. NPV(quarterly) different results magis Excel Worksheet Functions 3 January 6th 06 05:21 PM
APR - Annual Percentage Rate to Actual Interest Rate Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM
Annual Percentage Rate sts111 Excel Discussion (Misc queries) 1 February 1st 05 01:26 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"