Jump to content

jackpot007

Registered Users

Change your profile picture
  • Posts

    3
  • Joined

  • Last visited

Reputation

1 Neutral

1 Follower

  1. good. don't forget to update us every once in a while. it'll be interesting how this thing will go.
  2. but i have a feeling that it will turn out for the best. they will all get this exposure and everything and surely there will be more tourists who would want to visit the country.
  3. Calculate APR: Assume you will borrow $100,000, and the lender tells you you’ve got a 7% interest rate. You also have $1,000 in closing costs. The APR on a 30 year fixed rate mortgage would be 7.10%. Do this using microsoft excel: Find the monthly payment for loan and closing costs: =PMT(0.07/12,360,100000) The format is: PMT(rate,nper,pv,fv,type) .07 divided by 12 is the rate (you’re using a monthly rate to find monthly payments) 360 is the number of periods (payments or months – 30 years here) 100,000 is the present value of your loan (including additional costs) You should have a result of $665.30. Next, Solve for the APR: =RATE(360,-665.30,99000) The format is: RATE(nper,pmt,pv,fv,type,guess) 360 is the number of periods you pay on the loan (360 months or 30 years) - 671.96 is your payment 99,000 is the present value of your loan (how much you’re actually borrowing) You should have a result of .592%. This is a monthly rate. Multiply by 12 to get 7.0999%.
×
×
  • Create New...