Question Details

Answered: - Directions: Please place your name in the first cell (A1)


Directions:? Please place your name in the first cell (A1) of the excel spreadsheet.? Work each problem in excel using the appropriate excel function.? There are 11 problems.? Clearly label the answers in excel.? No credit will be given for problems that are not worked with the appropriate excel function.? I must be able to ?see? the excel function used to solve the problem when I click on the answer.? This means that if you work a problem and only type in the answer into the excel spreadsheetNO CREDIT WILL BE GIVEN FOR THAT PROBLEM.?


Excel Assignment

 

5% of overall course grade

 

Due Date: 3:00 pm on Tuesday, April 5, 2016

 

Submission Directions: Submit your excel spreadsheet using file submission on Canvas through the Excel

 

Assignment.

 

Directions: Please place your name in the first cell (A1) of the excel spreadsheet. Work each problem in excel

 

using the appropriate excel function. There are 11 problems. Clearly label the answers in excel. No credit will be

 

given for problems that are not worked with the appropriate excel function. I must be able to ?see? the excel

 

function used to solve the problem when I click on the answer. This means that if you work a problem and only

 

type in the answer into the excel spreadsheet NO CREDIT WILL BE GIVEN FOR THAT PROBLEM. This is not a team

 

or group assignment. You are required to do your own work. If you have a question about one of the problems,

 

please come see me and DO NOT DISCUSS the problem(s) with your classmates. WORKING TOGETHER is not

 

ALLOWED. In your excel spreadsheet, please type the following statements: ?All the work in this spreadsheet is

 

my own work. I did not work with others.?

 

1. (6 points) If you invest $6,000 today and plan to make annual investments of $3,000 per year for the next 30

 

years, how much will you accumulate if your investments earn 9% per year?

 

2. (5 points) If a company doubles its earnings in 9 years, what is the compounded annual growth rate?

 

3. (5 points) How long will it take $5,000 to reach $10,000 when it grows at 8 percent per year?

 

4. (7 points) Suppose you are interested in an investment that will pay you $10,000 (single cash flow) in 15 years.

 

Similar investments are offering a return of 6.5% per year (opportunity cost). What would you be willing to pay for

 

the investment? If the price of the investment is $3,500, would you buy the investment? Explain

 

5. (6 points) Calculate the price of a 9 percent coupon bond with 18 years left to maturity and a market interest

 

rate of 7 percent. Assume the par value is $1,000 and interest payments are semi-annual.

 

6. (6 points) What annual interest rate would you need to earn if you wanted a $500 per month contribution to

 

grow to $1,000,000 in 30 years?

 

7. (14 points) A 6.25 percent coupon bond with 25 years left to maturity can be called in 10 years. The call

 

premium is one year of coupon payments. It is offered for sale at $1,100. The par value is $1,000.

 

a. What is the yield to maturity is the bond offering? (Assume interest payments are paid semi-annually.)

 

b. What is the yield to call of the bond? (Assume that interest payments are paid semi-annually.)

 

8. (14 points) Pam and Tony are planning to retire at age 65. During their retirement, they would like to have

 

quarterly income of $20,000 for 30 years from their retirement account (account will be depleted at the end).

 

a. If they can earn 8% per year on their investments during retirement, how much will they need to have at age 65

 

in their retirement account to meet their quarterly requirements?

 

b. Pam and Tony are both 30 years old. They have not started saving for retirement yet but they plan to make

 

monthly contributions to their retirement account. Given the amount they need to have for retirement from part

 

a., how much do they need to invest each month to meet their retirement needs? Assume they can earn 11% per

 

year on their investments.

 


 

9. (14 points) You wish to buy a house that costs $130,000. You have enough funds saved for a 20 percent down

 

payment. The bank offers you a 25-year mortgage loan at 4.50 percent.

 

a. What are the monthly payments?

 

b. How much interest will you pay over the life of the loan?

 

c. If you pay an extra $100 per month, how long will it take to pay off the mortgage?

 

10. (8 points) You are interested in purchasing a stock. According to your estimates, you will receive a dividend of

 

$1.00 (D1) at the end of this year, $1.10 (D2) at the end of next year, $1.20 (D3) at the end of year three, $1.30

 


 

(D4) at the end of the fourth year, and $1.40 (D5) at the end of the fifth year. Immediately upon receiving the fifth

 

dividend, you expect to sell the stock for $50. If your required rate of return is 9%, what would you be willing to

 

pay for this stock?

 

11. (15 points) Compute the average return, standard deviation, and coefficient of variation for MasterCard and

 

Visa returns for the past five years. Discuss which investment would be preferred.

 


 

2011

 

2012

 

2013

 

2014

 

2015

 


 

MasterCard

 

66

 

32

 

70

 

3

 

13

 


 

Visa

 

44

 

49

 

47

 

18

 

18

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185467.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now