Homework Answers
11]
Monthly loan payment is calculated using PMT function in Excel :
rate = 4% / 12 (converting annual rate into monthly rate)
nper = 10*12 (10 year loan with 12 monthly payments each year)
pv = 200000 (loan amount)
PMT is calculated to be $2,024.90
Add Answer to:
please use excel functions
11. What is the draw (payment to the borrower) in a RAM...
15. What is the draw in a RAM for $300,000 at 4% interest and a maturity...
15. What is the draw in a RAM for $300,000 at 4% interest and a maturity of 10 years? (On Excel) Loan Amount Periods Per Year Interest Rate Years to Maturity What is the balance on the loan in the previous question 12 years after the original 10-year period ends? Loan Amount Periods Per Year Interest Rate Years After Original Maturity
please use excel functions 8. What is the payment in month 13 on a CAM loan...
please use excel functions
8. What is the payment in month 13 on a CAM loan for $150,000 with a maturity of 15 years at 5.85%? Answer Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount 9. What is the interest paid in month 14 on the loan in the previous question? Answer Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount
Please use excel functions 6. What is the payment in month 234 on a 30-year loan...
Please
use excel functions
6. What is the payment in month 234 on a 30-year loan for $925,000 at 4.85% that requires no payments during the first five years and fully amortizing payments for the remaining years of the loan? Answer Loan Amount Years Periods Per Year Interest Rate Balance at EOM 60 Total Amortization Years 7 What is the balloon nayment du at maturity for a 10-year loan for $325 000 at 5 9507 if
10. What is the payment in month 234 on a 30-year loan for $725,000 at 4.85%...
10. What is the payment in month 234 on a 30-year loan for $725,000 at 4.85% that requires payments of $0 for the first five years and fully amortizing payments for the remaining years of the loan? (On Excel) Loan Amount: Years: Periods Per Year: Interest Rate: Balance at EOM 60: Total Amortization Years: What is the balloon payment due at maturity for a 10-year loan for $225,000 at 5.85% if the negotiated payment amount each month is $100 less...
answer :4.78740% please no excel or actuarial calculator 4) A twenty-year loan of $25,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of $ 1 ,500 w...
answer :4.78740%
please no excel or actuarial calculator
4) A twenty-year loan of $25,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of $ 1 ,500 will apply during the first ten years, and a higher level payment will apply over the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing principal into a sinking fund with an annual effective interest rate...
You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
Please answer all parts A, B, and C. Please show all work! If you use Excel...
Please answer all parts A, B, and C. Please show all
work! If you use Excel to solve this problem please make clear the
calculations you made.
a. Calculate the monthly interest and principal cash flow for a fixed rate self amortizing mortgage with an initial balance of $350,000, a contract rate of 3.75%, and a maturity of two years. b. If the borrower decides to pay the loan back in full after the sixteenth month and the lender charges...
139.5 MB Problem 3 [25 points]: A house with price of $250,000 . 20% down payment, loan amount $200,000 30-year fixed r...
139.5 MB Problem 3 [25 points]: A house with price of $250,000 . 20% down payment, loan amount $200,000 30-year fixed rate mortgage with interest rate as follows: Choice Rate Points 1 7% 0 2 6.75 1 6.25 3 3 Suppose that there is S2,500 origination cost. 1 [10 points]: Which choice would you like to choose if you will live in the house for 30 years? 2 [15 points]: Which choice would you like to choose if you will...
Use the PMT function in Excel to compute the monthly payment on a $328000 business loan...
Use the PMT function in Excel to compute the monthly payment on a $328000 business loan at an annual interest rate of 7.15% over 20 years, where the interest is compounded monthly. Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type) Fv and Type are not necessary. Ignore them. Enter the amount of your monthly payment below. Do not include the dollar sign ($)
2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000...
2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 7%. What would the Year 3 monthly payment be? (15 points) Step I Step2 PV= -179084.11 PV = -200 000 I= 7412=10.58) I=47212= 10.33) N= 336 N=360 130x2)...
please use excel functions
8. What is the payment in month 13 on a CAM loan for $150,000 with a maturity of 15 years at 5.85%? Answer Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount 9. What is the interest paid in month 14 on the loan in the previous question? Answer Loan Amount Years Periods Per Year Payment Month at Issue Here Interest Rate Constant Amortization Amount
Please
use excel functions
6. What is the payment in month 234 on a 30-year loan for $925,000 at 4.85% that requires no payments during the first five years and fully amortizing payments for the remaining years of the loan? Answer Loan Amount Years Periods Per Year Interest Rate Balance at EOM 60 Total Amortization Years 7 What is the balloon nayment du at maturity for a 10-year loan for $325 000 at 5 9507 if
answer :4.78740%
please no excel or actuarial calculator
4) A twenty-year loan of $25,000 is negotiated with the borrower agreeing to repay principal and interest at 5%. A level payment of $ 1 ,500 will apply during the first ten years, and a higher level payment will apply over the remaining ten years. Each time the lender receives a payment from the borrower, he will deposit the portion representing principal into a sinking fund with an annual effective interest rate...
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
Please answer all parts A, B, and C. Please show all
work! If you use Excel to solve this problem please make clear the
calculations you made.
a. Calculate the monthly interest and principal cash flow for a fixed rate self amortizing mortgage with an initial balance of $350,000, a contract rate of 3.75%, and a maturity of two years. b. If the borrower decides to pay the loan back in full after the sixteenth month and the lender charges...
139.5 MB Problem 3 [25 points]: A house with price of $250,000 . 20% down payment, loan amount $200,000 30-year fixed rate mortgage with interest rate as follows: Choice Rate Points 1 7% 0 2 6.75 1 6.25 3 3 Suppose that there is S2,500 origination cost. 1 [10 points]: Which choice would you like to choose if you will live in the house for 30 years? 2 [15 points]: Which choice would you like to choose if you will...
2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 7%. What would the Year 3 monthly payment be? (15 points) Step I Step2 PV= -179084.11 PV = -200 000 I= 7412=10.58) I=47212= 10.33) N= 336 N=360 130x2)...
Most questions answered within 3 hours.
-
What is the temperature of 100.0 grams of chlorine gas in a
55.0-L container at 800....
asked 16 seconds from now -
The following information is available for two samples selected
from independent normally distributed populations. Population A:...
asked 1 minute ago -
Hello, I have questions on Matlab. Let's say that I have an
equation. Signal x(t)= cos(2*pi*10*t)...
asked 1 hour ago -
choose a radioactive isotope used in healthcare or another field
and report on how your isotope...
asked 31 minutes ago -
Balance the following half-reactions in acidic solution,
identify the oxidation states of the metal atoms, and...
asked 27 minutes ago -
describe
three ways that industrialized agriculture can impact human
health?
asked 44 minutes ago -
A resistor and capacitor are connected in series to a power
supply of 50 Volts. The...
asked 39 minutes ago -
(20
10Ne) (72 37Rb) (16 8O) (11 5B) why isotope of Rb is most unstable?
is...
asked 35 minutes ago -
A firm will pay a dividend of $2.01 next year. The dividend is
expected to grow...
asked 43 minutes ago -
The Bureau of Labor Statistics divides the adult population into
four categories: employed, underemployed, unemployed, and...
asked 56 minutes ago -
Question 29 Which of the following is not needed in order to
prepare a statement of...
asked 58 minutes ago -
iodination of vanillin
experiment
1. Briefly explain why the
iodination took place at the indicated position...
asked 1 hour ago