Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please confirm if I did 4-8 right. Then I need help doing 9 and 10 please. 4. In the range 08:09, calculate the total number
Please confirm if I did 4-8 right. Then I need help doing 9 and 10 please.
4. In the range 08:09, calculate the total number of months to repay the loan and the interest rate per month. 5. In cell 011, use the PMT function to calculate the monthly payment.Multiply the PMT function by -1 so that the result appears as a positive currency value rather than a negative value 6. In the range D25:025, enter the value of the monthly mortgage payment by creating an absolute reference to the value in cell 011 7. In the range D18:018, calculate the total income per month. In the range D27:027, calculate the total expenses incurred each month. In the range D28:028, calculate the couple's net income total income minus total expenses) each month. 8. In the range C4:C11, calculate the average monthly value of each expense categony 9. Add green gradient data bars to the values in the range C4:C11. Set the maximum length of the data bars to a value of 2500. 10. Insert line sparklines in the range D4:D11 using the expense values in the range D19:026. On the SPARKLINE TOOLS DESIGN tab, in the Show group, click the High Point check box to mark the high point of each sparklineStep 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