Dan buys a property for $240,000. He is offered a 30-year loan by the bank, at...

Question

Question

Dan buys a property for $240,000. He is offered a 30-year loan by the bank, at an interest rate of 6% per year. What is the a

business finance

Answer 1

Answer #1

C7 foc =PMT(C2,C3,-C4,C5,C6) в А 0.06 30 1 2 RATE 3 NPER 4 PV 5 FV 6 TYPE 7 PMT $ 240,000.00 Rate Per Period Total No.of Paym

Answer 2

Similar Homework Help Questions

Dan buys a property for $220,000 . He is offered a 30-year loan by the bank,...

Dan buys a property for $220,000 . He is offered a 30-year loan by the bank, at an interest rate of 7% per year. What is the annual loan payment Dan must make? a. $17,729.01 b. $21,274.81 c. $24,820,61 d. $28,366.42
Dan buys a property for $ 260000. He is offered a 30-year loan by the bank,...

Dan buys a property for $ 260000. He is offered a 30-year loan by the bank, at an interest rate of 9% per year. What is the annual loan payment Dan must make? A. $ 25307.45 B. $ 30368.94 C. $ 40491.92 D. $ 35430.43
Dan buys a property for $ 260,000. He is offered a 20-year loan by the bank,...

Dan buys a property for $ 260,000. He is offered a 20-year loan by the bank, at an interest rate of 7% per year. What is the annual loan payment Dan must make?

please choose one answer A,B,C,orD thank you Dan buys a property for $200,000. He is offered...

please choose one answer A,B,C,orD thank you Dan buys a property for $200,000. He is offered a 25-year loan by the bank, at an interest rate of 6% per year. What is the annual loan payment Dan must m ake? OA. $21,903.48 OB. $25,032.54 O C. $15,645.34 D. $18,774.41
QUESTION 11 John takes out a loan of $150,000 to buy a house. He is offered...

QUESTION 11 John takes out a loan of $150,000 to buy a house. He is offered a 15-year loan by the bank, at an interest rate of 5% per year. That is, John must pay for the house with 15 equal annual installments, with an interest rate of 5%. What is the annual loan payment John must make? A. $17,160 B. $17,812 C. $14,451 D. $13,526
QUESTION 4 John takes out a loan of $150,000 to buy a house. He is offered...

QUESTION 4 John takes out a loan of $150,000 to buy a house. He is offered a 15-year loan by the bank, at an interest rate of 5% per year. That is, John must pay for the house with 15 equal annual 1. Finstallments, with an interest rate of 5%. What is the annual loan payment John must make? A. $17,160 "B. $17,812 c. $14,451 D. $13,526

a student takes an education loan from a bank. He expects to borrow $40,000 a year...

a student takes an education loan from a bank. He expects to borrow $40,000 a year for the next 4 years (the first amount is drawn immediately, on 2/28/2010). The annual interest rate being charged is 8%; for the first several years, the interest is not paid, but it is added to the loan at the end of each year. He is required to repay the loan in equal annual payments starting 7 years from the date of the loan...
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...
Martin is offered an investment where for $6,000 today, he will receive $6,240 in one year....

Martin is offered an investment where for $6,000 today, he will receive $6,240 in one year. He decides to borrow $6,000 from the bank to make this investment. What is the maximum interest rate the bank needs to offer on the loan if Martin is at least to break even on this investment? A. 5% B. 2% C. 4% OD. 3%

Dan Schmidt plans to invest in a rental property worth $240,000. He plans to hold the...

Dan Schmidt plans to invest in a rental property worth $240,000. He plans to hold the property for 4 years and expects to sell it for $280,000 at the end of the fourth year. He estimates that the average monthly net income from renting the property will be $2,250. His target return is 8%. Calculate the net present value of the investment.