Question: 7- Consider the irregular cash flow shown below in Excel. What is the Excel formula you would use to solve for the present value
7- Consider the irregular cash flow shown below in Excel. What is the Excel formula you would use to solve for the present value of this cash flow assuming i = 7%? A B 1 t At 2 0 $910 3 1 -$240 4 2 0 5 3 $500 Select answer from the options below =NPV(7%,B3:B5)+910 =NPV(7%,B3:B5) =NPV(7%,B2:B5) 8- Smalltown issued 20-year bonds to finance a project. Smalltown makes interim payments to bondholders every year. The amount of the interim payments is The face or par value, multiplied by the effective interest rate. The face or par value, multiplied by the bond interest rate. The sales price multiplied by the bond rate. The purchase price multiplied by the interest rate. 9- What is the future value of the following cash flow? (+) (-) Answer:... $800 $600 $700 $800 LILI 0 7% 1 7% 2 9%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
