Question

In: Finance

3. Now repeat Problem 2 (in which you borrow $6500, make a total of 36 payments...

3. Now repeat Problem 2 (in which you borrow $6500, make a total of 36 payments with the first payment made immediately, and all payments are growing by 2% per month) - but now use an interest rate of r = 0%. Then answer the following questions:

A) What is the size of the 6th (sixth) payment? (Hint: The answer is not $140.79.)

B) If you sum up all 36 payments (i.e. just simply add them up, as an accountant might do) - what is the sum of all 36 payments? Hint: This is a super easy question (and it's discussed in the book). In fact, there is NO NEED for any computation at all! NONE! Do you understand why? You need to. If you don't see the answer in about 3 seconds (at most), then you did not read the book carefully enough. Fix that.

Solutions

Expert Solution

See computation below [Final answers given at the end] (rounded up to 2 decimal places, in the absence of information):

Payment
No.
Payment Amount (Previous cell x 1.02) Growth
1                   6,500.00
2                   6,630.00      130.00
3                   6,762.60      132.60
4                   6,897.86      135.26
5                   7,035.82      137.96
6                   7,176.54      140.72
7                   7,320.08      143.54
8                   7,466.49      146.41
9                   7,615.82      149.33
10                   7,768.14      152.32
11                   7,923.51      155.37
12                   8,081.99      158.48
13                   8,243.63      161.64
14                   8,408.51      164.88
15                   8,576.69      168.18
16                   8,748.23      171.54
17                   8,923.20      174.97
18                   9,101.67      178.47
19                   9,283.71      182.04
20                   9,469.39      185.68
21                   9,658.78      189.39
22                   9,851.96      193.18
23                10,049.00      197.04
24                10,249.98      200.98
25                10,454.98      205.00
26                10,664.08      209.10
27                10,877.37      213.29
28                11,094.92      217.55
29                11,316.82      221.90
30                11,543.16      226.34
31                11,774.03      230.87
32                12,009.52      235.49
33                12,249.72      240.20
34                12,494.72      245.00
35                12,744.62      249.90
36                12,999.52      254.90
TOTAL 337,967.06

A) $ 7176.54
B) $ 337967.06

Hope this helps.
Feel free to ask for clarifications.
Consider leaving a thumbs up.
Good luck!


Related Solutions

7. You borrow $35,000 today and will make equal annual payments for the next 3 years,...
7. You borrow $35,000 today and will make equal annual payments for the next 3 years,     starting in 1 year. a. What is the value of the annual payment if the nominal interest on the loan is: 9.50% Payment b. Show the amortization of the loan in the table set up below: Year Beg. Balance Payment Interest Principal Ending Balance 1 2 3 TOTAL Excel function or formula answer please
Borrow $250,000 at 3% (with monthly compounding). The borrower is required to make monthly interest payments...
Borrow $250,000 at 3% (with monthly compounding). The borrower is required to make monthly interest payments on the loan as well as make monthly deposits into sinking fund earning 6% (monthly compounding) to repay the loan in 15 years. What is the total amount paid each month?
You decided to borrow $20,000and make payments at the end of each month for 10years. The...
You decided to borrow $20,000and make payments at the end of each month for 10years. The maximum monthly payment you can afford is $1000. What is the maximum interest rate you can afford(keep two decimal places)? What is the maximum interest rate you can afford if you are making payments at the beginning of each month for 10 years (keep two decimal places)?
Problem 4-31 Non Annual Compounding It is now January 1. You plan to make a total...
Problem 4-31 Non Annual Compounding It is now January 1. You plan to make a total of 5 deposits of $500 each, one every 6 months, with the first payment being made today. The bank pays a nominal interest rate of 10% but uses semiannual compounding. You plan to leave the money in the bank for 10 years. How much will be in your account after 10 years? Round your answer to the nearest cent. $   You must make a...
Problem 4-31 Non Annual Compounding It is now January 1. You plan to make a total...
Problem 4-31 Non Annual Compounding It is now January 1. You plan to make a total of 5 deposits of $300 each, one every 6 months, with the first payment being made today. The bank pays a nominal interest rate of 8% but uses semiannual compounding. You plan to leave the money in the bank for 10 years. How much will be in your account after 10 years? Round your answer to the nearest cent. You must make a payment...
You would like to borrow $300,000.00 to finance a home. You wish to make monthly payments...
You would like to borrow $300,000.00 to finance a home. You wish to make monthly payments for 15 years. If the annual interest rate (APR) is quoted at 5.3%. What will the monthly payments be?
You would like to borrow $200,000.00 to finance a home. You wish to make monthly payments...
You would like to borrow $200,000.00 to finance a home. You wish to make monthly payments for 15 years. If the annual interest rate (APR) is quoted at 8.4%. What will the monthly payments be? Refinance the loan after you have made 84 payments. First what is remaining balance that is owed. Second If the new interest rate (APR) is 4% and n will be based on the remaining time period of the original loan what will be the new...
You borrow $5,530 to purchase furniture for your house. You agree to make monthly payments for...
You borrow $5,530 to purchase furniture for your house. You agree to make monthly payments for 4 years to pay for the furniture. If the interest rate is 5 percent with monthly compounding, how much are your monthly payments? Assume the first payment is made one month after purchase. $103.95 $123.18 $127.35 $104.31 $121.90
•Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the...
•Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the stated coupon rate is 9% per annum and the loan matures in 12 years. Determine the interest and principal payment for year 5. • Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the stated coupon rate is 9% per annum and the loan matures in 12 years. You also make a balloon payment of $1,000,000 in the...
You borrow $100,000 and make annual payments for 5 years. The interest rate is 8%. How...
You borrow $100,000 and make annual payments for 5 years. The interest rate is 8%. How much interest do you pay in year 2? PLEASE EXPLAIN STEP BY STEP HOW YOU SOLVE WITH ONLY YOUR FINANCIAL CALCULATOR
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT