Loans Dartagnan can afford $2100 per month to buy a house. He found a 20-year mortgage with an APR of 4.2%. How much could he borrow with that loan? PMT(1-(-3) P= 38 39 Question: 40 41 42 Formula: 43 44 45 46 Variables: 47 48 49 50 Solution: 51 Excel Formula: Payment PMT rate f number of periods n time (years) Principal How much is D'artagnan paying total for the loan? Total = PMTV Excel Formula: Total for Loan To 53 54 Follow up 55 56 Formula: 57 58 59 Solution: 60 61 62 63 Follow up: 64 65 Formula: 66 67 68 Solution: 69 How much is D'artagnan paying in interest? Interest - Total - Principal Excel Formula: Interest I 106788 Loans Dartagnan can afford $2100 per month to buy a house. He found a 20-year mortgage with an APR of 4.2%. How much could he borrow with that loan? PMT(1-(-3) P= 38 39 Question: 40 41 42 Formula: 43 44 45 46 Variables: 47 48 49 50 Solution: 51 Excel Formula: Payment PMT rate f number of periods n time (years) Principal How much is D'artagnan paying total for the loan? Total = PMTV Excel Formula: Total for Loan To 53 54 Follow up 55 56 Formula: 57 58 59 Solution: 60 61 62 63 Follow up: 64 65 Formula: 66 67 68 Solution: 69 How much is D'artagnan paying in interest? Interest - Total - Principal Excel Formula: Interest I 106788