The Finance Department requires an in-class valuation exercise using excel. As we don’t have normal lecture classes this is a take-home exercise. There was to be an excel exercise on personal finance,...

1 answer below »

The Finance Department requires an in-class valuation exercise using excel. As we don’t have normal lecture classes this is a take-home exercise. There was to be an excel exercise on personal finance, but I’d rather have Projects 2 and 3 focus on the more important logical issues of personal financial management than merely crunch more numbers. This exercise thus combines the course’s excel work in to one project worth 10% of the course grade.


Your Project 1 Creative Destruction analysis secured your position at Halliburton. It is now five years since you were hired and, given your abilities, your boss has asked you to develop an example of a corporate project that could be used to train junior managers in capital budgeting procedures.


Given your chosen industry, create a project that would add value to your company. Your project analysis should be supported by the following information.
The nature of the project and how it would be expected to add value to your company.
Determine whether the project will have an indefinite or finite time line.
Specify the initial capital investment and additional additions to capital investment over the life of the project.
Project the initial revenues and their growth rate
Develop the types and estimates of variable costs.
Calculate the cost of capital using insights from Chapter 14.
Assume straight-line depreciation and a tax rate of 21%


Use excel to calculate the projects NPV, IRR, and payback.


You will be evaluated on how well your project explains capital budgeting to the trainee junior managers. Major aspects of the evaluation are:
Creativity and realistic nature of your project.
Your development and explanation of the elements in the project,
Your use of excel to develop the metrics and explain how you arrived at your accept/reject project decision.

Answered Same DayDec 05, 2021

Answer To: The Finance Department requires an in-class valuation exercise using excel. As we don’t have normal...

Tanmoy answered on Dec 06 2021
136 Votes
Cover
    image kindly provided by: https://www.creditrepairexpert.org/
NPV, IRR, Payback
                Growth Rate    1%                        2%
    General                                                            Graphs
        Revenu
es        22,408    22632.08    22858.4008    23086.984808    23317.85465608    23551.0332026408    23787    24262.2744053606    24747.5198934678    25242.4702913371    25747
        Less: Variable Costs
        Cost of Services        15684    15493    15648    15805    15963    16122    16284    16446    16611    16777    16945
        Cost of Sales        4439    4332    4375    4419    4463    4508    4553    4598    4644    4691    4737
        Impairment and other charges        2506    1139    1151    1162    1174    1186    1197    1209    1222    1234    1246
        General & Administrative        227    246    248    251    253    256    258    261    263    266    269
        Gross Profit        -448    1422    1436    1451    1465    1480    1495    1747    2008    2275    2550
        Less: Interest Expenses        569    572    578    583    589    595    601    607    613    619    626
        Less: Others        105    101    102    103    104    105    106    107    108    109    110
        Less: Income Tax        7    432    436    440    445    449    454    458    463    467    472
        Gross Profit        -1129    317    321    324    327    330    334    575    823    1079    1342
    Assumptions
                2019    2020    2021    2022    2023    2024    2025    2026    2027    2028    2029
        Investment        -2,980
        Project Cash Flows            317    321    324    327    330    334    575    823    1,079    1,342
        Total Cash Flows        -2,980    317    321    324    327    330    334    575    823    1,079    1,342
        Discount Rate        10.27%
    Calculations
        Timeline        2019    2020    2021    2022    2023    2024    2025    2026    2027    2028    2029
        Year        0    1    2    3    4    5    6    7    8    9    10
        Discount Factor        1.00    0.91    0.82    0.75    0.68    0.61    0.56    0.50    0.46    0.41    0.38
        Discounted Cash Flows        -2,980    288    264    241    221    203    186    290    376    447    505
        Net Present Value
        NPV 1st way    41
        NPV 2nd way    41
        Internal Rate of...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here