Solved by Expert Tutors
Solved by Expert Tutors
Question

I need help with this and pls post the formula that you have used for it. not sure hwat subject this would go under so I just put "computer science"

118733503_965910700578489_2278621545139138622_n.png

118733503_965910700578489_2278621545139138622_n.png
r24 ' 5 )5. v A A | B | C I D I E I F I G I H I | | J I K | L I M I N _ (13(2 point 1- 1 bonus point): Use the following table to answer the questions below the table L
2
{The formula in C14 is -PMT[Bl4/12. C13. F9). 4 The PMTlinterest rate. number of payments. loan amount} formula calculates the monthly payments required for a loan.
57 [Note that 314 is divided by 12 in the formula in order to convert the annual interest rate to a monthly rate). E T— 3_ L Car Loan Amount $28,000 10 1T Monthly Payment 12 Interest Rate Loan Term (Months) 13— (Annual) 36 48 60 1'2 Annual Interest Rate 3.5%
1: 2.5% $808.12 Loan Term 48
1i 3.0% Monthly Payment 16 3.5% Bonus Question 17 4.0% 1E 4.5% 11 5.0% 2D 21 (13a (1 point): Adiust the relative and absolute addressing on 314, C13. and F9 directly in the formula in C14 so that it can be filled down and to the right.
22 while still correctly referring to the interest rate, loan term, and loan amount appropriate to that row and column.
23 Then fill out the rest of the table by using fill down and fill right to copy the formula in C14 to the rest of the table. E |:I 25 (13b (1 point): Use index function and match functions to build a monthly payment lookup tool in cell us for the Annual Interest Rate in cell In and the Loan Term in cell l14. 27' (13c (bonus 1 point): Build the same lookup tool as (13b. but use vlookup and match functions instead. Ready El JJ — 447 + 130%

Step-by-step answer


ng elit. N

gue

inia pulvinar tortor nec fa

gue

gue

molestie


et, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec


lestie consequat, ultrices ac magna. Fusce dui lectus, congue

gue

risus ante

m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia


consectetur adipiscing elit. Nam lacinia pulvinar to

Subscribe to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Computer Science tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes