Assignment 2 Excel And Microsoft Due 01/03

Answer all of the following questions/problems and submit them to your mentor in a Word document.

You should use a financial calculator and Excel to solve the problems.

Remember: You must export your table(s) from Excel to Word before submitting your work.

 

 

 

  1. Discuss the importance of financial statements and how they are used by businesses.
  1. What is the basic format of the income statement and what is the relevance of the basic categories?
  1. Cash flows for an organization come from operating activities and investment activities. Discuss the importance of each to the organization.
  1. The Happy Auto Shop has the following annual information:

 

Gross Sales $700,000
Net sales $696,000
Gross profit $448,000

What are the shop’s returns and allowances and cost of goods sold?

 

  1. Construct a statement of financial position (balance sheet) for the Humperdink family using the following information:

 

cash $50
Checking account $2,500
student loan balance $6,000
stocks and bonds $2,600
savings account $5,850
residence $110,000
automobile $12,000
savings account $5,800
automobile loan balance $12,000
401K retirement account $15,000
furniture, clothing, jewelry $8,000
credit card balance $4,000
mortgage loan balance $99,000

 

  1. What is the purpose of financial statement analysis?  How do the three types of financial statement analysis differ from each other and when is each used?
  1. Samantha Knight is applying for a small-business loan. She provides the bank with the following information:

 

cash in checking accounts $5,000
cash in savings $10,350
home market value $145,500
first mortgage on house $25,000
home equity loan limit $70,000
home equity loan $10,000
automobile market value $19,000
automobile loan outstanding $15,000
credit card debt $1,500

 

    1. Calculate the debt-to-asset ratio.
    2. Calculate the debt-to-equity ratio.
    3. What percentage of Samantha’s assets is owned by others?

 

  1. Given the profit loss (income statement) and balance sheet for Sam’s Sandwich Delivery (Table 4-8, page 121 of your textbook), answer the following:
    1. Calculate the following ratios: current, quick, accounts receivable turnover, fixed asset turnover.
    2. Using the inventory figure on the balance sheet as average inventory, calculate the inventory turnover ratio.
    3. Calculate the debt-to-equity ratio, debt-to-total asset ratio, and operating profit margin ratio.
    4. Perform a vertical analysis of the income statement.
    5. Perform a vertical analysis of the balance sheet.
    6. Based on your analysis, would you consider investing in Sam’s Sandwich Delivery?

School Versus Work, Bonus Versus Stock

Part III Prompt
The results of both sections of your employment examination have finally been received, and you were offered the position. You have a few important decisions
to make before you can formally accept or decline the position. When composing your answers to these decisions, ensure that they are cohesive and read like a
short essay.
Your submission must address the following critical elements:
I. School Versus Work
A. The school you would like to attend costs $100,000. To help finance your education, you need to choose whether or not to sell your 1,000
shares of Apple stock, 1,000 EE Savings Bonds (with $100 denominations and 4.25% coupon rate) that are five years from their 30-year maturity
date, or a combination of both. Provide the appropriate data and calculations that you would perform to make this decision.
B. What are the advantages and disadvantages of selling a combination of stocks and bonds? Be sure to support your answers.
C. Suppose that you choose to sell your stocks, bonds, or a combination of both. What is your choice, and what is your financial reasoning behind
this choice? Consider supporting your answer with quantitative data.
D. Suppose that you choose to accept the job. What is your financial reasoning behind this choice? Be sure to support your answer with
quantitative data.
II. Bonus Versus Stock
A. The company has offered you a $5,000 bonus, which you may receive today, or 100 shares of the company’s stock, which has a current stock
price of $50 per share. Mathematically, what is the best choice? Why?
B. What are the advantages and disadvantages of each option? Be sure to support your answers.
C. What would you ultimately choose to do? What is your financial reasoning behind this choice? Consider supporting your answer with
quantitative data

The Types Of Exercise Students Engage

