Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 36Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started