Suppose you found a house which comes with a price tag of $200,000. Your bank is willing to finance your upcoming purchase of your house . The bank has a two lines of loans : Loan to Value Ratio: 90, 8%APR, 30 year term; 80%loan to value ratio, 7%APR, 25 year Term. If you found a house with an asking price of $200,000 and you have $ 40,000 investment earning 16% annual return , How much is the additional Loan - to-Value coverage costing you , meaning getting the 90 % LTV vs. 80 % LTV ?

You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 30-year mortgage at 3.25% annual interest rate for the cost of the house after they receive a 20% down payment.   How much interest will they have paid?  What percent increase over the cost of the home does this interest represent?

You have taken out a 5 year loan from a bank to buy an engagement ring.  The ring costs $5000, you plan to put down $1000 and borrow $4000.  You will need to make annual payments of $1000 at the end of each year.  Show the timeline of the loan from your perspective.  How would the timeline differ if you created it from the bank's perspective.

You want to buy a $243,000 home. You plan to pay 10% as a down payment, and take out a loan with a rate of 8% for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if you have a 30-year loan? $ c) What will your monthly payments be if you have a 15-year loan? $ d) What is the total amount paid to the bank over the 30-years? $ e) Whatis the total amount paid to the bank over the 15-years? $ f) Find the total interest paid for the 30-year loan. $ g) Find the total interest paid for the 15-year loan. $

Suppose you decide to wait 5 years to save up before buying the house.  You are able to put a down payment of $30,000 on the house, so that you only need to borrow $170,000 from the bank.  Assume the interest rate is still the same, but you are now in a better financial position, and you can pay off the loan in 240 equal monthly payments. Answer the following questions about this loan. After making 240 monthly payments, how much of what you paid the bank was interest? $                      .  ROUND TO THE NEAREST CENT. THANKS APPRECIATE THE HELP!!!

You want to buy a $195,000 home. You plan to pay 5% as a down payment, and take out a 30 year loan at 5.35% interest for the rest. The bank will charge 1.5 points on the amount financed.a) What is the amount of the down payment?$b) How much is the loan amount going to be?$c) What will be the amount charged for 1.5 points?d) Find the amount of the monthly payment.

Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You!   A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?

You are assiting a newly hired employee. You begin explaning the process of utilizing excel to finance properties. Consider the following. A realator has a house on sale for $640,000. If possible you  believe you can finance the home for $300,000 for 20 years at a 3% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel. How would you caluclate this in Excel using the PV function? Rate: Nper: Pmt: FV: Type:

Please build an excel spreadsheet and show the formulas  to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?

You want to buy a $210,000 home. You plan to pay $10500 as a down payment, and take out a 30 year loan for the rest.a) How much is the loan amount going to be?