1.  Of the following research topics, which is most likely to be an observational study?

[removed] The relationship between hours of exercise and sleep.
[removed] The difference in minutes a day exercising between boys and girls.
[removed] The types of exercise students engage in after school.
[removed] Students’ feelings about after-school track practice.

 

2.     Correlational research allows the researcher to answer questions such as:

[removed] what is the relationship between Variable A and Variable B?
[removed] does change in Variable A cause change in Variable B?
[removed] is there a significant difference between scores on Variable A and scores on Variable B?
[removed] does change in Variable B causes change in Variable A?

3.    Which of the following is an example of a good research question for a correlational study?

[removed] What are the attitudes of the parents about our districts new homework policy?
[removed] Is there a relationship between student achievement and homework completion?
[removed] Are there differences in parent attitudes about homework between mothers and fathers?
[removed] How much homework does the average fifth grade teacher in our district assign?

4.    Advantages of questionnaires include all of the following EXCEPT:

[removed] large numbers of people can be contacted for a relatively low cost.
[removed] data can be gathered from a large number of people in a relatively short period of time.
[removed] participants may feel more confident about their anonymity and therefore respond more honestly.
[removed] because questions are in written form, they are less likely to be misunderstood by respondents.

5.    Regarding the length of questionnaires to be used in survey research, which of the following statements is most accurate?

[removed] Including a large number of items on the survey assures that you will get useful data for all of your trouble.
[removed] Keeping the survey short makes it more likely people will be willing to complete it.
[removed] A relatively lengthy survey communicates your seriousness about the research endeavor so people will be more willing to complete it.
[removed] Shorter surveys produce data that are ambiguous and therefore not useful.

6.    Qualitative research often involves what’s known as an iterative process for data collection and analysis. This terminology refers to the fact that, in qualitative research:

[removed] researchers focus more on narrative data than on statistics and numbers.
[removed] researchers typically do not begin by stating a hypothesis.
[removed] researchers may collect and analyze data, then collect and analyze some more data.
[removed] researchers first ask open-ended questions and then follow up with probing questions.

7.    In this type of study design, a particular group of individuals is studied in depth over a defined period of time.

[removed] case study
[removed] ethnography
[removed] phenomenology
[removed] grounded theory

 

8.    In this type of study design, the researcher studies the deep meaning an event or situation holds for other people.

[removed] phenomenological
[removed] ethnography
[removed] grounded theory
[removed] content analysis

9.    Carl Compost has been living and working on a communal organic farm for the past six months. He wants to understand the political, environmental, and social perspectives shared by the members of the commune. Dr. Compost is probably employing which of the following qualitative research designs?

[removed] case study
[removed] ethnographic
[removed] phenomenological
[removed] content analysis

10. Daniel Daring is an emerging playwright whose works have begun to stir great passions in the major U.S. cities where they are staged. Researcher Eugenia Edge is “shadowing” Mr. Daring for six months in an attempt to understand the artistic process. Dr. Edge is probably employing which of the following qualitative research designs?

[removed] case study
[removed] grounded theory
[removed] phenomenological
[removed] content analysis

 

 

11. Helen Heartwell flew to New York City a few weeks after the September 11, 2001, bombing of the World Trade Center. She wanted to know how the victims of the attack were making sense of what had happened to them. Dr. Heartwell is probably employing which of the following qualitative research designs?

[removed] case study
[removed] grounded theory
[removed] phenomenological
[removed] Ethnographic

12. The technique of participant observation is most associated with:

[removed] case study
[removed] ethnography.
[removed] grounded theory
[removed] content analysis

13. Qualitative researchers often begin by asking themselves, “What needs to be studied?” and then collect preliminary data that helps to develop a more focused research question and a plan for later data collection. This type of design is known as:

[removed] emerging design
[removed] case study design
[removed] qualitative design
[removed] mixed methods design

