90.2K

Verified Solution

Link Copied!

- 21 AaBbCcDdEe AaBbCcDdEe Aa BbCcDc AaBb CcDdE Normal No Spacing Heading 1 Heading 2 v Financial Statement Analysis - 90 points Create an Excel file using the file name (first name, last name. Financial Analysis 2019). Create a separate worksheet (and name appropriately) for each requirement below. Complete the requirements below using Excel formulas for the two most recent years reported in the annual report. 1. Income Statement Analysis. Create vertical and horizontal analysis income statement for the two most recent years, focusing in on the following lines. Stop at net income. Do not include earnings per share data other comprehensive income (loss). 2. Balance Sheet Analysis. Create vertical and horizontal analysis balance sheet for the two most recent years. 3. Discuss financial the trends and impact supported by the above analysis in the space below. 4. Review the analytical measures on page 926 and 927 of the text. Compute the following financial analysis measures, if applicable, for the two most recent years. a. Cash ratio 8. Inventory Turnover m. Rate of return on Common Stockholders' Equity n. Earnings per Share o. Dividend Yield b. Acid-test ratio c. Current Ratio h. Days' Sales In Inventory Accounts Receivable Turnover j. Days' Sales in Receivable k. Gross Profit Percentage L. Profit margin ratio p. Dividend Payout d. Debt Ratio e. Debt to equity ratio f. Times-interest earned ratio 5. Select 2 or 3 of the financial measures completed in step 4 and discuss how they relate to one another, the trends observed, and the possible impact the trends will have in the future. Focus & Financial Anal X American Homes 4 Rent - Fina x AHAR Annual Report_BMK1.p. X + doc_financials/annual/2019/AH4R_Annual Report_BMK1.pdf G Google W Wikipedia Facebook Twitter in Linkedin The Weather Cha... & Yelp TripAdvisor American Homes 4 Rent Consolidated Balance Sheets (Amounts in thousands, except share data) December 31, 2019 December 31, 2018 Land ... $ 1,756,504 $ 1,713,496 7,691,877 7.483,600 9.448,381 9,197,096 (1,462,105) (1,176,499) 7,986,276 8,000,597 355,427 153,651 209,828 318,327 8,551,531 8,492,575 37,575 30,284 126,544 144,930 29,618 29,027 202,056 146,034 6,840 12.686 25,666 25,666 120,279 120,279 $ 9,100,109 $ 9.001,481 $ Assets Single-family properties: Buildings and improvements Single-family properties in operation Less: accumulated depreciation Single-family properties in operation, net.. Single-family properties under development and development land Single-family properties held for sale, net. Total real estate assets, net Cash and cash equivalents Restricted cash Rent and other receivables, net I Escrow deposits, prepaid expenses and other assets Deferred costs and other intangibles, net Asset-backed securitization certificates Goodwill Total assets Liabilities Revolving credit facility Term loan facility, net Asset-backed securitizations, net Unsecured senior notes, net Accounts payable and accrued expenses Amounts payable to affiliates Total liabilities Commitments and contingencies (see Note 14) Equity Shareholders' equity Class A common shares (50.01 par value per share, 450,000,000 shares authorized, 300,107,599 and 296,014,546 shares issued and outstanding at December 31, 2019 and 2018, respectively) Class B common shares ($0.01 par value per share, 50,000,000 shares authorized, 635,075 shares issued and outstanding at December 31, 2019 and 2018) ... Preferred shares ($0,01 par value per share, 100,000,000 shares authorized, 35,350,000 shares issued and outstanding at December 31, 2019 and 2018) Additional paid-in capital Accumulated deficit Accumulated other comprehensive income Total shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 1,945,044 888,453 243,193 4,629 3,081,319 $ 250,000 99,232 1,961,511 492,800 219,229 4,967 3,027,739 3,001 2,960 6 6 354 354 5,790,775 5,732.466 (465,368) (491,214) 6,658 7,393 5,335,426 5,251,965 683_164 721,777 6,018,790 5.973,742 $ 9,100,109 S 9,001,481 The accompanying notes are an integral part of these consolidated financial statements ancials/annual/2019/AH4R_Annual Report BMK1.pdf ogle W Wikipedia Facebook Twitter in LinkedIn The Weather Cha... 2: Yelp TripAdviso American Homes 4 Rent, L.P. Consolidated Balance Sheets (Amounts in thousands, excepunit data) December 31, 2019, December 31, 2018 $ 1,756,504 $1,713,496 7,691,877 7,483,600 9,448,381 9,197,096 (1,462,105) (1,176,499) 7,986,276 8,020,597 355,427 153,651 209,828 318,327 8,551,531 8,492,575 37,575 30.284 126,544 144.930 29,618 29,027 201,776 145,807 25,946 25,893 6,840 12,686 120,279 120,279 $ 9,100,109 $ 9,001,481 $ Assets Single-family properties: Land. Buildings and improvements Single-family properties in operation Less: accumulated depreciation Single-family properties in operation, net Single-family properties under development and development land Single-family properties held for sale, net Total real estate assets, net Cash and cash equivalents Restricted cash Rent and other receivables, net Escrow deposits, prepaid expenses and other assets Amounts due from affiliates ... Deferred costs and other intangibles, net Goodwill Total assets Liabilities Revolving credit facility Term loan facility, net Asset-backed securitizations, net Unsecured senior notes, net Accounts payable and accrued expenses Amounts payable to affiliates Total liabilities Commitments and contingencies (see Note 14) Capital Partners' capital: General partner: Common units (300,742,674 and 296,649,621 units issued and outstanding at December 31, 2019 and 2018, respectively) Preferred units (35,350,000 units issued and outstanding at December 31, 2019 and 2018) Limited partner: Common units (52,026,980 and 55,316,826 units issued and outstanding at December 31, 2019 and 2018, respectively) Accumulated other comprehensive income Total capital Total liabilities and capital 1,945,044 888,453 243,193 $ 250,000 99,232 1,961,511 492,800 219,229 4,967 3,027,739 3,081,319 4,474,333 4,390,137 854,435 854,435 682,199 720,384 7,823 8,786 6,018,790 5,973,742 $ 9,100,109 $ 9,001,481 - 21 AaBbCcDdEe AaBbCcDdEe Aa BbCcDc AaBb CcDdE Normal No Spacing Heading 1 Heading 2 v Financial Statement Analysis - 90 points Create an Excel file using the file name (first name, last name. Financial Analysis 2019). Create a separate worksheet (and name appropriately) for each requirement below. Complete the requirements below using Excel formulas for the two most recent years reported in the annual report. 1. Income Statement Analysis. Create vertical and horizontal analysis income statement for the two most recent years, focusing in on the following lines. Stop at net income. Do not include earnings per share data other comprehensive income (loss). 2. Balance Sheet Analysis. Create vertical and horizontal analysis balance sheet for the two most recent years. 3. Discuss financial the trends and impact supported by the above analysis in the space below. 4. Review the analytical measures on page 926 and 927 of the text. Compute the following financial analysis measures, if applicable, for the two most recent years. a. Cash ratio 8. Inventory Turnover m. Rate of return on Common Stockholders' Equity n. Earnings per Share o. Dividend Yield b. Acid-test ratio c. Current Ratio h. Days' Sales In Inventory Accounts Receivable Turnover j. Days' Sales in Receivable k. Gross Profit Percentage L. Profit margin ratio p. Dividend Payout d. Debt Ratio e. Debt to equity ratio f. Times-interest earned ratio 5. Select 2 or 3 of the financial measures completed in step 4 and discuss how they relate to one another, the trends observed, and the possible impact the trends will have in the future. Focus & Financial Anal X American Homes 4 Rent - Fina x AHAR Annual Report_BMK1.p. X + doc_financials/annual/2019/AH4R_Annual Report_BMK1.pdf G Google W Wikipedia Facebook Twitter in Linkedin The Weather Cha... & Yelp TripAdvisor American Homes 4 Rent Consolidated Balance Sheets (Amounts in thousands, except share data) December 31, 2019 December 31, 2018 Land ... $ 1,756,504 $ 1,713,496 7,691,877 7.483,600 9.448,381 9,197,096 (1,462,105) (1,176,499) 7,986,276 8,000,597 355,427 153,651 209,828 318,327 8,551,531 8,492,575 37,575 30,284 126,544 144,930 29,618 29,027 202,056 146,034 6,840 12.686 25,666 25,666 120,279 120,279 $ 9,100,109 $ 9.001,481 $ Assets Single-family properties: Buildings and improvements Single-family properties in operation Less: accumulated depreciation Single-family properties in operation, net.. Single-family properties under development and development land Single-family properties held for sale, net. Total real estate assets, net Cash and cash equivalents Restricted cash Rent and other receivables, net I Escrow deposits, prepaid expenses and other assets Deferred costs and other intangibles, net Asset-backed securitization certificates Goodwill Total assets Liabilities Revolving credit facility Term loan facility, net Asset-backed securitizations, net Unsecured senior notes, net Accounts payable and accrued expenses Amounts payable to affiliates Total liabilities Commitments and contingencies (see Note 14) Equity Shareholders' equity Class A common shares (50.01 par value per share, 450,000,000 shares authorized, 300,107,599 and 296,014,546 shares issued and outstanding at December 31, 2019 and 2018, respectively) Class B common shares ($0.01 par value per share, 50,000,000 shares authorized, 635,075 shares issued and outstanding at December 31, 2019 and 2018) ... Preferred shares ($0,01 par value per share, 100,000,000 shares authorized, 35,350,000 shares issued and outstanding at December 31, 2019 and 2018) Additional paid-in capital Accumulated deficit Accumulated other comprehensive income Total shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 1,945,044 888,453 243,193 4,629 3,081,319 $ 250,000 99,232 1,961,511 492,800 219,229 4,967 3,027,739 3,001 2,960 6 6 354 354 5,790,775 5,732.466 (465,368) (491,214) 6,658 7,393 5,335,426 5,251,965 683_164 721,777 6,018,790 5.973,742 $ 9,100,109 S 9,001,481 The accompanying notes are an integral part of these consolidated financial statements ancials/annual/2019/AH4R_Annual Report BMK1.pdf ogle W Wikipedia Facebook Twitter in LinkedIn The Weather Cha... 2: Yelp TripAdviso American Homes 4 Rent, L.P. Consolidated Balance Sheets (Amounts in thousands, excepunit data) December 31, 2019, December 31, 2018 $ 1,756,504 $1,713,496 7,691,877 7,483,600 9,448,381 9,197,096 (1,462,105) (1,176,499) 7,986,276 8,020,597 355,427 153,651 209,828 318,327 8,551,531 8,492,575 37,575 30.284 126,544 144.930 29,618 29,027 201,776 145,807 25,946 25,893 6,840 12,686 120,279 120,279 $ 9,100,109 $ 9,001,481 $ Assets Single-family properties: Land. Buildings and improvements Single-family properties in operation Less: accumulated depreciation Single-family properties in operation, net Single-family properties under development and development land Single-family properties held for sale, net Total real estate assets, net Cash and cash equivalents Restricted cash Rent and other receivables, net Escrow deposits, prepaid expenses and other assets Amounts due from affiliates ... Deferred costs and other intangibles, net Goodwill Total assets Liabilities Revolving credit facility Term loan facility, net Asset-backed securitizations, net Unsecured senior notes, net Accounts payable and accrued expenses Amounts payable to affiliates Total liabilities Commitments and contingencies (see Note 14) Capital Partners' capital: General partner: Common units (300,742,674 and 296,649,621 units issued and outstanding at December 31, 2019 and 2018, respectively) Preferred units (35,350,000 units issued and outstanding at December 31, 2019 and 2018) Limited partner: Common units (52,026,980 and 55,316,826 units issued and outstanding at December 31, 2019 and 2018, respectively) Accumulated other comprehensive income Total capital Total liabilities and capital 1,945,044 888,453 243,193 $ 250,000 99,232 1,961,511 492,800 219,229 4,967 3,027,739 3,081,319 4,474,333 4,390,137 854,435 854,435 682,199 720,384 7,823 8,786 6,018,790 5,973,742 $ 9,100,109 $ 9,001,481

Answer & Explanation Solved by verified expert

See Answer