You have received a setup (synopsis) of an offering for Newport Warehouse, a 195,000 square foot, 100\% leased (single tenant) warehouse located in San Francisco, CA. The attached set-up sheet provides needed Base Year and First Year data, as well as the Holding Period Assumptions. QUESTIONS a. What is the Net Sale Price in 2018 ? b. What is the Before-Tax Cash Flow (BTCF) in 2014? c. What is the After-Tax Cash Flow (ATCF) in 2014? d. What is the Margin of Safety (excluding any sale dollars) in 2018 ? e. What is the Cash on Cash Return (After-Tax) in 2014-2018? f. What is the Net After-Tax Sales Proceeds? g. What is the Pre-Tax IRR for this investment (both Leveraged and Unlevered)? h. What is the After-Tax IRR for this investment (both Leveraged and Unlevered)? i. What is the NPV of this investment using a 12% discount rate (before tax)? j. What is the NPV of this investment using a 12% discount rate (after tax)? k. Should you purchase this asset? Why or why not? You have received a setup (synopsis) of an offering for Newport Warehouse, a 195,000 square foot, 100\% leased (single tenant) warehouse located in San Francisco, CA. The attached set-up sheet provides needed Base Year and First Year data, as well as the Holding Period Assumptions. QUESTIONS a. What is the Net Sale Price in 2018 ? b. What is the Before-Tax Cash Flow (BTCF) in 2014? c. What is the After-Tax Cash Flow (ATCF) in 2014? d. What is the Margin of Safety (excluding any sale dollars) in 2018 ? e. What is the Cash on Cash Return (After-Tax) in 2014-2018? f. What is the Net After-Tax Sales Proceeds? g. What is the Pre-Tax IRR for this investment (both Leveraged and Unlevered)? h. What is the After-Tax IRR for this investment (both Leveraged and Unlevered)? i. What is the NPV of this investment using a 12% discount rate (before tax)? j. What is the NPV of this investment using a 12% discount rate (after tax)? k. Should you purchase this asset? Why or why not