Question

In: Finance

Build a amortization table for the loan below add extra payment to pay off early by...

Build a amortization table for the loan below add extra payment to pay off early by no more the 6 months (the loan payment must last 4.5 years even with early payoff) . Show the money saved.

$35,000 loan, 5 years, 5.9% interest, monthly payments with no balloon.

Create an annuity solution to find the payment in Excel (that's the N I/Y PV PMT FV) and then do the amortization table for it.

Solutions

Expert Solution

Using excel function

= PMT (rate, nper, PV)

Rate = 5.9%/12 for monthly rate

nper = 5 years*12 = 60 months

PV = -35,000 (- sign for getting positive value of annuity)

=PMT( 5.9%/12, 60, -35000)

= $675.02

The amortization table will be as below:


Clearly, there is saving of money in extra payment to pay off early.

Saving = $5432.52 - $5,501.31 = $68.79

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of...
5. Construct an amortization schedule for the mortgage. If the Halls would pay extra payment of $150 a month starting 49th month, how quickly will they able to payoff the mortgage? Be sure to have a zero balance at the end of amortization. Loan Amount 180,576 Loan Length in months 240 Interest (APR) 4.250% Total interest payment Hint: Be sure to compute the total interest payments using "Sum()" function. Prepayment $150 Total # of pmts with prepay With the prepayments,...
On the third tab build the full amortization table for a 30 year Constant Payment Mortgage...
On the third tab build the full amortization table for a 30 year Constant Payment Mortgage (CPM) Loan with a 4.5% interest rate compounded monthly. The initial loan amount should be $2,500,000. in excel
If you pay off a loan early, you must also pay all the remaining interest payments...
If you pay off a loan early, you must also pay all the remaining interest payments along with the loan balance. Group of answer choices True False. Which of the following is correct? Group of answer choices Present values increase with a longer compounding period. Present values increase with a higher interest rate. Future values increase with a lower interest rate. Future values increase with a longer compounding period. 3. What does it mean when you see the message Error...
Complete the first 4 months of an amortization table for the 30 year loan. Include payment...
Complete the first 4 months of an amortization table for the 30 year loan. Include payment number, amount applied to interest, amount applied to principal, balance, and equity (%) as columns in your table. Repeat for the 15 year loan given in the same exercises.
25. The annual payment necessary to amortize (pay off) a 5% $200,000 loan with a 20...
25. The annual payment necessary to amortize (pay off) a 5% $200,000 loan with a 20 year repayment period (annual end of year payments required) is   __________________ 26. A prospective new creditor (a vendor for materials purchases) is evaluating financial ratios for ABC Company. The creditor is likely most interested in the __________ ratios a. inventory management related b. return on equity related c. return on assets related d. liquidity related 27. ABC Inc. signs a note payable in the...
(a) You need to pay off a car loan within the next two years. The payment...
(a) You need to pay off a car loan within the next two years. The payment will be $4,000 every month. Today you have made a single deposit into a return-guaranteed investment account that will allow you to cope with all the monthly payments. This account earns an effective annual interest rate of 12.68250301%. The first payment will be made in one month. (i) Calculate the corresponding monthly rate for the investment account. (ii) “You need to have at least...
(a) You need to pay off a car loan within the next two years. The payment...
(a) You need to pay off a car loan within the next two years. The payment will be $4,000 every month. Today you have made a single deposit into a return-guaranteed investment account that will allow you to cope with all the monthly payments. This account earns an effective annual interest rate of 12.68250301%. The first payment will be made in one month. (i) Calculate the corresponding monthly rate for the investment account. (ii) “You need to have at least...
Goal-seek Loan Amortization Schedule Amount of the loan: $500,000 Length of the loan: 30 years Payment:...
Goal-seek Loan Amortization Schedule Amount of the loan: $500,000 Length of the loan: 30 years Payment: Equal annual payment Interest rate: Annual interest rate is 3.0% in year 1, and increases 0.1% in year 2, etc. In other words, the annual interest rates will be 3.0%, 3.1%, 3.2%,…. M1 Assignment - Goal-seek Loan Amortization Schedule Rubric Successfully created year-by-year table with Year, Beginning balance, PMT, interest, principal, ending balance 3 pts Successfully created a column to reflect floating interest rates...
calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year...
calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year for 10 years, starting on 1/1/2010. All calculations must be shown, i.e., do not use a “package” to complete this question.   Loan period starts from 1/1/2010. I mean the first payment is to be made on 1/1/2010.
Prepare an amortization table for the calculation of interest and payment of the Document payable to...
Prepare an amortization table for the calculation of interest and payment of the Document payable to a natural person, for $ 2,000,000 at the annual rate of 12%, payable in 3 years. The interest plus the payment of the document will be made at the end of the 3 years. Calculate with simple interest and also calculate cost with compound interest
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT