Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

vcm_midterm_assignment_1_amortization_sched_, Assignments of Business Statistics

vcm_midterm_assignment_1_amortization_sched_

Typology: Assignments

2020/2021

Uploaded on 10/21/2023

naya-minatozaki
naya-minatozaki 🇵🇭

2 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Illustration:
A borrower is repaying a $5000 loan at 15% interest with monthly
payments
over 3 years. Construct an Amortization Schedule.
PV= 5,000
I= .15/12=0.0125
n= 3x12= 36
AP =
5,000
¿ ¿ ¿
=
5,000
¿¿¿
=
5,000
28.84726737
AP= 173.33
pf2

Partial preview of the text

Download vcm_midterm_assignment_1_amortization_sched_ and more Assignments Business Statistics in PDF only on Docsity!

Illustration:

A borrower is repaying a $5000 loan at 15% interest with monthly

payments

over 3 years. Construct an Amortization Schedule.

PV= 5,

I= .15/12=0.

n= 3x12= 36

AP =

AP= 173.

Period (1 month interval) Outstanding principal at the Beginning of Each period: Interest due at the end of the period Payment at the end of the each period Portion of Principal reduced by each payment 1 5,000.00 62.50 173.33 110. 2 4,889.17 61.11 173.33 112. 3 4,776.95 59.71 173.33 113. 4 4,663.34 58.29 173.33 115. 5 4,548.30 56.85 173.33 116. 6 4,431.82 55.40 173.33 117. 7 4,313.89 53.92 173.33 119. 8 4,194.48 52.43 173.33 120. 9 4,073.58 50.92 173.33 122. 10 3,951.17 49.39 173.33 123. 11 3,827.23 47.84 173.33 125. 12 3,701.74 46.27 173.33 127. 13 3,574.69 44.68 173.33 128. 14 3,446.04 43.08 173.33 130. 15 3,315.79 41.45 173.33 131. 16 3,183.90 39.80 173.33 133. 17 3,050.37 38.13 173.33 135. 18 2,915.17 36.44 173.33 136. 19 2,778.28 34.73 173.33 138. 20 2,639.68 33.00 173.33 140. 21 2,499.35 31.24 173.33 142. 22 2,357.26 29.47 173.33 143. 23 2,213.39 27.67 173.33 145. 24 2,067.73 25.85 173.33 147. 25 1,920.25 24.00 173.33 149. 26 1,770.92 22.14 173.33 151. 27 1,619.73 20.25 173.33 153. 28 1,466.64 18.33 173.33 155. 29 1,311.65 16.40 173.33 156. 30 1,154.71 14.43 173.33 158. 31 995.82 12.45 173.33 160. 32 834.93 10.44 173.33 162. 33 672.04 8.40 173.33 164. 34 507.11 6.34 173.33 166. 35 340.12 4.25 173.33 169. 36 171.04 2.14 173.18 171. TOTAL 1,239.73 6,239.73 5,000.