14. Qualitative researchers can best address concerns about validity in their study design and their data by:

[removed] collecting some quantitative data
[removed] ensuring that all participants provide informed consent
[removed] use one objective, reliable method for collecting data
[removed] comparing different data sources to see if they provide consistent results

15. Effective qualitative interviews usually require that the researcher:

[removed] adhere to set of questions determined in advance.
[removed] maintain an informal, friendly atmosphere.
[removed] remain as objective and detached as possible.
[removed] interview several participants at one time.

Spanish Homework Help A+ Rated

  • Daniela y yo vamos a las montañas.
    • No nos queda nada.
    • Nos encanta esquiar.
    • Nos aburren los paisajes.
  • Ellas no quieren ir al museo.
    • Les aburre el arte.
    • Les importan los cuadros (paintings) de Picasso.
    • Les molesta conducir.
  • La señorita Ríos trabaja en una agencia de viajes.
    • Le molesta el turismo.
    • Le interesa conocer otros países.
    • Le faltan dos maletas.
  • Usted tiene que ir al banco (bank).
    • Le faltan cincuenta dólares.
    • Le interesa viajar.
    • Le queda la chaqueta.
  • El señor García es profesor.
    • No le importa la cultura inca.
    • Le molestan las computadoras.
    • Le fascina enseñar filosofía.

Completar

Fill in the blanks with the correct present tense form of the verbs in parentheses. Include the indirect object pronoun.

  • A Ernesto y a Alejandro el golf. (fascinar)
  • A la señora Robles las ruinas de Machu Picchu. (interesar)
  • A ustedes cantar y bailar. (aburrir)
  • A mí la educación. (importar)
  • A nosotros ducharnos con agua fría. (molestar)

Oraciones

Write sentences using the information provided. Use the preterite or the present tense as indicated and make any necessary changes.

  • (a ti) / molestar / despertarse / temprano (presente)
  • (a José) / quedar / bien / zapatos / anaranjado (pretérito)
  • ¿(a ustedes) / encantar / sus vacaciones / playa? (pretérito)
  • (a Carlos y a mí) / aburrir / clases de sociología (presente)

En el cine

Complete the paragraph with the appropriate word(s).

  • Ayer mis amigos Esteban, Ana, Olivia y yo fuimos al cine a ver la nueva película de Javier Bardem. A mí me (1) la película porque Javier es uno de mis actores favoritos. Pero a (2) le (3) ; él empezó a dormirse al final. A Ana y (4) Olivia les molestaron las escenas (scenes) violentas. Si tengo que criticar algo de la película, digo que le faltaron más escenas con Javier, pero entiendo que (5) director le importó más el argumento (plot). Y a (6) , ¿te interesan las películas extranjeras?

Need an original Assignment:

Need an original Assignment: The “issue” of Stakeholder Management and Corporate Performance.

You are to write a minimum, 2 page essay, on this week’s subject matter per below. Also, please cite at least two (2) outside sources. This assignment does NOT have to be in APA format. You will also find a guide for your essay below.

Sociologist Erving Goffman has pointed out that all social groups including professionals develop a protective attitude toward members of their group, even when what some of the members do is seen as morally wrong. A sense of loyalty to the group often overrides what they would otherwise deem immoral.

Consider the arguments for and against exposing Stakeholders with whom you are personally close or with whom you have close professional ties. Develop a position on this issue that could serve as a guide for anyone in such a position with regard to Corporate Performance.

*Some Essay Guidelines*

What is a critical thinking essay?

Many college assignments require you to support a thesis. The concept of a critical thinking essay is that you start without an end in mind. You don’t necessarily know how you feel about a subject or what you want to say about the subject … you allow the research and your own thinking to determine the outcome. This is writing to learn rather than writing to prove what you know.

The critical thinking essay has you look at and contribute to a range of arguments rather than just one at a time. Critical thinking essays consider the strengths and weaknesses of various solutions to a problem or various answers to a question. It requires thinking … not information reporting.

