I think there is minor error. I'll be glad if you can clarify please. Why do we have to take into consideration the current price or MSRP? I mean, if I want to buy 2007 axio which at the time of purchase costed around $18,000K but now costs around $10,000K, would we still consider the original price for calculating taxes. Secondly, in final cell (D34) you have inserted equation as = D32+D6*D24, now this portion is bit errd I guess (only in my opinion) as total price in Pakistan would be taxes+ whatever price the vehicle is bought abroad and not the vehicles original price e.g. if I have bought Toyota Axio few months back for say AED 25,000(PKR 600,000) the final price should be (taxes, say PKR 1,000,000)+ (PKR 600,000) and not like (taxes PKR 1,000,000) + (vehicles original price i.e. $18,000K). Please reply if you understand what am trying to say.
Regards,