Help amorization table

[tigerlilly]

Hi
I need help with creating a amortization table. What I need is a program that produces straight-line depreciation. I need to include a field for the purchase price and the term in years over which the asset is depreciated. My table needs to display the year, yearly depreciation, end of year value, and the accumulated depreciation. Can anyone please help me on this I am not really good with VB.

Thanks

 

[MichaelRed]

Straight LIne Depreciation A.K.A. "SLN&quot would not usually be stored in the manner you describe, as three values can be used by a function to calculate the status indicated above. SLN is 'just' the original value (OrgVal) minus the Salvage Value (SalvVal) divides by the Number of periods (NPer) of the amortization.

An Example:

Sln = (OrgVal SalvVal) / NPer

So

Sln = (30000 - 7500) / 10 = 2250

So the amortization at any point can also be calculated as in the value at the end of five years is:

OrgVal - (Sln * Mprds) = 30000 - (2250 * 5) = 18750

Of course, you cannot use "SLN" or "NPer" as variable names in Ms A, as they are functions and thus are 'reserved'.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over