Calculate Monthly Accumulated Depreciation using C# and VB.Net in ASP.Net

Question

i want to write a code that monthly depreciates an asset over time using the straight line depreciation methodthe calculation has to be done in backend using c or vb and displays it result in html tablethe datas are Depreciable Cost 1000 Salvage Value 100 depreciable date start  Sept2019 Asset Life months 10 months depreciable method Straight Lineformula   Depreciable Cost  Salvage Value  Asset Life months below is a screenshot of the result in an html table

arunkurmi · Accepted Answer

Hi ucrhlynRefer below code for your referenceHTMLltaspGridView runat34server34 ID34gvData34 AutoGenerateColumns34false34gt    ltColumnsgt        ltaspBoundField DataField34Month34 HeaderText34Month34 gt        ltaspBoundField DataField34Depreciation34 HeaderText34Depriciation Expenses34 DataFormatString340N234 gt        ltaspBoundField DataField34Accumulated34 HeaderText34Accumulate Deprication at MonthEnd34            DataFormatString340N234 gt        ltaspBoundField DataField34BookValue34 HeaderText34Book Value at MonthEnd34 DataFormatString340N234 gt    ltColumnsgtltaspGridViewgtNamespacesCusing SystemDataVBNetImports SystemDataCodeCprotected void PageLoadobject sender EventArgs e    DateTime acquiredDate  new DateTime2019 09 01    DateTime startMonth  new DateTime2019 09 01    double depreciation  100

dharmendr · Answer

ucrhlyn saysDim acquiredDate As DateTime  New DateTimeacquireddatefromsql            Dim startMonth As DateTime  New DateTimeacquireddatefromsql  Relace above with belowDim acquiredDate As DateTime  ConvertToDateTimeacquireddatefromsqlDim startMonth As DateTime  ConvertToDateTimeacquireddatefromsql

Calculate Monthly Accumulated Depreciation using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us