Tableau Dashboard Activity 9-1 Understanding Principal and Interest on Installment Notes Review the Tableau visualization, and...

Transcribed Image Text:

Tableau Dashboard Activity 9-1 Understanding Principal and Interest on Installment Notes Review the Tableau visualization, and then answer the questions that follow. Term 60 Months 120 Months Annual Rate 4% 8% 12% Monthly Payment Schedule $2,000.00 $1,500.00 Payment Payment Interest Principal Balance: $0.00 $0.00 $0.00 $100,000.00 $1,000.00 1 $1,841.65 $333 33 $1,508 32 $90,491.68 2 $1,841.65 $328 31 $1,513 35 $96,978 33 3 $1,841 65 $323.26 $1,518 39 $95,459 94 4 $1,841.65 $318.201 $1,523.45 $93,936 49 $500.00 5 $1,841 65 $313.12 $1,528 53 $92,407 96 6 $1,041 65 $308.03 $1,533.63 $90,874.33 7 $1,841.65 $302.91 $1,538.74 $89,335 60 $0.00 8 $1,841.65 $297.79 $1,543.87 $87,791 73 9 $1,841 65 $292.64 $1,549.01 $86,242 72 10 $1,84165 $287.48 $1,554 18 $84,688 54 11 $1,841.65 $282.30 $1,559.36 $83,129 18 12 $1,841.65 $277.10 $1,564 55 $81,564.63 13 $1,841.65 $271.88 $1,569.77 $79.994.66 14 $1,841.65 $266.65 $1,575.00 $78,419 86 $2,000.00 15 $1,841.65 $261.40 $1,580 25 $76,839.60 Total Interest and Principal Paid $1,500 00 $100,000 00 $1,000.00 $500.00 Principal Portion of Each Payment 1 4 7 10 13 16 19.22 25 20 31 34 37 40 43 46 49 52 55 58 Payment#: 1 Principal $1,508.32 of Each Payment $10,499.13 $0.00 Interest Principal 147 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58 +ableau Tableau Dashboard Activity 9-1 Understanding Principal and Interest on Installment Notes Review the Tableau visualization, and then answer the questions that follow. Term 60 Months 120 Months Annual Rate 4% 8% 12% Monthly Payment Schedule $2,000.00 $1,500.00 Payment Payment Interest Principal Balance: $0.00 $0.00 $0.00 $100,000.00 $1,000.00 1 $1,841.65 $333 33 $1,508 32 $90,491.68 2 $1,841.65 $328 31 $1,513 35 $96,978 33 3 $1,841 65 $323.26 $1,518 39 $95,459 94 4 $1,841.65 $318.201 $1,523.45 $93,936 49 $500.00 5 $1,841 65 $313.12 $1,528 53 $92,407 96 6 $1,041 65 $308.03 $1,533.63 $90,874.33 7 $1,841.65 $302.91 $1,538.74 $89,335 60 $0.00 8 $1,841.65 $297.79 $1,543.87 $87,791 73 9 $1,841 65 $292.64 $1,549.01 $86,242 72 10 $1,84165 $287.48 $1,554 18 $84,688 54 11 $1,841.65 $282.30 $1,559.36 $83,129 18 12 $1,841.65 $277.10 $1,564 55 $81,564.63 13 $1,841.65 $271.88 $1,569.77 $79.994.66 14 $1,841.65 $266.65 $1,575.00 $78,419 86 $2,000.00 15 $1,841.65 $261.40 $1,580 25 $76,839.60 Total Interest and Principal Paid $1,500 00 $100,000 00 $1,000.00 $500.00 Principal Portion of Each Payment 1 4 7 10 13 16 19.22 25 20 31 34 37 40 43 46 49 52 55 58 Payment#: 1 Principal $1,508.32 of Each Payment $10,499.13 $0.00 Interest Principal 147 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58 +ableau