Question: find formula for interest in column V using if(abs(ipmt function order R s U M7 t x Y z Loan Amortization Table CUSTOMER ID: LE-7679
find formula for interest in column V using if(abs(ipmt function order
R s U M7 t x Y z Loan Amortization Table CUSTOMER ID: LE-7679 month #| interest principal loan balance interest_PCT principal_PCT 7 | \"7 a . . 1 $0.00 $595.56 $30,952.44 15.55% 84.45% Name: Lewis , Charleigh M. 2 $15,871.87 $598.02 $30,354.42 15.25% 84.75% . 3 $10,603.05 $600.49 $29,753.93 14.96% 85.04% Address: 180 West Hill St. 4 $7,968.67 $602.97 $29,150.96 14.66% 85.34% . 5 $6,388.05 $605.47 $28,545.49 14.37% 85.63% Credit Score: 790 6 $5,334.33 $607.97 $27,937.52 14.07% 85.93% 7 $4,581.68 $610.48 $27,327.04 13.77% 86.23% Purchase Price: $36,448 8 $4,017.20 $613.00 $26,714.04 13.47% 86.53% 9 $3,578.18 $615.54 $26,098.50 13.17% 86.83% Percent Down Payment: 13.44% 10 $3,226.96 $618.08 $25,480.41 12.86% 87.14% 11 $2,939.62 $620.64 $24,859.78 12.56% 87.44% Loan Amount: $31,548 12 $2,700.17 $623.20 $24,236.57 12.25% 87.75% 13 $2,497.56 $625.78 $23,610.79 11.94% 88.06% Annual Interest Rate: 14 $2,323.91 $628.37 $22,982.43 11.64% 88.36% . 15 $2,173.42 $630.96 $22,351.47 11.33% 88.67% Term (in years): 4 16 $2,041.74 $633.57 $21,717.90 11.02% 88.98% 17 $1,925.56 $636.19 $21,081.71 10.70% 89.30% Monthly Payment: $838.71 18 $1,822.29 $638.82 $20,442.89 10.39% 89.61% . 19 $1,729.90 $641.46 $19,801.43 10.07% 89.93% Total INTEREST to be paid: $3,297.92 20 $1,646.75 $644.11 $19,157.32 9.76% 90.24% 2 $1,571.53 $646.77 $18,510.54 9.44% 90.56% 22 $1,503.15 $649.45 $17,861.10 9.12% 90.88% 23 $1,440.71 $652.13 $17,208.97 8.80% 91.20% 24 $1,383.49 $654.83 $16,554.14 8.48% 91.52% 25 $1,330.85 $657.53 $15,896.61 8.16% 91.84% 26 $1,282.25 $660.25 $15,236.36 7.83% 92.17% 27 $1,237.27 $662.98 $14,573.38 751% 92.49% 28 $1,195.50 $665.72 $13,907.66 7.18% 92.82% 29 $1,156.61 $668.47 $13,239.19 6.85% 93.15% 30 $1,120.32 $671.23 $12,567.95 6.52% 93.48% 31 $1,086.37 $674.01 $11,893.94 6.19% 93.81% 32 $1,054.54 $676.80 $11,217.15 5.86% 94.14% 33 $1,024.65 $679.59 $10,537.55 5.53% 94.47%Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
