Question

Solve using financial calculator and show steps please A borrower is evaluating a loan $100,000 with...

Solve using financial calculator and show steps please

A borrower is evaluating a loan $100,000 with annual rate of interest at 12%. He anticipates making monthly payments of $2,100 then a lump sum payment of $10,000. How long is he expecting to be paying this loan rounded to the nearest number years / months?

Homework Answers

Answer #1

The number of years/months is calculated using financial calculator as below :

I/Y = 1 (monthly interest rate = annual rate / 12 = 12%/12 = 1%)

PMT = -2100 (Monthly payment. This is entered with a negative sign because it is a cash outflow)

PV = 100000 (Loan amount. This is entered with a negative sign because it is a cash inflow today)

FV = -10000 (Lumpsum payment at end. This is entered with a negative sign because it is a cash outflow)

CPT --> N

N is calculated to be 60.08

It will take 60.08 months to pay off the loan.

Rounded off, it will take 60 months, or 5 years to pay off the loan.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A borrower takes out a 30-year adjustable rate mortgage loan for $500,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $500,000 with monthly payments. The first year of the loan has a “teaser” rate of 3%, after that, the rate can reset with a 7% annual payment cap. On the reset date, the composite rate is 5%. What would be the Year 2 monthly payment be? Please show how to solve using a financial calculator.
Please explain how to do this by hand (w/o a financial calculator): Suppose you have a...
Please explain how to do this by hand (w/o a financial calculator): Suppose you have a choice between receiving a lump-sum payment of $10,000 today or four annual payments of $2,750 (with the first payment one year from today). Of the following, which is the highest annual interest rate at which you would prefer the four annual payments over the lump-sum payment? 2% 5% 7% 10%
Solve using a financial calculator: please show each step you use on the financial calculator! 1....
Solve using a financial calculator: please show each step you use on the financial calculator! 1. Given the following information, calculate the NPV for this property. Initial cash outflow: $200,000, Discount rate: 15%, CF for year 1: $25,876, CF for year 2: $23,998, CF for year 3: $23,130, CF for year 4: $22,105, CF for year 5: $144,670. Draw your cash flow diagram and show your steps used in financial calculator. 2. Suppose you purchased an income producing property for...
1. A borrower has secured a 30 year, $100,000 loan at 8%.  Fifteen years later, the borrower...
1. A borrower has secured a 30 year, $100,000 loan at 8%.  Fifteen years later, the borrower has the opportunity to refinance with a fifteen year mortgage at 7%.  However, the up-front fees, which will be paid in cash, are $2,000.   What is the monthly payment on the initial loan?   What is the loan balance at the time of refinancing?   What is the return on investment if the borrower expects to remain in the home for the next fifteen years after refinancing?  ...
(Solve using Excel and provide steps to build formulas) A company estimates that it will need...
(Solve using Excel and provide steps to build formulas) A company estimates that it will need $199,000 in 55 years to replace a computer. If it establishes a sinking fund by making fixed monthly payments into an account paying 3.1% compounded​ monthly, how much should each payment​ be?
please tell me the steps to solve on financial calculator if possible. a six year semi...
please tell me the steps to solve on financial calculator if possible. a six year semi annual coupon bond is selling for 991.38. the bond has a face value of 1,000 and a yield to matuirity of 9.19 percent. what is the coupon rate?
Angelo Lemay borrowed $8000 from his credit union. He agreed to repay the loan by making...
Angelo Lemay borrowed $8000 from his credit union. He agreed to repay the loan by making equal monthly payments for five years. Interest is 9% compounded monthly. (Please use financial BAII calculator method by showing calculator inputs) (a) What is the size of the monthly payments? (b) How much will the loan cost him? (c) How much will Angelo owe after 18 months? (d) How much interest will he pay in his 36th payment? (e) How much of the principal...
John borrowed $84,000 at 9.60% compounded monthly He agreed to repay the loan in equal monthly...
John borrowed $84,000 at 9.60% compounded monthly He agreed to repay the loan in equal monthly payments over a 15 year amortization term. (a) What is the size of the monthly payment? Enter answer to 2 decimal places For parts (b),(c) and (d) DO NOT round the monthly payments but use exact results as found in your calculator. Nevertheless enter answers you find in each answer box to 2 decimal places. (b) How much of the 22nd payment is interest?...
PLEASE SOLVE THIS QUESTION IN DETAILS AND WITHOUT USING FINANCIAL CALCULATOR, AGAIN DO NOT USE FINANCIAL...
PLEASE SOLVE THIS QUESTION IN DETAILS AND WITHOUT USING FINANCIAL CALCULATOR, AGAIN DO NOT USE FINANCIAL CALCULATOR: Today, you are retiring. You have a total of $411,016 in your retirement savings and have the funds invested such that you expect to earn an average of 7.10 percent, compounded monthly, on this money throughout your retirement years. You want to withdraw $2,500 at the beginning of every month, starting today. How long will it be until you run out of money?
PLEASE SHOW FORMULA USED(NOT FROM EXCEL) AND STEPS USING FINANCIAL CALC 7. Ann obtains a fully...
PLEASE SHOW FORMULA USED(NOT FROM EXCEL) AND STEPS USING FINANCIAL CALC 7. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What will be Ann’s mortgage balance after 20 years of payments (ie after 240 months)? 8. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What percent of Ann’s 20th payment goes to interest? 9. Ann obtains a fully amortizing 30 year Fixed...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT