Question

In: Finance

bob buys a property for $140,000. He is offered a 25-year loan by the bank, at...

bob buys a property for $140,000. He is offered a 25-year loan by the bank, at an interest rate of 6.88% per year. What is the annual loan payment Dan must make?   ________.

A businessman wants to buy a truck. The dealer offers to sell the truck for either $145,000 now, or 7 yearly payments of $24,000. What interest rate would make these two options financially equivalent?

Solutions

Expert Solution

Q-1)

- Loan amount of Property = $140,000

Calculating the Annual Loan Payment using Excel "PMT" function:-

So, the annual loan payment Dan must make is $11,883.89

Q-2)

The dealer offers businessman an offer for either $145,000 now, or 7 yearly payments of $24,000.

Present Value to buy truck today = $145,000

Or, Yearly Periodic annuity payment for 7 years = $24,000

Puting both equivalent to calculate the interest rate using Exce "rate" function:-

So, interest rate would make these two options financially equivalent is 3.82%

If you need any clarification, you can ask in comments.    

If you like my answer, then please up-vote as it will be motivating       


Related Solutions

Bob buys a property that costs $1,000,000. The property is projected to generate NOI as follows:...
Bob buys a property that costs $1,000,000. The property is projected to generate NOI as follows: Year NOI 1 $100,000 2 $105,000 3 $110,000 Bob will own the property for two years. Bob will sell the property at the end of year 2 at a cap rate that is 250 basis points lower than the cap rate at which he bought the property. Assume Bob finances his purchase with a 50% LTV Fixed Rate IO loan at an annual rate...
Bob is considering buying a home and selling it in one year. At t=0 he buys...
Bob is considering buying a home and selling it in one year. At t=0 he buys a house, the price is $100,000. At t=1 the house appreciates (i.e. the price goes up) by 20%, and Bob sells it. Bob also pays transaction costs: buying costs are 5% of buying price, selling costs are 8% of selling price. Each time period is a year. Bob does not take any mortgages. Find the NPV of this project if the interest rate is...
Aninvestor buys a property for $687,000 with a​ 25-year mortgage andmonthly payments at 6.3​%...
An investor buys a property for $687,000 with a 25-year mortgage and monthly payments at 6.3% APR. After 18 months the investor resells the property for $749,484. How much cash will the investor have made from the sale, once the mortgage is paid off?
An investor buys a property for $608,000 with a 25-year mortgage and monthly payments at 8.10%...
An investor buys a property for $608,000 with a 25-year mortgage and monthly payments at 8.10% APR. After 18 months the investor resells the property for $667,525. How much cash will the investor have from the sale, once the mortgage is paid off?
An investor buys a property for $608,000 with a 25-year mortgage that requires monthly payments at...
An investor buys a property for $608,000 with a 25-year mortgage that requires monthly payments at 5.10% APR. After 18 months the investor resells the property for $667,525. How much cash will the investor have from the sale, once the mortgage is paid off? Round to the nearest dollar.
ABC Bank sanctions a loan application for a 25 year mortage loan for US100,000. The interest...
ABC Bank sanctions a loan application for a 25 year mortage loan for US100,000. The interest rate on the loan is 12% per annum and the borrower is required to make equal monthly payments to repay the loan in 25 years. If the market interest rate goes down to 10% per annum, what will the loan be worth? (Answer up to two decimal places,
Bob buys a property with an 80% LTV interest only mortgage at an annual rate of...
Bob buys a property with an 80% LTV interest only mortgage at an annual rate of 6%, with annual compounding and annual payments. Bob’s annual cap rate for the first year is 8%. Which of the following is true about Bob’s Return on Equity (ROE) for the first year? A. ROE is higher than if he didn’t use leverage B. ROE is lower than if he didn't use leverage C. There is not enough information to answer this question D....
If a bank follows a strategy in which it buys reserves to cover loan requests they...
If a bank follows a strategy in which it buys reserves to cover loan requests they are likely doing: a funds management. b asset management. c liability management. d asset-liability coordinated management. eNone of the options is correct. You invest in a savings instrument in which you firstly make a lump sum payment. This amount is invested (i.e. by a manager) in different assets and at a later point you receive a stream of income. This is known as: a...
A property has a maturing loan and needs to be refinanced. It is appraised at $25...
A property has a maturing loan and needs to be refinanced. It is appraised at $25 million based on a cap rate of 6%. Your lender has put two constraints on your next loan. It must have debt service coverage of 1.5x and LTV of 50%.  Interest rates are 5% and the lender offers you a 10-year loan with a 20- year amortization schedule. Which constraint limits your loan? How much can you borrow?
Please show details of solving. Thank you RES 3200 Bob buys a property that costs $5,000,000....
Please show details of solving. Thank you RES 3200 Bob buys a property that costs $5,000,000. Year NOI 1 $300,000 2 $315,000 3 $330,000 Bob will own the property for two years. The NOI from the property for years 1-3 is to the right: Bob will sell the property at the end of year 2 at a cap rate that is 50 basis points lower than the cap rate at which he bought the property. Assume Bob finances his purchase...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT