FNCE 623 1 Homework NPV, IRR and other project evaluation criteria. Develop a proposal for the case if UCW wants to invest in a new Program. The project under consideration costs...

1 answer below »
Correct
calculations and
in-depth analysis
using the
concepts from
the topics
studied.
Avoid Grammar mistakes and avoid plagiarism.



FNCE 623 1 Homework NPV, IRR and other project evaluation criteria. Develop a proposal for the case if UCW wants to invest in a new Program. The project under consideration costs $7,000,000, has a 5 (five) years life, and has no salvage value. Depreciation is straight-line to zero. The required return is 17%. Sales are projected at 1,500 students/year. Tuition Fees per student will be $5,500. Variable cost per student will be $2,500, and fixed costs are $1,500,000 per year. Tax rate is 30%. Ignore CCA. Your proposal should contemplate the following questions and problems: Suppose you think that the number of students is accurate to within 15%. Calculate the upper and lower bounds for these projections. (BEST-case and WORST-case scenarios). 1. Calculate the Base-case NPV and IRR (1,500 students/year). Should UCW accept the project based on the base-case scenario? 2. Calculate the BEST-case NPV and the WORST-case NPV and IRR If you look at best and worst-case scenarios, what else should be considered? Will you change your recommendation and why? 3. Calculate other project evaluation criteria that you learned from the textbook and lessons: - Payback period - discounted payback period - breakeven point - profitability index, - average accounting return and explain what it means in terms of this project, how it will influence your decision. Maximum grade: 10% of the total. See the rubric below. FNCE 623 2 Rubric: 0-40% 41-70% 71-90% 91-100% Question 1 3 out of 3 The answer is missing or very brief and/or the concepts are only minimally used, and/or calculations are incorrect The concepts are used but there are significant gaps/errors in calculations or in the application of concepts. The concepts are used but the answer could have more depth, minor errors in calculations Correct calculations and analysis using the concepts from the topics studied. Question 2 3 out of 3 The answer is missing or very brief and/or the concepts are only minimally used, and/or calculations are incorrect The concepts are used but there are significant gaps/errors in calculations or in the application of concepts. The concepts are used but the answer could have more depth, minor errors in calculations Correct calculations and in-depth analysis using the concepts from the topics studied. Question 3 4 out of 4 The answer is missing or very brief and/or the concepts are only minimally used, and/or calculations are incorrect The concepts are used but there are significant gaps/errors in calculations or in the application of concepts. The concepts are used but the answer could have more depth, minor errors in calculations Correct calculations and in-depth analysis using the concepts from the topics studied.
Answered 1 days AfterNov 24, 2022

Answer To: FNCE 623 1 Homework NPV, IRR and other project evaluation criteria. Develop a...

Khushboo answered on Nov 26 2022
48 Votes
Sheet1
        Solution 1
            Base Case Input
            Initial investment    7,000,000
            Required rate of return    17%
            Sales    1500    students/year
            Tuition fee per student    5500
            Variable co
st per unit    2500
            Fixed costs    1500000
            Tax rate    30%
            Calculation of NPV and IRR
            Year    0    1    2    3    4    5
            Total sales        8250000    8250000    8250000    8250000    8250000
            Less: costs
            Variable costs        3750000    3750000    3750000    3750000    3750000
            Fixed costs        1500000    1500000    1500000    1500000    1500000
            Depreciation        1400000    1400000    1400000    1400000    1400000
            Total costs        6650000    6650000    6650000    6650000    6650000
            Income before tax        1600000    1600000    1600000    1600000    1600000
            Tax @ 30%        480000    480000    480000    480000    480000
            Net income        1120000    1120000    1120000    1120000    1120000
            Add: Depreciation        1400000    1400000    1400000    1400000    1400000
            Free cash flow    -7,000,000    2520000    2520000    2520000    2520000    2520000
            Pvf @ 17%    1    0.855    0.731    0.624    0.534    0.456
            Present Value    -7000000    2153846.15384615    1840894.14858646    1573413.80221065    1344798.12154756    1149400.1038868
            Net Present Value    1062352.33007762
            IRR    23%
            Based on the NPV and IRR the proposal should be accepted. The positive net present value indicates that the present value of the cash inflows are more than the present value of the cash outflows. IRR is also greater than the cost of capital. Hence this will be beneficial for the entity as it will result in additional cash flow and benefit to the entity.
        Solution 2    Best Case Input            Worst Case Input
            Initial investment    7,000,000        Initial investment    7,000,000
            Required rate of return    17%        Required rate of return    17%
            Sales    1725    students/year    Sales    1275    students/year
            Tuition fee per student    5500        Tuition fee per student    5500
            Variable cost per unit    2500        Variable cost per unit    2500
            Fixed...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here