Home Insert Draw Page Layout Formulas Data Review View & Conditional Formattin Times New Roman 11 ' ' General Format as Table Paste BIU PR a A $ % Cell Styles Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates. 1 K40 x A B L M N Below is information for planned expansion project by Plan 9 records. Use the information provided to calculate: 2 Calculate the Initial Outlay, Alar Tu Cash Flows, and Terminal Cash Flow. Use only Cell references and females in the yellow cells! 3 2 Calculate the total Cash Flows for the project in the orange cells. Use only cell references and formular in the orange cells 4 3 spis Calculate the NPV, PI, IRR and MERR for the project given Plane's WACC, the the WACC as the med fancing and investing rate 5 La MIRR 6 10. Give 2 reasons why Plaethould accept or reject the project. 2 15 pts Plan 9 is analyzing opening a second Richmond record store near VCU. They already own a building near campus. They could sell the buildng for $200,000 (assume that is the current book value on the building as well.) 10 11-They expect EBIT for the project to be $15,000 in the 1st year and then grow by 5% each year after that. 12 They expect Not Working capital will increase by $5,000 to start the business (this will be your initial NWC for the store), then increase with sales. 13] The building will be depreciated on a straight line basis over 20 years 14-They plan to keep the store open for 5 years and then sell the building for $220,000 15Net working capital will return to its previous level prior to opening the new store -There will be no shut down expenses for closing the store. 17 -Their marginal tax rate is 25%. Assume Plan 9's WACC is 10% 18 19 Tax Rate 2594 20 Grob 59 21 EBIT Year) $15.000 22 Initial NWC for store S5.000 23 Building Me) $200,000 24 Deprecatele 20 25 din salar $220.000 NOPATEBIT "Ne rating Profit der Tax 26 Initial Outlay Alter Tax Cash Flows 27 Building Year Year Year Year Year Year 28 Initial NWC 0 2 3 4 29 Total Initial Outla EBIT include growth! 30 Terminal Cash Flow NORAT 31 Building Depreciation 32 Cost Basis NWC for Stan 33 Cla Change is NWC 34 Taxon Cain ATCP Change in NWC Total Terminal Cash Flow 32 $ Call St Paste B ZU A $ % 98 99 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. K40 x fx G M 1 E D 1 Year Year 3 5 Cine ENOPAMMERIT after sex "el Operating Profit After Tar" After Tax Cash Flow Year Year Year 0 1 2 EBIT NOPAT Depreciation NWC for Star Change in NWC ATCE: 19 Tex Rare 25% 20 Growth 596 21 BBIT (Year 1) $15.000 22 Initial NWC for store $5,000 23 Building Time 0) $200,000 24 Depreciable 20 25 ilding (Sale) $220.000 26 Titial Outlay 27 Building 28 Initial NWC 29 Total Initial Outlay 130 Terminal Cash How 31 Building 32 Cost Basis 33 Gain 34 Tax on Cain 35 Change in NWC 36 Total Terminal Cash Flow 37 38 Project Cash Flows Year 39 0 140 Initial Outlay 41 ATCFS 42 Terminal Cash Flow 43 Total Cash Flows 44 45 46 WACC 47 45 NPV 49 Profitability Index 50 IRR 51 MIRR 52 Year Year Year Year 2 Year 4 3 53 54