1 | Data | Description |
2 | Finance rate | 4% |
3 | Reinvestment rate | 5% |
4 | Initial Investment cost | - $5,000 |
5 | Cash inflow from year 1 | $1,200 |
6 | Cash inflow from year 2 | $1,350 |
7 | Cash inflow from year 3 | $1,400 |
8 | Cash inflow from year 4 | $1,300 |
9 | MIRR | = |
1 Data Description 2 Finance rate 4% 3 Reinvestment rate 5% 4 Initial Investment cost -...
1 Data Description 2 Initial Investment cost - $5,000 3 Cash inflow from year 1 $1,200 4 Cash inflow from year 2 $1,350 5 Cash inflow from year 3 $1,400 6 Cash inflow from year 4 $1,300 7 8 IRR =
1 Data Description 2 Annual Discount Rate 10% 3 Initial Investment cost – $5,000 4 Cash inflow from year 1 $1,800 5 Cash inflow from year 2 $2,100 6 Cash inflow from year 3 $1,950 7 8 Net Present Value =
Short problem-solving questions (5 pts per question) Capital expenditure data for Project A Initial Investment Expected Cash Inflow:s Year 1 Year 2 Year 3 Year Year 5 $3,000 S5,000 $5,000 $2,000 $2,000 $15,000 (1) Calculate payback period for Project A (2) If the cash inflow in Year 4 were S5,000 instead of $2,000, calculate the payback period. 3 Investment A will generate S 150,000 (DCE)) our years rom now and investment B will generate $120 000 ive years rom now....
16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present Value (NPV) if the required rate of return is 12% per year? Period Cash Flow 0 $0 1 $100 2 $200 3 $300 4 $400 5 $500 Remember that Excel’s NPV function doesn't really calculate the net present value. Instead, it simply calculates the present value of...
CH. 9 WORKSHEET NPV and Other Investment Criteria For Problems 1-4, use a 5% discount rate and the following cash flows for projects A and B.: A: (-$2000, $500, $600, $700, $800) B: (-$2000, $950, $850, $400, $300) 1. Calculate the payback period for projects A and B. 2. Calculate the internal rate of return for projects A and B. 3. If A and B are mutually exclusive and the required rate of return is 5%, which should be accepted?...
1.) Fuzzy Button Clothing Company is analyzing a project that requires an initial investment of $450,000. The project’s expected cash flows are: Year Cash Flow Year 1 $300,000 Year 2 –125,000 Year 3 400,000 Year 4 500,000 Fuzzy Button Clothing Company’s WACC is 7%, and the project has the same risk as the firm’s average project. Calculate this project’s modified internal rate of return (MIRR): a.) 24.54% b.) 18.70% c.) 21.03% d.) 23.37% 2.) If Fuzzy Button Clothing Company’s managers...
Year 0 1 2 3 Cash Flow -$750,000 $450,000 $200,000 $250,000 Given the cash flows and assuming the firm’s finance rate and reinvestment rate is 10%, what is the MIRR of the project?
QUESTION 5 Consider the following sequence of year-end cash flows: EOY 1 2 4 Cash Flow $1,000 $1,100 $1,200 $1,300 $1,400 What is the uniform annual equivalent (to the nearest whole dollar) if the interest rate is 2% per year? (Do not enter a dollar sign $ with your answer.)
QUESTION 5 Consider the following sequence of year-end cash flows: EOY 1 2 4 Cash Flow $1,000 $1,100 $1,200 $1,300 $1,400 What is the uniform annual equivalent (to the nearest...
Cold Goose Metal Works Inc. is analyzing a project that requires an initial investment of $500,000. The project's expected cash flows are: Year Year 1 Year 2 Year 3 Year 4 Cash Flow $300,000 -175,000 475,000 425,000 Cold Goose Metal Works Inc.'s WACC is 9%, and the project has the same risk as the firm's average project. Calculate this project's modified internal rate of return (MIRR): O 19.75% 22.71% 17.78% O 23.70% this If Cold Goose Metal Works Inc.'s managers...
Cute Camel Woodcraft Company is analyzing a project that requires an initial investment of $500,000. The project's expected cash flows are: Year 1 Year 2 Year 3 Year 4 $275,000 -150,000 500,000 400,000 Cute Camel Woodcraft Company's WACC is 9%, and the project has the same risk as the firm's average project. Calculate this project's modified 21.06% 18.05% 19.06% 20.06% If Cute Camel Woodcraft Company's managers select projects based on the MIRR criterion, they should this independent project. Which of...