Please show how to calculate the Discounted Cash Glows using Excel. i will have to do this in Excel on the exam.

36,512,809 8,100,000 42,645,109 2,700,000 55,909,60959,967,109 900,000 900.000 25 Project Cash Flows 26 Year 27 OCF 28 Change in NWC 29 Capital spending 30 Total cash flow 31 Cumulative cash flow 32 Discounted cash flows 33 Cumulative discounted cash flow 65,000,000 65,000,000 65,000,000 64,221,169 (12,600,000) 5,810,315 57.431,484 330,066,118 44,612,809 109,612,809 45,345,10956,809,609 60,867,109 154,957,917 211,767,526 272,634,634 Electron Americas can manufacture the new smart phones for $350 each in variable costs. Fixed costs for the operation are estimated to run $4.25 million per year. The estimated sales volume is 80,000; 90,000; 120,000; 130,000; and 140,000 per year for the next five years, respectively. The unit price of the new smart phone will be $600. The necessary equipment can be purchased for $65 million and will be depreciated on a seven-year MACRS schedule. It is believed the value of the equipment in five years will be $3.5 million. The effective tax rate for the company is 21%. The project requires no initial NWC investment, and it requires NWC balance equal to 15% of sales, thereafter. The required return for the project is 14% 38.517.000 42.005.00 55,900.60 59.900.000 og 20.00 36,512,809 8,100,000 42,645,109 2,700,000 25 Project Cash Flows 26 Year 27 OCF 28. Change in NWC 29 Capital spending 30 Total cash flow 31 Cumulative cash flow 32 Discounted cash flows 33 Cumulative discounted cash flow 65,000,000 65,000,000 65,000,000 55,909,609 59,967,10964,221,169 900,000 900,000 (12,600,000) 5,810,315 56,809,609 60,867,109 57,431,484 211.767.526 272,634,634 330,066,118 44,612,809 109,612,809 45,345,109 154,957,917