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,...
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...
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...
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
|