Hello Rick,
Your approach sounds reasonable but the OP mentioned a serious
application (depreciation schedule) and IMHO you cannot really trust
Excel's fractional number format. Please see entry 4 of my Excel
Don'ts:
http://sulprobil.com/html/excel_don_ts.html
I suggest to use the idea of your approach together with my UDF NRN:
http://sulprobil.com/html/nearest_rational_number.html
Regards,
Bernd