Question and Problem Sets

User Generated

Nyvpwn17

Business Finance

Description

I have attached the word and excel sheet we need to complete the assigment.

Unformatted Attachment Preview

Ch. 5: Questions 3 & 4 (Question and Problems section): Microsoft® Excel® templates provided for Problems 3 and 4 3. Calculating Present Values [LO2] For each of the following, compute the present value: 4. Calculating Interest Rates [LO3] Solve for the unknown interest rate in each of the following: Ch. 6: Questions 2 & 20 (Questions and Problems section 2. Present Value and Multiple Cash Flows [LO1] Investment X offers to pay you $4,700 per year for eight years, whereas Investment Y offers to pay you $6,700 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 15 percent? 20. Calculating Loan Payments [LO2, 4] You want to buy a new sports coupe for $79,500, and the finance office at the dealership has quoted you an APR of 5.8 percent for a 60-month loan to buy the car. What will your monthly payments be? What is the effective annual rate on this loan? Ch. 7: Questions 3 &11 (Questions and Problems section) 3. Valuing Bonds [LO2] Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of €1,000, 23 years to maturity, and a coupon rate of 5.8 percent paid annually. If the yield to maturity is 4.7 percent, what is the current price of the bond? 11. Valuing Bonds [LO2] Union Local School District has a bond outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity on this bond is 3.9 percent, and the bond has a par value of $5,000. What is the price of the bond? Ch. 8: Questions 1 & 6 (Questions and Problems section): Microsoft® Excel® template provided for Problem 6 1. Valuing Bonds [LO2] Union Local School District has a bond outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity on this bond is 3.9 percent, and the bond has a par value of $5,000. What is the price of the bond? 6. Stock Valuation [LO1] Suppose you know that a company’s stock currently sells for $63 per share and the required return on the stock is 10.5 percent. You also know that the total return on the stock is evenly divided between a capital gains yield and a dividend yield. If it’s the company’s policy to always maintain a constant growth rate in its dividends, what is the current dividend per share? Chapter 8 Problems 4, 6, 7, 32 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." Chapter 8 Question 6 Input area: Stock price Required return Output area: Next year's dividend $ - Current dividend $ - Chapter 5 Problems 1, 2, 3, 4, 5 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." Chapter 5 Question 3 Output area: $ $ $ $ Present value - Input area: Years Interest rate Future value Chapter 5 Question 4 Input area: Present value Output area: Years Interest rate #NUM! #NUM! #NUM! #NUM! Future value
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, I am over with your work. Kindly find attached the work in excel and word format.

Chapter 5
Problems 1, 2, 3, 4, 5
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To install these, click on the Office button
then "Excel Options," "Add-Ins" and select
"Go." Check "Analyis ToolPak" and
"Solver Add-In," then click "OK."

Chapter 5
Question 3
Output area:

$
$
$
$

Present value
5,039.79
39,332.59
1,730.78
3.37

Input area:

Years

Interest rate
13
4
29
40

9%
7%
24%
35%

Future value
$
15,451
$
51,557
$
886,073
$
550,164

Calculations
(i)

From PV=FV (1+i)-n We can apply the formulae and solve each set as follows.
$5,039.79
PV=15,451(1+0.09)-13

(ii)

PV=51,557(1+0.07)-4

$39,332.59

(iii)

PV=886,073(1+0.24)-29

$1,730.78

(iv)

-40

PV= 550164(1+0.35)

$3.37

Chapter 5
Question 4
Input area:

Present value
$

Calculations

(i)

Years
181
335
48,000
40,353

4
18
19
25

Given PV= FV (1+i) -n
Rearranging the equation
(1+i) n = n √ FV÷ PV
4√(1+i) 4= 4√(297÷ 181)

(ii)

18√(1+i)18 = 18√(1080 ÷ 335)

(iii)

19√(1+i) 19 = 19√( 185,382 ÷ 48,000)

(iv)

25√(1+i) 25 = 25√ (531,618÷ 40353)

Output area:

Interest rate
Future value
13.18% $
297
6.72%
1,080
7.37%
185,382
10.86%
531,618

13.18%
6.72%
7.37%
10.86%


Chapter 8
Problems 4, 6, 7, 32
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To install these, click on the Office button
then "Excel Options," "Add-Ins" and select
"Go." Check "Analyis ToolPak" and
"Sol...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags