Amount financed = 240,000 - 91,088 = $148,912. This is Pv. Nper = 15 years*12 =...

60.1K

Verified Solution

Question

Finance

Amount financed = 240,000 - 91,088 = $148,912. This is Pv. Nper= 15 years*12 = 180 and rate = 4.5%/12 Amount paid each month =PMT(4.5%/12, 180, -148912) = 1139.07 The amortization table isshown below: Payment no. Loan balance at the start of the monthAmount of payment Interest Principal paid Loan balance at the endof the month find from payment # 10-100.
Payment no. Loan balance at the start of the month Amount of payment Interest Principal paid Loan balance at the end of the month
1                 148,912.00                         1,139.17      558.42               580.75         148,331.25
2                 148,331.25                         1,139.17      556.24               582.92         147,748.33
3                 147,748.33                         1,139.17      554.06               585.11         147,163.22
4                 147,163.22                         1,139.17      551.86               587.30         146,575.91
5                 146,575.91                         1,139.17      549.66               589.51         145,986.41
6                 145,986.41                         1,139.17      547.45               591.72         145,394.69
7                 145,394.69                         1,139.17      545.23               593.94         144,800.75
8                 144,800.75                         1,139.17      543.00               596.16         144,204.59
9                 144,204.59                         1,139.17      540.77               598.40         143,606.19
10                 143,606.19                         1,139.17      538.52               600.64         143,005.54
160                    22,963.44                         1,139.17         86.11           1,053.05            21,910.39
161                    21,910.39                         1,139.17         82.16           1,057.00            20,853.39
162                    20,853.39                         1,139.17         78.20           1,060.97            19,792.42

Answer & Explanation Solved by verified expert

4.3 Ratings (588 Votes)

Monthly Interest4512000375ABCA000375DBCEADPayment NoBeginning Loan balanceMonthly PaymentInterestPrincipal paidLoanBalance at End of See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

Amount financed = 240,000 - 91,088 = $148,912. This is Pv. Nper= 15 years*12 = 180 and rate = 4.5%/12 Amount paid each month =PMT(4.5%/12, 180, -148912) = 1139.07 The amortization table isshown below: Payment no. Loan balance at the start of the monthAmount of payment Interest Principal paid Loan balance at the endof the month find from payment # 10-100.Payment no.Loan balance at the start of the monthAmount of paymentInterestPrincipal paidLoan balance at the end of the month1 148,912.00 1,139.17 558.42 580.75 148,331.252 148,331.25 1,139.17 556.24 582.92 147,748.333 147,748.33 1,139.17 554.06 585.11 147,163.224 147,163.22 1,139.17 551.86 587.30 146,575.915 146,575.91 1,139.17 549.66 589.51 145,986.416 145,986.41 1,139.17 547.45 591.72 145,394.697 145,394.69 1,139.17 545.23 593.94 144,800.758 144,800.75 1,139.17 543.00 596.16 144,204.599 144,204.59 1,139.17 540.77 598.40 143,606.1910 143,606.19 1,139.17 538.52 600.64 143,005.54160 22,963.44 1,139.17 86.11 1,053.05 21,910.39161 21,910.39 1,139.17 82.16 1,057.00 20,853.39162 20,853.39 1,139.17 78.20 1,060.97 19,792.42

Payment no.	Loan balance at the start of the month	Amount of payment	Interest	Principal paid	Loan balance at the end of the month
1	148,912.00	1,139.17	558.42	580.75	148,331.25
2	148,331.25	1,139.17	556.24	582.92	147,748.33
3	147,748.33	1,139.17	554.06	585.11	147,163.22
4	147,163.22	1,139.17	551.86	587.30	146,575.91
5	146,575.91	1,139.17	549.66	589.51	145,986.41
6	145,986.41	1,139.17	547.45	591.72	145,394.69
7	145,394.69	1,139.17	545.23	593.94	144,800.75
8	144,800.75	1,139.17	543.00	596.16	144,204.59
9	144,204.59	1,139.17	540.77	598.40	143,606.19
10	143,606.19	1,139.17	538.52	600.64	143,005.54
160	22,963.44	1,139.17	86.11	1,053.05	21,910.39
161	21,910.39	1,139.17	82.16	1,057.00	20,853.39
162	20,853.39	1,139.17	78.20	1,060.97	19,792.42