How much will an organization have in five years

Assignment Help Financial Management

Reference no: EM131215438

Solve each problem using Excel. Show both the solution and the formula you used (by putting an apostrophe in front of the equals sign). Double-check each solution using your financial calculator. (Note: This assignment does not require that you understand the mechanics of the investment instruments. We will discuss investments later in the semester.)

1. How much will an organization have in five years if it invests $5,000in a certificate of deposit (CD) account with a 2.25% annual interest rate, compounded:

a) Monthly

b) Daily

2. How much must an organization invest in a mutual fund today in order to sell its shares for $50,000 in three years, assuming the average annual market return will be 9%,compounded biweekly (i.e., every two weeks)?

3. An organization plans to save $10,000 per month for a new building.The organization also will invest$15,000 it already has in reserves. (Hint: Whena problem involves monthly payments, assume monthly compounding.)

a) What annual rate of return must the organization earn in order to accumulate $800,000 at the end of five years?

b) If the organization can only earn an annual rate of 6%, how many years will it need to accumulate $800,000?

4. A small, private college is starting a scholarship fund. The college's fund managers expect the investments in the fund will earn an average annual return of 8%.

a) If the college deposits $10,000 into the scholarship fund on the first day of each month, how much money will be in the fund in 20 years?

b) After those 20 years have passed, how much in scholarship money can the college pay out on the first of each monthfor the next 25 years? (Assume the college will cease deposits into the fund.)

5. Ten years ago, an organization took out a $350,000 30-year mortgage with a 4.75% annual interest rate. Now, it is taking advantage of low interest rates to refinance the mortgage.The organization will pay $7,600 in up-front fees for a new 30-year mortgagewith a 2.5% annual interest rate. The organization can earn an annual return of 2% on any money it saves.

a) The new mortgage will be $300,000-enough to pay off the old mortgage and buy some new furniture. Ignoring the up-front fees for now, how much will the organization save each month by refinancing?(Hint: Mortgage payments are monthly cash outflows.)

b) How many years will it takethe organization to recover the up-front fees? (Hint: Treat the savings as a monthly cash inflow.)

c) How much money will the organization save in total (in today's dollars) over the next 20 years?

6. Do the reading assignment for the next class (Chapter 5 p. 176-end and Chapter 6) and then answer the following reading comprehension questions:

a) A manager is trying to decide which of two delivery vans to buy. One has a higher sticker price but is more fuel-efficient (and thus will have lower annual fuel costs) and is also expected to last two years longer than the other van. Which tool should the manager use to make her decision: net present cost, annualized cost, net present value, or internal rate of return? Explain.

b) An investor bought a $1,000 bond with a coupon rate of 5%. Shortly after he bought it, the market interest rate dropped to 4%. He is confused about how this will affect the value of his bond. Write a few sentences explaining whether his bond is now worth more or less than $1,000, and why. (You do not need to calculate the bond's value.)

Reference no: EM131215438

Questions Cloud

Calculate the cheung combined annual after-tax income : Calculate the Cheung's combined annual after-tax income. (Assume they are exempt from the Medicare levy surcharge because they have private health insurance in Alan's name)

Explore ancient mesopotamia and ancient egypt : Write a 500- to 700-word paper in which you explore ancient Mesopotamia and ancient Egypt.

Violate the civil rights of certain individuals : According to Truman, to violate the civil rights of certain individuals is to fundamentally oppose what American ideal?

What was his goal and unique style of life that could be use : What was his/her goal and unique style of life that could be used to achieve this goal? What steps did this person take to overcome their perceived inferiority?

How much will an organization have in five years : Financial Management - How much will an organization have in five years if it invests $5,000in a certificate of deposit (CD) account with a 2.25% annual interest rate. How much must an organization invest in a mutual fund today in order to sell its..

Anti-discrimination laws related to employment : Prepare 10 illegal questions that must not be asked. For each question, be sure to justify your reasoning. Prepare 10 legal questions that may be asked during the interview. For each question, be sure to justify each question.

Interactions with individuals and cultures : Bus 3505 - Self-Cultural Identity Analysis - Carry out the following two assessments and answer the associated questions in complete and correct sentences and using a separate section of your written report for each assessment, duly labelled. (Each..

Write a paper that discuss your selected public policy issue : Write a paper of no more than 700 words in which you discuss your selected public policy issues. Complete the following for each identified public policy issue. Introduce and identify the problem.

How many realizations of the vector may be generated : How many realizations of the vector may be generated? List them. - Are the realizations independent of one another?

User Account

All Pages