The critical thinking essay starts with a question, not a thesis. Your essay shows how your thinking changes as you research a topic. For example, when you begin researching capital punishment, you may be in favor of the death penalty because it is a deterrent. Then you may find some studies that question whether it has a deterrent effect and that may influence your thinking. You don’t have to know what you think about your topic when you start writing your critical thinking essay.

Critical thinking essay format.

Essays are shorter pieces of writing. Therefore, essays are (by nature) concise and require you to be clear and to the point. This means that there is no room for your thoughts to wander or stray … you must be deliberate and stay on topic.

Perhaps it is helpful to think of an essay in terms of a conversation or debate with a classmate. If you and I were discussing whether or not there should be a death penalty in the US, there would be a beginning, middle and end to our conversation. As with a conversation, your essay must be complete, and logically so, leaving no doubt as to your intent or argument.

However – again, think of this as a conversation – your essay shouldn’t be formal. Remember, you’re talking about your ideas and thought processes. Don’t try to do that in third person! To help you stay on topic, your critical thinking essay should be organized as follows.

Essay Outline

Introduction (1-2 paragraphs)

a) Focus on explaining the topic.

Body (minimum of 4-5 paragraphs but use as many as necessary. Several short paragraphs are better than 1-2 overly long paragraphs)

Write your body before your write your introduction and conclusion.

Examine all aspects of the topic. Show your knowledge and grasp of the material you have read.

a) Discuss the differing opinions of the topic as reflected in the research.

b) Discuss any issues or problems.

c) Did you have enough information?

d) Did the research raise issues you hadn’t considered?

e) Did the research contain confusing, incomplete or contradictory information?

f) Explain how your research influenced your thinking.

g) If your thinking has changed, what changed it?

h) If your thinking has not changed, how did what you learned support your original opinion?

i) If you’re not sure about your opinion, what information might you need to form an opinion?

Conclusion (generally 1 paragraph)

a) The conclusion rounds off the essay.

b) Refer back to your main ideas or points and reiterate your answer to the question.

c) NEVER introduce new information in your conclusion.

d) The conclusion moves from specific to general.

Unit 100

Please read the Harvard Case Study: “eBay Inc.: Internet Success or Fairy Tale?” by David F. Hawkins and Jacob Cohen. This case study can be found in the Harvard Case Study website.

Please answer the following questions about the case study:

  1. Use the 2002 Financial Statement data to replicate the Meyer’s report calculations that illustrate the following conclusion based on the 2001 data reached in the report: eBay has never been profitable. Why? Why not?
  2. Do you agree with Meyer’s report concept of “unfettered” cash flow? Why? Why not?
  3. What other conclusions can you reach about the company from the case study?

It has to be 300 word long . I have attach the case study .

Financial Ratio Analysis Grading Guide

Financial Ratio Analysis Grading Guide

FIN/571 Version 9

Foundations of Corporate Finance

University of phoenix school of business

Individual Assignment: Financial Ratio Analysis

Purpose of Assignment

The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions.

Resources Required

Microsoft® Excel®

 

Content

Met

Partially    Met

Not    Met

Comments:

 

Selected a Fortune 500 Company   from one of the following industries:

  • Pharmaceutical
  • Energy
  • Retail
  • Automotive
  • Computer Hardware

 

Reviewed the balance sheet and income statement in the company’s 2015   Annual Report.

 

Calculated the following ratios   using Microsoft® Excel®:

  • Current Ratio
  • Quick Ratio
  • Debt Equity Ratio
  • Inventory Turnover Ratio
  • Receivables Turnover Ratio
  • Total Assets Turnover Ratio
  • Profit Margin (Net Margin) Ratio
  • Return on Assets Ratio

 

Analyzed in 1,050 words why each   ratio is important for financial decision making.

 

Total   Available

