SOLVE IN EXCEL AND POST DETALS AND FORMULAS STEP BY STEP

You are considering investing in a project that requires an initial investment of $500,000. The project is expected to generate cash flows of $100,000 per year for the next 10 years, however, at the end of the fifth year, the project will require an additional investment of $60,000 to continue operations for another 5 years. At the end of the tenth year, the project has an expected salvage value of $180,000. We assume $250,000 is borrowed at (AAA+5)% annual compound interest and repaid in 10 years. We will use a 10-year planning horizon, a 21% tax rate, an (AAA+3)% BTMARR, and DDB depreciation method. Determine ATMARR, and then the preferred payment plan based on ATPW and determine the ATFW, ATAW, ATIRR, and ATERR for each of the following four plans: a) Plan 1: Pay interest each period, but make no principal payment until the end of the loan period b) Plan 2: Make equal end-of-period principal payments and pay interest each period on the unpaid balance at the beginning of the period c) Plan 3: Make equal end-of-period payments over the loan period d) Plan 4: Make no payment until the end of the loan period