Finance with Complete chapter solution you can change values and get solution

profile1 only Paper Writer
 (Not rated)
 (Not rated)
Chat
Home>Homework Answsers>Business & Finance homework help
Chapter 05  
    
Inputs are in Blue   
Answers are in Red   
    
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 
 
 Office button.BMP 
 
 
"Go." Check "Analysis ToolPak" and   
"Solver Add-In," then click "OK."  
    
         

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 

Compute the present value

 

 

 

 

 

 

 

 

 

 

 

of a $100 cash flow for the following combinations 

 of discount rates and times:      
            
 a.r =8.00%,t = 10.00 years.   
 b.r =8.00%,t = 20.00 years.   
 c.r =4.00%,t = 10.00 years.   
 d.r =4.00%,t = 20.00 years.   
            
  Cash Flow   $100.00      

 

 

Compute the future value of a $100 cash flow for the following combinations 
of discount rates and times:      
           

 

Old Time Savings Bank pays 4% interest on its savings accounts. If you deposit  
$1,000 in the bank and leave it there, how much interest will you earn in the first 
year? The second year? The tenth year? 
    

 

 

 

 

A zero-coupon bond that will pay $1,000 in 10 years is selling today for $422.41. 
What interest rate does the bond offer? 

 

 

 

 

 

A famous quarterback just signed a $15 million contract providing $3 million a year for  
5 years. A less famous receiver signed a $14 million 5-year contract providing $4 million
now and $2 million a year for 5 years. Who is better paid? The interest rate is 10%. 
        
        
Quarterback Contract:      
Contract Value  $15.00million    

 

 

 

 In mid-2010 a pound of apples cost $1.26, while oranges cost $1.10. Ten years earlier the price
 of apples was only $.92 a pound and that of oranges was $.70 a pound. What was the annual 
 compound rate of growth in the price of the two fruits? If the same rates of growth persist in the 
 future, what will be the price of apples in 2030? What about the price of oranges? 
If you take out an $8,000 car loan that calls for 48 monthly payments starting after 1 month at an APR   
of 10%, what is your monthly payment? What is the effective annual interest rate on the loan?   
            

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

    • 12 years ago
    Report issue
    Finance with Complete chapter solution you can change values and get solution
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      fundamentals_of_corporate_finance.5_chapter.xls