![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 02.12.2021 16:30 oliup567
Now Elena asks you to calculate the annual principal and interest payments for the airport shuttle service expansion. Go to the Loan Details worksheet. In cell B9, enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year 1 (payment 1 in cell B7 through payment 4 in cell B8). Use 0as the type argument in your formula because payments are made at the start of the period. Use absolute references for the rate, nper, and pv arguments, which are listed in the range A3:G3. Use relative references for the start and end arguments. Fill the range C9:F9 with the formula in cell B9 to calculate the principal paid in Years 2–5 and the total principal. In cell B10, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan for Year 1 (payment 1 in cell B7 through payment 4 in cell B8). Use 0 as the type argument. Use absolute references for the rate, nper, and pv arguments, and use relative references for the start
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 13:30, mads000
Drag the tiles to the correct boxes to complete the pairs. match the errors with their definitions. #name #value #ref when a formula produces output that is too lengthy to fit in the spreadsheet cell arrowright when you enter an invalid cell reference in a formula arrowright when you type text in cells that accept numeric data arrowright when you type in a cell reference that doesn’t exist arrowright reset next
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 24.06.2019 02:20, isabelsmhl
Peter is thinking of a number which isless than 50. the number has 9 factors. when he adds 4 to the number, itbecomes a multiple of 5. what is thenumber he is thinking of ?
Answers: 1
You know the right answer?
Now Elena asks you to calculate the annual principal and interest payments for the airport shuttle s...
Questions in other subjects:
![Konu](/tpl/images/cats/health.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 24.06.2019 01:00
![Konu](/tpl/images/cats/ekonomika.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 24.06.2019 01:00
![Konu](/tpl/images/cats/mat.png)
Mathematics, 24.06.2019 01:00
![Konu](/tpl/images/cats/en.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 24.06.2019 01:00
![Konu](/tpl/images/cats/mat.png)
Mathematics, 24.06.2019 01:00
![Konu](/tpl/images/cats/mat.png)
Mathematics, 24.06.2019 01:00