Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello! I am trying to figure out how to input this into excel but no matter what I try I cannot it correct. Much appreciated
Hello! I am trying to figure out how to input this into excel but no matter what I try I cannot it correct. Much appreciated if I could get some instruction on this
5. Kaleen now wishes to finalize the Amortization schedule In cell 14, create a formula without using a function that subtracts the value in cell I4 from the value in cell H4 to determine how much of the mortgage rincipal is being paid off each year Copy the formula in cell 14 to the range J5:118 6. In cell K4, create a formula using the IF function to calculate the interest aid on the mortgage (or the difference between the total payments made ea and the total amount of mortgage principal paid each year) year a. The formula should first check if the value in cell H4 (the balance remaining on the loan each year) is greater than o b If the value in cell H4 is greater than 0, the formula should return the value in 14 subtracted from the value in cell D5 multiplied by 12. Use a relative cell reference to cell J4 and an absolute cell reference to cell D5. (Hint: Use 12$D$5-4 as the is_true argument value in the formula.) c. If the value in cell H4 is not greater than 0, the formula should return a Copy the formula from cell K4 into the range K5:K18 symbol to the range K4: K18 value of O 7. Apply the Accounting number format with two decimal places and as theStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started