Archive for November, 2009

Where does one find the market bond interest rate on a specific date? »

kempemily79 asked: I’m trying to create a bond premium amortization schedule. I think I have done this right, but wanted to validate the effective interest rate on 8/20/08 against something.

Amortization of Loans? »

daisy s asked: How do you make an amortization schedule if you don’t know the monthly payments. only information given is the amount of said loan and annual interest rate. i don’t know how to use excel if any one can tell me how to do it with equations. Can someone help me Please! I [...]

What is the excel formual to find interest rate? »

Joe M asked: I have an amortization of 60 months, monthly payment amount and original loan amount. I am trying to find the excel formula that will help me compute the rate. i tried =rate(nper, pmt, pv)…but i get an error. what am i doing wrong?

What if I make payments at the beginning of a payment period? »

Wizard and Chips asked: What if I make payments at the beginning of a payment period? So I wanted to know whether or not it would be worth it for me to pay off my mortgage by making monthly installments at the beginning of the payment period instead of waiting until the end. Does anyone [...]

The cost of using a building in your business is recorded to the income statement as? »

tammy m asked: The cost of using a building you own in your business is recorded to the income statement as: the mortgage is paid, as depreciation expense, amortization expense, or when the building is replaced?

Can you refinance a home that is now worth less than the principal balance? »

jsn77raider asked: I just bought my 1st house middle of last year. I had to get a crummy loan to get in (Neg Amortization). Now I’d like to re-fi in the next 2-6 months. Problem is that my principal went up and the home value has probably dropped at least a little. If I can [...]

How can I know how much I need to pay to payoff my car loan…? »

Rank Roo asked: I see on my statement how much principal is left to be paid on my loan, but if I send in that amount, won’t I be short the interest I’ve been charged since my statement? Should I just overpay and hope for a refund? Note–this is not an amortization table question.

What if I make payments at the beginning of a payment period? »

Wizard and Chips asked: What if I make payments at the beginning of a payment period? So I wanted to know whether or not it would be worth it for me to pay off my mortgage by making monthly installments at the beginning of the payment period instead of waiting until the end. Does anyone [...]

How do i add a formula to calculate for adding mortgage insurance? »

Jon H asked: I have created a simple mortgage calculator which will work out the mortgage payments for a specific loan to value (5%, 10%, 15% down etc) and it will add mortgage insurance and calculate the income required. How do i add a formula which will work out the mortgage insurance for any down [...]

Mortgage Amortization Formula? »

Hootcoot asked: I have a 15 year mortgage and want to know how to determine a payoff schedule if I pay an additional $50/mo. toward the principal. 15 year; 5.625 fixed rate; 100K, paying $50 extra per month toward principal. Is there a formula I can use to determine the actual point of payoff?

Powered by Yahoo! Answers

Powered by Yahoo! Answers