Question: Correct the #DIV / O ! errors in the worksheet as follows: ( ) Use Trace Precedents arrows to find the source of the #DIV
Correct the #DIVO errors in the worksheet as follows:
Use Trace Precedents arrows to find the source of the #DIVO error in cell G
b Correct the formula in cell which should divide the remaining principal ce G by the loan amount cell D to find the percentage of remaining princips
c Fill the range H:K with the formula in cell to correct the remaining #DIVO errors.
d Remove any remaining trace arrows.
Now Hwan is ready to calculate the annual principal and interest payments for the startup loan. Start by calculating the cumulative interest payments as follows:
a In cell G enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan for Year payment in cell thro
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
