Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 »
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
-
eakeven 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 ru
ic below.








FNCE 623

2






Ru
ic:

0-40% 41-70%
71-90% 91-100%
Question 1
3 out
of 3
The answer is missing
or very
ief and/or
the concepts are only
minimally used,
and/or calculations
are inco
ect
The concepts are
used but there are
significant
gaps/e
ors in
calculations or in the
application of
concepts.
The concepts are
used but the
answer could have
more depth, minor
e
ors in
calculations
Co
ect
calculations and
analysis using the
concepts from
the topics
studied.
Question 2
3 out
of 3
The answer is missing
or very
ief and/or
the concepts are only
minimally used,
and/or calculations
are inco
ect
The concepts are
used but there are
significant
gaps/e
ors in
calculations or in the
application of
concepts.
The concepts are
used but the
answer could have
more depth, minor
e
ors in
calculations
Co
ect
calculations and
in-depth analysis
using the
concepts from
the topics
studied.
Question 3
4 out
of 4
The answer is missing
or very
ief and/or
the concepts are only
minimally used,
and/or calculations
are inco
ect
The concepts are
used but there are
significant
gaps/e
ors in
calculations or in the
application of
concepts.
The concepts are
used but the
answer could have
more depth, minor
e
ors in
calculations
Co
ect
calculations and
in-depth analysis
using the
concepts from
the topics
studied.
Answered 1 days After Nov 24, 2022

Solution

Khushboo answered on Nov 26 2022
37 Votes
Sheet1
        Solution 1
            Base Case Input
            Initial investment    7,000,000
            Required rate of return    17%
            Sales    1500    students/yea
            Tuition fee per student    5500
            Variable cost 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/yea
            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