Question

In: Finance

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

Solutions

Expert Solution

QUESTION 2 : A : SOLVED USING FORMULA AS WELL AS EXCEL FUNCTION


Related Solutions

Compute the monthly payment for a $133,440 home loan. The stated interest of the loan is...
Compute the monthly payment for a $133,440 home loan. The stated interest of the loan is 5% with monthly payments. The loan amortization is over 25 years.
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: ______?
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:            $...
If the interest rate on the loan is 7%, what is the amount of principal in the second payment?
You borrow $12,000 today. The loan will be repaid in annual payments over 10 years. If the interest rate on the loan is 7%, what is the amount of principal in the second payment?
loan amount - 1,200,000. terms(years) - 15 interest rate - 3.125% payment frequency - monthly Amortizing...
loan amount - 1,200,000. terms(years) - 15 interest rate - 3.125% payment frequency - monthly Amortizing Loan Assignment
The amount of a loan is $100,000 with an interest rate of 8%. The life of...
The amount of a loan is $100,000 with an interest rate of 8%. The life of the loan is 4 years. Create a loan amortization table.
On a 30-year, fixed-rate loan with a monthly payment of $1,000 and an interest rate of...
On a 30-year, fixed-rate loan with a monthly payment of $1,000 and an interest rate of 9%, what is the outstanding balance due on the loan with after the borrower has made 18 years of payments?
1. What are the monthly payments for a $100,000 mortgage amount, 8 percent interest rate, and...
1. What are the monthly payments for a $100,000 mortgage amount, 8 percent interest rate, and a 30-year term? A - 8,883 B - 740 C - 734 D - 8,000 2. You are borrowing $10,000 to purchase a car. You plan to make monthly payments for 24 months, and the interest rate is 12%. What is your monthly payment? A - 471 B - 1,285 C - 371 D - 5,075
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is 3% per year, Compounded annually Compounded monthly Compounded daily What are effective annual rates for 1,2, and 3 above?
Calculate the monthly payment for loan amount of $350,000 using the following parameters: • 20 Year...
Calculate the monthly payment for loan amount of $350,000 using the following parameters: • 20 Year Loan, fully amortizing • Interest Rate of 3.29% What is the monthly payment amount (rounded to the nearest dollar)? a. $2,466 b. $2,276 c. $1,992 d. $1,713 Calculate the monthly payment for loan amount of $150,000 using the following parameters: • 30 Year Loan, fully amortizing • Interest Rate of 7.00% What is the monthly payment amount (rounded to the nearest dollar)? a. $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT