Checkout
checkout
view
Your Cart Your Cart: item(s)
View Details $1.99 Download Add to Cart

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.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2371

OTA ID:

102850

View Details $1.99 Download Add to Cart

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?

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2373

OTA ID:

102850

View Details $1.99 Download Add to Cart

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.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2496

OTA ID:

102850

View Details $1.99 Download Add to Cart

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 to this? If not, explain.

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2502

OTA ID:

102309

View Details $1.99 Download Add to Cart

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?

Subject:

Business

Topic:

Accounting/Business Analysis/Financial Reporting

Posting ID:

2503

OTA ID:

102309

Page generated in 0.3043 seconds

About Us ·  Contact Us ·  Samples ·  Solutions ·  Legal Terms and Conditions ·  Privacy Policy

©2008 SolutionLibrary.com

Search for Solutions About Us Samples