Old MathJax webview

please see attached cash flow. here is some more information: - salvage value: 720,000 $Mn yen - economic life: 2 years - discount rate: assume 10%

can I please get some help generating: NPV, IRR, payback, BCR, LCC and EAC

thank you

I only have the information that capital investment is 500,000myen. I assume that that is all of the initial investments combined.

please let me know what other information is required.

thank you for your help.

1 L M N O P R 5 U V 1 9 (millions of yen) 2017 2 2028 3 2029 4 2030 5 2031 6 2032 7 2033 8 2034 10 2036 11 2037 2027 2035 288,5541 - 162,000 - 180,000 -$1.500 - 53,446 - 16,194 -37,252 302,982 - 162,000 - 90,000 -$1,429 50,982 15,4471 35,534 318,131 - 162,000 -60,000 -$1,357 96,131 29,128 67,003 334,037 - 162,000 - 45,000 -$1,284 -$ 127,037 38,492 288,555 -162,000 -36,000 -$1,212 90,5551 27,438 63,1171 302,983 - 162,000 - 30,000 -$1,139 110,983 33,628 77,3551 318,132 - 162,000 -25,714 -$1,066 130,418 39,517 90,901 334,038 - 162,000 - 22,500 -$992 149,538 45,310 104,228 334,038 - 162.0001 - 20,000 -5918 152,0381 46,068) 105,971 334,038 -X162,000 - 18,000 -5843 154,038 46,674 107,365 334,038 - 162,000 - 16,364 -$769 155,675 47,169 108,505 88,545 Cash flow statement Year Income statement +Revenue -O&M cost Depreciation -Debt interest Taxable income -Income tax Net income Cash flow statement Operating activities +Net income Depreciation Investing activities -Capital investment +Salvage value -Gains tax loss -investment in working Capital Working capital recovery Financing activities Borrowed Funds -Repayment of principal Netcash flow 67,003 -37,252 180,000 35,534 90.000 88.549 45,000 63.117 36.000 77,355 30,000 90,901 25,714 104,228 22.500 X60.000 105,971) 20,000 107.365 18,000 108,505 16,364 -500,000 $300,000 -$14,300 -$14,371 -$14,443 $14,516 200,000 $ 128,448 $ 111,163 $ 112,560 $ 119,029 $ -$14,588 84,5291 -$ -$14,661 -$14,734 -$14,808 $14,8821 -$14,956 -$15,031 92,694 $ 101,881 $ 111,920 $ 111,089 $ 110,408 $ 109,838 12 2038 13 2039 14 2040 15 2041 16 2042 17 2043 18 2044 19 2045 20 2046 Year Income statement +Revenue -O&M cost -Depreciation -Debt interest 2037 Completion of Nagoya - Osaka Increase in Revenue Increase in Maintenance Costs 602,094 -302,000 -15,000 -$694 285,094 602,094 -302,000 - 13,846 -$618 286,248 86,733 199,5151 602,094 -302,000 - 12,857 -5542 287,237 87,033 200,204 602,094 -302,000 - 12,000 -5466 288,094 87,293 200,802 602,0941 - 302,000 - 11,250 $3891 288.844 87,520 201,325 602,094 -302,000 - 10,588 -$312 289,506 87,720 201,786 602,094 -302,000 - 10,000 -52351 290,094 87,899 202,196 602,094 -302,000 - 9,474 -$157) 290,621 88,058 202,563 602,094 -302,000 - 9,000 -579 291,094 88,202 202,893 Taxable income 86,384 198,711 198,711 15,000 199,515 13,846 200,204 12.857 200,802 12.000 201,325 11,250 201,786 10,588 202,196 10.0001 202.563 9,474 202,893 9,000 |-Income tax Net income Net Income Cash flow statement Operating activities ... Petang +Net income | Depreciation Investing activities -Capital investment +Salvage value -Gains tax loss -investment in working Capital Working capital recovery Financing activities |+Borrowed Funds - Repayment of principal 720,000 - \215,433 -$15,106 -$15,1821 -$15,258 -515,334 -$15,411 -$15,488 $15,565 -$15,64 -515,721 $ 198,604 S 198,1795 197,804 $ 197,468 $ 197,164 $ 196,886 $ 196,631 S 196,393 $ 700,739 1 L M N O P R 5 U V 1 9 (millions of yen) 2017 2 2028 3 2029 4 2030 5 2031 6 2032 7 2033 8 2034 10 2036 11 2037 2027 2035 288,5541 - 162,000 - 180,000 -$1.500 - 53,446 - 16,194 -37,252 302,982 - 162,000 - 90,000 -$1,429 50,982 15,4471 35,534 318,131 - 162,000 -60,000 -$1,357 96,131 29,128 67,003 334,037 - 162,000 - 45,000 -$1,284 -$ 127,037 38,492 288,555 -162,000 -36,000 -$1,212 90,5551 27,438 63,1171 302,983 - 162,000 - 30,000 -$1,139 110,983 33,628 77,3551 318,132 - 162,000 -25,714 -$1,066 130,418 39,517 90,901 334,038 - 162,000 - 22,500 -$992 149,538 45,310 104,228 334,038 - 162.0001 - 20,000 -5918 152,0381 46,068) 105,971 334,038 -X162,000 - 18,000 -5843 154,038 46,674 107,365 334,038 - 162,000 - 16,364 -$769 155,675 47,169 108,505 88,545 Cash flow statement Year Income statement +Revenue -O&M cost Depreciation -Debt interest Taxable income -Income tax Net income Cash flow statement Operating activities +Net income Depreciation Investing activities -Capital investment +Salvage value -Gains tax loss -investment in working Capital Working capital recovery Financing activities Borrowed Funds -Repayment of principal Netcash flow 67,003 -37,252 180,000 35,534 90.000 88.549 45,000 63.117 36.000 77,355 30,000 90,901 25,714 104,228 22.500 X60.000 105,971) 20,000 107.365 18,000 108,505 16,364 -500,000 $300,000 -$14,300 -$14,371 -$14,443 $14,516 200,000 $ 128,448 $ 111,163 $ 112,560 $ 119,029 $ -$14,588 84,5291 -$ -$14,661 -$14,734 -$14,808 $14,8821 -$14,956 -$15,031 92,694 $ 101,881 $ 111,920 $ 111,089 $ 110,408 $ 109,838 12 2038 13 2039 14 2040 15 2041 16 2042 17 2043 18 2044 19 2045 20 2046 Year Income statement +Revenue -O&M cost -Depreciation -Debt interest 2037 Completion of Nagoya - Osaka Increase in Revenue Increase in Maintenance Costs 602,094 -302,000 -15,000 -$694 285,094 602,094 -302,000 - 13,846 -$618 286,248 86,733 199,5151 602,094 -302,000 - 12,857 -5542 287,237 87,033 200,204 602,094 -302,000 - 12,000 -5466 288,094 87,293 200,802 602,0941 - 302,000 - 11,250 $3891 288.844 87,520 201,325 602,094 -302,000 - 10,588 -$312 289,506 87,720 201,786 602,094 -302,000 - 10,000 -52351 290,094 87,899 202,196 602,094 -302,000 - 9,474 -$157) 290,621 88,058 202,563 602,094 -302,000 - 9,000 -579 291,094 88,202 202,893 Taxable income 86,384 198,711 198,711 15,000 199,515 13,846 200,204 12.857 200,802 12.000 201,325 11,250 201,786 10,588 202,196 10.0001 202.563 9,474 202,893 9,000 |-Income tax Net income Net Income Cash flow statement Operating activities ... Petang +Net income | Depreciation Investing activities -Capital investment +Salvage value -Gains tax loss -investment in working Capital Working capital recovery Financing activities |+Borrowed Funds - Repayment of principal 720,000 - \215,433 -$15,106 -$15,1821 -$15,258 -515,334 -$15,411 -$15,488 $15,565 -$15,64 -515,721 $ 198,604 S 198,1795 197,804 $ 197,468 $ 197,164 $ 196,886 $ 196,631 S 196,393 $ 700,739