Investment Project Analysis
VerifiedAdded on 2020/01/07
|22
|4156
|148
Report
AI Summary
This assignment focuses on analyzing the financial feasibility of an investment project undertaken by a company named 'start_'. The company is considering investing $5 million in a new plant while also accounting for existing office premises with a market value of $1 million that will be repurposed. The analysis includes calculating total cash inflows and outflows, considering factors such as revenue, cost of goods sold, overheads (allocated at 3% of the plant cost), and depreciation. The goal is to determine the project's financial viability.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Strategic finance for managers
1
1
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Table of Contents
INTRODUCTION................................................................................................................................3
Capital budgeting..................................................................................................................................3
Calculation of NPV and IRR............................................................................................................3
Interpretation..................................................................................................................................7
Sensitivity analysis with change in tax rate, rate of return and price increase.................................8
Decrease in discounting rates...........................................................................................................9
Decrease in tax rate @ 25%............................................................................................................10
Risk involved in investment appraisal............................................................................................11
Question 1...........................................................................................................................................12
Calculation of discounting rate.......................................................................................................12
Calculation of payback period and net present value.....................................................................12
Advise to FX about suitable project...............................................................................................14
Financing through debt capital.......................................................................................................14
Sensitivity analysis and its uses in project evaluation....................................................................15
QUESTION 2.....................................................................................................................................15
Incorrect items included in the list and its reasons.........................................................................16
Omitted items in the list..................................................................................................................17
Preparation of cash flow items.......................................................................................................17
Calculation of NPV.........................................................................................................................18
CONCLUSION..................................................................................................................................19
REFERENCES...................................................................................................................................21
APPENDIX........................................................................................................................................22
2
INTRODUCTION................................................................................................................................3
Capital budgeting..................................................................................................................................3
Calculation of NPV and IRR............................................................................................................3
Interpretation..................................................................................................................................7
Sensitivity analysis with change in tax rate, rate of return and price increase.................................8
Decrease in discounting rates...........................................................................................................9
Decrease in tax rate @ 25%............................................................................................................10
Risk involved in investment appraisal............................................................................................11
Question 1...........................................................................................................................................12
Calculation of discounting rate.......................................................................................................12
Calculation of payback period and net present value.....................................................................12
Advise to FX about suitable project...............................................................................................14
Financing through debt capital.......................................................................................................14
Sensitivity analysis and its uses in project evaluation....................................................................15
QUESTION 2.....................................................................................................................................15
Incorrect items included in the list and its reasons.........................................................................16
Omitted items in the list..................................................................................................................17
Preparation of cash flow items.......................................................................................................17
Calculation of NPV.........................................................................................................................18
CONCLUSION..................................................................................................................................19
REFERENCES...................................................................................................................................21
APPENDIX........................................................................................................................................22
2
INTRODUCTION
Finance is regarded as the soul of the business because none of the entity can survive in the market without sufficient availability of
monetary resources. It is the duty of finance manager to maintain adequate cash funds to support routine operations and manage business cost
through regular monitoring and controlling so as to make corporation financially strong. Financial manager are not only liable to administrate
daily functioning but also need to monitor their capital expenditures because they have a huge impact on overall operations. Capital budgeting
decisions are of great significance as it enables manager to make viable and strategic decisions about investment in fixed assets. The present
project report lay emphasizes on the application of different investment appraisal techniques, including both discounting and non-discounting
methods to make viable and qualitative investment decisions for the business success. Moreover, it also highlights the key factors that an entity
should address while considering to invest funds in any capital project.
CAPITAL BUDGETING
Every corporation needs to make long-term capital expenditures in the fixed assets, such as property, acquisition of new machinery, new
plant, and designing new product etc. It requires huge amount of capital to invest in the assets and affect corporation to a large extent. Therefore,
proper precautions should be taken while investing money in such kind of assets otherwise it may lead to business failure. In such regards, capital
budgeting techniques helps establishments to determine the most suitable or appropriate investment project which will deliver greater return to
the organization (Echanis and Kester, 2016). These techniques are also known as project appraisal which is regarded as a process of evaluating
and examining relative profitability and return of each and every proposal so as to find out the best among these. In the given scenario, it has
been stated that Downhill Ski Tows Pty. Ltd operates ski tows and chair lifts at N.S.W. winter sort for a number of years. Due to sudden increase
in skiers and sightseers, directors are considering to install a new ski run. There are number of appraisal methods available to the board members
to determine that whether this project will deliver sufficient yield or not in the future.
Calculation of NPV and IRR
Net present value: It can be computed by discounting all the forecasted cash flows at a cost of capital and total of it is subtracted from the
3
Finance is regarded as the soul of the business because none of the entity can survive in the market without sufficient availability of
monetary resources. It is the duty of finance manager to maintain adequate cash funds to support routine operations and manage business cost
through regular monitoring and controlling so as to make corporation financially strong. Financial manager are not only liable to administrate
daily functioning but also need to monitor their capital expenditures because they have a huge impact on overall operations. Capital budgeting
decisions are of great significance as it enables manager to make viable and strategic decisions about investment in fixed assets. The present
project report lay emphasizes on the application of different investment appraisal techniques, including both discounting and non-discounting
methods to make viable and qualitative investment decisions for the business success. Moreover, it also highlights the key factors that an entity
should address while considering to invest funds in any capital project.
CAPITAL BUDGETING
Every corporation needs to make long-term capital expenditures in the fixed assets, such as property, acquisition of new machinery, new
plant, and designing new product etc. It requires huge amount of capital to invest in the assets and affect corporation to a large extent. Therefore,
proper precautions should be taken while investing money in such kind of assets otherwise it may lead to business failure. In such regards, capital
budgeting techniques helps establishments to determine the most suitable or appropriate investment project which will deliver greater return to
the organization (Echanis and Kester, 2016). These techniques are also known as project appraisal which is regarded as a process of evaluating
and examining relative profitability and return of each and every proposal so as to find out the best among these. In the given scenario, it has
been stated that Downhill Ski Tows Pty. Ltd operates ski tows and chair lifts at N.S.W. winter sort for a number of years. Due to sudden increase
in skiers and sightseers, directors are considering to install a new ski run. There are number of appraisal methods available to the board members
to determine that whether this project will deliver sufficient yield or not in the future.
Calculation of NPV and IRR
Net present value: It can be computed by discounting all the forecasted cash flows at a cost of capital and total of it is subtracted from the
3
initial investment, called NPV. In case of a single project, if the total of discounted cash flows is higher than opening outlay than particular
project is considered worthy however, in case of negative results; management should not undertake the proposal. On the other hand, if there are
two projects available than those options will be considered more viable, in which, there is maximum possibility of return ( Net present value and
internal rate of return, 2012).
Year 1 2 3 4 5
Revenue 2092500 1395000 1395000 1436850 739977.75
Total cash inflow 2092500 1395000 1395000 1436850 739977.75
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other
installation cost 464000
Annual replacement cost 18000 18000 18000 18000 18000
Depreciation on equipments 166400 166400 166400 166400 166400
Wages and accommodation cost 32000 22000 22000 22000 16000
Accommodation and wages cost for new
employees 27000 18000 18000 18000 9000
Fuel and lubricants 15750 10500 10500 10500 5250
Maintenance cost 3150 2100 2100 2100 1050
Clearing cost 30000 30000 30000 30000 30000
Advertisement, printing and administrative cost 8000 8000 8160 8323.2 8489.664
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 1792200 1120000 1119840 1161526.8 485788.09
Tax payable 537660 336000 335952 348458.04 145736.43
Profit after taxes 1254540 784000 783888 813068.76 340051.66
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1420940 950400 950288 979468.76 506451.66
Year Cash flow PV factor @ 15% Present Value
4
project is considered worthy however, in case of negative results; management should not undertake the proposal. On the other hand, if there are
two projects available than those options will be considered more viable, in which, there is maximum possibility of return ( Net present value and
internal rate of return, 2012).
Year 1 2 3 4 5
Revenue 2092500 1395000 1395000 1436850 739977.75
Total cash inflow 2092500 1395000 1395000 1436850 739977.75
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other
installation cost 464000
Annual replacement cost 18000 18000 18000 18000 18000
Depreciation on equipments 166400 166400 166400 166400 166400
Wages and accommodation cost 32000 22000 22000 22000 16000
Accommodation and wages cost for new
employees 27000 18000 18000 18000 9000
Fuel and lubricants 15750 10500 10500 10500 5250
Maintenance cost 3150 2100 2100 2100 1050
Clearing cost 30000 30000 30000 30000 30000
Advertisement, printing and administrative cost 8000 8000 8160 8323.2 8489.664
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 1792200 1120000 1119840 1161526.8 485788.09
Tax payable 537660 336000 335952 348458.04 145736.43
Profit after taxes 1254540 784000 783888 813068.76 340051.66
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1420940 950400 950288 979468.76 506451.66
Year Cash flow PV factor @ 15% Present Value
4
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
1 1420940.00 0.87 1235600.00
2 950400.00 0.76 718638.94
3 950288.00 0.66 624829.79
4 979468.76 0.57 560014.44
5 506451.66 0.50 251795.98
Total present value 3390879.15
Less: Initial Investment -1664000.00
Net present Value 1726879.15
Internal rate of return: It is another discounted technique at which both the total of discounted cash inflows and project cost becomes
equal. Downhill Ski Tows Pty Ltd can compute IRR to examine the attractiveness of various proposals and chose the best among all. The
selection criteria of this technique demonstrates that if IRR of the proposal is greater than its cost of capital than such project can be accepted or
vice-versa (Bennouna and et.al., 2010).. However, in case of more than one proposal, bigger IRR is considered more appropriate.
Year Cash flow
0 -1664000
1 1420940.00
2 950400.00
3 950288.00
4 979468.76
5 506451.66
Internal rate of return 61%
Interpretation:
According to the results obtained, it can be seen that NPV of new ski run is positive to $1,726,879.15 and IRR is 61%, higher than cost of
capital of 15%, henceforth; it can be advised to the management that they should select the project. Thus, by installing new ski run Downhill Ski
5
2 950400.00 0.76 718638.94
3 950288.00 0.66 624829.79
4 979468.76 0.57 560014.44
5 506451.66 0.50 251795.98
Total present value 3390879.15
Less: Initial Investment -1664000.00
Net present Value 1726879.15
Internal rate of return: It is another discounted technique at which both the total of discounted cash inflows and project cost becomes
equal. Downhill Ski Tows Pty Ltd can compute IRR to examine the attractiveness of various proposals and chose the best among all. The
selection criteria of this technique demonstrates that if IRR of the proposal is greater than its cost of capital than such project can be accepted or
vice-versa (Bennouna and et.al., 2010).. However, in case of more than one proposal, bigger IRR is considered more appropriate.
Year Cash flow
0 -1664000
1 1420940.00
2 950400.00
3 950288.00
4 979468.76
5 506451.66
Internal rate of return 61%
Interpretation:
According to the results obtained, it can be seen that NPV of new ski run is positive to $1,726,879.15 and IRR is 61%, higher than cost of
capital of 15%, henceforth; it can be advised to the management that they should select the project. Thus, by installing new ski run Downhill Ski
5
Tows Pty. Ltd can maximize their profitability and reach targets.
Sensitivity analysis with change in utilization capacity
If capacity utilization in weekend goes down to 70% and 75% in the first and second year, than it influence on revenue, cash flows, NPV
and IRR will be as follows:
Year 1 2 3 4 5
Revenue 1957500 1350000 1395000 1436850 739977.75
Total cash inflow 1957500 1350000 1395000 1436850 739977.75
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other
installation cost 464000
Annual replacement cost 18000 18000 18000 18000 18000
Depreciation on equipments 166400 166400 166400 166400 166400
Wages and accommodation cost 32000 22000 22000 22000 16000
Accommodation and wages cost for new
employees 27000 18000 18000 18000 9000
Fuel and lubricants 15750 10500 10500 10500 5250
Maintenance cost 3150 2100 2100 2100 1050
Clearing cost 30000 30000 30000 30000 30000
Advertisement, printing and administrative cost 8000 8000 8160 8323.2 8489.664
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 1657200 1075000 1119840 1161527 485788.09
Tax payable 497160 322500 335952 348458 145736.43
Profit after taxes 1160040 752500 783888 813068.8 340051.66
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1326440 918900 950288 979468.8 506451.66
6
Sensitivity analysis with change in utilization capacity
If capacity utilization in weekend goes down to 70% and 75% in the first and second year, than it influence on revenue, cash flows, NPV
and IRR will be as follows:
Year 1 2 3 4 5
Revenue 1957500 1350000 1395000 1436850 739977.75
Total cash inflow 1957500 1350000 1395000 1436850 739977.75
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other
installation cost 464000
Annual replacement cost 18000 18000 18000 18000 18000
Depreciation on equipments 166400 166400 166400 166400 166400
Wages and accommodation cost 32000 22000 22000 22000 16000
Accommodation and wages cost for new
employees 27000 18000 18000 18000 9000
Fuel and lubricants 15750 10500 10500 10500 5250
Maintenance cost 3150 2100 2100 2100 1050
Clearing cost 30000 30000 30000 30000 30000
Advertisement, printing and administrative cost 8000 8000 8160 8323.2 8489.664
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 1657200 1075000 1119840 1161527 485788.09
Tax payable 497160 322500 335952 348458 145736.43
Profit after taxes 1160040 752500 783888 813068.8 340051.66
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1326440 918900 950288 979468.8 506451.66
6
Year Cash flow PV factor @ 15% Present Value
1 1326440.00 0.87 1153426.09
2 918900.00 0.76 694820.42
3 950288.00 0.66 624829.79
4 979468.76 0.57 560014.44
5 506451.66 0.50 251795.98
Total present value 3284886.71
Less: Initial Investment -1664000.00
Net present Value (NPV) 1620886.71
Year Cash flow
0 -1664000
1 1326440.00
2 918900.00
3 950288.00
4 979468.76
5 506451.66
Internal rate of return (IRR) 58%
Interpretation
Above table clearly presents that if maximum capacity utilization of skiing run decreased than NPV and IRR will be decline to
$1,620,886.71 and 58% which are adverse changes. Therefore, it can be suggested to the corporation that they need to ensure maximum
utilization of the avail capacity so that project return can be maximized.
Sensitivity analysis with change in tax rate, rate of return and price increase
If average price per ride goes increase to $6.00 than its impact on revenue, NPV and IRR will be as under:
7
1 1326440.00 0.87 1153426.09
2 918900.00 0.76 694820.42
3 950288.00 0.66 624829.79
4 979468.76 0.57 560014.44
5 506451.66 0.50 251795.98
Total present value 3284886.71
Less: Initial Investment -1664000.00
Net present Value (NPV) 1620886.71
Year Cash flow
0 -1664000
1 1326440.00
2 918900.00
3 950288.00
4 979468.76
5 506451.66
Internal rate of return (IRR) 58%
Interpretation
Above table clearly presents that if maximum capacity utilization of skiing run decreased than NPV and IRR will be decline to
$1,620,886.71 and 58% which are adverse changes. Therefore, it can be suggested to the corporation that they need to ensure maximum
utilization of the avail capacity so that project return can be maximized.
Sensitivity analysis with change in tax rate, rate of return and price increase
If average price per ride goes increase to $6.00 than its impact on revenue, NPV and IRR will be as under:
7
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Year Weeks
Demand on
weekends
Demand on
week days Total demand
Selling price per
ride Revenue
1 15 216000 202500 418500 6.00 2511000
2 10 144000 135000 279000 6.00 1674000
3 10 144000 135000 279000 6.00 1674000
4 10 144000 135000 279000 6.18 1724220
5 5 72000 67500 139500 6.37 887973.3
Year 1 2 3 4 5
Revenue 2511000 1674000 1674000 1724220 887973.3
Total cash inflow 2511000 1674000 1674000 1724220 887973.3
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other installation
cost 464000
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 2210700 1399000 1398840 1448896.8 633783.64
Tax payable 663210 419700 419652 434669.04 190135.09
Profit after taxes 1547490 979300 979188 1014227.76 443648.55
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1713890 1145700 1145588 1180627.76 610048.55
Year Cash flow
PV factor
@ 15% Present Value
1 1713890.00 0.87 1490339.13
2 1145700.00 0.76 866313.80
3 1145588.00 0.66 753242.71
4 1180627.76 0.57 675027.75
8
Demand on
weekends
Demand on
week days Total demand
Selling price per
ride Revenue
1 15 216000 202500 418500 6.00 2511000
2 10 144000 135000 279000 6.00 1674000
3 10 144000 135000 279000 6.00 1674000
4 10 144000 135000 279000 6.18 1724220
5 5 72000 67500 139500 6.37 887973.3
Year 1 2 3 4 5
Revenue 2511000 1674000 1674000 1724220 887973.3
Total cash inflow 2511000 1674000 1674000 1724220 887973.3
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other installation
cost 464000
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 2210700 1399000 1398840 1448896.8 633783.64
Tax payable 663210 419700 419652 434669.04 190135.09
Profit after taxes 1547490 979300 979188 1014227.76 443648.55
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1713890 1145700 1145588 1180627.76 610048.55
Year Cash flow
PV factor
@ 15% Present Value
1 1713890.00 0.87 1490339.13
2 1145700.00 0.76 866313.80
3 1145588.00 0.66 753242.71
4 1180627.76 0.57 675027.75
8
5 610048.55 0.50 303301.94
Total present value 4088225.33
Less: Initial Investment -1664000.00
Net present Value 2424225.33
Year Cash flow
0 -1664000
1 1713890.00
2 1145700.00
3 1145588.00
4 1180627.76
5 610048.55
Internal rate of return (IRR) 79%
As per the results, it is clear that if average price per ride increases than total revenue will be increase, which in turn, results in high NPV
and IRR to $2,424,225.33 and 79% respectively.
Decrease in discounting rates
Year Cash flow PV factor @ 10% Present Value
1 1420940.00 0.91 1291763.64
2 950400.00 0.83 785454.55
3 950288.00 0.75 713965.44
4 979468.76 0.68 668990.34
5 506451.66 0.62 314466.63
Total present value 3774640.60
Less: Initial Investment -1664000.00
Net present Value 2110640.60
9
Total present value 4088225.33
Less: Initial Investment -1664000.00
Net present Value 2424225.33
Year Cash flow
0 -1664000
1 1713890.00
2 1145700.00
3 1145588.00
4 1180627.76
5 610048.55
Internal rate of return (IRR) 79%
As per the results, it is clear that if average price per ride increases than total revenue will be increase, which in turn, results in high NPV
and IRR to $2,424,225.33 and 79% respectively.
Decrease in discounting rates
Year Cash flow PV factor @ 10% Present Value
1 1420940.00 0.91 1291763.64
2 950400.00 0.83 785454.55
3 950288.00 0.75 713965.44
4 979468.76 0.68 668990.34
5 506451.66 0.62 314466.63
Total present value 3774640.60
Less: Initial Investment -1664000.00
Net present Value 2110640.60
9
Presented table demonstrates that if discount rate goes decrease to 10% than NPV of the project will be inclining to $2,110,640.60 which is
good.
Decrease in tax rate @ 25%
Year 1 2 3 4 5
Revenue 2092500 1395000 1395000 1436850 739977.75
Total cash inflow 2092500 1395000 1395000 1436850 739977.75
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other installation
cost 464000
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 1792200 1120000 1119840 1161526.8 485788.09
Tax payable @ 25% 448050 280000 279960 290381.7 121447.02
Profit after taxes 1344150 840000 839880 871145.1 364341.06
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1510550 1006400 1006280 1037545.1 530741.06
Year Cash flow PV factor @ 15% Present Value
1 1510550.00 0.87 1313521.74
2 1006400.00 0.76 760982.99
3 1006280.00 0.66 661645.43
4 1037545.10 0.57 593219.78
5 530741.06 0.50 263872.11
Total present value 3593242.05
Less: Initial Investment -1664000.00
10
good.
Decrease in tax rate @ 25%
Year 1 2 3 4 5
Revenue 2092500 1395000 1395000 1436850 739977.75
Total cash inflow 2092500 1395000 1395000 1436850 739977.75
Cost of engine, cables, pylons and fittings 1200000
Installation, clearing, earthworks and other installation
cost 464000
Total expenses 300300 275000 275160 275323.2 254189.66
Profit before taxes 1792200 1120000 1119840 1161526.8 485788.09
Tax payable @ 25% 448050 280000 279960 290381.7 121447.02
Profit after taxes 1344150 840000 839880 871145.1 364341.06
Add: Depreciation 166400 166400 166400 166400 166400
Net cash flow 1510550 1006400 1006280 1037545.1 530741.06
Year Cash flow PV factor @ 15% Present Value
1 1510550.00 0.87 1313521.74
2 1006400.00 0.76 760982.99
3 1006280.00 0.66 661645.43
4 1037545.10 0.57 593219.78
5 530741.06 0.50 263872.11
Total present value 3593242.05
Less: Initial Investment -1664000.00
10
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Net present Value 1929242.05
Year Cash flow
0 -1664000
1 1510550.00
2 1006400.00
3 1006280.00
4 1037545.10
5 530741.06
Internal rate of return 67%
With the decrease in taxation rate, both the NPV and IRR will be increase to $1,929,242.05 and 67% respectively.
Risk involved in investment appraisal
Volatility in inflation rate may decline the time value of money and directly affects the project yield negatively.
Risk of unforeseen circumstances like decrease in maximum capacity utilization is also a risk involved in the project.
High corporation tax rates may lower down the cash inflow and results in less return (Galvin and et.al., 2012).
Decrease in consumer demand results in lower turnover and affect profitability adversely.
Increase in interest rate greatly affects the cost of capital and decline discounted cash inflows.
QUESTION 1
According to the scenario, FX-Red Lauren Ltd is well-established designer and manufacturer of men’s clothing in Australia. The
chairman and chief executive officer, named Fredricka Redman is thinking to grow its business outside the normal cloth designing and
manufacturing. For that purpose, he wants to introduce a new men’s aftershave, called Fred. The development and testing had already incurred a
cost of $400,000 at an estimated life of 4 year. The cost of new equipment requires an initial investment of $400,000 and it will be depreciated at
11
Year Cash flow
0 -1664000
1 1510550.00
2 1006400.00
3 1006280.00
4 1037545.10
5 530741.06
Internal rate of return 67%
With the decrease in taxation rate, both the NPV and IRR will be increase to $1,929,242.05 and 67% respectively.
Risk involved in investment appraisal
Volatility in inflation rate may decline the time value of money and directly affects the project yield negatively.
Risk of unforeseen circumstances like decrease in maximum capacity utilization is also a risk involved in the project.
High corporation tax rates may lower down the cash inflow and results in less return (Galvin and et.al., 2012).
Decrease in consumer demand results in lower turnover and affect profitability adversely.
Increase in interest rate greatly affects the cost of capital and decline discounted cash inflows.
QUESTION 1
According to the scenario, FX-Red Lauren Ltd is well-established designer and manufacturer of men’s clothing in Australia. The
chairman and chief executive officer, named Fredricka Redman is thinking to grow its business outside the normal cloth designing and
manufacturing. For that purpose, he wants to introduce a new men’s aftershave, called Fred. The development and testing had already incurred a
cost of $400,000 at an estimated life of 4 year. The cost of new equipment requires an initial investment of $400,000 and it will be depreciated at
11
straight line basis for tax purpose. Along with this, FX-Red Lauren Ltd also requires $400,000 for working capital that would be recouped at the
end of the project life.
Calculation of discounting rate
Cost of capital (discounting rate) is the minimum required rate of return that an entrepreneur wishes to obtain by investing money in
particular project. In other words, it refers to the rate which is used by the investment analysts to determine the current value of projected cash
flows. With reference to the given scenario, weighted average cost of capital is 14%, henceforth; it will be the discounting rate for the given
period. It is calculated by using following formula, presented below:
WACC = Equity/(Debt + equity)*( Ke) + debt/(Debt + Equity)*(Kd)*(1-t)
Here, Ke = cost of equity
Kd = cost of debt
T – Corporation tax rate
Calculation of payback period and net present value
Payback period: The first question that comes in the mind of any investors is that what time period will the project need to recover the
initial cost. Payback period (PP) method helps to answer that question as it helps to identify the length of time, in which, investor can get back
his/her initial cash outlay through generating cash inflows (Turner, 2016). Decision rule of the method suggests that FX-Red Lauren Ltd must go
for project whose PP is shorter. Although it is very simple to calculate the PP because investor just needs to find out the cumulative cash flows,
but still, it ignores monetary value and post-pay back cash inflows.
Particulars 0 1 2 3 4
Initial cost $400,000.00
Sales $4,000,000 $2,000,000 $1,200,000 $1,000,000
Less: Expenditures $3,600,000 $1,400,000 $800,000 $800,000
Net revenue $400,000 $600,000 $400,000 $200,000
12
end of the project life.
Calculation of discounting rate
Cost of capital (discounting rate) is the minimum required rate of return that an entrepreneur wishes to obtain by investing money in
particular project. In other words, it refers to the rate which is used by the investment analysts to determine the current value of projected cash
flows. With reference to the given scenario, weighted average cost of capital is 14%, henceforth; it will be the discounting rate for the given
period. It is calculated by using following formula, presented below:
WACC = Equity/(Debt + equity)*( Ke) + debt/(Debt + Equity)*(Kd)*(1-t)
Here, Ke = cost of equity
Kd = cost of debt
T – Corporation tax rate
Calculation of payback period and net present value
Payback period: The first question that comes in the mind of any investors is that what time period will the project need to recover the
initial cost. Payback period (PP) method helps to answer that question as it helps to identify the length of time, in which, investor can get back
his/her initial cash outlay through generating cash inflows (Turner, 2016). Decision rule of the method suggests that FX-Red Lauren Ltd must go
for project whose PP is shorter. Although it is very simple to calculate the PP because investor just needs to find out the cumulative cash flows,
but still, it ignores monetary value and post-pay back cash inflows.
Particulars 0 1 2 3 4
Initial cost $400,000.00
Sales $4,000,000 $2,000,000 $1,200,000 $1,000,000
Less: Expenditures $3,600,000 $1,400,000 $800,000 $800,000
Net revenue $400,000 $600,000 $400,000 $200,000
12
Less: depreciation $100,000.00 $100,000.00 $100,000.00 $100,000.00
Profit before taxation (PBT) $300,000 $500,000 $300,000 $100,000
Less: taxation @30% $90,000 $150,000 $90,000 $30,000
Profit after taxation (PAT) $210,000 $350,000 $210,000 $70,000
Add: Depreciation $100,000.00 $100,000.00 $100,000.00 $100,000.00
Resale value of equipment $100,000.00
Recoupment of working capital $400,000.00
Tax on sale 14000
Working capital $400,000.00
Total cash outflow/inflow $800,000.00 $310,000.00 $450,000.00 $310,000.00 $656,000.00
Depreciation (see appendix 1)
Years Cash flows Cumulative cash flows
0 -$800,000.00 -$800,000.00
1 $310,000.00 -$490,000.00
2 $450,000.00 -$40,000.00
3 $310,000.00 $270,000.00
4 $656,000.00 $926,000.00
Pay-back period = 2 year + ($40000/$310000)
= 2 + 0.13 year
= 2.13 year
Net Present Value: It is a type of discounted cash flow techniques in which firstly, directors need to discount all the estimated cash flows
at an appropriate discounting factor, also called cost of capital. The key reason behind this is money has time value over the period therefore it is
necessary for the FX-Red Lauren Ltd to identify the present value of forecasted cash inflows and thereafter it should be evaluated with initial
investment to find out net present value (NPV) (Higham, Fortune and Boothman, 2016). In the given scenario, at 14% cost of capital, NPV is
calculated here as under:
Years Cash flows Discounted value @14% Present value
13
Profit before taxation (PBT) $300,000 $500,000 $300,000 $100,000
Less: taxation @30% $90,000 $150,000 $90,000 $30,000
Profit after taxation (PAT) $210,000 $350,000 $210,000 $70,000
Add: Depreciation $100,000.00 $100,000.00 $100,000.00 $100,000.00
Resale value of equipment $100,000.00
Recoupment of working capital $400,000.00
Tax on sale 14000
Working capital $400,000.00
Total cash outflow/inflow $800,000.00 $310,000.00 $450,000.00 $310,000.00 $656,000.00
Depreciation (see appendix 1)
Years Cash flows Cumulative cash flows
0 -$800,000.00 -$800,000.00
1 $310,000.00 -$490,000.00
2 $450,000.00 -$40,000.00
3 $310,000.00 $270,000.00
4 $656,000.00 $926,000.00
Pay-back period = 2 year + ($40000/$310000)
= 2 + 0.13 year
= 2.13 year
Net Present Value: It is a type of discounted cash flow techniques in which firstly, directors need to discount all the estimated cash flows
at an appropriate discounting factor, also called cost of capital. The key reason behind this is money has time value over the period therefore it is
necessary for the FX-Red Lauren Ltd to identify the present value of forecasted cash inflows and thereafter it should be evaluated with initial
investment to find out net present value (NPV) (Higham, Fortune and Boothman, 2016). In the given scenario, at 14% cost of capital, NPV is
calculated here as under:
Years Cash flows Discounted value @14% Present value
13
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
1 $310,000.00 0.877192982 $271,929.82
2 $450,000.00 0.769467528 $346,260.39
3 $310,000.00 0.674971516 $209,241.17
4 $656,000.00 0.592080277 $388,404.66
Total discounted cash flows $1,215,836.04
less: initial investment $800,000.00
Net present value (NPV) $415,836.04
Advise to FX about suitable project
By taking into account both the results, it can be said that FX-Red Lauren Ltd’s manager should undertake this project. The reason behind
these decisions is it will get back the initial investment of $800,000 in 2.13 year. Moreover, the net present value is positive to $415,836.04 which
clearly reflects that by investing money in this project, company can get favourable yield and maximise their overall return.
Financing through debt capital
FX-Red Lauren Ltd can finance its new project by the use of equity, debt and retained earnings as well. Now, the question is if company
consider using partly debt than no-doubt, interest expenditures should be considered in investment analysis. It is because, net cash flow is
determined by subtracting total cash inflows net of total operating cash outflows and interest is a type of operating expenditures. Business need to
pay interest to their lenders during a fixed time interval. Thus, higher the rate of debt increases total cash expenditures and resulted less NCF or
vice-versa (Johnson and Pfeiffer, 2016). Therefore, it is essential for the investors to use a better and affordable mix of both the debt and equity
funds to finance the project. In the given scenario, interest is already adjusted in the calculation of weighted average cost of capital; so again,
there is no need for making necessary adjustments regarding interest.
Sensitivity analysis and its uses in project evaluation
Sensitivity analysis is a technique used to examine the impact of uncertain or sudden changes on project’s net return. It is applied to
evaluate that how independent variables impact a particular dependent variable, also called what if analysis (Locatelli, Invernizzi and Mancini,
2016). Investors use this technique to examine the influence of critical and non-critical factors on overall project profitability. It helps to adjust
14
2 $450,000.00 0.769467528 $346,260.39
3 $310,000.00 0.674971516 $209,241.17
4 $656,000.00 0.592080277 $388,404.66
Total discounted cash flows $1,215,836.04
less: initial investment $800,000.00
Net present value (NPV) $415,836.04
Advise to FX about suitable project
By taking into account both the results, it can be said that FX-Red Lauren Ltd’s manager should undertake this project. The reason behind
these decisions is it will get back the initial investment of $800,000 in 2.13 year. Moreover, the net present value is positive to $415,836.04 which
clearly reflects that by investing money in this project, company can get favourable yield and maximise their overall return.
Financing through debt capital
FX-Red Lauren Ltd can finance its new project by the use of equity, debt and retained earnings as well. Now, the question is if company
consider using partly debt than no-doubt, interest expenditures should be considered in investment analysis. It is because, net cash flow is
determined by subtracting total cash inflows net of total operating cash outflows and interest is a type of operating expenditures. Business need to
pay interest to their lenders during a fixed time interval. Thus, higher the rate of debt increases total cash expenditures and resulted less NCF or
vice-versa (Johnson and Pfeiffer, 2016). Therefore, it is essential for the investors to use a better and affordable mix of both the debt and equity
funds to finance the project. In the given scenario, interest is already adjusted in the calculation of weighted average cost of capital; so again,
there is no need for making necessary adjustments regarding interest.
Sensitivity analysis and its uses in project evaluation
Sensitivity analysis is a technique used to examine the impact of uncertain or sudden changes on project’s net return. It is applied to
evaluate that how independent variables impact a particular dependent variable, also called what if analysis (Locatelli, Invernizzi and Mancini,
2016). Investors use this technique to examine the influence of critical and non-critical factors on overall project profitability. It helps to adjust
14
the risk-factor in the project while making any investment decisions. Referring the case study, FX-Red Lauren Ltd can measure the impact of
volatile cost of capital on their project profitability to make better investment decisions.
Suppose, if rate goes beyond the current level and reach to 16% than its impact on NPV will be as follows:
Years Cash flows Discounted value @16% Present value
1 $310,000.00 0.862068966 $267,241.38
2 $450,000.00 0.743162901 $334,423.31
3 $310,000.00 0.640657674 $198,603.88
4 $656,000.00 0.552291098 $362,302.96
Total discounted cash flows $1,162,571.52
less: initial investment $800,000.00
Net present value $362,571.52
Table clearly presents that in case of high cost of capital to 16%, NPV will be decrease to $362,571.52 or vice-versa. It depicts that higher
the rate of discounting reduces the net profitability of the project, therefore, it is necessary for the manager to determine an accurate cost of
capital; otherwise, misleading decisions can be taken.
QUESTION 2
According to the given scenario, company conducted a feasibility study which incurred a cost of $400,000 and its management is
considering investing $5million in a new plant. For installing a new plant, it will occupy unused office premises with a market value of $1
million and it is already owned by the company. Headquarters’ overheads are $3 million that will be allocated on the basis of 3% of plant cost
worth, thus, total chargeable overheads for the year will be $150,000 (See appendix 2). Total revenue per year is $4 million and its cost is 40%,
thus, total cash inflows for the project is calculated here as under:
Incorrect items included in the list and its reasons
Cash flow is forecasted by subtracting total cash inflows from total cash outflows. In the given case, taxation amount is incorrect because it
is charged on business profit without deducting depreciation. However, taxes are charged on the net accounting profitability. The correct tax
15
volatile cost of capital on their project profitability to make better investment decisions.
Suppose, if rate goes beyond the current level and reach to 16% than its impact on NPV will be as follows:
Years Cash flows Discounted value @16% Present value
1 $310,000.00 0.862068966 $267,241.38
2 $450,000.00 0.743162901 $334,423.31
3 $310,000.00 0.640657674 $198,603.88
4 $656,000.00 0.552291098 $362,302.96
Total discounted cash flows $1,162,571.52
less: initial investment $800,000.00
Net present value $362,571.52
Table clearly presents that in case of high cost of capital to 16%, NPV will be decrease to $362,571.52 or vice-versa. It depicts that higher
the rate of discounting reduces the net profitability of the project, therefore, it is necessary for the manager to determine an accurate cost of
capital; otherwise, misleading decisions can be taken.
QUESTION 2
According to the given scenario, company conducted a feasibility study which incurred a cost of $400,000 and its management is
considering investing $5million in a new plant. For installing a new plant, it will occupy unused office premises with a market value of $1
million and it is already owned by the company. Headquarters’ overheads are $3 million that will be allocated on the basis of 3% of plant cost
worth, thus, total chargeable overheads for the year will be $150,000 (See appendix 2). Total revenue per year is $4 million and its cost is 40%,
thus, total cash inflows for the project is calculated here as under:
Incorrect items included in the list and its reasons
Cash flow is forecasted by subtracting total cash inflows from total cash outflows. In the given case, taxation amount is incorrect because it
is charged on business profit without deducting depreciation. However, taxes are charged on the net accounting profitability. The correct tax
15
liability of the corporation is conducted here as under;
Particulars
Initial
outlay 1 2
calculation
of tax is
computed
here as
under:3 4 5 6 7 8
Plant cost,
feasibility study
and unused
premises
-
$5,400,000.00
Cash sales $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00
Cost of sale $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00
Allocation of
overheads $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00
Depreciation $1,000,000.00 $800,000.00 $640,000.00 $512,000.00 $409,600.00 $327,680.00 $262,144.00 $209,715.20
Interest
expenditures $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00
Total
expenditures $3,950,000.00 $3,750,000.00 $3,590,000.00 $3,462,000.00 $3,359,600.00 $3,277,680.00 $3,212,144.00 $3,159,715.20
profit before
taxation $50,000.00 $250,000.00 $410,000.00 $538,000.00 $640,400.00 $722,320.00 $787,856.00 $840,284.80
Taxation @30% $15,000.00 $75,000.00 $123,000.00 $161,400.00 $192,120.00 $216,696.00 $236,356.80 $252,085.44
Total tax liabilities = $15000+$75000+$123000+$161400+$192120+$216696+$236356.80+$252085.44 = $1,271,658.24
From the derived results, it becomes clear that company entered inaccurate amount of taxes worth $1,050,000 whilst actual amount of tax is
$1,271,658.24. Thus, it can be said that taxable amount has been under-valued by $221,658.24 that is an error.
Omitted items in the list
Although cash flow projection does not consider non-cash affecting transactions like depreciation, but still, it must be keep in mind that for
16
Particulars
Initial
outlay 1 2
calculation
of tax is
computed
here as
under:3 4 5 6 7 8
Plant cost,
feasibility study
and unused
premises
-
$5,400,000.00
Cash sales $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00
Cost of sale $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00
Allocation of
overheads $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00
Depreciation $1,000,000.00 $800,000.00 $640,000.00 $512,000.00 $409,600.00 $327,680.00 $262,144.00 $209,715.20
Interest
expenditures $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00
Total
expenditures $3,950,000.00 $3,750,000.00 $3,590,000.00 $3,462,000.00 $3,359,600.00 $3,277,680.00 $3,212,144.00 $3,159,715.20
profit before
taxation $50,000.00 $250,000.00 $410,000.00 $538,000.00 $640,400.00 $722,320.00 $787,856.00 $840,284.80
Taxation @30% $15,000.00 $75,000.00 $123,000.00 $161,400.00 $192,120.00 $216,696.00 $236,356.80 $252,085.44
Total tax liabilities = $15000+$75000+$123000+$161400+$192120+$216696+$236356.80+$252085.44 = $1,271,658.24
From the derived results, it becomes clear that company entered inaccurate amount of taxes worth $1,050,000 whilst actual amount of tax is
$1,271,658.24. Thus, it can be said that taxable amount has been under-valued by $221,658.24 that is an error.
Omitted items in the list
Although cash flow projection does not consider non-cash affecting transactions like depreciation, but still, it must be keep in mind that for
16
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
tax computation depreciation need to be deducted for profit determination (Bennouna and et.al., 2010). As per the presented table, it can be seen
that depreciation has been excluded as it is non-cash item and tax is calculated without addressing this amount. Henceforth, it can be said that
depreciations item has been omitted from the list while company need to charge depreciation at the rate of 20% as per written-down value
method. Referring the current scenario, the calculation of depreciation has been done in Appendix 3.
Preparation of cash flow items
According to the given scenario, cash flow of the project has been computed here as under:
Particulars Initial outlay 1 2 3 4 5 6 7 8
Plant cost,
feasibility
study and
unused
premises -$5,400,000.00
Cash sales $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00
Cost of sale $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00
Allocation of
overheads $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00
Depreciation $1,000,000.00 $800,000.00 $640,000.00 $512,000.00 $409,600.00 $327,680.00 $262,144.00 $209,715.20
Interest
expenditures $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00
Total
expenditures $3,950,000.00 $3,750,000.00 $3,590,000.00 $3,462,000.00 $3,359,600.00 $3,277,680.00 $3,212,144.00 $3,159,715.20
profit before
taxation $50,000.00 $250,000.00 $410,000.00 $538,000.00 $640,400.00 $722,320.00 $787,856.00 $840,284.80
Taxation
@30% $15,000.00 $75,000.00 $123,000.00 $161,400.00 $192,120.00 $216,696.00 $236,356.80 $252,085.44
Profit after
taxation $35,000.00 $175,000.00 $287,000.00 $376,600.00 $448,280.00 $505,624.00 $551,499.20 $588,199.36
Profit on sale
of plant $1,161,139.20
17
that depreciation has been excluded as it is non-cash item and tax is calculated without addressing this amount. Henceforth, it can be said that
depreciations item has been omitted from the list while company need to charge depreciation at the rate of 20% as per written-down value
method. Referring the current scenario, the calculation of depreciation has been done in Appendix 3.
Preparation of cash flow items
According to the given scenario, cash flow of the project has been computed here as under:
Particulars Initial outlay 1 2 3 4 5 6 7 8
Plant cost,
feasibility
study and
unused
premises -$5,400,000.00
Cash sales $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00 $4,000,000.00
Cost of sale $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00
Allocation of
overheads $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00
Depreciation $1,000,000.00 $800,000.00 $640,000.00 $512,000.00 $409,600.00 $327,680.00 $262,144.00 $209,715.20
Interest
expenditures $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00 $1,200,000.00
Total
expenditures $3,950,000.00 $3,750,000.00 $3,590,000.00 $3,462,000.00 $3,359,600.00 $3,277,680.00 $3,212,144.00 $3,159,715.20
profit before
taxation $50,000.00 $250,000.00 $410,000.00 $538,000.00 $640,400.00 $722,320.00 $787,856.00 $840,284.80
Taxation
@30% $15,000.00 $75,000.00 $123,000.00 $161,400.00 $192,120.00 $216,696.00 $236,356.80 $252,085.44
Profit after
taxation $35,000.00 $175,000.00 $287,000.00 $376,600.00 $448,280.00 $505,624.00 $551,499.20 $588,199.36
Profit on sale
of plant $1,161,139.20
17
Taxation on
sale of plant
@30% $348,341.76
Add;
Depreciation $1,000,000.00 $800,000.00 $640,000.00 $512,000.00 $409,600.00 $327,680.00 $262,144.00 $209,715.20
Cash
outflow/Inflow -$5,400,000.00 $1,035,000.00 $975,000.00 $927,000.00 $888,600.00 $857,880.00 $833,304.00 $813,643.20 $1,610,712.00
Calculation of NPV
NPV is the differences between total discounted cash inflows and initial cash outlay, positive is preferred while negative NPV is rejected
(Irani, 2010).
Particulars Initial outlay 1 2 3 4 5 6 7 8
Cash
outflow/Inflow -$5,400,000.00 $1,035,000.00 $975,000.00 $927,000.00 $888,600.00 $857,880.00 $833,304.00 $813,643.20 $1,610,712.00
Discounted factors
@ 24%` 1 $0.80645 $0.65036 $0.52449 $0.42297 $0.34111 $0.27509 $0.22184 $0.17891
Discounted cash
flows -$5,400,000.00 $834,677.42 $634,105.10 $486,199.69 $375,854.34 $292,629.51 $229,231.00 $180,502.08 $288,167.11
Net present value -$2,078,633.75
Initial investment (see appendix 4)
NPV = (-$5,400,000+$834,677.42+$634,105.10+$486,199.69+$375,854.34+$292,629.51+$229,231+$180,502.08+$288,167.11)
= -$2,078,633.75
On the basis of results, it can be suggested to the company that it should reject the project. The reason behind this decisions is there is
unfavorable NPV of $2,0780,633.75 which indicates that proposal of investment in new plant will not be worthy for the business.
CONCLUSION
In conclusion of the report, it can be said that company should introduce a new ski run for their customers so as to generate positive return.
18
sale of plant
@30% $348,341.76
Add;
Depreciation $1,000,000.00 $800,000.00 $640,000.00 $512,000.00 $409,600.00 $327,680.00 $262,144.00 $209,715.20
Cash
outflow/Inflow -$5,400,000.00 $1,035,000.00 $975,000.00 $927,000.00 $888,600.00 $857,880.00 $833,304.00 $813,643.20 $1,610,712.00
Calculation of NPV
NPV is the differences between total discounted cash inflows and initial cash outlay, positive is preferred while negative NPV is rejected
(Irani, 2010).
Particulars Initial outlay 1 2 3 4 5 6 7 8
Cash
outflow/Inflow -$5,400,000.00 $1,035,000.00 $975,000.00 $927,000.00 $888,600.00 $857,880.00 $833,304.00 $813,643.20 $1,610,712.00
Discounted factors
@ 24%` 1 $0.80645 $0.65036 $0.52449 $0.42297 $0.34111 $0.27509 $0.22184 $0.17891
Discounted cash
flows -$5,400,000.00 $834,677.42 $634,105.10 $486,199.69 $375,854.34 $292,629.51 $229,231.00 $180,502.08 $288,167.11
Net present value -$2,078,633.75
Initial investment (see appendix 4)
NPV = (-$5,400,000+$834,677.42+$634,105.10+$486,199.69+$375,854.34+$292,629.51+$229,231+$180,502.08+$288,167.11)
= -$2,078,633.75
On the basis of results, it can be suggested to the company that it should reject the project. The reason behind this decisions is there is
unfavorable NPV of $2,0780,633.75 which indicates that proposal of investment in new plant will not be worthy for the business.
CONCLUSION
In conclusion of the report, it can be said that company should introduce a new ski run for their customers so as to generate positive return.
18
While, on the other hand, sensitivity analysis identified that with the decrease in discounting rate, tax rates, price increase, both the NPV and IRR
goes increase or vice-versa. Second part of the report concluded that FX-Red Lauren Ltd should undertake its new project and invest funds in
new equipment. In the end, report identified that there is negative NPV henceforth; company should not acquire new plant in the business.
19
goes increase or vice-versa. Second part of the report concluded that FX-Red Lauren Ltd should undertake its new project and invest funds in
new equipment. In the end, report identified that there is negative NPV henceforth; company should not acquire new plant in the business.
19
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
REFERENCES
Books and Journals
Bennouna, K. and et.al., 2010. Improved capital budgeting decision making: evidence from Canada. Management decision. 48(2). pp. 225-247.
Echanis, E. S. and Kester, G. W., 2016. Capital Budgeting Practices of Listed Philippine Firms. Philippine Management Review. 7(1). pp. 45-56.
Galvin, R. and et.al., 2012. Including fuel price elasticity of demand in net present value and payback time calculations of thermal retrofits: Case
study of German dwellings. Energy and Buildings. 50(5). pp. 219-228.
Higham, A. P., Fortune, C. and Boothman, J. C., 2016. Sustainability and investment appraisal for housing regeneration projects. Structural
Survey. 34(2). Pp .150-167.
Irani, Z., 2010. Investment evaluation within project management: an information systems perspective. Journal of the Operational Research
Society. 61(6). pp. 917-928.
Johnson, N. B. and Pfeiffer, T., 2016. Capital Budgeting and Divisional Performance Measurement. Foundations and Trends® in Accounting.
10(1). pp. 1-100.
Locatelli, G., Invernizzi, D. C. and Mancini, M., 2016. Investment and risk appraisal in energy storage systems: A real options approach. Energy.
104(6). pp. 114-131.
Turner, J. A., 2016. Net Operating Working Capital, Capital Budgeting, And Cash Budgets: A Teaching Example. American Journal of Business
Education. 9(1). pp. 31-45.
Online
Koening, E., 2015. [Online]. Available through: http://smallbusiness.chron.com/sensitivity-analysis-capital-budgeting-10153.html. [Accessed on
12th October 2016].
Net present value and internal rate of return. 2012. [Online]. Available through: https://www.nibusinessinfo.co.uk/content/net-present-value-and-
internal-rate-return. [Accessed on 12th October 2016].
20
Books and Journals
Bennouna, K. and et.al., 2010. Improved capital budgeting decision making: evidence from Canada. Management decision. 48(2). pp. 225-247.
Echanis, E. S. and Kester, G. W., 2016. Capital Budgeting Practices of Listed Philippine Firms. Philippine Management Review. 7(1). pp. 45-56.
Galvin, R. and et.al., 2012. Including fuel price elasticity of demand in net present value and payback time calculations of thermal retrofits: Case
study of German dwellings. Energy and Buildings. 50(5). pp. 219-228.
Higham, A. P., Fortune, C. and Boothman, J. C., 2016. Sustainability and investment appraisal for housing regeneration projects. Structural
Survey. 34(2). Pp .150-167.
Irani, Z., 2010. Investment evaluation within project management: an information systems perspective. Journal of the Operational Research
Society. 61(6). pp. 917-928.
Johnson, N. B. and Pfeiffer, T., 2016. Capital Budgeting and Divisional Performance Measurement. Foundations and Trends® in Accounting.
10(1). pp. 1-100.
Locatelli, G., Invernizzi, D. C. and Mancini, M., 2016. Investment and risk appraisal in energy storage systems: A real options approach. Energy.
104(6). pp. 114-131.
Turner, J. A., 2016. Net Operating Working Capital, Capital Budgeting, And Cash Budgets: A Teaching Example. American Journal of Business
Education. 9(1). pp. 31-45.
Online
Koening, E., 2015. [Online]. Available through: http://smallbusiness.chron.com/sensitivity-analysis-capital-budgeting-10153.html. [Accessed on
12th October 2016].
Net present value and internal rate of return. 2012. [Online]. Available through: https://www.nibusinessinfo.co.uk/content/net-present-value-and-
internal-rate-return. [Accessed on 12th October 2016].
20
APPENDIX
1. Calculations of depreciation
Initial investment $400,000.00
Estimated life (in years) 4
Depreciation
Initial investment/estimated
life $100,000.00
2. Overheads
Overheads $3,000,000.00 per year
3% plant
cost $150,000.00 per year
3. Depreciation
Year Written down value Depreciation
1 5000000 1000000
2 4000000 800000
3 3200000 640000
4 2560000 512000
5 2048000 409600
6 1638400 327680
7 1310720 262144
8 1048576 209715.2
Total depreciation 4161139.2
Residual value $838,860.80
21
1. Calculations of depreciation
Initial investment $400,000.00
Estimated life (in years) 4
Depreciation
Initial investment/estimated
life $100,000.00
2. Overheads
Overheads $3,000,000.00 per year
3% plant
cost $150,000.00 per year
3. Depreciation
Year Written down value Depreciation
1 5000000 1000000
2 4000000 800000
3 3200000 640000
4 2560000 512000
5 2048000 409600
6 1638400 327680
7 1310720 262144
8 1048576 209715.2
Total depreciation 4161139.2
Residual value $838,860.80
21
Resale value $2,000,000.00
Profit on sale of new plant $1,161,139.20
4. Initial cash outlay
Feasibility study $400,000.00
New plant cost $5,000,000.00
Unused premises $1,000,000.00
Total initial investment $6,400,000.00
22
Profit on sale of new plant $1,161,139.20
4. Initial cash outlay
Feasibility study $400,000.00
New plant cost $5,000,000.00
Unused premises $1,000,000.00
Total initial investment $6,400,000.00
22
1 out of 22
Related Documents
Your All-in-One AI-Powered Toolkit for Academic Success.
+13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
Unlock your academic potential
© 2024 | Zucol Services PVT LTD | All rights reserved.