You have been presented with the following set of financial statements for National Property Trust, a REIT that is about to make an initial stock offering to the public. This REIT specializes in the acquisition and management of warehouses. Your firm, Blue Street Advisors, is an investment management company that is considering the purchase of National Property Trust shares. You have been asked to prepare a financial analysis of the REIT. $ 114,000,000 National Property Trust Panel A. Operating Statement Summary Net revenue Less: Operating expenses Depreciation and amortization General and administrative expenses Management expense Income from operations Less: Interest expense* Net income (loss) *At 8% interest only. 45,600,000 36,000,000 7,400,000 4,400,000 20,600,000 6,400,000 $ 14,200,000 $ 52,900,000 3,900,000 840,000,000 464,000,000 376,000,000 $ 432,800,000 Panel B. Balance Sheet Summary Assets Cash Rents receivable Properties @ cost Less: Accumulated depreciation Properties-net Total net assets Liabilities Short term Mortgage debt* Total Shareholder equityt Total liabilities and equity *At 8% interest only. +innnnnnn haar mandinn $ 126,800,000 80,000,000 206,800,000 226,000,000 $ 432,800,000 Required: a. Develop a set of financial ratios that will provide Blue Street Advisors with useful information in the evaluation and comparison of National Property Trust with other REITs. b. Your research also indicates that the shares of comparable REITs specializing in warehouse acquisitions in the same regions are selling at dividend yields in the range of 8 percent. Price multiples for these REITs are about 12 current FFO. What price range does this suggest for National shares? c. What is the NAV for National Property Trust assuming that a blended capitalization rate of 10 percent would be applicable for the properties owned by Blue Street Advisors? Complete this question by entering your answers in the tabs below. Required A Required B Required C Develop a set of financial ratios that will provide Blue Street Advisors with useful information in the evaluation and comparison of National Property Trust with other REITs. (Round your intermediate calculations and final answers to 2 decimal places. Negative values should be indicated by a minus sign. ROA and ROE should be entered as percentages.) EPS NOI FFO ROC Cash Retention per Share Net Assets per Share Equity or Book Value per Share ROA % % ROE Complete this question by entering your answers in the tabs below. Required A Required B Required C Your research also indicates that the shares of comparable REITs specializing in warehouse acquisitions in the same regions are selling at dividend yields in the range of 8 percent. Price multiples for these REITs are about 12 current FFO. What price range does this suggest for National shares? (Round your intermediate calculations and final answers to 2 decimal places.) Price range from to Required A Required C > Required: a. Develop a set of financial ratios that will provide Blue Street Advisors with useful information in the evaluation and comparison of National Property Trust with other REITs. b. Your research also indicates that the shares of comparable REITs specializing in warehouse acquisitions in the same regions are selling at dividend yields in the range of 8 percent. Price multiples for these REITs are about 12 current FFO. What price range does this suggest for National shares? c. What is the NAV for National Property Trust assuming that a blended capitalization rate of 10 percent would be applicable for the properties owned by Blue Street Advisors? Complete this question by entering your answers in the tabs below. Required A Required B Required C What is the NAV for National Property Trust assuming that a blended capitalization rate of 10 percent would be applicable for the properties owned by Blue Street Advisors? (Round your answer to 2 decimal places.) NAV per share You have been presented with the following set of financial statements for National Property Trust, a REIT that is about to make an initial stock offering to the public. This REIT specializes in the acquisition and management of warehouses. Your firm, Blue Street Advisors, is an investment management company that is considering the purchase of National Property Trust shares. You have been asked to prepare a financial analysis of the REIT. $ 114,000,000 National Property Trust Panel A. Operating Statement Summary Net revenue Less: Operating expenses Depreciation and amortization General and administrative expenses Management expense Income from operations Less: Interest expense* Net income (loss) *At 8% interest only. 45,600,000 36,000,000 7,400,000 4,400,000 20,600,000 6,400,000 $ 14,200,000 $ 52,900,000 3,900,000 840,000,000 464,000,000 376,000,000 $ 432,800,000 Panel B. Balance Sheet Summary Assets Cash Rents receivable Properties @ cost Less: Accumulated depreciation Properties-net Total net assets Liabilities Short term Mortgage debt* Total Shareholder equityt Total liabilities and equity *At 8% interest only. +innnnnnn haar mandinn $ 126,800,000 80,000,000 206,800,000 226,000,000 $ 432,800,000 Required: a. Develop a set of financial ratios that will provide Blue Street Advisors with useful information in the evaluation and comparison of National Property Trust with other REITs. b. Your research also indicates that the shares of comparable REITs specializing in warehouse acquisitions in the same regions are selling at dividend yields in the range of 8 percent. Price multiples for these REITs are about 12 current FFO. What price range does this suggest for National shares? c. What is the NAV for National Property Trust assuming that a blended capitalization rate of 10 percent would be applicable for the properties owned by Blue Street Advisors? Complete this question by entering your answers in the tabs below. Required A Required B Required C Develop a set of financial ratios that will provide Blue Street Advisors with useful information in the evaluation and comparison of National Property Trust with other REITs. (Round your intermediate calculations and final answers to 2 decimal places. Negative values should be indicated by a minus sign. ROA and ROE should be entered as percentages.) EPS NOI FFO ROC Cash Retention per Share Net Assets per Share Equity or Book Value per Share ROA % % ROE Complete this question by entering your answers in the tabs below. Required A Required B Required C Your research also indicates that the shares of comparable REITs specializing in warehouse acquisitions in the same regions are selling at dividend yields in the range of 8 percent. Price multiples for these REITs are about 12 current FFO. What price range does this suggest for National shares? (Round your intermediate calculations and final answers to 2 decimal places.) Price range from to Required A Required C > Required: a. Develop a set of financial ratios that will provide Blue Street Advisors with useful information in the evaluation and comparison of National Property Trust with other REITs. b. Your research also indicates that the shares of comparable REITs specializing in warehouse acquisitions in the same regions are selling at dividend yields in the range of 8 percent. Price multiples for these REITs are about 12 current FFO. What price range does this suggest for National shares? c. What is the NAV for National Property Trust assuming that a blended capitalization rate of 10 percent would be applicable for the properties owned by Blue Street Advisors? Complete this question by entering your answers in the tabs below. Required A Required B Required C What is the NAV for National Property Trust assuming that a blended capitalization rate of 10 percent would be applicable for the properties owned by Blue Street Advisors? (Round your answer to 2 decimal places.) NAV per share