This website uses cookies to ensure you have the best experience. Learn more

Excel Worksheet Essay

1016 words - 5 pages

1) Assume that the average firm in your company's industry is expected to grow at a constant rate of 4% and that its dividend yield is 7%. Your company is about as risky as the average firm in the industry, but it has just successfully completed some R&D work that leads you to expect that its earnings and dividends will grow at a rate of 50% [D1 = D0(1 + g) = D0(1.50)] this year and 30% the following year, after which growth should return to the 4% industry average. If the last dividend paid (D0) was $2.75, what is the value per share of your firm's stock? Round your answer to the nearest cent. Do not round your intermediate computations.

2) The Moore Corporation had operating ...view middle of the document...

The trees can be harvested in 14 years, at which time W-P plans to sell the forest at an expected price of $10 million. What is W-P's expected rate of return? Round your answer to two decimal places.

7) While Mary Corens was a student at the University of Tennessee, she borrowed $12,000 in student loans at an annual interest rate of 9.10%. If Mary repays $1,500 per year, how long (to the nearest year) will it take her to repay the loan?

8) Wilson Wonders's bonds have 10 years remaining to maturity. Interest is paid annually, the bonds have a $1,000 par value, and the coupon interest rate is 7%. The bonds sell at a price of $985. What is their yield to maturity? Round your answer to two decimal places.

9) The current price of a stock is $33, and the annual risk-free rate is 5%. A call option with a strike price of $32 and 1 year until expiration has a current value of $6.00. What is the value of a put option written on the stock with the same exercise price and expiration date as the call option? Round your answer to the nearest cent.

10) Needham Pharmaceuticals has a profit margin of 4% and an equity multiplier of 1.6. Its sales are $90 million and it has total assets of $40 million. What is its ROE? Round your answer to two decimal places.

11) Thress Industries just paid a dividend of $4.00 a share (i.e., D0 = 4.00). The dividend is expected to grow 9% a year for the next 3 years and then at 13% a year thereafter. What is the expected dividend per share for each of the next 5 years? Round your answers to the nearest cent.
a. D1 = $  

b. D2 = $  

c. D3 = $  

d. D4 = $  

e. D5 = $  
12) Pearson Brothers recently reported an EBITDA of $7.0 million and net income of $1.75...

Other Papers Like Excel Worksheet

Budget Essay

1765 words - 8 pages save a blank worksheet with the following name:“Student’s First InitialLast Name Excel” Example: JSmith ExcelSet Page Layout to Landscape | 0.1 | Use Print Preview to review how spreadsheet would print. | 2 | In the worksheet, insert a Custom Header titled, "My Personal Budget." | 0.25 | This Custom Header text must be Arial 14 point, Bold, and be centered on the page. | 3 | Add a custom Footer with your name in the Left Section and automatic

Critical Thinking Worksheet Appendix I Essay

931 words - 4 pages Critical Thinking Worksheet Associate Level Material Appendix I Critical Thinking Worksheet Chose one of the following scenarios: You are a member of a group working on a class project. The group members are enthusiastic about the project and arrange a meeting time to begin planning. You forget to mark your calendar and miss the meeting. The group posts a summary of the meeting with assignments and deadlines for the project. You

Time To Practice – Week One

918 words - 4 pages ® software, compute all of the measures of variability you can for height and weight. Copy and paste the output from IBM® SPSS® into this worksheet. Variable | Definition | Height | Height in inches | Weight | Weight in pounds | 8. Review the following frequency distribution. Create a histogram either by hand or by using some other application such as a Microsoft® Excel® document. Copy and paste the histogram into this document

Marketing

2855 words - 12 pages MARKETING ENGINEERING FOR EXCEL TUTORIAL VERSION v130522 Tutorial Customer Choice (Logit) Marketing Engineering for Excel is a Microsoft Excel add-in. The software runs from within Microsoft Excel and only with data contained in an Excel spreadsheet. After installing the software, simply open Microsoft Excel. A new menu appears, called “ME XL.” This tutorial refers to the “ME XL/Customer Choice (Logit)” submenu. Overview The

Comp Problem

957 words - 4 pages January 2, 20x3. Required: 1) Prepare any entries to correct the books as of December 31, 20x4. The books for 20x4 have not yet been closed. 2) Be sure to review the existing statements for any other omissions and errors. 3) Prepare in proper and good form the multi-step Income Statement, Statement of Retained Earnings, and the classified Balance sheet for 20x3 and 20x4. 4) Each statement should be on a separate worksheet and

It Request

