*Data given is in blue and calculated numbers are in red
Chapter 5 - Section 3
More About Present and Future Values
Finding the interest rate necessary for a present value to reach a desired future value in a desired time period is a relatively simple pro
Because it is given
Each angle has one unique angle
bisector
An angle bisector is a ray whose endpoint is the vertex of the
angle and which divides the angle into two congruent angles.
Reflexive Property. A quantity is congruent to itself.
SAS - If two si
Chapter 001 Introduction to Corporate Finance
Multiple Choice Questions
1. The person generally directly responsible for overseeing the tax management, cost
accounting, financial accounting, and data processing functions is the:
a. treasurer.
b. director.
*Data given is in blue and calculated numbers are in red
Chapter 8 - Section 1
Common Stock Valuation
Constant Dividend Growth
Unlike bond pricing, Excel does not have built-in functions for stock pricing, so we need to create our own equations. We will b
*Data given is in blue and calculated numbers are in red
Chapter 7 - Section 1
Bonds and Bond Valuation
As with any financial instrument, the price of a bond is just the present value of the future cash flows. What is the price of a bond with semiannual c
*Data given is in blue and calculated numbers are in red
Chapter 7 - Section 7
Determinants of Bond Yields
Figure 7.7 in the textbook shows a current Treasury yield curve, as well as the yield curve for last month and last year. Of course, we would like t
*Data given is in blue and calculated numbers are in red
Chapter 8 - Section 3
The Stock Markets
Whenever a stock market is open, stock prices will most likely be changing. While we have used Excel in a way that we can change the inputs, Excel will also g
*Data given is in blue and calculated numbers are in red
Chapter 7 - Section 5
Bond Markets
How many days are there between July 17th and September 1st? When you are dealing with bond prices, the answer depends on who issued the bond! We discussed the a m
*Data given is in blue and calculated numbers are in red
Chapter 6 - Section 4
Loan Types and Loan Amortization
Pure Discount Loans
Pure discount loans are relatively simple since they are nothing more than a lump sum. Suppose we have a pure discount loan
*Data given is in blue and calculated numbers are in red
Chapter 6 - Section 3
Comparing Rates: The Effect of Compounding
Excel has functions to calculate the effective annual rate and the annual percentage rate.
Example 6.8: What's the EAR?
Suppose you m
*Data given is in blue and calculated numbers are in red
Chapter 5 - Section 1
Future Value and Compounding
Excel contains numerous financial functions, many of which relate to the time value of money. We will begin by using equations before moving to Exc
*Data given is in blue and calculated numbers are in red
Chapter 6 - Section 2
Valuing Level Cash Flows: Annuities and Perpetuities
Present Value for Annuity Cash Flows
Finding the present value of an annuity is a simple task in Excel. Remember the Pmt ar
*Data given is in blue and calculated numbers are in red
Chapter 5 - Section 2
Present Value and Discounting
Now that we have used the FV function, we will skip entering an equation to find the present value, but rather talk about the PV function. The PV
*Data given is in blue and calculated numbers are in red
Chapter 6 - Section 1
Present Value and Future Value of Multiple Cash Flows
Future Value of Multiple Unequal Cash Flows
Unfortunately, Excel does not have a function to calculate the future value of
At the heart of marketing there is a transaction.
The reason why a consumer buys a product is because it has value.
A marketing campaign will not be successful with out value
Can Market:
Product
Service
Places
People
Events
Ideals
Where Does Value lay?
Al