9/10/23, 9:42 PM Assignment Print View

1. Award: 10.00 points

Use the FV function in Excel to answer this problem.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

Attempt(s)

A1

Sheet1

100%READY

Calculating future values – Excel

FILE

Clipboard

Paste

Font

Calibri 11

Alignment Number

Styles

Conditional
Formatting

Format as
Table

Cell
Styles

Cells Editing

INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign InHOME

References

Excel Simulation Difficulty: 1 Basic Section: 5.1 Future Value and Compounding

9/10/23, 9:43 PM Assignment Print View

2. Award: 10.00 points

Use the PV function in Excel to answer this problem.

Attempt(s)

A1

Sheet1

70%READY

Calculating present values – Excel

FILE

Clipboard

Paste

Font

Calibri 11

Alignment Number

Styles

Conditional
Formatting

Format as
Table

Cell
Styles

Cells Editing

INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign InHOME

References

Excel Simulation Difficulty: 1 Basic Section: 5.2 Present Value and Discounting

9/10/23, 9:44 PM Assignment Print View

3. Award: 10.00 points

Use the RATE function in Excel to answer this problem.

Attempt(s)

A1

Sheet1

100%READY

Calculating interest rates – Excel

FILE

Clipboard

Paste

Font

Calibri 11

Alignment Number

Styles

Conditional
Formatting

Format as
Table

Cell
Styles

Cells Editing

INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign InHOME

References

Excel Simulation Difficulty: 1 Basic Section: 5.3 More about Present and Future Values

9/10/23, 9:45 PM Assignment Print View

4. Award: 10.00 points

Use the NPER function in Excel to answer this problem.

Attempt(s)

A1

Sheet1

100%READY

Calculating the number of periods – Excel

FILE

Clipboard

Paste

Font

Calibri 11

Alignment Number

Styles

Conditional
Formatting

Format as
Table

Cell
Styles

Cells Editing

INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign InHOME

References

Excel Simulation Difficulty: 1 Basic Section: 5.3 More about Present and Future Values

9/10/23, 9:45 PM Assignment Print View

5. Award: 10.00 points

Imprudential, Inc., has an unfunded pension liability of $700 million that must be paid in 20 years. To assess
the value of the firm’s stock, financial analysts want to discount this liability back to the present. If the relevant
discount rate is 7.0 percent, what is the present value of this liability? 

$180,893,302

$184,511,168

$195,357,153

$177,275,436

$166,421,838

References

Multiple Choice Difficulty: Basic Learning Objective: 05-2

9/10/23, 9:46 PM Assignment Print View

6. Award: 10.00 points

You have just made your first $3,000 contribution to your retirement account. Assume you earn an 8 percent
annual rate of return and make no additional contributions.

Required:
(a) What will your account be worth when you retire in 40 years?

(Click to select)

(b) What will your account be worth if you wait 7 years before contributing?

(Click to select)

References

Worksheet Difficulty: Intermediate Learning Objective: 05-1

9/10/23, 9:46 PM Assignment Print View

7. Award: 10.00 points

You’re trying to save to buy a new $150,000 Ferrari. You have $34,000 today that can be invested at your
bank. The bank pays 5.0 percent annual interest on its accounts. How long will it be before you have enough
to buy the car?

NOTE: In this problem there is only one cash flow (chapter 5 problem). FV = PV (1+r)t is the equation you use.
In this problem you are solving for t.

30.67 years

28.42 years

30.92 years

30.42 years

30.17 years

References

Multiple Choice Difficulty: Basic Learning Objective: 05-4

9/10/23, 9:48 PM Assignment Print View

10. Award: 10.00 points

A zero coupon bond with a face value of $1,000 is issued with an initial price of $350. The bond matures in 14 years. What is the implicit annual interest rate
on the bond?
NOTE: Assume all bonds (unless otherwise noted) have a $1,000 face value, which is a promise to pay $1,000 at maturity (when the loan comes due). When
bonds pay interest over the life of the loan, we refer to these interest payments as coupons. A zero coupon is a pure discount loan, so it pays no coupons.
That is, it is a bond where the company agrees to borrow money today in exchange for a single payment ($1,000) at maturity. U.S. Treasury Bills mentioned
in the text book are an example.

9.79%

8.79%

6.79%

7.79%

5.79%

References

Multiple Choice Learning Objective: 07-01
Important bond features and
types of bonds.

Difficulty: Medium Section: 7.4

9/10/23, 9:47 PM Assignment Print View

8. Award: 10.00 points

You are scheduled to receive $43,000 in two years. When you receive it, you will invest it for 7 more years at
7.5 percent per year. How much will you have in 9 years?

rev: 09_17_2012

$74,906.07

$82,441.26

$50,257.42

$71,339.11

$67,772.16

9/10/23, 9:48 PM Assignment Print View

9. Award: 10.00 points

In January 2007, the average price of an asset was $28,158. 8 years earlier, the average price was $21,908.
What was the annual increase in selling price?

3.51%

2.87%

-3.09%

3.19%

3.82%

References

Multiple Choice Difficulty: Basic Learning Objective: 05-3

  • Assignment Print View
  • Assignment Print View1
  • Assignment Print View2
  • Assignment Print View3
  • Assignment Print View4
  • Assignment Print View5
  • Assignment Print View6
  • Assignment Print View10
  • Assignment Print View67
  • Assignment Print View103

Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.

"Do you have an upcoming essay or assignment due?


Get any topic done in as little as 6 hours

If yes Order Similar Paper

All of our assignments are originally produced, unique, and free of plagiarism.