# assist fin

### Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.

Order a Similar Paper Order a Different Paper

## Module 2

Trident University |

FIN301: Principles of Finance |

Module 2: SLP Template |

FILL IN ALL CELLS THAT ARE HIGHLIGHTED IN YELLOW |

Please remember to save this file with your last name in the file name. For example: FIN301 Module 2 SLP Template, Doe.doc |

Name: |

STOCK 1 FOR RISK AVERSE INVESTOR |

Company Name: |

Ticker Symbol: |

Reason for Buying: |

Current Price: |

Previous Close Price: |

52-week High: |

52-week Low: |

Beta: |

Market Cap: |

P/E Ratio: |

STOCK 2 FOR RISK LOVING INVESTOR |

Company Name: |

Ticker Symbol: |

Reason for Buying: |

Current Price: |

Previous Close Price: |

52-week High: |

52-week Low: |

Beta: |

Market Cap: |

P/E Ratio: |

STOCK 3 FOR RISK NEUTRAL INVESTOR |

Company Name: |

Ticker Symbol: |

Reason for Buying: |

Current Price: |

Previous Close Price: |

52-week High: |

52-week Low: |

Beta: |

Market Cap: |

P/E Ratio: |

## Questions 1 and 2

Trident University |

FIN301: Principles of Finance |

Module 2: Case Template |

FILL IN ALL CELLS THAT ARE HIGHLIGHTED IN YELLOW |

Please remember to save this file with your last name in the file name. For example: FIN301 Module 2 Case Template, Doe.doc |

Name: |

QUESTION 1: Compute the future value for the following: |

a $2,000 after being invested for two years in a savings account with 3% interest rate |

FUTURE VALUE = |

b. $5,000 after being invested for ten years in a savings account with a 1% interest rate |

FUTURE VALUE = |

c. $3,500 after being invested for nine years in a savings account with an 11% interest rate |

FUTURE VALUE = |

QUESTION 2: Compute the present value for the following: |

a. $3,000 to be paid in one year with a 9% discount rate |

PRESENT VALUE = |

b. $3,000 to be paid in three years with a 9% discount rate |

PRESENT VALUE = |

c. $4,000 to be paid in ten years with a 5% discount rate |

PRESENT VALUE = |

NOTE: YOU CAN EITHER USE THE EXCEL FORMULA FOR FUTURE VALUE OR CALCULATE BY HAND USING THE FUTURE VALUE FORMULA. THE TAB LABELED “Help for Future Value” IN THIS WORKBOOK WALKS YOU THROUGH USING THE EXCEL FORMULA. IF YOU PREFER TO CALCULATE BY HAND USING THE FUTURE VALUE FORMULA, IT IS: FV = PV(1+r)t

NOTE: YOU CAN EITHER USE THE EXCEL FORMULA FOR PRESENT VALUE OR CALCULATE BY HAND USING THE PRESENT VALUE FORMULA. THE TAB LABELED “Help for Present Value” IN THIS WORKBOOK WALKS YOU THROUGH USING THE EXCEL FORMULA. IF YOU PREFER TO CALCULATE BY HAND USING THE PRESENT VALUE FORMULA, IT IS: PV = FV/(1+r)t

## Questions 3 – 5

QUESTION 3: Compute the present value for the following: |

a. An investment that will pay you $1,000 in one year, another $1,000 in two years, and a third payment of $1,000 in three years (e.g., three payments of $1,000 to be paid once a year for three years). The discount rate is 4%. |

PRESENT VALUE = |

b. The same three $1,000 payments as in part a) above, but with a 6% discount rate |

PRESENT VALUE = |

c. An investment that will pay you $2,000 in one year, another $1,500 in two years, and a third payment of $3,000 in three years. The discount rate is 4%. |

PRESENT VALUE = |

QUESTION 4: Compute the value of the following bonds assuming a 3% discount rate (required rate of return) |

a. A zero-coupon bond that pays $1,000 in five years (Hint: PMT = 0) |

BOND PRICE (PRESENT VALUE) = |

