Problem 5-35 Value of mixed streams. Find the present value of the streams of cash flows...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 5-35 Value of mixed streams. Find the present value of the streams of cash flows shown in the following table. Assume that the firm's opportunity cost is 12%. Important: Do not use cell references to cells in rows 7 to 11. For all required answers, use cell references to values starting in row 16. A B C Year 1 Cash flow $ Year Cash flow Year Cash flow -2,000 1 $ 10,000 1-5 2 3,000 2-5 5,000/yr 6-10 $10,000/yr 8,000/yr 3 4,000 6 7,000 4 6,000 5 8,000 Solution Project A Opportunity cost 12% CF1 $ -2.000 CF2 S 3.000 CF3 $ 4.000 CF4 S 6.000 CF5 S 8.000 Net present value Project B Opportunity cost 12% CF1 $ 10.000 CF2 S 5.000 CF3 S 5.000 CF4 $ 5.000 CF5 $ 5.000 CF6 $ 7.000 Net present value Project C Opportunity cost 12% CF1 $ 10.000 CF2 S 10.000 CF3 $ 10.000 CF4 $ 10.000 CF5 $ 10.000 CF6 $ 8.000 CF7 S 8.000 CF8 S 8.000 CF9 S 8.000 CF10 S 8.000 Net present value quirements Points 1 In cell E22, by using cell references to the given data and the function NPV, calculate the net present value of project A. 1 2 In cell E32, by using cell references to the given data and the function NPV, calculate the net present value of project B. 1 3 In cell E46, by using cell references to the given data and the function NPV, calculate the net present value of project C. 4 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 1 0 Problem 5-35 Value of mixed streams. Find the present value of the streams of cash flows shown in the following table. Assume that the firm's opportunity cost is 12%. Important: Do not use cell references to cells in rows 7 to 11. For all required answers, use cell references to values starting in row 16. A B C Year 1 Cash flow $ Year Cash flow Year Cash flow -2,000 1 $ 10,000 1-5 2 3,000 2-5 5,000/yr 6-10 $10,000/yr 8,000/yr 3 4,000 6 7,000 4 6,000 5 8,000 Solution Project A Opportunity cost 12% CF1 $ -2.000 CF2 S 3.000 CF3 $ 4.000 CF4 S 6.000 CF5 S 8.000 Net present value Project B Opportunity cost 12% CF1 $ 10.000 CF2 S 5.000 CF3 S 5.000 CF4 $ 5.000 CF5 $ 5.000 CF6 $ 7.000 Net present value Project C Opportunity cost 12% CF1 $ 10.000 CF2 S 10.000 CF3 $ 10.000 CF4 $ 10.000 CF5 $ 10.000 CF6 $ 8.000 CF7 S 8.000 CF8 S 8.000 CF9 S 8.000 CF10 S 8.000 Net present value quirements Points 1 In cell E22, by using cell references to the given data and the function NPV, calculate the net present value of project A. 1 2 In cell E32, by using cell references to the given data and the function NPV, calculate the net present value of project B. 1 3 In cell E46, by using cell references to the given data and the function NPV, calculate the net present value of project C. 4 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 1 0
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Adam Hoover bought 72 shares of General Oil Co. stock at a par value of $85 per share. The stock paid annual dividends of 7 1/2%. How much did Adam receive in dividends this year? Commissions 0. Mrs....
-
Molybdenum forms a substitutional solid solution with tungsten. Compute the weight percent of molybdenum that must be added to tungsten to yield an alloy that contains 1.0 10 22 Mo atoms per cubic...
-
The following information pertains to Sneed Corp. at January 1, 2011. Sneed Corp. completed the following transactions during 2011: 1. Issued 2,000 shares of \(\$ 10\) par common stock for \(\$ 43\)...
-
The adjusted trial balance for Phoenix Consultant Corporation at the end of its fiscal year is shown below. Prepare the required closing entries. Phoenix Consultant Corporation Trial Balance December...
-
On July 1, 2014, Dobbs Co. pays $14,400 to Kalter Insurance Co. for a 3-year insurance contract. Both companies have fiscal years ending December 31. For Dobbs Co., journalize and post the entry on...
-
\ table [ [ te , Activities,Units Acq,uired at Cost,Units Sold at Retail ] , [ nuary 1 , Beginning inventory, 6 0 0 units,@ $ 4 5 per unit, ] , [ bruary 1 0 , Purchase, 4 0 0 units,a $ 4 2 per unit,...
-
Pratt, inc. uses a standard costing system and developed its predetermined overhead rate from the annual flexible budget. The budget is based on an expected annual output of 40,000 units requiring...
-
Roof Wall, V w sky Vi wW i w,floor Vi floor sky Vi floor W Wi floorW 0.45 Vi roofsky 0.50 1.0 0.44 0.38 0.28 0.20 Wall Assuming solar noon with outgoing radiation {100, 125, 150} Wm-2, calculate the...
-
Transfer of Data John needs to transfer a data set of 50,000 tuples from database schema1 to database schema2 . Database schema1 contains table1 , which has seven attributes and database schema2...
-
Below is selected information taken from the balance sheet of CCK Corporation as of 12/31/06. From the operating section of the statement of cash flows, you determine that the depreciation expense...
-
7. The population of Almenia was 14.6 million in 1994. The growth rate is 1.6% per year. What would you expect the population to be in the year 2060? (10 points) 3
-
On January 1, 2024, the Merit Group issued to its bank a $43 million, five-year installment note to be paid in five equal payments at the end of each year. Installment payments of $10.600 million...
-
A recent 10-year study conducted by a research team at the Great Falls Medical School was conducted to assess how age, systolic blood pressure, and smoking relate to the risk of strokes. Risk is...
-
In Problems, solve each system of equations. x + 2y + 3z = 5 y + 11z = 21 5y + 9z = 13
-
Bank Reconciliation (Partial)} The cash account for Feldman Company contains the following information for April: \section*{Required:} Assuming there were no deposits in transit at March 31 and that...
-
Bank Reconciliation} Valentine Investigations has the following information for its cash account: Valentine's bank statement for February contained the following information: A comparison of company...
-
What three elements make up audit risk? Define each.
Study smarter with the SolutionInn App