#### 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 spreadsheet**NO 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:**

Answered

QUALITY

Approved

ANSWER RATING

This question was answered on: * Sep 18, 2020 *

* * Solution~0001185467.zip (25.37 KB)

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 .

#### About this Question

STATUSAnswered

QUALITYApproved

DATE ANSWEREDSep 18, 2020

EXPERTTutor

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).

#### 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.