b. A bond that pays $1,000 in five years, with five annual coupon payments of $20 each |

BOND PRICE (PRESENT VALUE) = |

c. What is the coupon rate if coupon payments are $20 per year? At what discount rate would the value of the bond be “at par” (e.g., be worth $1,000?). Explain your reasoning. |

COUPON RATE = |

DISCOUNT RATE IF VALUE AT PAR = |

EXPLAIN ANSWER FOR DISCOUNT RATE ABOVE = |

QUESTION 5: This part of the assignment is purely conceptual with no computations required. Explain the following with references to the required readings: |

What is likely to happen to interest rates if the rate of inflation suddenly increases? |

ANSWER: |

Suppose there are two bonds each with coupon payments of $50. The first bond pays $1,000 in five years, and the other one pays $1,000 in ten years. If interest rates increased, would the value of the bonds increase or decrease? |

ANSWER: |

Which of the two bonds would have their value change more after the increase in interest rates? |

ANSWER: |

Explain your reasoning to your answer above. |

ANSWER: |

NOTE: YOU CAN EITHER USE THE EXCEL FORMULA FOR NET PRESENT VALUE OR CALCULATE BY HAND USING THE PRESENT VALUE FORMULA. THE TAB LABELED “Help for Multiple Cash Flows Q3” IN THIS WORKBOOK WALKS YOU THROUGH USING THE EXCEL FORMULA. IF YOU PREFER TO CALCULATE BY HAND USING THE PRESENT VALUE FORMULA, IT IS: PV = FV/(1+r)t

NOTE: BOND PRICE CAN BE FOUND BY USING THE PRESENT VALUE FORMULA. YOU CAN EITHER USE THE EXCEL FORMULA FOR PRESENT VALUE OR CALCULATE BY HAND USING THE PRESENT VALUE FORMULA FOR EACH CASH FLOW.

IF USING THE EXCEL FORMULA:

RATE = DISCOUNT RATE

NPER = NUMBER OF TIMES PERIODS UNTIL THE BOND MATURES

PMT = COUPON PAYMENT

FV = FACE VALUE

INCREASE

DECREASE

STAY THE SAME

THE VALUE OF THE FIRST BOND PAYING $1,000 IN FIVE YEARS WOULD CHANGE MORE

THE VALUE OF THE SECOND BOND PAYING $1,000 IN TEN YEARS WOULD CHANGE MORE

THE VALUES OF THE BONDS WOULD NOT CHANGE

THE VALUES OF THE BONDS WOULD CHANGE BY THE SAME AMOUNT

## Help for Future Value Q1

TO COMPUTE FUTURE VALUE IN EXCEL: | |

STEP 1: INSERT THE FUTURE VALUE (FV) FORMULA. CHOOSE THE FORMULAS TAB – FINANCIAL – FV (SEE BELOW). YOU CAN ALSO INSERT THE FORMULA BY TYPING =FV IN ANY CELL. | |

STEP 2: FILL OUT EACH OF THE FIELDS IN THE FUTURE VALUE WINDOW | |

RATE = INTEREST RATE, ENTERED AS A PERCENT OR DECIMAL | |

NPER = NUMBER OF TIME PERIODS THE INVESTMENT WILL ACCRUE INTEREST | |

PMT = 0 UNLESS PAYMENTS ARE MADE | |

PV = THIS IS THE PRESENT VALUE OF THE INVESTMENT; IF YOU ARE PUTTING MONEY INTO AN ACCOUNT, YOU WILL NEED TO INCLUDE A NEGATIVE (-) BEFORE IT TO INDICATE THE MONEY IS LEAVING YOUR POCKET AND GOING INTO AN ACCOUNT | |

TYPE = LEAVE AS 0, WHICH INDICATES INTEREST IS PAID AT THE END OF EACH TIME PERIOD | |

FOR THE SAMPLE WINDOW BELOW, $2,000 WAS PUT INTO AN ACCOUNT THAT EARNED 3% INTEREST FOR 1 YEAR. AT THE END OF THAT ONE YEAR, THE ACCOUNT BALANCE WAS $2,060. | |

