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"

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%

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

### 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