Question: Can someone help me check my answer is correct or wrong, if wrong help me solve this problem thank u. B13 X =PMT(B10/12,39*12,811,0,0) G H
Can someone help me check my answer is correct or wrong, if wrong help me solve this problem thank u.
B13 X =PMT(B10/12,39*12,811,0,0) G H 1 J K 1 M N o P R S T U . B E F 1 Loan Repayment 2 10 Points 3 4 Write formulas in the yellow cells to determine interest and payment amounts. Use the PMT and PPMT functions we learned in class. 5 Enter formluas in cells B13:C15 6 7 Bank Loans 8 US Bank Chase Bank 9 Amortization (years) 6 3 10 Interest Rate (annual rate) 2.75% 4.25% 11 Loan Amount $ 300,000 $ 300,000 12 13 Monthly Payment ($4,524.63) ($8,890.60) 14 Principal Payment for the fourth month S (3,863.57) $ (7,911.57) 15 Total Amount of Loan to be paid Back $ (325,773.16) $ (320,061.52) 16 17 Which loan is better and why? I think the loans provided by these two banks have their own characteristics. The first is US Bank, which has a longer repayment period, so the total price that needs to be paid in the end will be higher than that of Chase Bank, but he needs to repay each month. Compared to Chase Bank, it is nearly half less. This is a good choice for groups with low monthly income. In summary, I personally prefer US Bank loans. Choosing them allows me to The economic pressure of the month is much smaller. 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