Total   Earned

 

5

#/5

 

Writing Guidelines

Met

Partially    Met

Not    Met

Comments:

 

The paper—including tables and   graphs, headings, title page, and reference page—is consistent with APA   formatting guidelines and meets course-level requirements.

 

Intellectual property is recognized   with in-text citations and a reference page.

 

Paragraph and sentence transitions   are present, logical, and maintain the flow throughout the paper.

 

Sentences are complete, clear, and   concise.

 

Rules of grammar and usage are   followed including spelling and punctuation.

 

Total   Available

Total   Earned

 

3

#/3

 

Assignment Total

#

8

#/8

 

Additional comments:

Managerial Finance Chapter 4-7

In the percent-of-sales forecasting method, all of the following balance sheet and income statement items are
assumed to increase proportionately with sales EXCEPT:
Pro forma financial statements are used to:
Cash budgeting can be employed effectively by management to
The first step in cash budget preparation is the
Computerized financial planning models may be classified as any of the following except:
Pro forma financial statements show the results of some ____ event rather than a (an) ____ event
Peerless believes that its sales next year will increase 20 percent from the current level of $800,000.
Management calculates that assets must increase $110,000 to support the new sales level, and current
liabilities will increase $70,000. What total financing will be needed?
Calculate United’s total assets if the firm expects sales to grow 15 percent this year and the earnings after tax
will be $50,000. United paid $20,000 in dividends last year and expects to increase dividends 10 percent this
year. The firm will need additional financing of $25,000 to finance the expected growth. United started the
year with $40,000 in accounts payable; $30,000 in notes payable; and $100,000 in long-term debt. The
company is operating at full capacity.
The financial statement that shows the effects of a company’s operating, investing, and financing activities on
its cash balance is known as the:
The Financial Accounting Standard Board (FASB) requires companies to prepare their statement of cash
flows using the:

 

Which of the following shows the effects of a company’s operating, investing, and financing activities on its
cash flows?
The Hudson River Line Company has a balance sheet as of the end of the year as follows:
Cash $ 5,000 Accounts Payable $ 15,000
Accounts Receivable 20,000 Notes Payable 10,000
Inventories 40,000 Total Current Liab. 25,000
Total Current Assets $ 65,000 Long-term Debt 30,000
Fixed Assets, net 50,000 Stockholder’s Equity 60,000
Total Assets $115,000 Total Liabilities & Equity $115,000
Last year, the firm had sales of $148,750. This year the company expects sales to increase 25%, to generate
earnings after tax of $16,000, and to pay a dividend of $5,000. Hudson operated its fixed assets at 85%
capacity last year. What additional financing will be needed to support the sales increase?
Which of the following is an example of a deterministic model?
Short-term operational plans are generally conducted over what time frame?
The first step in the preparation of a cash budget is:
The values shown in ordinary annuity tables (either present value or compound value) can be adjusted to the
annuity due form by ____ the ordinary annuity interest factor by ____.
An annuity due is one in which
The effective rate of interest will always be ____ the nominal rate.
Comet Powder Company has purchased a piece of equipment costing $100,000. It is expected to generate a
ten-year stream of benefits amounting to $16,273 per year. Determine the rate of return Comet expects to earn
from this equipment.

You sold 100 shares of stock today for $30 per share that you paid $20 for 6 years ago. Determine the average
annual rate of return on your investment, assuming the stock paid no dividends.

 

Designs Now is opening a showcase office to display and sell it’s computer designed poster art. Designs
expects cash flows to be $120,000 in the first year, $180,000 in the second year, $240,000 in the third year. If
Designs uses 11 percent as its discount rate, what is the present value of the cash flows?
Joe Brady just won a $450,000 lottery in Pennsylvania. Instead of receiving a lump sum, he found that he
would receive $22,500 annually (end of year) for 20 years. Joe is 75 years old and wants his money now. He
has been offered $140,827 to sell his ticket. What rate of return is the buyer expecting to make if Joe accepts
the offer?
Your brother, who is 6 years old, just received a trust fund that will be worth $25,000 when he is 21 years old.
If the fund earns 10 percent interest compounded annually, what is the value of the fund today?

