Question

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 than the payment would be if the loan were fully amortizing?

Loan Amount:

Years:
Periods Per Year:
Interest Rate:
Fully Amortizing Payment:
Negotiated Payment Shortfall:
Negotiated Monthly Payment:
0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
10. What is the payment in month 234 on a 30-year loan for $725,000 at 4.85%...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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

  • 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

  • 5. Create a complete amortization table for the following loan: Plain vanilla fully amortizing constant payment...

    5. Create a complete amortization table for the following loan: Plain vanilla fully amortizing constant payment loan with monthly payments 30 year term Rate on loan 4.5% Loan amount $777,777 ****do work in excel please****

  • please use excel functions 11. What is the draw (payment to the borrower) in a RAM...

    please use excel functions 11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and a maturity of 10 years? Answer Loan Amount Periods Per Year Interest Rate Years to Maturity 12. What is the balance on the loan in the previous question 2 years after the original 10-year period ends? (assume the borrower stays in the house for 12 years after origination) (use the FV function) Answer Loan Amount Periods Per Year...

  • You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30...

    You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your monthly payment? Round your answer to 2 decimal places. 2. You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your Month 1 interest payment? Round your answer to...

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

  • A common arrangement in real estate lending might call for a 5 year loan with, say,...

    A common arrangement in real estate lending might call for a 5 year loan with, say, a 15 years amortization. What this means is that the borrower makes a payment every month of a fixed amount based on a 15 year amortization. However, after 60 months, the borrower makes a single, much larger payment called a “balloon’ or “bullet” to pay off the loan. Because the monthly payments don’t fully pay off the loan, the loan is said to be...

  • You need to borrow $200,000. E-Click loans will make a 30 year, fully amortizing mortgage loan...

    You need to borrow $200,000. E-Click loans will make a 30 year, fully amortizing mortgage loan with monthly payments, with no points at an interest rate of 8%. (a) Construct a loan amortization schedule for the first 4 months of the loan. (b) What is the principal amount of your loan outstanding after 7 years (84 months) of making payments? Show that you can determine this by finding the FV of the loan after 7 years. Highlight your final answer

  • You purchase a home and need to borrow $350,000. The bank is offering a 30-year loan...

    You purchase a home and need to borrow $350,000. The bank is offering a 30-year loan that requires monthly payments and has a stated interest rate of 9% per year. What is your monthly mortgage payment? Now suppose that you can only afford to pay $2,500 per month. The bank agrees to allow you to pay this amount each month, yet still borrow the original amount. At the end of the mortgage in 30 years, you must make a balloon...

  • A 30-year mortgage has an annual interest rate of 5.25 percent and a loan amount of...

    A 30-year mortgage has an annual interest rate of 5.25 percent and a loan amount of $175,000. What are the monthly mortgage payments? (Round your answer to 2 decimal places.) Payment A 30-year mortgage has an annual interest rate of 4.65 percent and a loan amount of $225,000. (Hint: Use the "IPMT" and "PPMT" functions in Excel.) What are the interest and principal for the 84th payment? (Round your answers to 2 decimal places.) Interest Principal A 20-year mortgage has...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT