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
find payment number 100-160.
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
163                    19,792.42                         1,139.17         74.22           1,064.95            18,727.48

Answer & Explanation Solved by verified expert

4.3 Ratings (866 Votes)

Please find below Payment No Loan balance at the start of the month Amount of payment Interest Principal paid Loan balance at the end 100 7944860 113917 29793 84123 7860737 101 7860737 113917 29478 84439 7776298 102 7776298 113917 29161 84756 7691542 103 7691542 113917 28843 85073 7606469 104 7606469 113917 28524 85392 7521076 105 7521076 113917 28204 85713 7435364 106 7435364 113917 27883 86034 7349330 107 7349330 113917 27560 86357 7262973 108 7262973 113917 27236 86681 7176293 109 7176293 113917 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%/12Amount paid each month = PMT(4.5%/12, 180, -148912) =1139.07find payment number 100-160.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.42163 19,792.42 1,139.17 74.22 1,064.95 18,727.48

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
163	19,792.42	1,139.17	74.22	1,064.95	18,727.48