Please calculate in excel, I need Five-year cash flow & Calculate NPV, IRR and Payback Period. investment 250.00 million

Apple Inc. 5 Year Cash Flow Statement Sep 26, 2015 53,394 US$ in millions 12 months ended: Net income Depreciation and amortization Share-based compensation expense Deferred income tax expense (benefit) Other Accounts receivable, net Inventories Vendor non-trade receivables Other current and non-current assets Accounts payable Deferred revenue Other current and non-current liabilities Changes in operating assets and liabilities Adjustments to reconcile net income to cash generated by operating activities Cash generated by operating activities Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net Purchases of non-marketable securities Proceeds from non-marketable securities Other Cash (used in) generated by investing activities Proceeds from issuance of common stock Excess tax benefits from equity awards Sep 28, 2019 55,256 12,547 6,068 (340) (652) 245 (289) 2,931 873 (1,923) (625) (4,700) (3,488) Sep 29, 2018 59,531 10,903 5,340 (32,590) (444) (5,322) 828 (8,010) (423) 9,175 (44) 38,490 34,694 Sep 30, 2017 48,351 10,157 4,840 5,966 (166) (2,093) (2,723) (4,254) (5,318) 9,618 (626) (154) (5,550) Sep 24, 2016 45,687 10,505 4,210 4,938 486 527 217 (51) 1,055 1,837 (1,554) (2,033) (2) 11,257 3,586 1,382 385 417 (238) (3,735) (283) 5,001 1,042 9,058 11,262 17,903 77,434 (71,356) 55,881 14,135 69,391 (39,630) 40,102 56,988 (10,495) (624) (1,001) 1,634 (1,078) 45,896 781 15,247 63,598 (159,486) 31,775 94,564 (12,451) (329) (521) 126 (124) (46,446) 555 627 20,137 65,824 (142,428) 21,258 90,536 (12,734) (297) (1,388) 27,872 81,266 (166,402) 14,538 107,447 (11,247) (343) 47,838 (13,313) (721) (1,871) 353 (745) 16,066 669 (924) (45,977) 495 407 (267) (56,274) 543 749 14,135 69,391 (39,630) 40,102 Adjustments to reconcile net income to cash generated by operating activities Cash generated by operating activities Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net Purchases of non-marketable securities Proceeds from non-marketable securities Other Cash (used in) generated by investing activities Proceeds from issuance of common stock Excess tax benefits from equity awards Payments for taxes related to net share settlement of equity awards Payments for dividends and dividend equivalents Repurchases of common stock Proceeds from issuance of term debt, net Repayments of term debt Proceeds from (repayments of) commercial paper, net Other Cash used in financing activities 17,903 77,434 (71,356) 55,881 47,838 (13,313) (721) (1,871) 353 (745) 16,066 669 20,137 65,824 (142,428) 21,258 90,536 (12,734) (297) (1,388) 15,247 63,598 (159,486) 31,775 94,564 (12,451) (329) (521) 126 (124) (46,446) 555 627 27,872 81,266 (166,402) 14,538 107,447 (11,247) (343) 56,988 (10,495) (624) (1,001) 1,634 (1,078) 45,896 781 (924) (45,977) 495 407 (267) (56,274) 543 749 (2,817) (14,119) (66,897) 6,963 (8,805) (5,977) (105) (90,976) (2,527) (13,712) (72,738) 6,969 (6,500) (37) (1,874) (12,769) (32,900) 28,662 (3,500) 3,852 (1,570) (12,150) (29,722) 24,954 (2,500) (397) (1,499) (11,561) (35,253) 27,114 2,191 (87,876) (17,347) (20,483) (17,716) Increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash, beginning balances Cash, cash equivalents and restricted cash, ending balances 24,311 25,913 50,224 5,624 20,289 25,913 (195) 20,484 20,289 (636) 21,120 20,484 7,276 13,844 21,120 Apple Inc. 5 Year Cash Flow Statement Sep 26, 2015 53,394 US$ in millions 12 months ended: Net income Depreciation and amortization Share-based compensation expense Deferred income tax expense (benefit) Other Accounts receivable, net Inventories Vendor non-trade receivables Other current and non-current assets Accounts payable Deferred revenue Other current and non-current liabilities Changes in operating assets and liabilities Adjustments to reconcile net income to cash generated by operating activities Cash generated by operating activities Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net Purchases of non-marketable securities Proceeds from non-marketable securities Other Cash (used in) generated by investing activities Proceeds from issuance of common stock Excess tax benefits from equity awards Sep 28, 2019 55,256 12,547 6,068 (340) (652) 245 (289) 2,931 873 (1,923) (625) (4,700) (3,488) Sep 29, 2018 59,531 10,903 5,340 (32,590) (444) (5,322) 828 (8,010) (423) 9,175 (44) 38,490 34,694 Sep 30, 2017 48,351 10,157 4,840 5,966 (166) (2,093) (2,723) (4,254) (5,318) 9,618 (626) (154) (5,550) Sep 24, 2016 45,687 10,505 4,210 4,938 486 527 217 (51) 1,055 1,837 (1,554) (2,033) (2) 11,257 3,586 1,382 385 417 (238) (3,735) (283) 5,001 1,042 9,058 11,262 17,903 77,434 (71,356) 55,881 14,135 69,391 (39,630) 40,102 56,988 (10,495) (624) (1,001) 1,634 (1,078) 45,896 781 15,247 63,598 (159,486) 31,775 94,564 (12,451) (329) (521) 126 (124) (46,446) 555 627 20,137 65,824 (142,428) 21,258 90,536 (12,734) (297) (1,388) 27,872 81,266 (166,402) 14,538 107,447 (11,247) (343) 47,838 (13,313) (721) (1,871) 353 (745) 16,066 669 (924) (45,977) 495 407 (267) (56,274) 543 749 14,135 69,391 (39,630) 40,102 Adjustments to reconcile net income to cash generated by operating activities Cash generated by operating activities Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net Purchases of non-marketable securities Proceeds from non-marketable securities Other Cash (used in) generated by investing activities Proceeds from issuance of common stock Excess tax benefits from equity awards Payments for taxes related to net share settlement of equity awards Payments for dividends and dividend equivalents Repurchases of common stock Proceeds from issuance of term debt, net Repayments of term debt Proceeds from (repayments of) commercial paper, net Other Cash used in financing activities 17,903 77,434 (71,356) 55,881 47,838 (13,313) (721) (1,871) 353 (745) 16,066 669 20,137 65,824 (142,428) 21,258 90,536 (12,734) (297) (1,388) 15,247 63,598 (159,486) 31,775 94,564 (12,451) (329) (521) 126 (124) (46,446) 555 627 27,872 81,266 (166,402) 14,538 107,447 (11,247) (343) 56,988 (10,495) (624) (1,001) 1,634 (1,078) 45,896 781 (924) (45,977) 495 407 (267) (56,274) 543 749 (2,817) (14,119) (66,897) 6,963 (8,805) (5,977) (105) (90,976) (2,527) (13,712) (72,738) 6,969 (6,500) (37) (1,874) (12,769) (32,900) 28,662 (3,500) 3,852 (1,570) (12,150) (29,722) 24,954 (2,500) (397) (1,499) (11,561) (35,253) 27,114 2,191 (87,876) (17,347) (20,483) (17,716) Increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash, beginning balances Cash, cash equivalents and restricted cash, ending balances 24,311 25,913 50,224 5,624 20,289 25,913 (195) 20,484 20,289 (636) 21,120 20,484 7,276 13,844 21,120