Question

More Calculator Practice-Borrowing Capacity Use your calculator to solve the following problems. You can default to Excel ifMore Calculator Practice-Medium Term Notes Use your calculator to solve the following problems. You can default to Excel if t

More Calculator Practice-Borrowing Capacity Use your calculator to solve the following problems. You can default to Excel if this is not possible. 1. You can afford to pay $6,000 a month for a 30-year mortgage. When interest rates are 6.125% how much can you borrow? Your answer: 2. If the loan represents 60% of the property's total value, how much is the property worth? Your answer: 3. How much equity do you require for the property? Your answer: 4. Suppose you want to use and interest only (IO) loan. Now how much could you borrow? Your answer: 5. How large of a property could you acquire now? Your answer :
More Calculator Practice-Medium Term Notes Use your calculator to solve the following problems. You can default to Excel if this is not possible. 1. How much would you pay per month to service (pay interest and principal) a 10-year, $3 million loan, fully amortizing loan? Your answer: 2. If the loan represents 55 % of the property's total value, how much the property worth? Your answer: 3. What would be your monthly payment on an IO loan? Your answer: 4. What would be your monthly payment if the loan had a 30-year amortization schedule? Click cell J14 for some help. The font is white. Either change it to another color or read the response in the formula bar. Your answer: 5. Assume you are able to pay the same monthly amount calculated in the first question above. How much could you borrow using a 30-year amortization schedule? Your answer What would be the most you could pay for a property using a 55% LTV (loan- -value, where the loan represents 55% of the total property value)? Your answer:
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. The money you can borrow is $987,474.64. Calculation given below:

Monthly interest rate=6.125%/12=0.510%

Total number of months you have to pay EMI=30*12=360 months

A PMT 6000 Number of months for loan tenure Monthly Interest Rate PV 360 0.510% ($987,474.64),

C PMT 6000 Number of months for loan tenure 360 Monthly Interest Rate PV 0.510% |=PV(B3,B2,B1,0) PV(rate, nper, pmt, [fv], [t

2. If the property value is X (Say) then

X*60%= 987,474.64 or X=$1645791.07

So, property value is $1,645,791.07

3. Equity needed to buy the property= (1,645,791.07- 987,474.64)=$6,58,316.4

4. Suppose, X is the amount I can borrow

So, X*0.510%=6000 or X=$1,176,471

So, I can borrow $1,176,471

5. Now the value of property I can buy= 1,176,471/0.6=$1960785

Add a comment
Know the answer?
Add Answer to:
More Calculator Practice-Borrowing Capacity Use your calculator to solve the following problems. You can default to Exc...
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
  • 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...

  • can I please have help with this? how would I calculate this in a financial calculator?...

    can I please have help with this? how would I calculate this in a financial calculator? Calculate the effective cost of the following loan if the borrower Loan amount: $100,000; Term: 30 years a. 8.285% b. C. prepays at the end of year 3 Interest rate: 7.5%; Monthly Payment: 5% prepayment penalty over entire te mn 8.645% 8.935% None of the above d. 20. You borrow $100,000 mortgage with monthly payments. You can either choose 15-year term wi choose 30-year...

  • Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs...

    Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs (ie. N, PV, etc.) to get partial credit. 1. How much would you pay for the right to receive $12,000 at the end of 15 years if you can earn a 15% return on a real estate investment with similar risk? 2. What constant amount invested at the end of each year at a 10% annual interest rate will be worth $20,000 at the...

  • all answered in microsoft excel thank you! Problem #1: For Problems 1 and 2, you can...

    all answered in microsoft excel thank you! Problem #1: For Problems 1 and 2, you can use any Excel technique explored in the last two labs. You have taken a loan of $286,000 CAD. The nominal annual rate of interest compounded monthly on this loan is 4.01%. You can afford to pay monthly $ 1242.43 CAD. How many months it will take you to repay the loan? Your answer will be an integer value that includes the last monthly payment,...

  • Can someone show me how to do the math for this question. I use a TI-84...

    Can someone show me how to do the math for this question. I use a TI-84 plus calculator. Thank you. You can afford to pay $5,000 per month for a personal loan to establish your business. The interest rate is 2.25% for a 15-year fixed loan. a. How much can your borrow? Round to the nearest dollar. b. How much is the total payment? Round to the nearest dollar. c. How much is the interest? Round to the nearest dollar.

  • Suppose that you plan to borrow $20,000 student loans to attend UM-Dearborn. You are considering borrowing...

    Suppose that you plan to borrow $20,000 student loans to attend UM-Dearborn. You are considering borrowing the loan from SallieMae. SallieMae offers two options for the repayment of your loan. One is the deferred repayment option and the other is interest repayment option. The APR for the deferred repayment option is 6.75% and the APR for the interest repayment option is 5.75%. You plan to finish your undergraduate study in UM-Dearborn within five years. The two repayment options are described...

  • Amortization Table. You wish to buy a $40,000 car. The bank can finance you with a 3-year loan at a 4 percent APR. If yo...

    Amortization Table. You wish to buy a $40,000 car. The bank can finance you with a 3-year loan at a 4 percent APR. If you make a $7,000 down payment on the purchase. What are the monthly payments on your loan? How much will you pay in interest each year? Show the amortization table (use monthly payments).

  • How to calculate the content of green grid? Thank you 13. You have reviewed your budget...

    How to calculate the content of green grid? Thank you 13. You have reviewed your budget and determined that you can afford to pay $300 per month as a car payment. How much can you borrow if your credit is good and the interest rate is 4 percent using a 48 month loan? How much can you borrow if your credit is bad and the interest rate is 8 percent using the same loan term? This problem is similar to...

  • You bought a house a year ago for $250,000, borrowing $200,000 at 10% on a 30-year...

    You bought a house a year ago for $250,000, borrowing $200,000 at 10% on a 30-year term- loan (with monthly payments Interest rates have since come down to 9%. You can refinance your mortgage at this rate, with a closing cost that will be 3% of the loan. Your opportunity cost is 8%. Ignore tax effects. 17. ow much are your monthly payments on your current loan (at 10%)? How would your monthly payments be if you could refinance your...

  • You borrow $500,000 to purchase a house. The mortgage is a 30-year fixed rate mortgage, with...

    You borrow $500,000 to purchase a house. The mortgage is a 30-year fixed rate mortgage, with monthly payments. A. Assume that you have good credit, and can borrow money at a 3.75% annual interest rate. What will your monthly payment be? B. Now, assume that you have lousy credit, and must pay a 6.5% annual interest rate to obtain a mortgage. What will your monthly payment be? C. Having lousy credit can be costly. How much additional interest will you...

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