C D 1 LOAN ANALYSIS Can Pam and Jim afford the monthly payments required to purchase a house if they were to take a loan from a bank? Complete colls F10:10 using the PMT function 30 Year $ 2,400 $ 1.200 $ 3,600 $ 15 Year 2.400 1.200 3.600 Loan Conditions Loon Amount Length of Loan Annual Interest Rate $ 30 Year 150,000.00 $ 30 4,65% 15 Year 150,000.00 15 3.88% Monthly Payment Income Parm Jim 9. Total 10 11 Expenses 12 Rent 13 Food 14 Ulises 15 Phone 16 Loan Payments 17 Car Payments Insurance 19 Miscellaneous 20 Entertainment 21 Tuition 22 Books 21 Total 14 as Net Income $0.00 800 235 78 150 175 50 171 179 350 91 $ 2.279 $ $0.00 800 235 78 150 175 50 171 179 350 91 2279 S29215 1,321 2