LS e Properties Refresh All Stocks Currencies Workbook Links ata (Power uery) xfx B NA AZ Sort Filter Reapply Advanced C D E F G H. J K L Grossman Automative Text to Columns $500.00 $5,000.00 $10,000.00 $15,000.00 Input Purchase Price Down Payment Tax Monthly Pmt Purchase Price $ 36,297.11 20,000.00 2,000 1,400 276 20,000.00 Sales Tax Down Payment 7% 25,000.00 2,500 1,750 344 25,000.00 10% 30,000.00 3,000 2,100 413 30,000.00 Months Financed 72 35,000.00 3,500 2,450 482 35,000.00 APR 3.25% 40,000.00 4,000 2,800 551 40,000.00 45,000.00 4,500 3,150 620 45,000.00 Output 50,000.00 5,000 3,500 689 50,000.00 Down Payment Amount $ 3,629.71 55,000.00 5,500 3,850 758 55,000.00 Amount Financed $ 32,667.40 60,000.00 6,000 4,200 827 60,000.00 Tax Owed $ 2,540.80 65,000.00 6,500 4,550 895 65,000.00 Monthly Payment $500.00 70,000.00 7,000 4,900 964 70,000.00 75,000.00 7,500 5,250 1,033 75,000.00 Finance Worksheet Range Names +