Question: In cell B 1 0 , enter a formula using the CUMIPMT function to calculate the cumulative Interest pald on the loas for Year 1
In cell B enter a formula using the CUMIPMT function to calculate the cumulative Interest pald on the loas for Year payment In cell B through payment in cell B Use as the type argument. Use absolute references for the rate, nper, and pv arguments, and use relative references for the start and end arguments. Fill the range C:F with the formula in cell B to calculate the interest paid In Years and the total interest.
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
