HomeworkLib
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:
business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
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.

Log In

Sign Up

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

  • What is the payment in month 204 on a 30-year loan for $925,000 at 4.85% that...

    What is the payment in month 204 on a 30-year loan for $925,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?

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

  • The goal of this project is to create a worksheet that through inputs and a series...

    The goal of this project is to create a worksheet that through inputs and a series of formulas, be a basis of an expandable tool, that you can use to create project an amortization schedule. The spreadsheet should be able to do various calculations using automated formulas. Both, fully amortizing, partially amortizing (balloon) or Interest only (bullet). there should be no balance or payment of interest past the term Yield with or with out closing costs. Interest Only periods. should...

  • 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

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