Accounting Help for College and University Students

A discounted cash flow analysis. Attachment in Excel.

If the appropriate discount rate for the following cash flows is 12.25 percent per year, what is the present value of the cash flows? Year 1 Cash flow is $1500. Year 2 cash flow is $3200. Year 3 cash flow is $7200. Year 4 cash flow is $9600.

Working with interest in an amortization schedule with equal payments. Attachments in Excel.

Prepare an amortization schedule for a 3-year loan of $40,000. The interest rate is 11 percent per year and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?

Question on PRICE and YIELD function in spreadsheet

Please see attached examples from my textbook. I don't have the PRICE and YIELD functions on my spreadsheet, so how would I solve similar problems to these? Thanks.

Bond Prices

Mullineaux Co. issued 11-year bonds 1 year ago at a coupon rate of 8.25 percent. The bonds make semiannual payments. If theYTM on these bonds is 9.2 percent, what is the current bond price? I tried to work this out on a spreadsheet based on instruction that a TA gave me on a similar problem. Is $426.42 the correct answer t ...continues

Bond Yields

Please explain how to do the following on a spreadsheet. I am having difficulty in doing this. Furst Co. issued 12-year bonds 2 years ago at a coupon rate of 8.4 percent. The bonds make semiannual payments. If these bonds currently sell for 87 percent of par value, what is the YTM?

Bond Yields

BDJ Co. wants to issue new 20-year bonds for some much-needed expansion projects. The company currently has 9 percent coupon bonds on the market that sell for $1135, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par?

Valuing Preferred Stock

Is there a way to do this on a spreadsheet? If so, please show me. Fuel, Inc., has an issue of preferred stock outstanding that pays a $4.50 dividend every year, in perpetuity. If this issue currently sells for $46 per share, what is the required return?

Finding the Dividend (18)

I cannot figure out the formula to use to get this dividend per share. Tubby Corporation stock currently sells for $64 per share. The market requires a 14 percent return on the firm's stock. If the company maintains a constant 5 percent growth rate in dividends, what was the most recent dividend per share paid on the stock?

Financial analysis of Kerzner International Ltd

Can you tell me who to use the financial report to analysis KZL financial performance, all the financial report you can find at: www.Kerzner.com

Understanding debits and credit

Understanding debits and credit