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. 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. Panel B. Balance Sheet Summary Assets Cash Rents receivable Properties @ cost Less: Accumulated depreciation Properties-net $ 117,000,000 46,800,000 39,000,000 7,700,000 4,700,000 18,800,000 6,400,000 $ 12,400,000 $ 53,200,000 4,200,000 870,000,000 467,000,000 403.000.000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

D1.

 

Problem 21-1
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.
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.
Panel B. Balance Sheet Summary
Assets
Cash
Rents receivable
Properties @ cost
Less: Accumulated depreciation
Properties-net
Total net assets.
Liabilities
$ 117,000,000
46,800,000
39,000,000
7,700,000
4,700,000
18,800,000
6,400,000
$ 12,400,000
$ 53,200,000
4,200,000
870,000,000
467,000,000
403,000,000
$ 460,400,000
Transcribed Image Text:Problem 21-1 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. 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. Panel B. Balance Sheet Summary Assets Cash Rents receivable Properties @ cost Less: Accumulated depreciation Properties-net Total net assets. Liabilities $ 117,000,000 46,800,000 39,000,000 7,700,000 4,700,000 18,800,000 6,400,000 $ 12,400,000 $ 53,200,000 4,200,000 870,000,000 467,000,000 403,000,000 $ 460,400,000
Short term
Mortgage debt*
Total
Shareholder equityt
Liabilities
Total liabilities and equity
*At 8% interest only.
†10,000,000 shares outstanding.
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
EPS
$ 151,400,000
80,000,000
231,400,000
229,000,000
$ 460,400,000
NOI
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.)
Transcribed Image Text:Short term Mortgage debt* Total Shareholder equityt Liabilities Total liabilities and equity *At 8% interest only. †10,000,000 shares outstanding. 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 EPS $ 151,400,000 80,000,000 231,400,000 229,000,000 $ 460,400,000 NOI 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.)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Information
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education