YOU COULD ALSO USE THE FUTURE VALUE FORMULA AND HAND CALCULATE: FV = PV(1+r)t | |

FV = 2000(1+.03)1 | |

FV = 2060 |

## Help for Present Value Q2

TO COMPUTE PRESENT VALUE IN EXCEL: | |

STEP 1: INSERT THE PRESENT VALUE (PV) FORMULA. CHOOSE THE FORMULAS TAB – FINANCIAL – PV (SEE BELOW). YOU CAN ALSO INSERT THE FORMULA BY TYPING =PV IN ANY CELL. | |

STEP 2: FILL OUT EACH OF THE FIELDS IN THE PRESENT VALUE WINDOW | |

RATE = INTEREST RATE, ENTERED AS A PERCENT OR DECIMAL | |

NPER = NUMBER OF TIME PERIODS THE INVESTMENT WILL ACCRUE INTEREST | |

PMT = 0 UNLESS PAYMENTS ARE MADE | |

FV = THIS IS THE FUTURE VALUE OF THE INVESTMENT | |

TYPE = LEAVE AS 0, WHICH INDICATES INTEREST IS PAID AT THE END OF EACH TIME PERIOD | |

FOR THE SAMPLE WINDOW BELOW, AN INVESTOR WANTS TO WITHDRAW $3,000 IN 2 YEARS. THE INVESTMENT WILL EARN 9% INTEREST. HOW MUCH WOULD NEED TO BE INVESTED TODAY? THE INVESTOR WOULD NEED TO PUT $2,525.04 INTO AN ACCOUNT. | |

YOU COULD ALSO USE THE PRESENT VALUE FORMULA AND HAND CALCULATE: PV = FV/(1+r)t | |

PV = 3000/(1+.09)2 | |

PV = 2525.04 |

## Help for Mutiple Cash Flows Q3

TO COMPUTE THE PRESENT VALUE FOR MULTIPLE CASH FLOWS IN EXCEL: | |||||||||||||

STEP 1: INSERT THE PRESENT VALUE (NPV) FORMULA. CHOOSE THE FORMULAS TAB – FINANCIAL – NPV (SEE BELOW). YOU CAN ALSO INSERT THE FORMULA BY TYPING =NPV IN ANY CELL. | |||||||||||||

STEP 2: FILL OUT EACH OF THE FIELDS IN THE NET PRESENT VALUE WINDOW | |||||||||||||

RATE = INTEREST RATE, ENTERED AS A PERCENT OR DECIMAL | |||||||||||||

VALUE 1 = FIRST CASH FLOW | |||||||||||||

VALUE 2 = SECOND CASH FLOW | |||||||||||||

VALUE 3, ETC. = ALL SUBSEQUENT CASH FLOWS | |||||||||||||

FOR THE SAMPLE WINDOW BELOW, AN INVESTOR WANTS TO WITHDRAW $1,000 EVERY YEAR FOR THE NEXT 4 YEARS. | |||||||||||||

THE INVESTMENT WILL EARN 5% INTEREST. HOW MUCH WOULD NEED TO BE INVESTED TODAY TO BE ABLE TO MAKE THESE WITHDRAWALS? | |||||||||||||

THE INVESTOR WOULD NEED TO PUT $3,545.95 INTO AN ACCOUNT. | |||||||||||||

YOU COULD ALSO USE THE PRESENT VALUE FORMULA FOR EACH CASH FLOW AND HAND CALCULATE: PV = FV/(1+r)t | |||||||||||||

ONCE YOU HAVE THE PRESENT VALUE FOR EACH CASH FLOW, YOU WOULD THEN THESE PRESENT VALUES TOGETHER. | |||||||||||||

PV = 1000/(1+.05)1 | PV = 1000/(1+.05)2 | PV = 1000/(1+.05)3 | PV = 1000/(1+.05)4 | ||||||||||

PV = 952.38 | PV = 907.03 | PV = 863.84 | PV = 822.70 | TOTAL = $3,545.95 |