A zero coupon bond with a $1,000 par value is selling for $356 and matures in 12 years. What is the implied
discount rate (yield to maturity)?

Your local bank offers 4-year certificates of deposit (CD) at a 12 percent annual nominal interest rate
compounded quarterly. Determine how much additional interest you will earn over 4 years on a $10,000 CD
that is compounded quarterly compared with one that is compounded annually.

 

 

 

You plan to lease a Saab automobile that sells for $22,657 and has no salvage value. If the monthly lease is
$499, with the first of 60 payments due immediately. What is the implied annual interest rate on your lease?

 

What is the present value of the following net cash flows if the discount rate is 12%:
Year Cash Flow
1-5 $10,000 each year
6-10 $15,000 each year
11-15 $17,000 each year
What is the present value of the following net cash flows if the discount rate is 10%?
Year Net Cash Flow
1-10 $20,000 each year
11-15 $15,000 each year
16-20 $10,000 each year
Your monthly statement from your bank credit card shows that the monthly rate of interest is 1.5%. What is
the annual effective rate of interest you are being charged on your credit card?

What monthly rate of interest will yield an annual effective rate of interest of 14%?

Al Corbin is 25 years old today and he wishes to accumulate enough money over the next 35 years to provide
for a 20 year retirement annuity of $100,000 at the beginning of each year, starting with his 60th birthday. He
can save $2,000 at the end of each of the next 10 years and $3,000 each year for the following 10 years. How
much must he save each year at the end of years 21 through 35 to obtain his goal? Assume that the average
rate of return over the entire period will be 10%.

Assume you purchased a home and borrowed $100,000 at a rate of 8% compounded monthly over 30 years.
What is your monthly payment?

 

 

Which of the following statements is/are correct?
I. At 6% interest, the present value of: $400 for the first year, $600 for the second year, and $800 for the third
year is $1,603.00.
II. The future value of a mixed cash flow stream (if it is from an annuity due): $400 for the first year, $600 for
the second year, and $800 for the third year is $1,999 (rounded).

 

 

 

Determine the present value of $5,000 to be received 4 years from now at the continuously discounted rate of
8 percent.

First Texas National Bank is offering a one-year CD with a nominal rate of 9.5 percent. If compounding
occurs continuously, what is the effective annual rate?

Zero coupon bonds are an example of
The basic relationship in bond valuation is for a given percentage point change in the required rate of return, the ____ the time to maturity, the ____ the change in value.
. The following bond quotation indicates that the holder expects to receive ____ in interest annually:
PAC EI 11s 09 11.6 20 95 -1
A Treasury bill with 182 days to maturity is quoted at 5.62 bid, 5.60 asked, and an asked yield of 5.84. How much would you pay for this security?

A WPI 10s 08 bond closed at 89. What is the current yield on this bond?

Assume that the dividend on Central Power Company’s $3.25 preferred stock issue is paid annually at the end of the year. Determine the value of this preferred stock to an investor who requires a 12 percent rate of return.

Mid-States Utility Company sold a 10-year note with a 7 7/8% coupon and a par value of $1,000. If the note sold at a discount for $930, what was the implied yield-to-maturity to the nearest tenth of one percent? Assume interest is paid semiannually.

 

 

 

. Baywa has an outstanding bond that has a coupon rate of 8.3%. What is the market price of this bond if it pays interest semi-annually, has 15 years to maturity, and the current required rate of return is 9% on bonds of similar quality?

. King World zero coupon bonds were issued in 1998 at $124. These bonds will mature in 2018. What will these bonds sell for in 2008 if the required rate of return in 2008 is 9.5%?

 

 

 

 

