# SOLUTION: FIN 310 Great Basin College Stocks Capital Gains Yield Worksheet

I need help with a Accounting question. All explanations and answers will be used to help me learn.

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. Finknautle, Inc. currently has the following sources of financing for its balance sheet. After analyzing each source of financing, answer the question associated with each. (Please carry all answers out to two decimal places.) 1. An issue of \$1,000 face value, 6% coupon bonds that mature in 22 years.What is the value of one such bond if investors require a rate of return of 6%? ___________2. An issue of \$1,000 face value, 3% coupon bonds that mature in 25 years. Calculate the price of these bonds 15 years from now if market rates at that time are at 6%. ____________3. An issue of \$1,000 face value, zero coupon bonds which mature in 25 years. What is the value of one such bond if investors require a rate of return of 4.5%? ____________4. An issue of \$1,000 face value, 7% coupon bonds which mature in 19 years. Calculate the bond’s yield-to-maturity if its current market price is \$1,260. ___________5. An issue of 6% preferred stock with a par value of \$50. Calculate the price of one share of such stock when investors require a rate of return of 8%. ___________6. An issue of \$5 preferred stock with a par value of \$30. Calculate the required rate of return on such stock if its market price is \$57. __________7. An issue of common stock that paid a dividend yesterday of \$2.40. Calculate the value of one share of this stock to an investor who requires a 10% rate of return and who forecasts that the company’s dividends will grow at a constant annual rate of 4%. ___________8. An issue of common stock that paid a dividend yesterday of \$3.70, and is currently priced at \$50 per share. Calculate this stock’s current dividend yield for the coming year if investors anticipate the company’s dividends to grow for the foreseeable future at a rate of 5%. _____________9. An issue of common stock that paid a dividend yesterday of \$2.15, and is currently priced at \$70 per share. Calculate this stock’s capital gains yield if investors anticipate the company’s dividends to grow for the foreseeable future at a rate of 4%. _____________10. An issue of common stock that paid a dividend yesterday of \$4.71, and is currently priced at \$62 per share. Calculate this stock’s total rate of return if investors anticipate the company’s dividend to grow for the foreseeable future at a rate of 5%. _____________

Our Basic features
• Free title page and bibliography
• Plagiarism-free guarantee
• Unlimited revisions
• Money-back guarantee
Our Options
• Writer’s samples
• Overnight delivery
• Part-by-part delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our customer is the center of what we do and thus we offer 100% original essays..
By ordering our essays, you are guaranteed the best quality through our qualified experts.All your information and everything that you do on our website is kept completely confidential.

### Money-back guarantee

Academicwritingcompany.com always strives to give you the best of its services. As a custom essay writing service, we are 100% sure of our services. That is why we ensure that our guarantee of money-back stands, always

### Zero-plagiarism tolerance guarantee

The paper that you order at academicwritingcompany.com is 100% original. We ensure that regardless of the position you are, be it with urgent deadlines or hard essays, we give you a paper that is free of plagiarism. We even check our orders with the most advanced anti-plagiarism software in the industry.

### Free-revision guarantee

The Academicwritingcompany.com thrives on excellence and thus we help ensure the Customer’s total satisfaction with the completed Order.To do so, we provide a Free Revision policy as a courtesy service. To receive free revision the Academic writing Company requires that the you provide the request within Fifteen (14) days since the completion date and within a period of thirty (30) days for dissertations and research papers.

### Privacy and Security policy

With Academicwritingcompan.com, your privacy is the most important aspect. First, the academic writing company will never resell your personal information, which include credit cards, to any third party. Not even your lecturer on institution will know that you bought an essay from our academic writing company.