how would i go about doing this problem through excell any help is appreciated.

1) You purchased an airplane for $300,000 and will depreciate it using a 5-year MACRS, but it will only have a 4-year life. You will finance (get a loan) for half of the $150,000, which you will repay in 4 equal annual payments. Interest rate of the loan is 12% annual rate, compounded annually. The remaining $150,000 will be financed by your company. Salvage value in year 4 of the plane is expected to be $80,000. The airplane is expected to increase revenues by $75,000 per year, however, O&M costs are expected to be $30,000 per year. Your accountants advise you that you will be required to invest $25,000 in Working Capital initially, which will be released when the project is complete. Your company is in a 25% tax bracket and your MARR is 18%. Show the end of year cash flows for this project for years 0 through 4. What is the Net Present Worth of this investment? . B G H 1 Income Statement and Cash Flow Statement 0 2 2 3 4 5 3 Income statement 25% 4 tax rate 5 Revenues 6 Expenses 7 O&M 8 Labor 9 Material 10 Overhead 11 Depreciation 12 Debt Interest 13 14 Taxable income 15 Income taxes 16 17 Net income 18 19 Cash Flow Statement 20 21 Operating activities 22 Net income 23 Depreciation 24 Investment activities 25 Investment 26 Salvage 27 Gains tax 28 Working capital 29 Financing activities 30 Borrowed funds 31 Principal repayment 32 33 Net Cash Flow 34 35 NPV 36 NPV(manually) 37 IRR 38 1) You purchased an airplane for $300,000 and will depreciate it using a 5-year MACRS, but it will only have a 4-year life. You will finance (get a loan) for half of the $150,000, which you will repay in 4 equal annual payments. Interest rate of the loan is 12% annual rate, compounded annually. The remaining $150,000 will be financed by your company. Salvage value in year 4 of the plane is expected to be $80,000. The airplane is expected to increase revenues by $75,000 per year, however, O&M costs are expected to be $30,000 per year. Your accountants advise you that you will be required to invest $25,000 in Working Capital initially, which will be released when the project is complete. Your company is in a 25% tax bracket and your MARR is 18%. Show the end of year cash flows for this project for years 0 through 4. What is the Net Present Worth of this investment? . B G H 1 Income Statement and Cash Flow Statement 0 2 2 3 4 5 3 Income statement 25% 4 tax rate 5 Revenues 6 Expenses 7 O&M 8 Labor 9 Material 10 Overhead 11 Depreciation 12 Debt Interest 13 14 Taxable income 15 Income taxes 16 17 Net income 18 19 Cash Flow Statement 20 21 Operating activities 22 Net income 23 Depreciation 24 Investment activities 25 Investment 26 Salvage 27 Gains tax 28 Working capital 29 Financing activities 30 Borrowed funds 31 Principal repayment 32 33 Net Cash Flow 34 35 NPV 36 NPV(manually) 37 IRR 38