Preferred Apartment Communities, Inc. is a publicly traded REIT (Real Estate Investment Trust.) The Company was formed primarily to acquire and operate multifamily properties in select targeted markets throughout the United States. As a secondary strategy, the Company also may acquire or originate senior mortgage loans, subordinate loans or real estate loan investments secured by interests in multifamily properties, membership or partnership interests in multifamily properties and other multifamily related assets and invest a lesser portion of its assets in other real estate related investments, including other income-producing property types, senior mortgage loans, subordinate loans or real estate loan investments secured by interests in other income-producing property types. The Company uses a variety of sources of long-term capital including common stock, redeemable preferred stock units and limited partnership interests. The preferred stock is sold as units consisting of a share of the preferred stock and a warrant to purchase 20 shares of the Company's common shares exercisable over a four year period. There is no secondary market for the preferred stock units. As a Financial Analyst, you need to determine whether the preferred units are an attractive investment by analyzing the financial health of Preferred Apartment Communities. Your analysis should include an examination of the financial statements and the business environment in which the Company operates. Additionally, through a comprehensive analysis of the various financial and other ratios you should decide if the preferred units are an attractive investment. Support for your analysis should be no more than 8 double-spaced pages and include outside references using AP-style in-text and end-text citations (references.) In particular, your analysis should include the following items: Calculate and analyze the following categories of the financial ratios for the past three years using the attached financial statements: A- Profitability Analysis 1. Return on Assets (ROA) 2. Return on Common Equity (ROCE) 3. Return on Net Operating Assets (RNOA) B. Risk Analysis 1. Coverage Analysis Times Interest Earned Ratio, EBITDA Ratio, and Cash from Operations to Total Debt 2. Short-term Liquidity Current ratio, Quick ratio, and Working Capital 3. Longer-term Solvency Liabilities-to-Equity, Total Debt-to-Equity, and Financial Leverage 4- Calculate Z Score, a Bankruptcy Prediction Indicator for the most recent year. Show your Calculations to indicate the formulas and calculations. Offer your Analysis to identify the underlying trend and changes, compare with the prior years (horizontally) and the industry benchmarks (horizontally and vertically.) See the attached financial statements in Excel. All numbers provided are hypothetical. Pease only use what is provided for your calculations. The statutory tax rate is 37%. The current market prices per share for the preferred stock is $1000 and common stock is $1. B C D E F 1 Annual Financials for Preferred Apartment Communities Inc. 2 Income Statements 3 Income Statement (in millions) 4 2014 56.63 2015 80.82 2016 198.47 2017 297.34 2018 403.18 4.28 9.5 19.3 36.64 51.39 54.5 83.24 112.58 10.19 21.32 44.28 16.09 9.61 76.49 8.19 12.43 20.53 2014 2015 2016 -28.06 -36.28 -36.11 4.27 205.42 67.47 120.11 16.76 2017 - 75.78 37.64 228.34 95.56 177.04 19.15 2018 -65.52 69.713 4.27 37.64 69.71 888 -1039.06 -204.94 -28.06 -36.28 -44.65 5 Fiscal year is January-December. All values USD millions. 6 Sales/Revenue 7 Total Investment Income 8 Sundry Revenue/Income 9 Trading Account Income 10 Trust Income, Commissions & Fees 11 Commission & Fee Income 12 Total Expense 13 Total Interest Expense 14 Depreciation & Amortization Expense 15 Other Operating Expense 16 17 Operating Income 18 Non-Operating Income (Expense) 19 Non-Operating Interest Income 20 Miscellaneous Non Operating Expense 21 Equity in Affiliates (Pretax) 22 Unusual Expense 23 Pretax Income 24 25 Income Tax - Current - Domestic 26 Income Tax - Current - Foreign 27 Income Tax-Deferred - Domestic 28 Income Tax - Deferred - Foreign 29 Income Tax Credits 30 Equity in Affiliates 31 Other After Tax Income (Expense) 32 Consolidated Net Income 33 Minority Interest Expense 34 Net Income 35 Extraordinaries & Discontinued Operations 36 Extra Items & Gain/Loss Sale Of Assets 37 Cumulative Effect - Accounting Chg 38 Discontinued Operations 39 Net Income After Extraordinaries 40 Preferred Dividends 41 Net Income Available to common 42 Common Dividends 43 EPS (Basic, in dollars) 44 Basic Shares Outstanding 45 EPS (Diluted, in dollars)) 46 Diluted Shares Outstanding 0 0 2.1 -2.45 -9.86 33 25 60 -63.16 -58.83 -94.79 0 28.65 44.52 99 100 -1166.71 349.46 7.38 18.75 41.08 63.65 86.74 -70.54 -77.58 -135.87 -1230.36 -436.20 -4.05 17.4 -4.05 17.4 -3.50 22.18 -3.50 22.18 -5.67 23.97 -5.67 23.97 -38.53 31.93 -38.53 31.93 -10.90 40.03 -10.90 40.03 47 D E F 2017 2018 2015 -36.28 -8.51 -75.78 2016 -36.11 36.48 4.04 -65.52 -76.94 37.37 -45.37 -26.81 -48.52 0 0 0 0 156.28 25.3 -46.3 73.67 78.08 517 325.53 72.5 2015 -580 2016 -1300 2017 -1950 2018 -450 A B 1 Summary of Cash Flow Statements 2 3 Operating Activities (in millions unless other wise noted 4 Fiscal year is January-December. All values USD millions. 2014 5 Funds from Operations -28.06 6 Changes in Working Capital 9.25 7 Receivables 36.74 8 Inventories 9 Accounts Payable 0 10 Other Assets/Liabilities 2.09 11 Net Operating Cash Flow 20.02 12 Investing Activities - 13 2014 : 14 Net Investing Cash Flow -680 :15 Financing Activities 2014 17 Cash Dividends Paid - Total -7.38 18 Common Dividends 0 19 Preferred Dividends -7.38 20 Change in Common Stock 110.03 21 Repurchase of Common & Preferred Stk. : 22 Sale of Preferred Stock 250 23 Issuance/Reduction of Debt, Net 0 24 Change in Long-Term Debt 351.6 25 Other Sources : 26 Net Financing Cash Flow 704.25 27 Exchange Rate Effect 28 Miscellaneous Funds 29 Net Change in Cash 44.27 16 2016 -41.08 2017 -63.65 2018 -86.74 2015 -18.75 0 -18.75 0 0 0 -41.08 138.91 -63.65 300.32 -86.74 370.40 155.03 0 0 200 350 550 100 0 0 0 0 307.5 795.9 1138.691 -252.341 643.78 1243.73 1925.36 131.3196 17.48 21.81 47.86 6.85 B D E F 1 Balance Sheets 2 2014 44.27 2015 61.75 2016 83.56 2017 131.42 2018 138.27 36.74 63.55 59.51 104.88 153.40 269.95 558.34 1123.30 2078.58 1906.52 3518.30 28.53 25.70 99.17 125.10 165.04 15.83 9.98 20.02 22.35 29.08 12.70 15.72 79.16 102.74 135.96 696.41 1300.00 2420.00 2393.01 4410.00 3 Assets 4 Fiscal year is January-December. All values USD millions. 5 Cash Only 6 Total Short-Term Investments 7 Short-Term Receivables 8 Investment Securities 9 Securities in Custody 10 Other Investments 11 Plant & Equipment 12 Goodwill 13 Long Term Investments 14 Intangible Assets 15 Total Assets 16 17 Liabilities & Shareholders' Equity 18 Total Debt 19 ST Debt & Current Portion LT Debt 20 Short Term Debt 21 Current Portion of Long Term Debt 22 Long-Term Debt 23 LT Debt excl. Capitalized Leases 24 Capitalized Lease Obligations 25 Deferred Taxes 26 Other Liabilities 27 Total Liabilities 28 Redeemable Preferred Stock (Par $1000) 29 Non-Redeemable Preferred Stock 30 Common Stock (Par $0.01) 31 Additional Paid-In Capital/Capital Surplus 32 Retained Earnings 33 ESOP Debt Guarantee 34 Cumulative Translation Adjustment/Unrealized For. Exch. Gain 35 Unrealized Gain/Loss Marketable Securities 36 Revaluation Reserves 37 Other Appropriated Reserves 38 Unappropriated Reserves 39 Treasury Stock 40 Accumulated Minority Interest 41 Total Equity 42 Liabilities & Shareholders' Equity 43 2014 2015 386.91 736.89 35.31 77.79 32.49 34.5 2.82 43.29 351.6 659.1 300 550 51.6 109.1 2016 1545 90 40 50 1455 1200 255 2017 2018 1,840.00 2585 103.3 243.44 45.5 62.5 57.8 180.94 1736.70 2341.35 1550 1650 186.7 691.35 17.92 33.19 404.83 770.08 250 450 70.48 128.17 439.77 1615.48 1968.17 3024.56 800 1,350 1,450 0.17 0.22 109.86 154.81 -70.54-77.58 0.24 0.32 0.40 138.67 300 370 -135.87 -1230.36 -436.20 2.09 2.47 1.48 4.88 1.24 291.58 529.92 804.52 424.84 1,385.44 696.41 1,300.00 2,420.00 2,393.01 4,410.00 Preferred Apartment Communities, Inc. is a publicly traded REIT (Real Estate Investment Trust.) The Company was formed primarily to acquire and operate multifamily properties in select targeted markets throughout the United States. As a secondary strategy, the Company also may acquire or originate senior mortgage loans, subordinate loans or real estate loan investments secured by interests in multifamily properties, membership or partnership interests in multifamily properties and other multifamily related assets and invest a lesser portion of its assets in other real estate related investments, including other income-producing property types, senior mortgage loans, subordinate loans or real estate loan investments secured by interests in other income-producing property types. The Company uses a variety of sources of long-term capital including common stock, redeemable preferred stock units and limited partnership interests. The preferred stock is sold as units consisting of a share of the preferred stock and a warrant to purchase 20 shares of the Company's common shares exercisable over a four year period. There is no secondary market for the preferred stock units. As a Financial Analyst, you need to determine whether the preferred units are an attractive investment by analyzing the financial health of Preferred Apartment Communities. Your analysis should include an examination of the financial statements and the business environment in which the Company operates. Additionally, through a comprehensive analysis of the various financial and other ratios you should decide if the preferred units are an attractive investment. Support for your analysis should be no more than 8 double-spaced pages and include outside references using AP-style in-text and end-text citations (references.) In particular, your analysis should include the following items: Calculate and analyze the following categories of the financial ratios for the past three years using the attached financial statements: A- Profitability Analysis 1. Return on Assets (ROA) 2. Return on Common Equity (ROCE) 3. Return on Net Operating Assets (RNOA) B. Risk Analysis 1. Coverage Analysis Times Interest Earned Ratio, EBITDA Ratio, and Cash from Operations to Total Debt 2. Short-term Liquidity Current ratio, Quick ratio, and Working Capital 3. Longer-term Solvency Liabilities-to-Equity, Total Debt-to-Equity, and Financial Leverage 4- Calculate Z Score, a Bankruptcy Prediction Indicator for the most recent year. Show your Calculations to indicate the formulas and calculations. Offer your Analysis to identify the underlying trend and changes, compare with the prior years (horizontally) and the industry benchmarks (horizontally and vertically.) See the attached financial statements in Excel. All numbers provided are hypothetical. Pease only use what is provided for your calculations. The statutory tax rate is 37%. The current market prices per share for the preferred stock is $1000 and common stock is $1. B C D E F 1 Annual Financials for Preferred Apartment Communities Inc. 2 Income Statements 3 Income Statement (in millions) 4 2014 56.63 2015 80.82 2016 198.47 2017 297.34 2018 403.18 4.28 9.5 19.3 36.64 51.39 54.5 83.24 112.58 10.19 21.32 44.28 16.09 9.61 76.49 8.19 12.43 20.53 2014 2015 2016 -28.06 -36.28 -36.11 4.27 205.42 67.47 120.11 16.76 2017 - 75.78 37.64 228.34 95.56 177.04 19.15 2018 -65.52 69.713 4.27 37.64 69.71 888 -1039.06 -204.94 -28.06 -36.28 -44.65 5 Fiscal year is January-December. All values USD millions. 6 Sales/Revenue 7 Total Investment Income 8 Sundry Revenue/Income 9 Trading Account Income 10 Trust Income, Commissions & Fees 11 Commission & Fee Income 12 Total Expense 13 Total Interest Expense 14 Depreciation & Amortization Expense 15 Other Operating Expense 16 17 Operating Income 18 Non-Operating Income (Expense) 19 Non-Operating Interest Income 20 Miscellaneous Non Operating Expense 21 Equity in Affiliates (Pretax) 22 Unusual Expense 23 Pretax Income 24 25 Income Tax - Current - Domestic 26 Income Tax - Current - Foreign 27 Income Tax-Deferred - Domestic 28 Income Tax - Deferred - Foreign 29 Income Tax Credits 30 Equity in Affiliates 31 Other After Tax Income (Expense) 32 Consolidated Net Income 33 Minority Interest Expense 34 Net Income 35 Extraordinaries & Discontinued Operations 36 Extra Items & Gain/Loss Sale Of Assets 37 Cumulative Effect - Accounting Chg 38 Discontinued Operations 39 Net Income After Extraordinaries 40 Preferred Dividends 41 Net Income Available to common 42 Common Dividends 43 EPS (Basic, in dollars) 44 Basic Shares Outstanding 45 EPS (Diluted, in dollars)) 46 Diluted Shares Outstanding 0 0 2.1 -2.45 -9.86 33 25 60 -63.16 -58.83 -94.79 0 28.65 44.52 99 100 -1166.71 349.46 7.38 18.75 41.08 63.65 86.74 -70.54 -77.58 -135.87 -1230.36 -436.20 -4.05 17.4 -4.05 17.4 -3.50 22.18 -3.50 22.18 -5.67 23.97 -5.67 23.97 -38.53 31.93 -38.53 31.93 -10.90 40.03 -10.90 40.03 47 D E F 2017 2018 2015 -36.28 -8.51 -75.78 2016 -36.11 36.48 4.04 -65.52 -76.94 37.37 -45.37 -26.81 -48.52 0 0 0 0 156.28 25.3 -46.3 73.67 78.08 517 325.53 72.5 2015 -580 2016 -1300 2017 -1950 2018 -450 A B 1 Summary of Cash Flow Statements 2 3 Operating Activities (in millions unless other wise noted 4 Fiscal year is January-December. All values USD millions. 2014 5 Funds from Operations -28.06 6 Changes in Working Capital 9.25 7 Receivables 36.74 8 Inventories 9 Accounts Payable 0 10 Other Assets/Liabilities 2.09 11 Net Operating Cash Flow 20.02 12 Investing Activities - 13 2014 : 14 Net Investing Cash Flow -680 :15 Financing Activities 2014 17 Cash Dividends Paid - Total -7.38 18 Common Dividends 0 19 Preferred Dividends -7.38 20 Change in Common Stock 110.03 21 Repurchase of Common & Preferred Stk. : 22 Sale of Preferred Stock 250 23 Issuance/Reduction of Debt, Net 0 24 Change in Long-Term Debt 351.6 25 Other Sources : 26 Net Financing Cash Flow 704.25 27 Exchange Rate Effect 28 Miscellaneous Funds 29 Net Change in Cash 44.27 16 2016 -41.08 2017 -63.65 2018 -86.74 2015 -18.75 0 -18.75 0 0 0 -41.08 138.91 -63.65 300.32 -86.74 370.40 155.03 0 0 200 350 550 100 0 0 0 0 307.5 795.9 1138.691 -252.341 643.78 1243.73 1925.36 131.3196 17.48 21.81 47.86 6.85 B D E F 1 Balance Sheets 2 2014 44.27 2015 61.75 2016 83.56 2017 131.42 2018 138.27 36.74 63.55 59.51 104.88 153.40 269.95 558.34 1123.30 2078.58 1906.52 3518.30 28.53 25.70 99.17 125.10 165.04 15.83 9.98 20.02 22.35 29.08 12.70 15.72 79.16 102.74 135.96 696.41 1300.00 2420.00 2393.01 4410.00 3 Assets 4 Fiscal year is January-December. All values USD millions. 5 Cash Only 6 Total Short-Term Investments 7 Short-Term Receivables 8 Investment Securities 9 Securities in Custody 10 Other Investments 11 Plant & Equipment 12 Goodwill 13 Long Term Investments 14 Intangible Assets 15 Total Assets 16 17 Liabilities & Shareholders' Equity 18 Total Debt 19 ST Debt & Current Portion LT Debt 20 Short Term Debt 21 Current Portion of Long Term Debt 22 Long-Term Debt 23 LT Debt excl. Capitalized Leases 24 Capitalized Lease Obligations 25 Deferred Taxes 26 Other Liabilities 27 Total Liabilities 28 Redeemable Preferred Stock (Par $1000) 29 Non-Redeemable Preferred Stock 30 Common Stock (Par $0.01) 31 Additional Paid-In Capital/Capital Surplus 32 Retained Earnings 33 ESOP Debt Guarantee 34 Cumulative Translation Adjustment/Unrealized For. Exch. Gain 35 Unrealized Gain/Loss Marketable Securities 36 Revaluation Reserves 37 Other Appropriated Reserves 38 Unappropriated Reserves 39 Treasury Stock 40 Accumulated Minority Interest 41 Total Equity 42 Liabilities & Shareholders' Equity 43 2014 2015 386.91 736.89 35.31 77.79 32.49 34.5 2.82 43.29 351.6 659.1 300 550 51.6 109.1 2016 1545 90 40 50 1455 1200 255 2017 2018 1,840.00 2585 103.3 243.44 45.5 62.5 57.8 180.94 1736.70 2341.35 1550 1650 186.7 691.35 17.92 33.19 404.83 770.08 250 450 70.48 128.17 439.77 1615.48 1968.17 3024.56 800 1,350 1,450 0.17 0.22 109.86 154.81 -70.54-77.58 0.24 0.32 0.40 138.67 300 370 -135.87 -1230.36 -436.20 2.09 2.47 1.48 4.88 1.24 291.58 529.92 804.52 424.84 1,385.44 696.41 1,300.00 2,420.00 2,393.01 4,410.00