Question

1 Approved Answer

Posted on Jul 26, 2024

if possible i need a link for both of these to where i can copy and paste, because I have forgotten how to auto solve

if possible i need a link for both of these to where i can copy and paste, because I have forgotten how to auto solve on excel, that is once i have put in the variables and etc. it would mean a lot and save me hours from typing.

G 3 A 1 MSRP $ 28,745.00 Total Interest Paid $ 2.159.21 2 Down Payment $ 2,874.50 Total Principal Paid $25,870.50 3 Principal $ 25,870.50 4 Annual interest Rate 3.20 5 Months 60 6 Payment 5467.16 Principal 7 Month Balance it-1) interest Pald Payment Balance 1 $ 25,870.50 $ 68.99 $ 398.17 $467.36 $25,472.33 9 2 $ 25,472.33 $ 67,93 $ 399.24 $467.16 $25,073.09 10 1 $ 25,071,09 $ 66.865 400.30 $467.16 $24,672.79 11 4 $ 24,672.79 565.79 5 401.37 $467.16 $24.271.42 53 24271.42 S 64.72 5402.44 $467.16 523,868.98 6 $ 21,868.98 $ 63.65 5 403.51 $467.16 $21,465.47 7 5 23,465.47 $ 62.57 $ 404.59 $467.16 $23,060.89 15 # $ 23,060.19 5 61.50 $ 405.67 $467.16 $22,655.22 16 9 5 22,655.22 $ 60.41 5 406.75 5467.16 $22,248.47 17 10 $ 22,248.47 $ 59.33 $ 407.80 $467.16 $21,840.64 18 11 $ 21,840.64 $ 58.24 5 408.92 $467.16 521,431.72 12 5 21.431.72 $ 57.15 $ 410.01 $467.16 $21.021.71 20 13 $ 21,021.71 $ 56,06 $ 411.10 $467.16 $20,610.60 14 5 20.610.60 $ 54.965 412.20 $467.16 520,198.40 22 15 S 20,198.40 $ 53.86 $ 413.30 $467.16 $19,785.10 16 $ 19,785.10 $ 52.76 $ 414.40 $467.16 $19,370,70 24 17 $ 19,370.70 5 51.66 $415.51 $467.16 $18,955.20 25 18 S 18,955.20 $ 50.55 $ 416.61 $467.16 $18,538.58 25 19 5 18,538.58 $ 49.44 $ 417.73 $467.16 518,120.86 27 20 5 18,120.86 5 48 32 5418.84 5467.16 517,702.02 LAN Sheet1 Sheet2 Sher Sheet Homeburt Page Layout Formules Dute Tell me what you want to do 161 41 42 13 44 45 45 47 45 49 So 51 52 53 54 55 56 57 58 32 $ 13,020,41 $ 34.72 S 432.44 $467.16 $12.587.97 33 $ 12,587.97 $ 2257 S 433 59 $467.16 $12,154.37 34 S 12,154.37 5 12.41 5434,75 5467.16 $11,719.62 35 S 11,719.62 5 31.255 435.91 $467.16 511,283.71 36 5 11,283.71 $ 30.095 437.07 $467.16 $10,846.64 37 5 10,546,64 5 28925 438.24 $467.16 510,408.40 38 $ 10,408.40 5 27.76 $ 439.41 $467.16 $ 9,969.00 19 $ 9,969.00 $ 26.58 S 440.58 $467.16 $9,528.42 40 59,528.42 $ 25.41 5 441.75 5467.16 5 9,086.67 41 $ 9,086.67 $ 24.23 $ 442.93 $467.16 $ 8,643.73 42 $ 8,643.73 $ 23.05 $ 444.11 $467.16 $ 8,199.62 41 $ 8,199.62 S 21.87 $ 445.30 $467.16 5 7,754.33 44 5 7.754.33 $ 20.68 $ 446.48 $467.16 $ 7,307.84 45 $ 7,307.84 $ 19.49 $ 447.67 $467.16 $ 6,960.17 46 5 6.160.17 5 18.29 5 448.87 5467.16 5 6411.30 47 $ 6,411.30 5 17.10 $ 450.07 $467.16 5 5,961.24 45 5 5,961,24 5 15.90$ 45127 5467.16 5 5,509.97 49 5 5,509.97 5 14.69 5 452.47 $467.16 5 5,057.50 50 5 5.057.50 5 11.49 5 453.68 $467.16 5 4,601.83 51 $ 4,603.83 $ 12.28 5 454.89 $467.16 $4,148.94 52 5. 4,148.54 5 11.06 5 456.10 $467.16 $ 3,692.84 $ a 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 1 5 25,870.50 $ 68.99 S 38.17 5467.16 $25,472.33 2 5 25,472.33 $ 67.99 $ 199.24 $467.16 $25,073.09 35 25,073.09 5 66.86 5 100.10 $467.16 524,572.79 4 $ 24,672.79 $ 65,795 101.37 $467.16 $24,271.42 5 5 24,271.42 $ 64.72 $ 402.44 $467.16 523,168.98 6 $ 23,168,98 $ 63.65 $ 403.51 $467.16 $23,465.47 7 5 23,465.47 $ 62.575 404.59 $46716 523,060.89 & S 23,060.89 $61.50 S 405.67 $467.16 $22,655.22 9 $ 22,655.22 $ 60.41 5 106.75 $467.16 $22,248.47 10 S 22,248.47 $ 59.33 $ 407.835467.16 $21,840.64 11 $ 21,840.64 $ 58.24 5 4892 $467.16 $21.431.72 12 5 21431.72 5 57.15 S 410.01 $467.16 $21,021.71 13 $ 21,021.71 556.06 S 411.10 $467.16 $20,610.60 14 S 20,610.60 $ 54.96 $ 412.20 $467.16 $20,198.40 15 5 20,198.40 5 53.865 412.10 $467.16 519,785.10 16 S 19,785.10 $ 52.76 $ 434.40 $467.16 $ 19,370.70 17 $ 19,370.70 $ 51.66 $ 415.51 $467.16 $ 18,955 20 18 S 18,955.20 5 50.555 416.61 $467.16 $18,538.58 19 $ 18,538.88 $ 49.44 $ 417.73 $467.16 $18,120.86 20 $ 18,120.86 5 48.325 418.84 5467.16 $17,702.02 AM Sheet1 Sheet2 Sheet Sheet Book File Home Inert Page Layout Formules Dute Review you want to do 161 G 39 40 41 42 41 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 A 3 C D E 32 $ 13,020.41 $ 34.72 5432.44 $467.16 $12,587.97 33 5 12,587.97 33.57 $ 433.59 $467.16 $12,154 37 34 S 12,154,37 $ 32.43S 434.75 $467.16 $11,719.62 35 S 11,719.62 5 31.25 5 435.91 5467.16 $11,283.71 36 S 11,288.71 $ 30.095 437.07 $467.16 $10,846.64 27 S 10,846.54 $26.92 438.24 $457.16 $10,408.40 38 S 10,408.40 S 27.76 S 429.41 $467.16 $ 9,900.00 39 $ 9,969.00 $ 2658 4408 5457.16 5 9,528.42 40 5 9,528.42 $ 25.41 S 441.75 $467.16 S 9,086.67 41 $ 9,086.67 $ 24.235 442.93 $467.16 $ 8,543.73 42 S 8,643.73 5 23.05$ 44411 5467.16 $ 8,199.62 43 5 8,199.62 5 21.87 S 445.30 $467.16 5 7,754.33 44 S 7,754.33 $ 20.68 5 446 48 5467.16 S 7,307.84 45 $ 7,807.84 $ 19.495 467.67 $467.16 56,86017 46 S 6,860.17 5 36.295 ALS 37 $467.16 $ 6,411.30 47 $ 6411.30 $ 17.10 $ 450.07 $467.16 $ 5,96124 48 5 5,961.24 $ 15.90 S 451.27 $467.16 5 5,509.97 49 5 5,509.97 $ 14,69 S 452.47 $467.16 S 5,057.50 50 5 5,057.50 5 11.49 5 453.68 $467.16 5 4,603.83 51 5 4,603.83 5 12.28 5 454.89 $467.16 5 4,148.94 52 $ 4,148.94 $ 1106 S 456.10 $467.16 $ 3,692.84 53 S 1,692.84 5 9.85$ 457.31 $467.16 $ 3.235.53 54 $ 3.235.53 $ 8.63 452 53 5467.16 5 2,777.00 55 5 2,777.00 $ 7.41 5 459.76 5467.16 5 2,317.24 56 5 2,317.24 6 618 5 460.98 $467.15 S 1,856.26 57 1,856.26 $ 4.95 S 162.21 $467.16 $ 1,394.04 5 $ 1,394.04 $ 3.72 $ 463.44 $467.16 S 930.60 59 $ 930.60 $ 2.48 $ 464.68 $467.16 $ 465.92 ATA Sheet1 Sheet2 Shera Sheet + 35333336 PE O a D 1 MSRP $ 28,745.00 Total Interest Pald $ 2.159.21 2 Down Payment $ 2,874.50 Total Principal Paid $ 25,870.50 3 Principal $ 2570.50 4 Annual interest Rate 1.20% 5 Months 60 6 Payment $467.16 Principal 7 Month Balance it 1) Interest Paid Payment Balance 8 1 5 25,870.50 $ 68.995 198.17 $467.16 $25,472.13 9 2 $ 25,472 31 5 67.91 S 199.24 $467.16 $ 25,073.00 0 3 $ 25,073.00 $ 66.86 S 400.30 $467.16 $24,672.79 1 4 $ 24,672.79 $ 65,795 101.37 $467.16 $24.27142 2 5 $ 24,271.42 $ 64.72 $ 402.44 $467.16 $23,868.98 3 6 $ 21,868.08 $63.65 $ 403.51 $467.16 $23,465.47 54 7 $ 23,465.47 5 62.57 $ 404.59 $467.16 $23,060.89 15 8 $ 23,060.89 561.50 $ 405.67 $467.16 $22,655 22 6 9 $ 22,655.22 $ 60.41 $ 406.75 $467.16 $22,248.47 17 10 $ 22,248.47 $59.33 $ 407.83 $467.16 $21,340.64 15 11 $ 21,140.645 58.24 5 408.92 $46716 521,431.72 12 S 21.431.72 $ 57.15 $ 410.01 $467.16 $21,021.71 20 13 $ 21,021,71 5 56,065 411.10 $467.16 $20,610,60 21 14 $ 20,610.60 5 54.96 $ 412.20 $467.16 $20,198.40 22 15 5 20,198.40 5 51.865 413.30 $467.16 $19,785.10 23 16 5 19,785.10 $ 52.76 S 414.40 $467.16 $19,370.70 24 17 $ 19,370.70 $ 51.66 $ 415.51 $467.16 518,955.20 es 18 $ 18,955 20 $ 50.55 5 416,61 $467.16 $18,538.58 26 19 S 18,538.58 $ 49.44 $ 417.73 $467.16 $18,120.86 27 20 $ 13, 120.865 48.32 S 418.84 5467.16 $17,702.02 WA AN G 3 A 1 MSRP $ 28,745.00 Total Interest Paid $ 2.159.21 2 Down Payment $ 2,874.50 Total Principal Paid $25,870.50 3 Principal $ 25,870.50 4 Annual interest Rate 3.20 5 Months 60 6 Payment 5467.16 Principal 7 Month Balance it-1) interest Pald Payment Balance 1 $ 25,870.50 $ 68.99 $ 398.17 $467.36 $25,472.33 9 2 $ 25,472.33 $ 67,93 $ 399.24 $467.16 $25,073.09 10 1 $ 25,071,09 $ 66.865 400.30 $467.16 $24,672.79 11 4 $ 24,672.79 565.79 5 401.37 $467.16 $24.271.42 53 24271.42 S 64.72 5402.44 $467.16 523,868.98 6 $ 21,868.98 $ 63.65 5 403.51 $467.16 $21,465.47 7 5 23,465.47 $ 62.57 $ 404.59 $467.16 $23,060.89 15 # $ 23,060.19 5 61.50 $ 405.67 $467.16 $22,655.22 16 9 5 22,655.22 $ 60.41 5 406.75 5467.16 $22,248.47 17 10 $ 22,248.47 $ 59.33 $ 407.80 $467.16 $21,840.64 18 11 $ 21,840.64 $ 58.24 5 408.92 $467.16 521,431.72 12 5 21.431.72 $ 57.15 $ 410.01 $467.16 $21.021.71 20 13 $ 21,021.71 $ 56,06 $ 411.10 $467.16 $20,610.60 14 5 20.610.60 $ 54.965 412.20 $467.16 520,198.40 22 15 S 20,198.40 $ 53.86 $ 413.30 $467.16 $19,785.10 16 $ 19,785.10 $ 52.76 $ 414.40 $467.16 $19,370,70 24 17 $ 19,370.70 5 51.66 $415.51 $467.16 $18,955.20 25 18 S 18,955.20 $ 50.55 $ 416.61 $467.16 $18,538.58 25 19 5 18,538.58 $ 49.44 $ 417.73 $467.16 518,120.86 27 20 5 18,120.86 5 48 32 5418.84 5467.16 517,702.02 LAN Sheet1 Sheet2 Sher Sheet Homeburt Page Layout Formules Dute Tell me what you want to do 161 41 42 13 44 45 45 47 45 49 So 51 52 53 54 55 56 57 58 32 $ 13,020,41 $ 34.72 S 432.44 $467.16 $12.587.97 33 $ 12,587.97 $ 2257 S 433 59 $467.16 $12,154.37 34 S 12,154.37 5 12.41 5434,75 5467.16 $11,719.62 35 S 11,719.62 5 31.255 435.91 $467.16 511,283.71 36 5 11,283.71 $ 30.095 437.07 $467.16 $10,846.64 37 5 10,546,64 5 28925 438.24 $467.16 510,408.40 38 $ 10,408.40 5 27.76 $ 439.41 $467.16 $ 9,969.00 19 $ 9,969.00 $ 26.58 S 440.58 $467.16 $9,528.42 40 59,528.42 $ 25.41 5 441.75 5467.16 5 9,086.67 41 $ 9,086.67 $ 24.23 $ 442.93 $467.16 $ 8,643.73 42 $ 8,643.73 $ 23.05 $ 444.11 $467.16 $ 8,199.62 41 $ 8,199.62 S 21.87 $ 445.30 $467.16 5 7,754.33 44 5 7.754.33 $ 20.68 $ 446.48 $467.16 $ 7,307.84 45 $ 7,307.84 $ 19.49 $ 447.67 $467.16 $ 6,960.17 46 5 6.160.17 5 18.29 5 448.87 5467.16 5 6411.30 47 $ 6,411.30 5 17.10 $ 450.07 $467.16 5 5,961.24 45 5 5,961,24 5 15.90$ 45127 5467.16 5 5,509.97 49 5 5,509.97 5 14.69 5 452.47 $467.16 5 5,057.50 50 5 5.057.50 5 11.49 5 453.68 $467.16 5 4,601.83 51 $ 4,603.83 $ 12.28 5 454.89 $467.16 $4,148.94 52 5. 4,148.54 5 11.06 5 456.10 $467.16 $ 3,692.84 $ a 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 1 5 25,870.50 $ 68.99 S 38.17 5467.16 $25,472.33 2 5 25,472.33 $ 67.99 $ 199.24 $467.16 $25,073.09 35 25,073.09 5 66.86 5 100.10 $467.16 524,572.79 4 $ 24,672.79 $ 65,795 101.37 $467.16 $24,271.42 5 5 24,271.42 $ 64.72 $ 402.44 $467.16 523,168.98 6 $ 23,168,98 $ 63.65 $ 403.51 $467.16 $23,465.47 7 5 23,465.47 $ 62.575 404.59 $46716 523,060.89 & S 23,060.89 $61.50 S 405.67 $467.16 $22,655.22 9 $ 22,655.22 $ 60.41 5 106.75 $467.16 $22,248.47 10 S 22,248.47 $ 59.33 $ 407.835467.16 $21,840.64 11 $ 21,840.64 $ 58.24 5 4892 $467.16 $21.431.72 12 5 21431.72 5 57.15 S 410.01 $467.16 $21,021.71 13 $ 21,021.71 556.06 S 411.10 $467.16 $20,610.60 14 S 20,610.60 $ 54.96 $ 412.20 $467.16 $20,198.40 15 5 20,198.40 5 53.865 412.10 $467.16 519,785.10 16 S 19,785.10 $ 52.76 $ 434.40 $467.16 $ 19,370.70 17 $ 19,370.70 $ 51.66 $ 415.51 $467.16 $ 18,955 20 18 S 18,955.20 5 50.555 416.61 $467.16 $18,538.58 19 $ 18,538.88 $ 49.44 $ 417.73 $467.16 $18,120.86 20 $ 18,120.86 5 48.325 418.84 5467.16 $17,702.02 AM Sheet1 Sheet2 Sheet Sheet Book File Home Inert Page Layout Formules Dute Review you want to do 161 G 39 40 41 42 41 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 A 3 C D E 32 $ 13,020.41 $ 34.72 5432.44 $467.16 $12,587.97 33 5 12,587.97 33.57 $ 433.59 $467.16 $12,154 37 34 S 12,154,37 $ 32.43S 434.75 $467.16 $11,719.62 35 S 11,719.62 5 31.25 5 435.91 5467.16 $11,283.71 36 S 11,288.71 $ 30.095 437.07 $467.16 $10,846.64 27 S 10,846.54 $26.92 438.24 $457.16 $10,408.40 38 S 10,408.40 S 27.76 S 429.41 $467.16 $ 9,900.00 39 $ 9,969.00 $ 2658 4408 5457.16 5 9,528.42 40 5 9,528.42 $ 25.41 S 441.75 $467.16 S 9,086.67 41 $ 9,086.67 $ 24.235 442.93 $467.16 $ 8,543.73 42 S 8,643.73 5 23.05$ 44411 5467.16 $ 8,199.62 43 5 8,199.62 5 21.87 S 445.30 $467.16 5 7,754.33 44 S 7,754.33 $ 20.68 5 446 48 5467.16 S 7,307.84 45 $ 7,807.84 $ 19.495 467.67 $467.16 56,86017 46 S 6,860.17 5 36.295 ALS 37 $467.16 $ 6,411.30 47 $ 6411.30 $ 17.10 $ 450.07 $467.16 $ 5,96124 48 5 5,961.24 $ 15.90 S 451.27 $467.16 5 5,509.97 49 5 5,509.97 $ 14,69 S 452.47 $467.16 S 5,057.50 50 5 5,057.50 5 11.49 5 453.68 $467.16 5 4,603.83 51 5 4,603.83 5 12.28 5 454.89 $467.16 5 4,148.94 52 $ 4,148.94 $ 1106 S 456.10 $467.16 $ 3,692.84 53 S 1,692.84 5 9.85$ 457.31 $467.16 $ 3.235.53 54 $ 3.235.53 $ 8.63 452 53 5467.16 5 2,777.00 55 5 2,777.00 $ 7.41 5 459.76 5467.16 5 2,317.24 56 5 2,317.24 6 618 5 460.98 $467.15 S 1,856.26 57 1,856.26 $ 4.95 S 162.21 $467.16 $ 1,394.04 5 $ 1,394.04 $ 3.72 $ 463.44 $467.16 S 930.60 59 $ 930.60 $ 2.48 $ 464.68 $467.16 $ 465.92 ATA Sheet1 Sheet2 Shera Sheet + 35333336 PE O a D 1 MSRP $ 28,745.00 Total Interest Pald $ 2.159.21 2 Down Payment $ 2,874.50 Total Principal Paid $ 25,870.50 3 Principal $ 2570.50 4 Annual interest Rate 1.20% 5 Months 60 6 Payment $467.16 Principal 7 Month Balance it 1) Interest Paid Payment Balance 8 1 5 25,870.50 $ 68.995 198.17 $467.16 $25,472.13 9 2 $ 25,472 31 5 67.91 S 199.24 $467.16 $ 25,073.00 0 3 $ 25,073.00 $ 66.86 S 400.30 $467.16 $24,672.79 1 4 $ 24,672.79 $ 65,795 101.37 $467.16 $24.27142 2 5 $ 24,271.42 $ 64.72 $ 402.44 $467.16 $23,868.98 3 6 $ 21,868.08 $63.65 $ 403.51 $467.16 $23,465.47 54 7 $ 23,465.47 5 62.57 $ 404.59 $467.16 $23,060.89 15 8 $ 23,060.89 561.50 $ 405.67 $467.16 $22,655 22 6 9 $ 22,655.22 $ 60.41 $ 406.75 $467.16 $22,248.47 17 10 $ 22,248.47 $59.33 $ 407.83 $467.16 $21,340.64 15 11 $ 21,140.645 58.24 5 408.92 $46716 521,431.72 12 S 21.431.72 $ 57.15 $ 410.01 $467.16 $21,021.71 20 13 $ 21,021,71 5 56,065 411.10 $467.16 $20,610,60 21 14 $ 20,610.60 5 54.96 $ 412.20 $467.16 $20,198.40 22 15 5 20,198.40 5 51.865 413.30 $467.16 $19,785.10 23 16 5 19,785.10 $ 52.76 S 414.40 $467.16 $19,370.70 24 17 $ 19,370.70 $ 51.66 $ 415.51 $467.16 518,955.20 es 18 $ 18,955 20 $ 50.55 5 416,61 $467.16 $18,538.58 26 19 S 18,538.58 $ 49.44 $ 417.73 $467.16 $18,120.86 27 20 $ 13, 120.865 48.32 S 418.84 5467.16 $17,702.02 WA AN