1521 words - 7 pages worksheet by the Training and Development specialist. The recruiters for Riordan Manufacturing each maintain applicant information for open positions. Employee resumes are kept in a central storage area, and an Excel spreadsheet is used to track the status of applicants. Riordan manufacturing has outsourced workers’ compensation to a third-party provider which keeps its own records. The current HR system that Riordan manufacturing maintains

Five

4343 words - 18 pages the Job Placement Office in the Student Services building, Room 178. DUE: Two weeks prior to the end of the semester Activity Credit earned: 1 Hour Resume: See Resume instructions, worksheet and sample in this handbook. Additional help is available in the Job Placement Office in the Student Services building, Room 178. DUE: Two weeks prior to the end of the semester Activity Credit earned: 2 Hours Computer Guidance Program (Career Center

1. Perform A Quantitative Insourcing/Outsourcing Analysis Using The Data Provided. What Qualitative Issues Might Affect Your Final Decision? Identify Any Costs Or Issues That Are Not Part Of Your...

4548 words - 19 pages a process or technology, which contributes to greater cost differentials between firms. ▪ Firms will increasingly focus on what they excel at while outsourcing areas of non-expertise. Some organizations are formally defining their core competencies to help guide the insourcing/outsourcing effort. This has affected decisions concerning what businesses a firm should engage. ▪ The need for responsiveness in the marketplace is

Insoucring/Outsourcing Case

4548 words - 19 pages a process or technology, which contributes to greater cost differentials between firms. ▪ Firms will increasingly focus on what they excel at while outsourcing areas of non-expertise. Some organizations are formally defining their core competencies to help guide the insourcing/outsourcing effort. This has affected decisions concerning what businesses a firm should engage. ▪ The need for responsiveness in the marketplace is

Lafarge S.A

2924 words - 12 pages NAME: IHEKANANDU KINGSLEY N. COURSE: MGMT 292 / F12 N01 TITLE: INDIVIDUAL CASE STUDY (LAFARGE S.A.) SUBMITTED: October 5, 2012 TABLE OF CONTENTS 2. INTRODUCTION 3 3. DESCRIPTION OF CASE 4 4. VALUES 4 4.1. Types of values 4 5. TEAMWORK 7 6. MOTIVATION 8 7. CREATIVITY 9 7.1. Components of creativity 9 8. CONCLUSION 12 9. BIBLIOGRAPHY 13 INTRODUCTION This report aims to provide an in-depth analysis of initiatives pursued by Lafarge as

Finance

665 words - 3 pages Financial statements are the most common tool used for making business decisions. They consist of the balance sheet, income statement and statement of cash flows. The analysis tools used affect all aspects of a company not just a few. A systematic review of the resources a company used to achieve its mission is cost control. Cash flow should be kept at necessary levels for operations is one of the major benefits of cost control. It is a very

Related Essays

Integration Feature Essay

1322 words - 6 pages Integration Feature Linking an Excel Worksheet and Chart 5/24/2011 Northwestern Business College Gloria Gallegos Table of Contents Introduction 3 Linking an Excel Worksheet and Chart 4 Excel Basics 4 To Link an Excel Worksheet to a Word Document 4 To Link an Excel Chart to a Word Document 7 Table of Figures 8 Index 9 Introduction With Microsoft Office, you can copy part or all of a project created in one Office program

Nothing Essay

2545 words - 11 pages +SPACEBAR displays the Control menu for the Excel window. | TAB | Moves one cell to the right in a worksheet.Moves between unlocked cells in a protected worksheet.Moves to the next option or option group in a dialog box.SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box.CTRL+TAB switches to the next tab in dialog box.CTRL+SHIFT+TAB switches to the previous tab in a dialog box. | Auditing Excel 2010

Test 1 Essay

414 words - 2 pages Question 1 (13 marks total) Open the Excel worksheet top-10-mobile-phones-in-use.xlsx The spreadsheet contains details of the top 10 countries of the world in terms of the number of ‘mobile phones in use’ as at 31/12/2012. a) Graph the ‘mobile phones in use’ data appropriately, for the Top 10 countries. (2 marks) b) Graph the ‘proportion’ data appropriately (in a different way from question ‘a’) for the Top 10 countries. (3

Business Essay

6895 words - 28 pages : Using the Remington’s Zip File (purple icon, in week 1 of Moodle): (2) o In a 1 – 2 page ‘Word’ or ‘Excel’ document do the following: o Part 1: Calculate and interpret the mean, standard deviation and range, for the data in Column K, “The degree of agreement among patrons that Remington’s has large portions,” on the Remington Data worksheet of the Remington’s Data Set workbook. (Be sure to show your calculations either in an