{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter_06 - Ross Westerfield and Jordan's Spreadsheet...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
by Brad Jordan and Joe Smolira Version 9.0 Chapter 6 (Beta In these spreadsheets, you will learn how to use The following conventions are used in these spr 1) Given data in blue 2) Calculations in red NOTE: Some functions used in these spreadsheets may Ross, Westerfield, and Jordan's Spreadsheet Master Fundamentals of Corporate Finance, 9th edition SUM NPV PV of an annuity PMT Annuity interest rate Annuity periods Annuity due EAR APR Exponential function Nested function FV of an annuity Loan amortization worksheet
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
the "Analysis ToolPak" or "Solver Add-In" be installed in To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analysis ToolPak" and "Solver Add-In," then click "OK."
Background image of page 2
a) e the following Excel functions: readsheets: y require that
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
n Excel.
Background image of page 4
Chapter 6 - Section 1 Present Value and Future Value of Multiple Cash Flows Future Value of Multiple Unequal Cash Flows t Cash flow 1 $10,000 2 15,000 3 2,000 4 19,000 5 16,500 Interest rate: 10% t Cash flow 1 $14,641.00 2 19,965.00 3 2,420.00 4 20,900.00 5 16,500.00 Total: $74,426.00 RWJ Excel Tip To add the future values together, we used the SUM function. The SUM function is used so Present Value of Multiple Unequal Cash Flows t Cash flow 1 $8,250,000 2 7,750,000 Unfortunately, Excel does not have a function to calculate the future value of multiple cash future value of individual cash flows and sum them. Suppose we have the following set of c What is the future value of these cash flows? We can set up a table to find the future value year 5, we will use a simple trick. The number of years each cash flow will be compounded number of periods and use the interest rate as an absolute reference. The future value of t To find the present value of multiple unequal cash flows, we will first discuss the same met Chad Johnson's contract which was discussed in the chapter opener. What is the present
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
3 3,250,000 4 4,750,000 5 5,250,000 6 6,250,000 Interest rate: 12% t Cash flow 1 $7,366,071 2 $6,178,253 3 $2,313,286 4 $3,018,711 5 $2,978,991 6 $3,166,445 Total: $25,021,756 Present value: $25,021,756 RWJ Excel Tip The NPV function is located under the Financial functions. We used the following argument We can set up a table to find the present value of each cash flow similar to the table we us is: Excel does have a function that can be utilized to find the present value of unequal cash flo detail later, but for now, we will use it to find the present value of these cash flows. Using th
Background image of page 6
While we could have entered each cash flow individually (Year 1 cash flow as Value 1, Yea Excel automatically places the cash flow one period apart when entered in this manner.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
o often that it has its own button on the Home menu. h flows when the cash flows are of different amounts. However, we can calculate the cash flows: e of each cash flow and sum the future values. Since we want the future value at d is 5 minus the year of the cash flow. So, we will use (5 - current year) as the the cash flows is: thod we used to find the future value of multiple unequal cash flows. Let's look at value of the contract?
Background image of page 8
ts: sed to find the future value of each cash flow. So, the present value of the contract ows, the NPV, or net present value, function. We will discuss NPV in much more he NPV function, the present value of the contract is:
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
ar 2 cash flow as Value 2, etc.,) we chose to enter all of the cash flows as an array.
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}