A U.S. Government bond was quoted at 95:13 “bid” and 95:15 “asked”. How much would you have to pay for one of these $1,000.00 face value bonds?

UOP, a petroleum processing technology firm, issued a 10% coupon, 20 year to maturity first mortgage bond five years ago. If the current market rate of debt for UOP is 8%, at what price should this bond sell, to the nearest dollar? Assume a par value of $1,000, and pays interest semi-annually

 

 

 

What is the yield to maturity of a TVA bond that has a 9 1/2 percent coupon, pays interest semi-annually, has 12 years to maturity, and sells for $871.50?

 

 

 

 

 

. What is the yield-to-maturity of an Acme bond selling for $1107.50 with 5 years to maturity, a 12 1/2% coupon, and semi-annual compounding?

 

 

 

Debt is usually issued with a par value of
The largest user of mortgage bonds is
Stockholders’ equity includes all of the following except:
Common stockholders have a number of general rights, including all of the following except:
A change in the market price of an asset will occur as a result of changes in:
The valuation of common stock is considerably more complicated than the valuation of bonds or preferred stocks because:
From an accounting standpoint, stock dividends involve a transfer from the
____ result in what is known as treasury stock.
From the following stock quotation, what is AT&T’s dividend yield?
ATT 1.20 4.3 19 1667 29.50 29 29 -.25
The P/E ratio indicates
Assume that the dividend ($3.25) on Central Power Company’s common stock issue is paid annually at the end of the year. This dividend is not expected to increase for the foreseeable future. Determine the value of this stock to an investor who requires a 12 percent rate of return.

The earnings and dividends of MicroSun Computer Co. are expected to grow at an annual rate of 15 percent over the next 4 years and then slow to a constant growth rate of 8 percent per year. MicroSun currently pays a dividend of $0.50 per share. What is the value of MicroSun stock to an investor who requires a 14 percent rate of return?

 

 

 

 

Lawton Company common stock currently sells for $38 and pays (year 0) a dividend of $2. Determine the implied growth rate for Lawton assuming that an investor’s required rate of return is 12% and that the stock can be evaluated using a constant growth valuation model.

 

Helix common stock currently sells for $30 and its current dividend is $1.50. If the required rate of return on Helix stock is 15%, what is the implied growth rate of its earnings and dividends?

 

Over the past 10 years the dividends of Allegro have grown from $0.45 to $1.82 per share. Determine the value of Allegro’s common stock to an investor who requires a 20% rate of return, assuming that dividends continue growing at the same rate as they grew over the past 10 years.

 

 

What is the estimated price of Once in a Blue Moon stock that has the following dividends? The return on similar investments is 18%. (Round the growth rate to the nearest whole percent)
YEAR DIVIDENDS
2003 $2.50
2002 $2.48
2001 $2.36
2000 $2.32

All of the following are ways that securities are offered to the public in a public offering EXCEPT:
a. Securities are sold through competitive bidding
b. Securities are sold through negotiated underwriting to a purchasing syndicate
c. Securities are sold through excess-market pricing
d. Securities are sold on a best efforts basis

Finance Test 1 (52 Question)

1Question: If inflation is anticipated to be 5 percent during the next year, while the real rate of interest for a one-year loan is 5 percent, then what should the nominal rate of interest be for a risk-free one-year loan?

A    5 percent
B    10 percent
C    25 percent
D    None of the above

2 Question: Which one of the following statements is not true?
A    The value of a dollar invested at a positive interest rate grows over time
B    The further in the future you receive a dollar, the less it is worth today
C    A dollar in hand today is worth more than a dollar to be received in the future
D    The further in the future you receive a dollar, the more it is worth today

3 Question: Efficiency ratio: Jet, Inc., has net sales of $712,478 and accounts receivables of $167,435. What are the firm’s accounts receivables turnover and days’ sales outstanding?
A    0.24 times; 78.5 days
B    4.26 times; 85.7 days
C    5.2 times; 61.3 days
D    None of the above