## image1.png

## image2.png

## image3.png

## image4.png

## image5.png

## image6.png

**Present Value and Bond Valuation**

**Assignment Overview**

This assignment is in a different direction than your Module 1 Case in that it is mostly computational in nature. Before starting this assignment, work through some of the examples in the background readings to make sure you understand all of the steps involved in future value and present value, including use of present value formulas to compute the value of a bond.

**Case Assignment**

Please download the

__Case 2 Template__

. You will type your answers into this document. Save the document with your last name and submit to the dropbox. Note that you will get partial credit if you show your work even if the answers are incorrect.

1. Compute the future value for the following:

a. $2,000 after being invested for two years in a savings account with 3% interest rate

b. $5,000 after being invested for ten years in a savings account with a 1% interest rate

c. $3,500 after being invested for nine years in a savings account with an 11% interest rate

2. Compute the present value for the following:

a. $3,000 to be paid in one year with a 9% discount rate

b. $3,000 to be paid in three years with a 9% discount rate

c. $4,000 to be paid in ten years with a 5% discount rate

3. Compute the present value for the following:

a. An investment that will pay you $1,000 in one year, another $1,000 in two years, and a third payment of $1,000 in three years (e.g., three payments of $1,000 to be paid once a year for three years). The discount rate is 4%.

b. The same three $1,000 payments as in part a) above, but with a 6% discount rate

c. An investment that will pay you $2,000 in one year, another $1,500 in two years, and a third payment of $3,000 in three years. The discount rate is 4%.

4. Compute the value of the following bonds assuming a 3% discount rate (required rate of return):

a. A zero-coupon bond that pays $1,000 in five years

b. A bond that pays $1,000 in five years, with five annual coupon payments of $20 each

c. What is the coupon rate if coupon payments are $20 per year? At what discount rate would the value of the bond be “at par” (e.g., be worth $1,000?). Explain your reasoning.

5. This part of the assignment is purely conceptual with no computations required. Explain the following with references to the required readings:

a. What is likely to happen to interest rates if the rate of inflation suddenly increases?

b. Suppose there are two bonds each with coupon payments of $50. The first bond pays $1,000 in five years, and the other one pays $1,000 in ten years. If interest rates increased, would the value of the bonds increase or decrease? Which of the two bonds would have their value change more after the increase in interest rates? Explain your reasoning.

Answer the assignment questions directly.

· Stay focused on the precise assignment questions. Do not go off on tangents or devote a lot of space to summarizing general background materials.

· For computational problems, make sure to show your work and explain your steps.

Part 2

**Virtual Stock Exchange Project**

**Module 2 SLP Assignment **

· Make 3 stock purchases and provide information about the purchases

Please download the

__Module 2 SLP template__

. You will type your answer into this Excel workbook. When finished with the SLP assignment, please save the document with your last name and submit to the dropbox.

1. Purchase 4: Assume you are a very risk averse investor (you don’t like risk). Buy at least $10,000 worth of a company’s stock that is appropriate given your risk preference.

2. Purchase 5: Assume you are a very risk loving investor (you LOVE risk). Buy at least $10,000 worth of a company’s stock that is appropriate given your risk preference.

3. Purchase 6: Assume you are an investor willing to accept average market risk (the Beta of the stock should be around 1). Buy at least $10,000 worth of a company’s stock that is appropriate given your risk preference.

You are free to make additional purchases, but you only need to explain the reasoning behind your required purchases 4 through 6.

4. You will need to include the following information for each stock in this workbook:

· Company Name

· Ticker Symbol

· Reason for Buying

· Current Price

· Previous Close Price

· 52-week High

· 52-week Low

· Beta

· Market Cap

· P/E Ratio

**SLP Assignment Expectations**

· Answer the assignment questions directly.

· Stay focused on the precise assignment questions. Do not go off on tangents or devote a lot of space to summarizing general background materials.

· For computational problems, make sure to show your work and explain your steps.

## image1.jpeg

### Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.

Order a Similar Paper Order a Different Paper