By Admin on Nov 30, 2009 in Investing | 3 Comments
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.
By Admin on Nov 29, 2009 in Other - Business & Finance | 1 Comment
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 [...]
By Admin on Nov 28, 2009 in Software | 2 Comments
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?
By Admin on Nov 27, 2009 in Credit | 1 Comment
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 [...]
By Admin on Nov 26, 2009 in Other - Careers & Employment | 1 Comment
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?
By Admin on Nov 24, 2009 in Renting & Real Estate | 8 Comments
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 [...]
By Admin on Nov 23, 2009 in Personal Finance | 5 Comments
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.
By Admin on Nov 22, 2009 in Personal Finance | 1 Comment
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 [...]
By Admin on Nov 21, 2009 in Renting & Real Estate | 2 Comments
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 [...]
By Admin on Nov 20, 2009 in Renting & Real Estate | 4 Comments
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?