Question based on the case study
-
Stakeholder theory
According to Harrison, et al.,2015, that state that the stakeholder theory is the base for the management decision making. As according to freeman Harrison and wicks the stakeholder analysis helps in managing the ethical environment, increasing efficiency and effectiveness in the project completion, sustainability in the market of the company. The stakeholder theory helps in understanding the market demand and complexities in the consumer market. The integration of the policies formation an organization need to study the internal and external stakeholder of the company. The internal stakeholder includes employees, supplier and the shareholder member of the company. The external stakeholder will be customer, government, creditor and the investor of the company. They eventually impact the management decision and also constitute the ethical background of the company. The stakeholder helps in suggesting certain measures and evaluating the corporate governance and sustainable policy within organization as well as in the chosen project. The firm has been designated to satisfied the stakeholder of the company and interlinked all the information before embedding it within the market and within the organization.
Stakeholder theory implication in the Kimco environment
The use of stakeholder theory helps in establishing the ethicality and corporate governance within the organization through analysing the need of the stakeholder and the engaging them in the decision making of the firm. The stakeholder plays a vital role in sustaining the firm for long term base. As in the case of Kimco, they put effort to design the family like structure within the workplace. So that employee will work within it comfort zone and work with efficiently and effectively. Kimco involves all the internal and external stakeholder in their decision-making purposes and make decision as per the majority concerns. Kimco follows all the social responsibility that has been embed toward the society and communities by sharing the profitability with them. The modernisation and relocation that has been proposed will better embed if there is support of the internal and external stakeholder. Hence, through that stakeholder theory has been implicated in the company ethicality and management decision (Vidal, et al.,2015).
-
Ethical consideration of the Kimco line of business
The ethical consideration based on the Kimco line of business that is paper and pulp industry will be-
- The ethics that has been followed while implication of the business is the necessary code of conduct that has been inserted in the aspect of the performance. The WHS conduct and the worker relationship standard will lead to mend better relationship between the employer and employee and bring steadiness in the working (Zovico, 2020).
- The ethical pricing and worker pay scale will be essential for balancing the system effectively and manage to reduce the employee turnover in the company. An employee is the biggest assets of the company. So, it is necessary that organization should protect the employees’ interest and implement certain measure that is anti-discrimination rules and managing the employee problem while facilitating them.
- The ethical code of conduct in the use of the trees and the wood for making papers and pulp. The environmental standard should be implemented so that use of the environmental product should be in limit and use the 3R’s rules for preparing the paper and for further processing.
- The sustainable practice and incorporating corporate governance in the working to measure the performance and elimination destruction and protecting natural regime for future benefit. It is one of the essential ethics that a paper and pulp business should adopted for fulfilling social responsibility as well contributing themselves toward conservation of natural resources (Zovico, 2020).
The ethical consideration affects the financial decision are as follows-
It leads to impact the business viable decision through restricting certain margin of usage and the chemical intact within the production cycle to protect the air and water environment. So, it leads to develop an alternative that immensely indulge in high cost practices and affect the financial decision.
Another reason that affect the financial decision will be the ethical consideration toward society and delivering the good that has been presented with low price. This will entail to build certain strategy to reduce the cost and low the price margin of the product. Hence, this is one of the financial decisions (Lappi, 2020).
Hence, this is the ethical consideration that will affect the financial decision of Kimco.
-
Letter to Kimco management
To, Kimco management
Tasmania, Australia
Date- 15 September 2020
Subject – suggestion for becoming better corporate citizen and delivering better value to their investors
Greeting for the day
Dear management team
I hope you all are doing well and I am glad you approached me for the purpose of the getting suggestion on the purpose of creating value and ethical conduct by giving priority to the stakeholder and the communities and employee of the company. An organization will be sustaining in the market for the long time due to the stakeholder support and community trust on the company. if any breaking of ethical behaviour has been seen by them, they will never tolerate and by the time the firm will face decline of the reputation as well as the market value of the company (Chesbrough, et al.,2018).
For creating the market value and the reputation in the market Kimco should not decline their expectation, should give preference to the environment standard and does not ignore and neglect their decision and considered the way they are approaching the firm environment. The corporate governance in the organziation delivered standard, certain code and conduct that has been mandate to followed by the organziation to meet the governmental needs as well as the interna and external market needs.
The value can be created through engagement of the society and the stakeholder within the organziation certain decision. As it related to financial decision, employment generation decision and the project selection decision. All these decisions need to take very carefully. Henceforth, through the decision-making process, all the constituent that integrate the internal and external factors into it.
The company should not stop their analysis process and always adhered toward innovation and new practices, that will create the essence for the value embedment and increase the strong market collaboration and enhance market turnover.
I hope you will consider these points for future value creation and indulge the presence of the ethical consideration and satisfying the investors as well (Chesbrough, et al.,2018).
Thanking you
-
Evaluation of the cash flow for capital project
Cash flow that involve in the capital project of the company will be-
Cash flow related to the operating activities
The cash flow related to the operating activities has been essential to evaluate so that the company will acquire the necessary cost and the expenses for the company capital project. The operating cost include the sale revenue, assets and liabilities arrangement and the taxes that has been incurred in the followed project while completing it. Hence, operating cost are the general prevailing cost that has been required the certain amount of the cash for meeting daily operational needs (Pivorienė, 2017).
Cash flow in the investment activities
Under this head the cash flow related to the investment in the capital project that has been proposed by the company has been incurred under this. The investment required certain amount cash for managing the profitability, resources, labour and the economic activities for enhancing the feasibility of the project. So, for this investment cash flow has been required and incorporate for smooth functioning
Managing capital expenditure
The cash flow has been also requiring for managing the capital expenditure of the company. the capital expenditure includes the purchase of the fixed assets, selling of an asset etc. The capital expenditure has been required for the establishment of the capital expenses that required to be meet and it also need the cash flow with the manager to manage the capital expenses during the project.
Future cash flow management
The future cash flow has been considered under this as the project has been surrounded with certain risk and uncertainty. So, to be secure in this context the company evaluate the future cash flow of the firm from the proposed project by ascertaining the margin of investment, estimating present cash flow as well as future cash flow by inserting certain formula (Leyman & Vanhoucke, 2017).
Hence, these are the certain cash flow that has been administrated in the proposed project and restructuring of the industry and furnished it with modern technique and equipment.
Opportunity cost
The opportunity cost is the cost that has been determine by choosing the one alternative over other after evaluating the cost structure and determining the future value. So, selection of one of the alterative over other will be called as the opportunity cost for the company. In the case of the Kimco ltd. opportunity cost can be determined as the choosing the best alternative out of many through analysis. The decision of resources and labour will be estimated with the help of the opportunity cost method as it leads to better decision (Yan & Otto, 2020).
Sunk cost
The sunk cost is the cost that has been determined as the cost structure that has been already being incurred and there is no hope of recovery for this cost. Hence, in the case of the Kimco ltd. the chances of this cost are least and as studying the detail of the project there is no sunk cost incurred by the project (Feldman & Wong, 2018).
-
Dilemma in cash Flow identification
The cash flow identification is the estimation of the cash flow which are to be required during the project life. This stage is relay important in the project life, because it helps in understanding that how much funds are to be required in the period lifecycle and what are the expected cash flows. The capital techniques become easier with the help of cash flows, the calculation of NPV, IRR and payback will be useful in identifying that the project will be profitable or not.
IN the given situation, there are capital investment which have to be incurred in the 0 years, where as the working capital cost will have to paid in the year or later. As per the given statement, the cash flows are important to be invested in the 0 years, but they will be giving profit to the later years, in the increased capacity.
-
Cash Flow Statement
Computation of cash flow for each alternative | Existing | ||||||||||
Year6 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Capacity of production | 150000 | ||||||||||
Capital Cost | 0 | ||||||||||
Additional working capital at the year 3 | 0 | ||||||||||
Operating Cost | |||||||||||
Labour cost ore tome | 48750000 | 49725000 | 50719500 | 51733890 | 52768567.8 | 53823939.16 | 54900417.94 | 55998426.3 | 57118394.82 | 58260762.72 | |
Material and another variable | 62250000 | 63557250 | 64891952.25 | 66254683.25 | 67646031.6 | 69066598.26 | 70516996.82 | 71997853.76 | 73509808.68 | 75053514.67 | |
Fixed Operating Cost | 400000 | 404800 | 409657.6 | 414573.4912 | 419548.3731 | 424582.9536 | 429677.949 | 434834.0844 | 440052.0934 | 445332.7185 | |
Total Cash Outflow | 0 | 111400000 | 113687050 | 116021109.9 | 118403146.7 | 120834147.8 | 123315120.4 | 125847092.7 | 128431114.1 | 131068255.6 | 133759610.1 |
Sales price | 920 | 947.6 | 976.028 | 1005.30884 | 1035.468105 | 1066.532148 | 1098.528113 | 1131.483956 | 1165.428475 | 1200.391329 | |
Total Cash inflow | 138000000 | 142140000 | 146404200 | 150796326 | 155320215.8 | 159979822.3 | 164779216.9 | 169722593.4 | 174814271.2 | 180058699.4 | |
Net Cash Inflow /Outflow | 26600000 | 28452950 | 30383090.15 | 32393179.26 | 34486068.01 | 36664701.88 | 38932124.21 | 41291479.29 | 43746015.63 | 46299089.26 |
Computation of cash flow for each alternatives Modernisation of Old Plant | |||||||||||||||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
Capacity of production | 300000 | ||||||||||||||||||||||
Capital Cost | 60000000 | 60000000 | 60000000 | 100000000 | |||||||||||||||||||
Additional working capital at the year 3 | 0 | ||||||||||||||||||||||
Operating Cost | |||||||||||||||||||||||
Labour cost ore tome | 97500000 | 99450000 | 84000000 | 85680000 | 87393600 | 89141472 | 90924301.44 | 92742787.47 | 94597643.22 | 96489596.08 | 98419388 | 100387775.8 | 102395531.3 | 104443441.9 | 106532310.7 | 108662957 | 110836216.1 | 113052940.4 | 115313999.2 | 117620279.2 | 119972684.8 | 122372138.5 | |
Material and another variable | 62250000 | 63557250 | 124500000 | 127114500 | 129783904.5 | 132509366.5 | 135292063.2 | 138133196.5 | 141033993.6 | 143995707.5 | 147019617.4 | 150107029.3 | 153259276.9 | 156477721.8 | 159763753.9 | 163118792.8 | 166544287.4 | 170041717.4 | 173612593.5 | 177258458 | 180980885.6 | 184781484.2 | |
Fixed Operating Cost | 400000 | 404800 | 9000000 | 9126000 | 9253764 | 9383316.696 | 9514683.13 | 9647888.694 | 9782959.135 | 9919920.563 | 10058799.45 | 10199622.64 | 10342417.36 | 10487211.2 | 10634032.16 | 10782908.61 | 10933869.33 | 11086943.5 | 11242160.71 | 11399550.96 | 11559144.67 | 11720972.7 | |
Total Cash Outflow | 60000000 | 220150000 | 223412050 | 317500000 | 221920500 | 226431268.5 | 231034155.2 | 235731047.8 | 240523872.7 | 245414596 | 250405224.2 | 255497804.8 | 260694427.7 | 265997225.6 | 271408374.9 | 276930096.8 | 282564658.3 | 288314372.8 | 294181601.4 | 300168753.4 | 306278288.1 | 312512715.1 | 318874595.4 |
Sales price | 920 | 947.6 | 976.028 | 1005.30884 | 1035.468105 | 1066.532148 | 1098.528113 | 1131.483956 | 1165.428475 | 1200.391329 | 1236.403069 | 1273.495161 | 1311.700016 | 1351.051016 | 1391.582547 | 1433.330023 | 1476.329924 | 1520.619822 | 1566.238416 | 1613.225569 | 1661.622336 | 1711.471006 | |
Salvage Value | 5000000 | ||||||||||||||||||||||
Total Cash inflow | 138000000 | 142140000 | 292808400 | 301592652 | 310640431.6 | 319959644.5 | 329558433.8 | 339445186.9 | 349628542.5 | 360117398.7 | 370920920.7 | 382048548.3 | 393510004.8 | 405315304.9 | 417474764.1 | 429999007 | 442898977.2 | 456185946.5 | 469871524.9 | 483967670.6 | 498486700.8 | 518441301.8 | |
Net Cash Inflow /Outflow | -60000000 | -82150000 | -81272050 | -24691600 | 79672152 | 84209163.06 | 88925489.32 | 93827386.08 | 98921314.18 | 104213946.5 | 109712174.6 | 115423115.9 | 121354120.6 | 127512779.2 | 133906930 | 140544667.2 | 147434348.7 | 154584604.4 | 162004345.1 | 169702771.5 | 177689382.5 | 185973985.7 | 199566706.4 |
Building a new mill
Cash Flow Statement
|
|||||||||||||||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
Capacity of production | 400000 | ||||||||||||||||||||||
Capital Cost | 200000000 | 175000000 | 125000000 | 100000000 | |||||||||||||||||||
Offset compensation | 30000000 | ||||||||||||||||||||||
Additional working capital at the year 3 | 0 | ||||||||||||||||||||||
Operating Cost | |||||||||||||||||||||||
Labour cost ore tome | 130000000 | 132600000 | 88000000 | 89760000 | 91555200 | 93386304 | 95254030.08 | 97159110.68 | 99102292.9 | 101084338.8 | 103106025.5 | 105168146 | 107271509 | 109416939.1 | 111605277.9 | 113837383.5 | 116114131.1 | 118436413.8 | 120805142 | 123221244.9 | 125685669.8 | 128199383.2 | |
Material and another variable | 62250000 | 63557250 | 166000000 | 169486000 | 173045206 | 176679155.3 | 180389417.6 | 184177595.4 | 188045324.9 | 191994276.7 | 196026156.5 | 200142705.8 | 204345702.6 | 208636962.4 | 213018338.6 | 217491723.7 | 222059049.9 | 226722289.9 | 231483458 | 236344610.6 | 241307847.4 | 246375312.2 | |
Fixed Operating Cost | 400000 | 404800 | 11520000 | 11681280 | 11844817.92 | 12010645.37 | 12178794.41 | 12349297.53 | 12522187.69 | 12697498.32 | 12875263.3 | 13055516.98 | 13238294.22 | 13423630.34 | 13611561.17 | 13802123.02 | 13995352.74 | 14191287.68 | 14389965.71 | 14591425.23 | 14795705.18 | 15002845.06 | |
Total Cash Outflow | 200000000 | 367650000 | 321562050 | 395520000 | 270927280 | 276445223.9 | 282076104.7 | 287822242.1 | 293686003.6 | 299669805.4 | 305776113.8 | 312007445.3 | 318366368.8 | 324855505.8 | 331477531.8 | 338235177.7 | 345131230.2 | 352168533.8 | 359349991.4 | 366678565.8 | 374157280.7 | 381789222.4 | 389577540.5 |
Sales price | 920 | 947.6 | 976.028 | 1005.30884 | 1035.468105 | 1066.532148 | 1098.528113 | 1131.483956 | 1165.428475 | 1200.391329 | 1236.403069 | 1273.495161 | 1311.700016 | 1351.051016 | 1391.582547 | 1433.330023 | 1476.329924 | 1520.619822 | 1566.238416 | 1613.225569 | 1661.622336 | 1711.471006 | |
Salvage value | 75000000 | ||||||||||||||||||||||
Sale of Land | 51647141.93 | ||||||||||||||||||||||
Total Cash inflow | 138000000 | 142140000 | 390411200 | 402123536 | 414187242.1 | 426612859.3 | 439411245.1 | 452593582.5 | 466171390 | 480156531.6 | 494561227.6 | 509398064.4 | 524680006.4 | 540420406.6 | 556633018.7 | 573332009.3 | 590531969.6 | 608247928.7 | 626495366.5 | 645290227.5 | 664648934.4 | 811235544.3 | |
Net Cash Inflow /Outflow | -200000000 | -229650000 | -179422050 | -5108800 | 131196256 | 137742018.2 | 144536754.6 | 151589003 | 158907578.9 | 166501584.5 | 174380417.9 | 182553782.3 | 191031695.6 | 199824500.6 | 208942874.7 | 218397841.1 | 228200779.1 | 238363435.8 | 248897937.3 | 259816800.8 | 271132946.8 | 282859711.9 | 421658003.8 |
-
Financial Viability of the projects
NPV
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
Capacity of production | 300000 | ||||||||||||||||||||||
Capital Cost | 60000000 | 60000000 | 60000000 | 100000000 | |||||||||||||||||||
Additional working capital at the year 3 | 0 | ||||||||||||||||||||||
Operating Cost | |||||||||||||||||||||||
Labour cost ore tome | 97500000 | 99450000 | 84000000 | 85680000 | 87393600 | 89141472 | 90924301.44 | 92742787.47 | 94597643.22 | 96489596.08 | 98419388 | 100387775.8 | 102395531.3 | 104443441.9 | 106532310.7 | 108662957 | 110836216.1 | 113052940.4 | 115313999.2 | 117620279.2 | 119972684.8 | 122372138.5 | |
Material and another variable | 62250000 | 63557250 | 124500000 | 127114500 | 129783904.5 | 132509366.5 | 135292063.2 | 138133196.5 | 141033993.6 | 143995707.5 | 147019617.4 | 150107029.3 | 153259276.9 | 156477721.8 | 159763753.9 | 163118792.8 | 166544287.4 | 170041717.4 | 173612593.5 | 177258458 | 180980885.6 | 184781484.2 | |
Fixed Operating Cost | 400000 | 404800 | 9000000 | 9126000 | 9253764 | 9383316.696 | 9514683.13 | 9647888.694 | 9782959.135 | 9919920.563 | 10058799.45 | 10199622.64 | 10342417.36 | 10487211.2 | 10634032.16 | 10782908.61 | 10933869.33 | 11086943.5 | 11242160.71 | 11399550.96 | 11559144.67 | 11720972.7 | |
Write off expenses | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | |||
Total Cash Outflow | 60000000 | 220150000 | 223412050 | 322500000 | 226920500 | 231431268.5 | 236034155.2 | 240731047.8 | 245523872.7 | 250414596 | 255405224.2 | 260497804.8 | 265694427.7 | 270997225.6 | 276408374.9 | 281930096.8 | 287564658.3 | 293314372.8 | 299181601.4 | 305168753.4 | 311278288.1 | 317512715.1 | 323874595.4 |
Sales price | 920 | 947.6 | 976.028 | 1005.30884 | 1035.468105 | 1066.532148 | 1098.528113 | 1131.483956 | 1165.428475 | 1200.391329 | 1236.403069 | 1273.495161 | 1311.700016 | 1351.051016 | 1391.582547 | 1433.330023 | 1476.329924 | 1520.619822 | 1566.238416 | 1613.225569 | 1661.622336 | 1711.471006 | |
Salvage Value | 5000000 | ||||||||||||||||||||||
Total Cash inflow | 138000000 | 142140000 | 292808400 | 301592652 | 310640431.6 | 319959644.5 | 329558433.8 | 339445186.9 | 349628542.5 | 360117398.7 | 370920920.7 | 382048548.3 | 393510004.8 | 405315304.9 | 417474764.1 | 429999007 | 442898977.2 | 456185946.5 | 469871524.9 | 483967670.6 | 498486700.8 | 518441301.8 | |
Net Cash Inflow /Outflow | -60000000 | -82150000 | -81272050 | -29691600 | 74672152 | 79209163.06 | 83925489.32 | 88827386.08 | 93921314.18 | 99213946.46 | 104712174.6 | 110423115.9 | 116354120.6 | 122512779.2 | 128906930 | 135544667.2 | 142434348.7 | 149584604.4 | 157004345.1 | 164702771.5 | 172689382.5 | 180973985.7 | 194566706.4 |
Profit | -22150000 | -21272050 | 70308400 | 74672152 | 79209163.06 | 83925489.32 | 88827386.08 | 93921314.18 | 99213946.46 | 104712174.6 | 110423115.9 | 116354120.6 | 122512779.2 | 128906930 | 135544667.2 | 142434348.7 | 149584604.4 | 157004345.1 | 164702771.5 | 172689382.5 | 180973985.7 | 194566706.4 | |
Tax | -6645000 | -6381615 | 21092520 | 22401645.6 | 23762748.92 | 25177646.79 | 26648215.82 | 28176394.25 | 29764183.94 | 31413652.37 | 33126934.76 | 34906236.17 | 36753833.75 | 38672079.01 | 40663400.17 | 42730304.6 | 44875381.31 | 47101303.54 | 49410831.44 | 51806814.75 | 54292195.71 | 58370011.93 | |
Profit after tax | -15505000 | -14890435 | 49215880 | 52270506.4 | 55446414.14 | 58747842.52 | 62179170.26 | 65744919.92 | 69449762.53 | 73298522.21 | 77296181.11 | 81447884.4 | 85758945.43 | 90234851.03 | 94881267.06 | 99704044.06 | 104709223.1 | 109903041.6 | 115291940 | 120882567.8 | 126681790 | 136196694.5 | |
Discounting Factor | 0.8928571 | 0.7971939 | 0.7117802 | 0.63551808 | 0.567426856 | 0.506631121 | 0.452349215 | 0.403883228 | 0.360610025 | 0.321973237 | 0.287476104 | 0.256675093 | 0.22917419 | 0.204619813 | 0.182696261 | 0.163121662 | 0.145644341 | 0.13003959 | 0.116106777 | 0.103666765 | 0.092559612 | 0.08264251 | |
Cumulative Cash Flows | -60000000 | -75505000 | -74890435 | -50784120 | 52270506.4 | 55446414.14 | 58747842.52 | 62179170.26 | 65744919.92 | 69449762.53 | 73298522.21 | 77296181.11 | 81447884.4 | 85758945.43 | 90234851.03 | 94881267.06 | 99704044.06 | 104709223.1 | 109903041.6 | 115291940 | 120882567.8 | 126681790 | 136196694.5 |
Discounted Cash Flow | -60000000 | -67415179 | -59702196 | -36147134 | 33218851.8 | 31461784.44 | 29763485.32 | 28126698.88 | 26553270.48 | 25044280.6 | 23600162.43 | 22220805.01 | 20905643.3 | 19653736.86 | 18463838.31 | 17334452.76 | 16263889.36 | 15250305.78 | 14291746.48 | 13386175.56 | 12531504.75 | 11725617.29 | 11255636.74 |
NPV | 167787377.8 | ||||||||||||||||||||||
PI | 60% |
Computation of cash flow for each alternative Building a new mil | |||||||||||||||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
Capacity of production | 400000 | ||||||||||||||||||||||
Capital Cost | 200000000 | 175000000 | 125000000 | 100000000 | |||||||||||||||||||
Offset compensation | 30000000 | ||||||||||||||||||||||
Additional working capital at the year 3 | 0 | ||||||||||||||||||||||
Operating Cost | |||||||||||||||||||||||
Labour cost ore tome | 130000000 | 132600000 | 88000000 | 89760000 | 91555200 | 93386304 | 95254030.08 | 97159110.68 | 99102292.9 | 101084338.8 | 103106025.5 | 105168146 | 107271509 | 109416939.1 | 111605277.9 | 113837383.5 | 116114131.1 | 118436413.8 | 120805142 | 123221244.9 | 125685669.8 | 128199383.2 | |
Material and another variable | 62250000 | 63557250 | 166000000 | 169486000 | 173045206 | 176679155.3 | 180389417.6 | 184177595.4 | 188045324.9 | 191994276.7 | 196026156.5 | 200142705.8 | 204345702.6 | 208636962.4 | 213018338.6 | 217491723.7 | 222059049.9 | 226722289.9 | 231483458 | 236344610.6 | 241307847.4 | 246375312.2 | |
Fixed Operating Cost | 400000 | 404800 | 11520000 | 11681280 | 11844817.92 | 12010645.37 | 12178794.41 | 12349297.53 | 12522187.69 | 12697498.32 | 12875263.3 | 13055516.98 | 13238294.22 | 13423630.34 | 13611561.17 | 13802123.02 | 13995352.74 | 14191287.68 | 14389965.71 | 14591425.23 | 14795705.18 | 15002845.06 | |
Write of Expenses | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | 31500000 | |||
Total Cash Outflow | 200000000 | 192650000 | 196562050 | 295520000 | 270927280 | 276445223.9 | 282076104.7 | 287822242.1 | 293686003.6 | 299669805.4 | 305776113.8 | 312007445.3 | 318366368.8 | 324855505.8 | 331477531.8 | 338235177.7 | 345131230.2 | 352168533.8 | 359349991.4 | 366678565.8 | 374157280.7 | 381789222.4 | 389577540.5 |
Sales price | 920 | 947.6 | 976.028 | 1005.30884 | 1035.468105 | 1066.532148 | 1098.528113 | 1131.483956 | 1165.428475 | 1200.391329 | 1236.403069 | 1273.495161 | 1311.700016 | 1351.051016 | 1391.582547 | 1433.330023 | 1476.329924 | 1520.619822 | 1566.238416 | 1613.225569 | 1661.622336 | 1711.471006 | |
Salvage value | 75000000 | ||||||||||||||||||||||
Sale of Land | 51647141.93 | ||||||||||||||||||||||
Total Cash inflow | 138000000 | 142140000 | 390411200 | 402123536 | 414187242.1 | 426612859.3 | 439411245.1 | 452593582.5 | 466171390 | 480156531.6 | 494561227.6 | 509398064.4 | 524680006.4 | 540420406.6 | 556633018.7 | 573332009.3 | 590531969.6 | 608247928.7 | 626495366.5 | 645290227.5 | 664648934.4 | 811235544.3 | |
Net Cash Inflow /Outflow | -200000000 | -54650000 | -54422050 | 94891200 | 131196256 | 137742018.2 | 144536754.6 | 151589003 | 158907578.9 | 166501584.5 | 174380417.9 | 182553782.3 | 191031695.6 | 199824500.6 | 208942874.7 | 218397841.1 | 228200779.1 | 238363435.8 | 248897937.3 | 259816800.8 | 271132946.8 | 282859711.9 | 421658003.8 |
Profit | 75350000 | 78177950 | 181391200 | 189456256 | 197797218.2 | 206423058.6 | 215343033.1 | 224566689.6 | 234103877.4 | 243964756.6 | 254159807.8 | 264699841.7 | 275596009.5 | 286859813.9 | 298503119 | 310538162.6 | 322977567 | 335834351.1 | 349121942.8 | 362854191.7 | 377045381.7 | 518357387 | |
Tax | 22605000 | 23453385 | 54417360 | 56836876.8 | 59339165.45 | 61926917.59 | 64602909.94 | 67370006.88 | 70231163.22 | 73189426.99 | 76247942.34 | 79409952.5 | 82678802.86 | 86057944.16 | 89550935.71 | 93161448.78 | 96893270.09 | 100750305.3 | 104736582.8 | 108856257.5 | 113113614.5 | 155507216.1 | |
Profit after tax | 52745000 | 54724565 | 126973840 | 132619379 | 138458052.7 | 144496141.1 | 150740123.2 | 157196682.7 | 163872714.2 | 170775329.7 | 177911865.5 | 185289889.2 | 192917206.7 | 200801869.7 | 208952183.3 | 217376713.8 | 226084296.9 | 235084045.8 | 244385360 | 253997934.2 | 263931767.2 | 362850170.9 | |
Discounting Factor | 0.8928571 | 0.7971939 | 0.7117802 | 0.63551808 | 0.567426856 | 0.506631121 | 0.452349215 | 0.403883228 | 0.360610025 | 0.321973237 | 0.287476104 | 0.256675093 | 0.22917419 | 0.204619813 | 0.182696261 | 0.163121662 | 0.145644341 | 0.13003959 | 0.116106777 | 0.103666765 | 0.092559612 | 0.08264251 | |
Cumulative Cash Flows | -200000000 | 52745000 | 54724565 | 126973840 | 132619379 | 138458052.7 | 144496141.1 | 150740123.2 | 157196682.7 | 163872714.2 | 170775329.7 | 177911865.5 | 185289889.2 | 192917206.7 | 200801869.7 | 208952183.3 | 217376713.8 | 226084296.9 | 235084045.8 | 244385360 | 253997934.2 | 263931767.2 | 362850170.9 |
Discounted Cash Flow | -200000000 | 47093750 | 43626088 | 90377471 | 84282013 | 78564817.5 | 73206241.95 | 68187176.44 | 63489103.64 | 59094143.55 | 54985085.62 | 51145409.96 | 47559299.52 | 44211644.6 | 41088040.95 | 38174782.67 | 35458850.81 | 32927898.41 | 30570232.95 | 28374796.47 | 26331144.17 | 24429421.88 | 29986849.03 |
NPV | 893164262.6 | ||||||||||||||||||||||
PI | 142% |
IRR
For the modernisation of project is 13.24%
For building of new project is 15.54%
Profitability Index
For the modernisation of project: 60%
For building of new project is 142%
8. Acceptance or Rejection of Project
Both the project has the positive NPV as well as good IRR. The profitability index So on the basis of capital budgeting techniques, company can accept both the projects.
- IF the project is mutually exclusive, then the calculation of NPV is very important, because to will justify whether the project is acceptable or not, IF the test signifies positive results of NPV, and the value of IRR is more than discounting rate, so the project should be acceptable.
9. NPV in given scenario
- NPV for the modernisation is 157098196
NPV of Building new project is 825822423
- If the sale price is 950
NPV for the modernisation is 210614589
NPV of Building new project is 895377948
- If variable cost is 415
NPV for the modernisation is 202549997
NPV of Building new project is 887313355
- Yes, the project sensitivity is very important to the project, it changes the decision s change in the variable. The Highest NPV model should be selected
10. Discount Rate
The discount rate will be the rate which is presently serving in the market as per the industry, So the discus rate is low than IRR, hence it is suitable it uses same discounting rate for the same
11. Recommendation
On the basis of above information, it had been recommended that, company should use the project with the highest NPV, in the analyses m to had been observed that the building new project will be more successful , as it given positive NOV in each scenario, as well as have the highest profitability index, So the company must go with the new building and relocating.
References
Chesbrough, H., Lettl, C., & Ritter, T. (2018). Value creation and value capture in open innovation. Journal of Product Innovation Management, 35(6), 930-938.
Feldman, G., & Wong, K. F. E. (2018). When action-inaction framing leads to higher escalation of commitment: A new inaction-effect perspective on the sunk-cost fallacy. Psychological science, 29(4), 537-548.
Harrison, J. S., Freeman, R. E., & Abreu, M. C. S. D. (2015). Stakeholder theory as an ethical approach to effective management: Applying the theory to multiple contexts. Revista brasileira de gestão de negócios, 17(55), 858-869.
Lappi, D. (2020). Sustainability Reporting Transparency among Front-runners of the Practice: An embedded single case study from the Finnish forest, paper, and pulp industry.
Leyman, P., & Vanhoucke, M. (2017). Capital-and resource-constrained project scheduling with net present value optimization. European Journal of Operational Research, 256(3), 757-776.
Pivorienė, A. (2017). Real options and discounted cash flow analysis to assess strategic investment projects. Economics and Business, 30(1), 91-101.
Vidal, N. G., Berman, S., & Buren, H. V. (2015). Stakeholder theory and value creation models in Brazilian firms. Revista brasileira de gestão de negócios, 17(55), 911-931.
Yan, X., & Otto, A. R. (2020). Cognitive effort investment and opportunity costs in strategic decision-making: An individual differences examination. Personality and Individual Differences, 167, 110283.
Zovico, N. (2020). The Sustainable Development Goals: an analysis of Sustainability Reporting in the Italian Paper and Pulp Industry (Doctoral dissertation, Politecnico di Torino).