Two-Car Magic Formula
Step 1. Examine the chart at the bottom to see the results in this example.
Step 2. Enter both your before and after data below, then examine the chart.
Step 3. Ignore error messages until you complete your input of data
The way you are--the BEFORE column -- enter the following:
	Vehicle 1	Vehicle 2
Business miles per year
Total miles per year
Cost/value of vehicle
Estimated selling price
The way you could be--the AFTER column--enter the following:
Business miles per year--vehicle 2
Total miles per year for vehicle 2
Estimated selling price vehicle 1
Estimated selling price vehicle 2
	Before		After
	Vehicle 1	Vehicle 2	Vehicle 1	Vehicle 2
Business miles
Total miles
Business %
Cost/value of vehicle
Estimated selling price
Loss in value
Tax Deductions
Totals
Results--the winner is
Dollar amount
Percentage			Copyright 2011 W. Murray Bradford, CPA