use this sheet to solve the problem

ignore the second data sheet

EX* t ## 1) You purchased an airplane for $500,000 and will depreciate it using a 7-year MACRS, but it will only have a 4-year life. You will finance (get a loan) for half of the $500,000, which you will repay in 4 equal annual payments. Interest rate of the loan is 12% annual rate, compounded annually. The remaining $250,000 will be financed by your company. Salvage value in year 4 of the plane is expected to be $220,000. The airplane is expected to increase revenues by $200,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 $40,000 in Working Capital initially, which will be released when the project is complete. Your company is in a 21% tax bracket and your MARR is 18%. Show the end of year cash flows for this project for years through 4. What is the Net Present Worth of this investment? Times New Roma B at E Year 0 PL Year 1 Year 2 Year 3 Year 4 NPW 384 Generalized Cash Flow approach - if marginal tax rate will remain the same 5 6 N Cash flow elements tax rate Investment in San win Operating (1-mon 11-min (1 mln Em D Financing Bn PPA Net Cash flow An Income Statement and Cash Flow Statement 1 2 3 4 21% Income statement tax rate Revenues Expenses O&M Labor Material Overhead Depreciation Debt interest Taxable income Income taxes Net Income Cash Flow Statement Operating activities Net income Depreciation Investment activities Investment Salvage Gains tax Working capital Financing activities Borrowed funds Principal repayment Net Cash Flow NPV NPV(manually) IRR