Use SUM OFFSET to model straight line depreciation
Use the SUM(), OFFSET() and MIN() functions to dynamically compute straight-line depreciation for capital expenditure in any year.
Topics
Pinned
Monday, December 14, 2020
Three "epic fails" nearly wiped me clean this year. Here are five things I’d learned from these painful lessons: 1) Despair and greed...
Sunday, October 18, 2020
In 1990, a psychologist quoted in the New York Times reported that people “turn on the TV when they feel sad, lonely, upset or worried,...
Sunday, July 26, 2020
Good investors are first and formost by nature: business people. They should be entrepreneurs, owners of businesses or have been placed...
Thursday, July 23, 2020
IB isn't only about late nights & number crunching, but also the toxic & condescending environment one has to put up for many years to come.
Saturday, July 4, 2020
There’s nothing you should regret in life - all the good things that you have today are a result of everything that has happened....
Wednesday, March 4, 2020
Money is the one thing that you can always replace any time or at some point of time in the future - money is just money.
Friday, August 2, 2019
More than three years since I started out, I discovered a new-found respect for the many areas of businesses which are presumably...
Wednesday, December 31, 2003
Learning, knowledge and staying up to date with the news and what's going on in the world is your own personal responsibility. The same...