Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedCan 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Floyd A. Beams, Joseph H. Anthony, Bruce Bettinghaus, Kenneth Smith

11th Edition

978-0132568968, 9780132568968

More Books

Students also viewed these Accounting questions

Question

What is the correlation between NO. DEGREES and PERFORMANCE RATING?

Answered: 1 week ago