4 Question: If you have loaned capital to a firm, then you could be
A    A shareholder
B    A stakeholder
C    A partner
D    All of the above

5 Question: Which one of the following is not an advantage of using ROE as a goal?
A    ROE is highly correlated with shareholder wealth maximization
B    ROE and the DuPont analysis allow management to break down the performance and identify areas of strengths and weaknesses
C    ROE does not consider risk
D    All of the above are advantages of using ROE as a goal

  • attachment

    test.docx

Ponzi Corporation Has Bonds On The Market With 14.5 Years To Maturity, A YTM

Problem 1:

Interpreting Bond Yields.  Is the yield to maturity on a bond the same thing as the required return?  Is the YTM the same thing as the coupon rate?  Suppose today a 10 percent coupon bond sells at par.  Two years from now, the required return on the same bond is 8 percent.  What is the coupon rate of the bond then?  The YTM?

Problem 3:

Valuing Bonds.  Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual €1,000, 25 years to maturity, and a coupon rate of 6.4 percent paid annually.  If the yield to maturity is 7.5 percent, what is the current price of the bond?

Problem 8:

Coupon Rates.  Ponzi Corporation has bonds on the market with 14.5 years to maturity, a YTM of 6.1 percent, and a current price of 1,038.  The bonds make semiannual payments.  What must the coupon rte be on these bonds?

Problem 10:

Inflation and Nominal Returns.  Suppose the real rate is 2.5 percent and the inflation rate is 4.1 percent.  What rate would you expect to see on a Treasury bill?

Problem 12:

Nominal versus Real Returns.  Say you own an asset that had a total return last year of 10.7 percent.  If the inflation rate last year was 3.7 percent, what was the real return?

Problem 14:

Using Treasury Quotes.  Is this a premium or discount bond? What is the current yield?  What is it’s yielded to maturity?  What is the bid-ask spread?

Maturity:  August 2029

Coupon:  6.125

Bid:  123:13

Asked:  123:15

Change: -58

Asked Yield: 4.2790

 

Problem 17:

Interest Rate Risk.  Bond J is a 3 percent coupon bond.  Bond K is a 9 percent coupon bond.  Both bonds have 15 years to maturity, make semiannual payments, and have a YTM of 6 percent.  If interest rates suddenly rise by 2 percent, what is the percentage price change of these bonds?  What if rates suddenly fall by 2 percent instead?  What does this problem tell you about the interest rate risk of lower-coupon bonds?

Problem 18:

Bond Yields.  Martin Software has 9.2 percent coupon bonds on the market with 18 years to maturity.  The bonds make semiannual payments and currently sell for 106.8 percent of par.  What is the current yield on the bonds?  They YTM? The effective annual yield?

Problem 26:

Zero Coupon Bonds.  Suppose your company needs to raise $45 million and you want to issue 30-year bonds for this purpose.  Assume the required return on your bond issue will be 6 percent, and you’re evaluating two issue alternatives: a 6 percent semiannual coupon bond and a zero coupon bond.  Your company’s tax rate is 35 percent.

a.       How many of the coupon bonds would you need to issue to raise the $45 million?  How many of the zeros would you need to issue?

b.      In 30 years, will your company’s repayment be if you issue the coupon bonds?  What if you issue the zeroes?

c.       Based on your answers in (a) and (b), why would you ever want to issue the zeroes?  To answer, calculate the firm’s aftertax cash outflows for the first year under the two different scenarios.  Assume the IRS amortization rules apply for the zero coupon bonds.

Problem 28:

Real Cash Flows.  You want to have $2 million in real dollars in an account when you retire in 40 years.  The nominal return on your investment is 10 percent and the inflation rate is 3.8 percent.  What real amount must you deposit each year to achieve your goal?