Remember Me?

Posted to microsoft.public.excel.worksheet.functions
 CAnn external usenet poster Posts: 2 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

Posted to microsoft.public.excel.worksheet.functions
 John external usenet poster Posts: 2,069 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

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

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post John Excel Worksheet Functions 4 April 4th 23 12:45 PM Assad Excel Worksheet Functions 7 June 8th 07 07:43 PM magis Excel Worksheet Functions 3 January 6th 06 05:21 PM Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM sts111 Excel Discussion (Misc queries) 1 February 1st 05 01:26 PM

All times are GMT +1. The time now is 09:32 AM. Copyright ©2004-2023 ExcelBanter.