Question: Whats wrong with the function in D8? Nmin 00 D8 VOX fx =IPMT(D$4,28,D$3*D$2,-B$4) A B D D E F G H 1 Input Area Payment
Whats wrong with the function in D8?
Nmin 00 D8 VOX fx =IPMT(D$4,28,D$3*D$2,-B$4) A B D D E F G H 1 Input Area Payment Dates & Cumulative Interest 2 Equipment Cost $ 25,000.00 # of Months/Year 12 First Payment Date 9/1/2021 3 Down Payment $ 5,000.00 # of Years in Loan 5 Last Payment Date 10/1/2026 4 Amount of the Loan $20,000.00 Loan APR 6.0% Year of Last Payment 5.08 5 Monthly Payment $ 386.66 Monthly Rate 0.5% 6 Beginning Monthly Principal Ending Cumulative Cumulative Pmt # Balance Payment Interest Paid Reduction Balance Principal Yearly Interest 1 $ 20,000.00 $ 386.66 D$3*D$2,-B$4) ! $ 286.66 $ 19,713.34 $ 286.66 9 2 $ 19,713.34 $ 386.66 $ $ 1,197.75 $ 286.66 $ 19,426.69 $ 288.09 10 3 $ 19,426.69 $ 386.66 $ 1,195.36 $ 286.66 $ 19,140.03 $ 289.53 11 4 $ 19,140.03 $ 386.66 $ 1,192.83 $ 286.66 $ 18,853.38 $ 290.98 12 5 $ 18,853.38 $ 386.66 $ 1,190.15 $ 286.66 $ 18,566.72 $ 292.43 13 6 $ 18,566.72 $ 386.66 $ 1,187.31 $ 286.66 $ 18,280.06 $ 293.89 14 7 $ 18,280.06 $ 386.66 $ 1,184.30 $ 286.66 $ 17,993.41 $ 295.36 15 8 $17,993.41 $ 386.66 $ 1,181.11 $ 286.66 $ 17,706.75 $ 296.84 16 9 Function Arguments ? 17 10 18 11 IPMT 19 12 Rate DS4 = 0.06 (1,103.81) 20 13 Per AS 1 = 1 21 14 Nper DS3 DS2 1 = 60 22 15 Py -B$4 = -20000 23 16 FV number 24 17 25 18 = 1200 Returns the interest payment for a given period for an investment, based on periodic, constant payments and a 26 19 constant interest rate. 27 20 Rate is the interest rate per period. For example, use 6%/4 for quarterly 28 21 payments at 6% APR. 29 22 30 23 Formula result. S 1,200.00 31 24 885.71 32 25 Help on this function OK Cancel 33 26 PIZ JOU.UU TUTU.JI ZOU.UU > J24.12 34 27 $ 12,546.94 $ 386.66 $ 1,066.85 $ 286.66 $ 12,260.29 $ 326.35 35 28 $12,260.29 $ 386.66 $ 1,056.61 $ 286.66 $ 11,973.63 $ 327.98 A = UU.,214 > > > IZJ40.34
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
