In: Finance
EMI = Loan / PVAF (r%., n)
PVAF (r%, n) = SUm [ PVF(r%, n) ]
PVF (r%, n) = 1 /(1+r)^n
r - Int Rate per month
n - No. of months
= $ 125,000 / PVAF (0.2583%, 60)
= $ 125000 / 55.5150
= $ 2251.65
Loan Amortization:
Month | opening Bal | Instalment | Int | Principal Repay | Closing Bal |
1 | $ 1,25,000.00 | $ 2,251.65 | $ 322.92 | $ 1,928.73 | $ 1,23,071.27 |
2 | $ 1,23,071.27 | $ 2,251.65 | $ 317.93 | $ 1,933.71 | $ 1,21,137.56 |
3 | $ 1,21,137.56 | $ 2,251.65 | $ 312.94 | $ 1,938.71 | $ 1,19,198.85 |
4 | $ 1,19,198.85 | $ 2,251.65 | $ 307.93 | $ 1,943.72 | $ 1,17,255.14 |
5 | $ 1,17,255.14 | $ 2,251.65 | $ 302.91 | $ 1,948.74 | $ 1,15,306.40 |
6 | $ 1,15,306.40 | $ 2,251.65 | $ 297.87 | $ 1,953.77 | $ 1,13,352.63 |
7 | $ 1,13,352.63 | $ 2,251.65 | $ 292.83 | $ 1,958.82 | $ 1,11,393.81 |
8 | $ 1,11,393.81 | $ 2,251.65 | $ 287.77 | $ 1,963.88 | $ 1,09,429.94 |
9 | $ 1,09,429.94 | $ 2,251.65 | $ 282.69 | $ 1,968.95 | $ 1,07,460.98 |
10 | $ 1,07,460.98 | $ 2,251.65 | $ 277.61 | $ 1,974.04 | $ 1,05,486.95 |
11 | $ 1,05,486.95 | $ 2,251.65 | $ 272.51 | $ 1,979.14 | $ 1,03,507.81 |
12 | $ 1,03,507.81 | $ 2,251.65 | $ 267.40 | $ 1,984.25 | $ 1,01,523.56 |
13 | $ 1,01,523.56 | $ 2,251.65 | $ 262.27 | $ 1,989.38 | $ 99,534.18 |
14 | $ 99,534.18 | $ 2,251.65 | $ 257.13 | $ 1,994.52 | $ 97,539.67 |
15 | $ 97,539.67 | $ 2,251.65 | $ 251.98 | $ 1,999.67 | $ 95,540.00 |
16 | $ 95,540.00 | $ 2,251.65 | $ 246.81 | $ 2,004.83 | $ 93,535.16 |
17 | $ 93,535.16 | $ 2,251.65 | $ 241.63 | $ 2,010.01 | $ 91,525.15 |
18 | $ 91,525.15 | $ 2,251.65 | $ 236.44 | $ 2,015.21 | $ 89,509.95 |
19 | $ 89,509.95 | $ 2,251.65 | $ 231.23 | $ 2,020.41 | $ 87,489.53 |
20 | $ 87,489.53 | $ 2,251.65 | $ 226.01 | $ 2,025.63 | $ 85,463.90 |
21 | $ 85,463.90 | $ 2,251.65 | $ 220.78 | $ 2,030.86 | $ 83,433.04 |
22 | $ 83,433.04 | $ 2,251.65 | $ 215.54 | $ 2,036.11 | $ 81,396.93 |
23 | $ 81,396.93 | $ 2,251.65 | $ 210.28 | $ 2,041.37 | $ 79,355.56 |
24 | $ 79,355.56 | $ 2,251.65 | $ 205.00 | $ 2,046.64 | $ 77,308.92 |
25 | $ 77,308.92 | $ 2,251.65 | $ 199.71 | $ 2,051.93 | $ 75,256.99 |
26 | $ 75,256.99 | $ 2,251.65 | $ 194.41 | $ 2,057.23 | $ 73,199.75 |
27 | $ 73,199.75 | $ 2,251.65 | $ 189.10 | $ 2,062.55 | $ 71,137.21 |
28 | $ 71,137.21 | $ 2,251.65 | $ 183.77 | $ 2,067.87 | $ 69,069.33 |
29 | $ 69,069.33 | $ 2,251.65 | $ 178.43 | $ 2,073.22 | $ 66,996.12 |
30 | $ 66,996.12 | $ 2,251.65 | $ 173.07 | $ 2,078.57 | $ 64,917.55 |
31 | $ 64,917.55 | $ 2,251.65 | $ 167.70 | $ 2,083.94 | $ 62,833.60 |
32 | $ 62,833.60 | $ 2,251.65 | $ 162.32 | $ 2,089.33 | $ 60,744.28 |
33 | $ 60,744.28 | $ 2,251.65 | $ 156.92 | $ 2,094.72 | $ 58,649.56 |
34 | $ 58,649.56 | $ 2,251.65 | $ 151.51 | $ 2,100.13 | $ 56,549.42 |
35 | $ 56,549.42 | $ 2,251.65 | $ 146.09 | $ 2,105.56 | $ 54,443.86 |
36 | $ 54,443.86 | $ 2,251.65 | $ 140.65 | $ 2,111.00 | $ 52,332.86 |
37 | $ 52,332.86 | $ 2,251.65 | $ 135.19 | $ 2,116.45 | $ 50,216.41 |
38 | $ 50,216.41 | $ 2,251.65 | $ 129.73 | $ 2,121.92 | $ 48,094.49 |
39 | $ 48,094.49 | $ 2,251.65 | $ 124.24 | $ 2,127.40 | $ 45,967.09 |
40 | $ 45,967.09 | $ 2,251.65 | $ 118.75 | $ 2,132.90 | $ 43,834.19 |
41 | $ 43,834.19 | $ 2,251.65 | $ 113.24 | $ 2,138.41 | $ 41,695.79 |
42 | $ 41,695.79 | $ 2,251.65 | $ 107.71 | $ 2,143.93 | $ 39,551.85 |
43 | $ 39,551.85 | $ 2,251.65 | $ 102.18 | $ 2,149.47 | $ 37,402.38 |
44 | $ 37,402.38 | $ 2,251.65 | $ 96.62 | $ 2,155.02 | $ 35,247.36 |
45 | $ 35,247.36 | $ 2,251.65 | $ 91.06 | $ 2,160.59 |
Related SolutionsYou buy a car, which cost $100.000. The purchase can be financed with a payment of...You buy a car, which cost $100.000. The purchase can be
financed with a payment of 20% and the remaining 80% is covered by
an 8-year annuity loan. The loan bears interest rate of 3% p.a.,
and it has monthly terms in the following you therefore also apply
a discount rate of 3% p.a.
a) Determine the size of the payment, U, and the monthly
payment, Y, belonging to the loan.
You consider if it is realistic to sell the...
You buy a car, which cost $320.000. The purchase can be financed with a payment of...You buy a car, which cost $320.000. The purchase can be
financed with a payment of 20% and the remaining 80% is covered by
an 8-year annuity loan. The loan bears interest rate of 3% p.a.,
and it has monthly terms in the following you therefore also apply
a discount rate of 3% p.a.
a) Determine the size of the payment, U, and the monthly
payment, Y, belonging to the loan.
You consider if it is realistic to sell the...
You buy a car, which cost $320.000. The purchase can be financed with a payment of...You buy a car, which cost $320.000. The purchase can be
financed with a payment of 20% and the remaining 80% is covered by
an 8-year annuity loan. The loan bears interest rate of 3% p.a.,
and it has monthly terms in the following you therefore also apply
a discount rate of 3% p.a.
-------------------------------------------------------------------------------------------------------------------------------------------------
>>>>>>>>>>>>>>>>>>>>>>>NOTE:
I only need help with question e) and f)
:)<<<<<<<<<<<<<<<<<<<
-------------------------------------------------------------------------------------------------------------------------------------------------
a) Determine the size of the payment, U, and the monthly
payment, Y,...
Ziggy is considering purchasing a new car. The cash purchase price for the car is $47913....Ziggy is considering purchasing a new car. The cash purchase
price for the car is $47913. What is the annual interest rate if
Ziggy is required to make annual payments of $12000 at the end of
the next five years? Use Factor Table.
8%.
11%.
6%.
10%.
You are considering buying a new car for $37,000. If you purchase the car you will...You are considering buying a new car for $37,000. If you
purchase the car you will pay $7,000 of the purchase price as a
down payment. Below are two options to choose from. Option 1: Pay
off the amount borrowed to purchase the car with a 5 year loan, and
the annual percentage rate (APR) will be 0%. Option 2: Receive a
$2,000 instant rebate. This will lower your loan amount. Pay off
the amount borrowed to purchase the car...
You are considering buying a new car for $37,000. If you purchase the car you will...You are considering buying a new car for $37,000. If you
purchase the car you will pay $7,000 of the purchase price as a
down payment. Below are two options to choose from. Option 1: Pay
off the amount borrowed to purchase the car with a 5 year loan, and
the annual percentage rate (APR) will be 0%. Option 2: Receive a
$2,000 instant rebate. This will lower your loan amount. Pay off
the amount borrowed to purchase the car...
Tom is trying to enter the used car business. He knows that Jean-Ralphio will sell him...Tom is trying to enter the used car business. He knows that
Jean-Ralphio will sell him a car that needs repairs. Once repaired,
Tom can sell it for $100 more than he spent to purchase it.
Further, he knows that each car has an 80% chance of being a good
car, and a 20% chance of being a bad car. Good cars only cost $20
to repair, but bad cars cost $200 to repair.
Mona-Lisa decides to sweeten the deal...
A friend proposes to him to invest in a business for which he has projected the...A friend proposes to him to invest in a business for which he
has projected the following costs and income: 1. Initial cost of $
100 0002. Expenditure in year 1 of $ 50 0003. Annual expenses from
year 2 to 10 of $ 10 000. Additionally he projects that from In
year 4, these expenses will increase by $ 2,000 each year. 4.
Annual income of $ 40,000 from year 1 to 10. Additionally, it
projects that from year...
Veridian Dynamics is considering the purchase of a new cloning machine, which will cost $390 million...Veridian Dynamics is considering the purchase of a new cloning
machine, which will cost $390 million plus an additional $10
million to ship and install. The new machine will replace the
existing machine, which has zero book value and could be sold today
for $40 million. The new machine will have a 4 year useful life and
willl be depreciated to zero using the straight line method. The
machine will require $10 million worth of spare parts to be
purchased...
Ravi Shankar plans to purchase a car for $62,800 and he has $8,200 as a down...Ravi Shankar plans to purchase a car for $62,800 and he has
$8,200 as a down payment. He will need to borrow the
rest and plans to get a loan for 3 years at 3.90%. His monthly
payments on the loan will be closest to:
A.
$1,609.58.
B.
$1,432.13.
C.
$1,250.53.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|