Question

In: Economics

A machine is purchased for $2 million dollars with a monthly loan payment lasting 3 years.

A machine is purchased for $2 million dollars with a monthly loan payment lasting 3 years. With a nominal interest rate at 4%, what is the balance due after 22 months?

Solutions

Expert Solution

Nominal interest rate of 4% per annum will translate to 4%/12 = 0.33% as monthly rate of interest. We can set up a table in Excel to solve it once we know the monthly loan payment. That can be found using the formula for PV of annuity

A = P*((1-(1+r)^-n)/r)

Where

A = $2000000

P = to be found

r = 0.33% per month

n = 36, i.e., 12 months * 3 years

P = $2000000/((1-(1.0033^-36))/0.0033) = $59012.39

Now we can set it up in Excel to find out the balance due after 22 months. It will be 806080.525

Time Machine cost Interest = 0.33% * balance due previous month Monthly payment Balance due = balance due previous month + interest - monthly payment
0 2000000 2000000
1 6600.000 59012.390 1947587.610
2 6427.039 59012.390 1895002.259
3 6253.507 59012.390 1842243.377
4 6079.403 59012.390 1789310.390
5 5904.724 59012.390 1736202.724
6 5729.469 59012.390 1682919.803
7 5553.635 59012.390 1629461.048
8 5377.221 59012.390 1575825.880
9 5200.225 59012.390 1522013.715
10 5022.645 59012.390 1468023.970
11 4844.479 59012.390 1413856.060
12 4665.725 59012.390 1359509.395
13 4486.381 59012.390 1304983.386
14 4306.445 59012.390 1250277.441
15 4125.916 59012.390 1195390.966
16 3944.790 59012.390 1140323.366
17 3763.067 59012.390 1085074.044
18 3580.744 59012.390 1029642.398
19 3397.820 59012.390 974027.828
20 3214.292 59012.390 918229.730
21 3030.158 59012.390 862247.498
22 2845.417 59012.390 806080.525
23 2660.066 59012.390 749728.200
24 2474.103 59012.390 693189.913
25 2287.527 59012.390 636465.050
26 2100.335 59012.390 579552.995
27 1912.525 59012.390 522453.130
28 1724.095 59012.390 465164.835
29 1535.044 59012.390 407687.489
30 1345.369 59012.390 350020.468
31 1155.068 59012.390 292163.145
32 964.138 59012.390 234114.893
33 772.579 59012.390 175875.083
34 580.388 59012.390 117443.080
35 387.562 59012.390 58818.253
36 194.100 59012.390 -0.037

Related Solutions

An loan is paid in 3 years with monthly payment starting one month after the loan...
An loan is paid in 3 years with monthly payment starting one month after the loan is made. The payments are 540 each in the first year, and 900 per month in the second year, and 700 each in the last year. Interest is at a nominal rate of 7.8 percent convertible monthly. What is the outstanding balance after the 15th payment. Keep 4 decimal places only.
What will be the monthly payment on a loan of $602, amortizedover 29 years ,...
What will be the monthly payment on a loan of $602, amortized over 29 years , at an annual interest rate of 9%
      4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly)...
      4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly) with a lump-sum pay down of $20,000 made after 12 years have lapsed. New MP: Calculate the upfront fees that needs to be charged by the lender given a loan for $150,000 with terms 6%, 30 years (monthly compounding). The lender wants to earn a 6.6% yield. Assume a holding period of 12 years. Calculate the total payments and total interest expense for a...
2. A What is the monthly payment amount on a $100,000 home loan if the rate...
2. A What is the monthly payment amount on a $100,000 home loan if the rate is 8.0% APR, and the loan is made for a 15-year period? B A four-year investment requires annual deposits of $300 at the beginning of each year. The deposits earn 6% per year. What is the investment’s future value? Remember, the deposits are made at the beginning of each year (annuity due).
Loan Term: 5 Years Amortization Period: 5 years Payment Terms: Monthly at the end of the...
Loan Term: 5 Years Amortization Period: 5 years Payment Terms: Monthly at the end of the month Initial Principal Amount: $12,000,000 Interest Rate: 5.75% annually Develop an Amortization schedule for this particular loan. The schedule must show all payments associated with the loan. At the end of the fifth year of the loan, the loan balance should be zero.
Loan Term: 5 Years Amortization Period: 5 years Payment Terms: Monthly at the end of the...
Loan Term: 5 Years Amortization Period: 5 years Payment Terms: Monthly at the end of the month Initial Principal Amount: $12,000,000 Interest Rate: 5.75% annually Develop an Amortization schedule for this particular loan. The schedule must show all payments associated with the loan. At the end of the fifth year of the loan, the loan balance should be zero.
Determine the monthly payment using the added interest method Loan Amount: $ 2,700 Loan term: 2...
Determine the monthly payment using the added interest method Loan Amount: $ 2,700 Loan term: 2 years Interest rate: 7.5% monthly payment: ______?
Find the periodic payment R required to amortize a loan of P dollars over t years...
Find the periodic payment R required to amortize a loan of P dollars over t years with interest charged at the rate of r%/year compounded m times a year. (Round your answer to the nearest cent.) a. P = 50,000, r = 4, t = 15, m = 4 b. P = 90,000, r = 3.5, t = 17, m = 12' c. P = 120,000, r = 5.5, t = 29, m = 4
Your company purchased a machine for $60,000. The loan is for four years and calls for...
Your company purchased a machine for $60,000. The loan is for four years and calls for 8% interest. What will be the monthly payment due on the loan?
The monthly payment on a loan may be calculated by the following formula: Payment =    Rate *...
The monthly payment on a loan may be calculated by the following formula: Payment =    Rate * (1 + Rate)N ((1 + Rate)N -1) Rate is the monthly interest rate, which is the annual interest rate divided by 12. (12 percent annual interest would be 1 percent monthly interest.) N is the number of payments, and L is the amount of the loan. Write a program that asks for these (Input) values then displays a report similar to: Loan Amount:            $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT