I bid on vehicle auctions and I would like to input some figures before the auction so I have a detailed financial report on the vehicle i am bidding on. There are some fixed or known numbers involved: Vat on purchase price : buyers commision on purchase price : document handling fee, which is fixed but also Vatable.
I also know the Trade and retail values of the vehicle. So I would like to know what amount I can bid up to, when added to the auction costs, amount to the trade value. So working out the costs backwards from a price which I can sell the vehicle for.
I would also like to be able to automaticall copy vehicle descriptions from wesbank which I have in a table form.
I have a feeling a pivot table is involved.
Does this make sense? I can send you what I have done in excel to give you a better understanding, but I know the formulas are wrong.
15 freelancers are bidding on average R1396 for this job
I am an Excel expert and can create an easy-to-use template as per your requirement. Relevant Skills and Experience Excel Proposed Milestones R1088 ZAR - default