By Admin on Sep 23, 2009 in Investing | 3 Comments
Uncle Pennybags asked: Supposedly, investors who invested in these mortage backed securities are taking a bath, and the securities have declined big time, right? Well, these securities must have some value, I mean not every loan is defaulting, and even the ones that are are backed by homes with some real value. So I figure [...]
By Admin on Sep 13, 2009 in Investing | 0 Comments
Fireswan asked: I have an amortization spreadsheet and I need a cell at the top of the page that will tell me the remaining balance based on today’s date. Is there any way to get this? I have a basic understanding of using functions but if it is complicated I’ll need a detailed explanation.
By Admin on Sep 7, 2009 in Investing | 1 Comment
Robert asked: 5 year bonds issued on Jan 1, 2002 $800,000 at 9% at 96. The bonds pay semi annual interest Jan 1 and July 1. Prepare journal entry and balance sheet through Jan 2003. Calculate effective interest rate.
By Admin on Aug 29, 2009 in Investing | 1 Comment
smoofus70 asked: I have a question about TIPS (Treasury Inflation-Protected Securities). Do people buy these at premiums/discounts or are they just bought at par and adjust based on the Consumer Price Index?
By Admin on Aug 25, 2009 in Investing | 1 Comment
Paul H asked: I would highly appreciate if somebody has example Excel spreadsheet of Scientific method of how to amortize loan premium. Thanks alot
By Admin on Aug 24, 2009 in Investing | 1 Comment
elnel55 asked: long term liabilities
By Admin on Aug 23, 2009 in Investing | 1 Comment
elnel55 asked: long term liabilities
By Admin on Aug 21, 2009 in Investing | 1 Comment
conor asked: On January 1, 2008, Whitefeather Industries issued 300, $1,000 face value bonds. The bonds have a five-year life and pay interest at the rate of 10%. Interest is paid semiannually on July 1 and January 1. The market rate of interest on January 1 was 10%. I am just completely confused on this [...]
By Admin on Aug 20, 2009 in Investing | 1 Comment
Hasham asked: I would also like to know about the working of IRR (internal Rate of Return) on Investments. How IRR is calculated if my investment is $100,000/- and my Maturity is 10 years @ 21.06%(on maturity). (AMORTIZATION SCHEDULE)
By Admin on Aug 19, 2009 in Investing | 3 Comments
AshenNova asked: Free Cash Flow = Net income + Amortization/Depreciation – Capital expenditure = changes in working capital