want be able to calculate monthly and accumulated depreciation for an asset using the straight line formula. plus when i select a particular month for an asset, it should give me the results for its monthly depreciation and accumulated value.
E.g is if an asset is suppose to depreciate over 5 months, if assuming its starts on january when i select january it should give the monthly depreciation and accumulated value for january. and so on for the rest of the months. but still can get to total monthly depreciation and accumulated value of the whole 5months.
i hope my problem is clear and will get the needed support and guidance. Thank you