Excel question?

: If the initial cost of an investment is 45000, Salvage Value is 9500 and Lifespan in year is 20 and then find the yearly depreciation allowance for the first year by using SYD function of Excel.

The sum of the years digits is (20 x 19) / 2 = 190
The first year's depreciation is 20/190 times (cost - salvage)

$35,500 x 20/190 = $3,736

First Year Dep. will be 3,380.95

use this formula:
=SYD(45000,9500,20,1)

The answer is $3,380.95.

Please note in Serge M's response, he used $35,500 x 20/190 = $3,736; he should have used 35,500 * 20/210 = 3,380.95 -- the sum of the digits sums to 210, not 190. I think the formula is [n*(n-1)]/2 + n for sum of the digits.

Tags

　　Venture Capitalist 　　Venture Capital 　　VC Fund 　　Vanguard Fund 　　Value Investment 　　Trust Investment 　　Stock Investment 　　startup Investments

Related information

What's the history of warren buffet?

The Story of Berkshire Hathaway's Billionaire Chairman Warren Buffett is Born Warren Edward Buffett was born on August 30, 1930 to his father Howard, a stockbroker-turned-Congressman. Th...

We purchased our first home (brand new) approx. 6 months ago...?

One possibility is that you may of bought early enough in the construction stage that the builders may of misjudged what the house will appraise for. Every once in awhile families get lucky and th...

All insurance is based on a principle called?

Division of Risk. And it's so BLATANTLY OBVIOUS that you either need to build your vocabulary, or read the book.

...

Interest???

I am interpretting the question as "How much would I have to invest today to have $4,000 in five years if the investment earns 6% compounded yearly?" To answer that question, first ...

ADRE 4:1 split on july 7,2006? Shouldn't this be 2007?

any details about stock market, i hope this will helps u... ...

Any news on the Iraqi Dinar?

lol.. from one owner to another.. let's not hold our breath I don't see any significant change.. and if there is, it's probably because our dollar is sinking vs the dinar rising. ...

Why do you have to exclude year 0 in excel when calculating NPV, but not when calculating IRR?

NPV is Net Present Value. The technique takes a stream of future payments and discounts by an interest rate to determine what that future stream is worth now. There is no year zero, because that&#...

Sale/Leaseback Home?

Good luck.

...